Table: Staff_Area_Rating
Columns
Name | Type | Constraints | Description
staff_area_rating_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |
staff_KEY | int | NOT NULL | Foreign key of the staff this Rate Table belongs to.
staff_skill_rating_KEY | int | NOT NULL | Foreign key - Registers rates expertise for a staff in a particular area
staff_skill_area_KEY | int | NOT NULL | Foreign key - Registers area of expertise for a given staff.

Primary key
Name | Columns | Description
PK_Staff_Area_Rating$staff_area_rating_KEY | staff_area_rating_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Staff_Area_Rating__staff_KEY__staff_skill_area_KEY__staff_skill_rating_KEY | staff_KEY, staff_skill_area_KEY, staff_skill_rating_KEY | Each staff can only have a single skill area and skill rating pair.
Indexes
Name | Columns | Description
IX_Staff_Area_Rating$staff_skill_area_KEY | staff_skill_area_KEY |
IX_Staff_Area_Rating$staff_skill_rating_KEY | staff_skill_rating_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Staff_Area_Rating__Staff__staff_KEY | staff_KEY | Staff |
FK_Staff_Area_Rating__Staff_Skill_Area__staff_skill_area_KEY | staff_skill_area_KEY | Staff_Skill_Area |
FK_Staff_Area_Rating__Staff_Skill_Rating__staff_skill_rating_KEY | staff_skill_rating_KEY | Staff_Skill_Rating |