Table testsql_comments.course_instructors 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
course_id int 10
courses
foreign key to link to courses.course_id
borrowernumber int 10
borrowers
foreign key to link to borrowers.borrowernumber for instructor information

Table contained 0 rows at Tue Dec 27 18:01 NZDT 2016

Indexes:
Column(s) Type Sort
course_id + borrowernumber Primary key Asc/Asc
borrowernumber Performance Asc

Close relationships  within of separation: