Table testsql_comments.course_reserves Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
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.course_id course_reserves_ibfk_1 R
foreign key to link to courses.course_id
ci_id int 10
course_items.ci_id course_reserves_ibfk_2 C
foreign key to link to courses_items.ci_id
staff_note longtext 2147483647  √  null staff only note
public_note longtext 2147483647  √  null public, OPAC visible note
timestamp timestamp 19 CURRENT_TIMESTAMP

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

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

Close relationships  within of separation: