Table: Staff_Skill_Rating
Columns
NameTypeConstraintsDescription
staff_skill_rating_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
create_date_utcdatetimeNOT NULL
row_versiontimestampNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
descriptionnvarchar (250)NOT NULLUser defined description (unique).
Primary key
NameColumnsDescription
PK_Staff_Skill_Rating$staff_skill_rating_KEYstaff_skill_rating_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Staff_Skill_Rating$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Staff_Skill_Area_Rating__Staff_Skill_Rating__staff_skill_rating_KEYstaff_skill_rating_KEYStaff_Skill_Area_Ratingon delete cascade;
FK_Staff_Area_Rating__Staff_Skill_Rating__staff_skill_rating_KEYstaff_skill_rating_KEYStaff_Area_Rating

Schema diagram