Table: dbo.Staff_Security_Group
Columns
NameTypeConstraintsDescription
staff_security_group_KEYint (4)NOT NULLDatabase assigned primary key for this table.
staff_KEYint (4)NOT NULLForeign key to Staff.
security_group_KEYint (4)NOT NULLForeign key to Security Group.
Primary key
NameColumnsDescription
PK_Staff_Security_Groupstaff_security_group_KEY
Unique constraints
NameColumnsDescription
UK_Staff_Security_Group$staff_KEY$security_group_KEYstaff_KEY, security_group_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Security_Group__Security_Group__security_group_KEYsecurity_group_KEYSecurity_Group (security_group_KEY)
FK_Staff_Security_Group__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram