Table: Staff_Area_Rating
Columns
NameTypeConstraintsDescription
staff_area_rating_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
staff_KEYintNOT NULLForeign key of the staff this Rate Table belongs to.
staff_skill_rating_KEYintNOT NULLForeign key - Registers rates expertise for a staff in a particular area
staff_skill_area_KEYintNOT NULLForeign key - Registers area of expertise for a given staff.
Primary key
NameColumnsDescription
PK_Staff_Area_Rating$staff_area_rating_KEYstaff_area_rating_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Staff_Area_Rating$staff_KEY$staff_skill_area_KEY$staff_skill_rating_KEYstaff_KEY, staff_skill_area_KEY, staff_skill_rating_KEYEach staff can only have a single skill area and skill rating pair.
Indexes
NameColumnsDescription
IX_Staff_Area_Rating$staff_skill_area_KEYstaff_skill_area_KEY
IX_Staff_Area_Rating$staff_skill_rating_KEYstaff_skill_rating_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Area_Rating__Staff__staff_KEYstaff_KEYStaff
FK_Staff_Area_Rating__Staff_Skill_Area__staff_skill_area_KEYstaff_skill_area_KEYStaff_Skill_Area
FK_Staff_Area_Rating__Staff_Skill_Rating__staff_skill_rating_KEYstaff_skill_rating_KEYStaff_Skill_Rating

Schema diagram