course_instructors

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
course_id INT 10 null
courses.course_id course_instructors_ibfk_2R

foreign key to link to courses.course_id

borrowernumber INT 10 null
borrowers.borrowernumber course_instructors_ibfk_1C

foreign key to link to borrowers.borrowernumber for instructor information

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc course_id + borrowernumber
borrowernumber Performance Asc borrowernumber

Relationships