Table: dbo.Accrual_Date
Columns
NameTypeConstraintsDescription
accrual_date_KEYint (4)NOT NULLPrimary key
client_benefit_KEYint (4)NOT NULLKey of the associated client benefit
accrual_datesmalldatetime (4)NOT NULLThe benefit accrues on this date
Primary key
NameColumnsDescription
PK_Accrual_Dateaccrual_date_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Accrual_Date__Client_Benefit__client_benefit_KEYclient_benefit_KEYClient_Benefit (client_benefit_KEY)

Schema diagram