Table testsql_comments.courses 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
course_id int 10  √ 
course_instructors.course_id course_instructors_ibfk_2 R
course_reserves.course_id course_reserves_ibfk_1 R
unique id for the course
department varchar 80  √  null the authorised value for the DEPARTMENT
course_number varchar 255  √  null the "course number" assigned to a course
section varchar 255  √  null the 'section' of a course
course_name varchar 255  √  null the name of the course
term varchar 80  √  null the authorised value for the TERM
staff_note mediumtext 16777215  √  null the text of the staff only note
public_note mediumtext 16777215  √  null the text of the public / opac note
students_count varchar 20  √  null how many students will be taking this course/section
enabled enum 4 yes determines whether the course is active
timestamp timestamp 19 CURRENT_TIMESTAMP

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

Indexes:
Column(s) Type Sort Constraint Name
course_id Primary key Asc PRIMARY

Close relationships  within of separation: