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) |