Table: dbo.Benefit_Item_Worker_Compensation_Exemption
Columns
NameTypeConstraintsDescription
benefit_item_worker_compensation_exemption_KEYint (4)NOT NULLunique key
client_benefit_KEYint (4)NOT NULLbenefit item this exemption is for
Primary key
NameColumnsDescription
PK_Benefit_Item_Worker_Compensation_Exemptionbenefit_item_worker_compensation_exemption_KEY
Unique constraints
NameColumnsDescription
UK_Benefit_Item_Worker_Compensation_Exemption$client_benefit_KEYclient_benefit_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Benefit_Item_Worker_Compensation_Exemption__Client_Benefit__client_benefit_KEYclient_benefit_KEYClient_Benefit (client_benefit_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Benefit_Item_Worker_Compensation_Exemption_Detail__Benefit_Item_Worker_Compensation_Exemption__benefit_item_worker_compensatibenefit_item_worker_compensation_exemption_KEYBenefit_Item_Worker_Compensation_Exemption_Detail

Schema diagram