Table: Staff_Benefit
Columns
NameTypeConstraintsDescription
staff_benefit_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
staff_KEYintNOT NULLKey to a Staff.
benefit_KEYintNOT NULLKey to a Benefit.
activebitNOT NULLDetermines whether the benefit is enabled for this Staff.
effective_datesmalldatetimeThe effective date of this staff benefit.
Primary key
NameColumnsDescription
PK_Staff_Benefit$staff_benefit_KEYstaff_benefit_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Staff_Benefit$benefit_KEY$staff_KEYbenefit_KEY, staff_KEY
Indexes
NameColumnsDescription
IX_Staff_Benefit$staff_KEYstaff_KEYIndex supports foreign key FK_Staff_Benefit__Staff__staff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Benefit__Benefit__benefit_KEYbenefit_KEYBenefiton delete cascade;
FK_Staff_Benefit__Staff__staff_KEYstaff_KEYStaffon delete cascade;
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Staff_Benefit_Entry__Staff_Benefit__staff_benefit_KEYstaff_benefit_KEYStaff_Benefit_Entry

Schema diagram