Table: Accruable_Benefit
Columns
NameTypeConstraintsDescription
accruable_benefit_KEYintNOT NULLPrimary key for this table, same value as [benefit_KEY].
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
create_datedatetimeNOT 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