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_utc | datetime | NOT NULL | |
create_date_utc | 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 |