Table: dbo.Engagement_Binder_N_Staff
This table stores information about staff assigned to work on an Engagement and their assigned roles.
Columns
NameTypeConstraintsDescription
engagement_binder_n_staff_KEYint (4)NOT NULL
engagement_binder_KEYint (4)NOT NULLPrimary key. This points to record in the Engagement_Binder table.
staff_KEYint (4)NOT NULLThe staff assigned to work on this engagement.
Primary key
NameColumnsDescription
PK_Engagement_Binder_N_Staffengagement_binder_n_staff_KEY
Unique constraints
NameColumnsDescription
UK_Engagement_Binder_N_Staff$engagement_binder_KEY$staff_KEYengagement_binder_KEY, staff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Engagement_Binder_N_Staff__Engagement_Binder__engagement_binder_KEYengagement_binder_KEYEngagement_Binder (engagement_binder_KEY)
FK_Engagement_Binder_N_Staff__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram