Table: Accruable_Benefit
Columns
NameTypeConstraintsDescription
accruable_benefit_KEYintNOT NULLPrimary key for this table, same value as [benefit_KEY].
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
benefit_KEYintNOT NULLKey to a Benefit that the accruable benefit is for.
activity_KEYintNOT NULLKey to an Activity that the accruable benefit is for.
Primary key
NameColumnsDescription
PK_Accruable_Benefit$accruable_benefit_KEYaccruable_benefit_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Accruable_Benefit$activity_KEYactivity_KEY
UK_Accruable_Benefit$benefit_KEYbenefit_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Accruable_Benefit__Activity__activity_KEYactivity_KEYActivity
FK_Accruable_Benefit__Benefit__benefit_KEYbenefit_KEYBenefit

Schema diagram