Table: Staff_Skill_Area_Rating
Columns
NameTypeConstraintsDescription
staff_skill_area_rating_KEYintNOT NULL
staff_skill_area_KEYintNOT NULL
staff_skill_rating_KEYintNOT NULL
Primary key
NameColumnsDescription
PK_Staff_Skill_Area_Rating$staff_skill_area_rating_KEYstaff_skill_area_rating_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Staff_Skill_Area_Rating$staff_skill_area_KEY$staff_skill_rating_KEYstaff_skill_area_KEY, staff_skill_rating_KEYEach skill area and rating pair must be unique.
Indexes
NameColumnsDescription
IX_Staff_Skill_Area_Rating$staff_skill_rating_KEYstaff_skill_rating_KEYIndex supports foreign key FK_Staff_Skill_Area_Rating__Staff_Skill_Rating__staff_skill_rating_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Skill_Area_Rating__Staff_Skill_Area__staff_skill_area_KEYstaff_skill_area_KEYStaff_Skill_Areaon delete cascade;
FK_Staff_Skill_Area_Rating__Staff_Skill_Rating__staff_skill_rating_KEYstaff_skill_rating_KEYStaff_Skill_Ratingon delete cascade;

Schema diagram