Table: Staff_Security_Group
Columns
NameTypeConstraintsDescription
staff_security_group_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
staff_KEYintNOT NULLForeign key to Staff.
security_group_KEYintNOT NULLForeign key to Security Group.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Staff_Security_Group$staff_security_group_KEYstaff_security_group_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Staff_Security_Group$staff_KEY$security_group_KEYstaff_KEY, security_group_KEY
Indexes
NameColumnsDescription
IX_Staff_Security_Group$security_group_KEYsecurity_group_KEYIndex supports foreign key FK_Staff_Security_Group__Security_Group__security_group_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Security_Group__Security_Group__security_group_KEYsecurity_group_KEYSecurity_Group
FK_Staff_Security_Group__Staff__staff_KEYstaff_KEYStaffon delete cascade;

Schema diagram