CourseStaff


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CourseStaffSeq int identity 4 √ null
StaffID int 4 null
Staff.ID FK_CourseStaff_Staff R
CoursesSeq int 4 null
Courses.CoursesSeq FK_CourseStaff_Courses R
StaffSeq int 4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_CourseStaff Primary key Asc CourseStaffSeq
AK_CourseStaff_StaffID_CoursesSeq Performance Asc/Asc StaffID + CoursesSeq

Relationships

Close relationships within degrees of separation