Table testsql_comments.course_reserves Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
cr_id int 10  √ 
course_id int 10
courses
foreign key to link to courses.course_id
ci_id int 10
course_items
foreign key to link to courses_items.ci_id
staff_note mediumtext 16777215  √  null staff only note
public_note mediumtext 16777215  √  null public, OPAC visible note
timestamp timestamp 19 CURRENT_TIMESTAMP

Table contained 0 rows at Mon Jun 26 10:02 NZST 2017

Indexes:
Column(s) Type Sort
cr_id Primary key Asc
course_id Performance Asc
ci_id Performance Asc
course_id + ci_id Must be unique Asc/Asc

Close relationships  within of separation: