Table: dbo.Engagement_Binder_N_Staff | |||
This table stores information about staff assigned to work on an Engagement and their assigned roles. | |||
Columns | |||
Name | Type | Constraints | Description |
engagement_binder_n_staff_KEY | int (4) | NOT NULL | |
engagement_binder_KEY | int (4) | NOT NULL | Primary key. This points to record in the Engagement_Binder table. |
staff_KEY | int (4) | NOT NULL | The staff assigned to work on this engagement. |
Primary key | |||
Name | Columns | Description | |
PK_Engagement_Binder_N_Staff | engagement_binder_n_staff_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Engagement_Binder_N_Staff$engagement_binder_KEY$staff_KEY | engagement_binder_KEY, staff_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Engagement_Binder_N_Staff__Engagement_Binder__engagement_binder_KEY | engagement_binder_KEY | Engagement_Binder (engagement_binder_KEY) | |
FK_Engagement_Binder_N_Staff__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |