Table: dbo.Benefit_Item_Worker_Compensation_Exemption_Detail
Columns
NameTypeConstraintsDescription
benefit_item_worker_compensation_exemption_detail_KEYint (4)NOT NULLunique key
benefit_item_worker_compensation_exemption_KEYint (4)NOT NULLparticular benefit item this detail is for
ste_state_code_KEYnvarchar (4)NOT NULLstate this benefit item is exempt from worker compensation calculation
Primary key
NameColumnsDescription
PK_Benefit_Item_Worker_Compensation_Exemption_Detailbenefit_item_worker_compensation_exemption_detail_KEY
Unique constraints
NameColumnsDescription
UK_Benefit_Item_Worker_Compensation_Exemption_Detail$benefit_item_worker_compensation_exemption_KEY$ste_state_code_KEYbenefit_item_worker_compensation_exemption_KEY, ste_state_code_KEY
Foreign keys
NameColumnsReferenced 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 (benefit_item_worker_compensation_exemption_KEY)
FK_Benefit_Item_Worker_Compensation_Exemption_Detail__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)

Schema diagram