course_instructors


Columns

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

foreign key to link to courses.course_id
borrowernumber INT 10 null
borrowers.borrowernumber course_instructors_ibfk_1 C

foreign key to link to borrowers.borrowernumber for instructor information

Table contained 0 rows

Indexes

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

Relationships

Close relationships within degrees of separation