Table: dbo.Payroll_Item_Worker_Compensation_Exemption
Columns
NameTypeConstraintsDescription
payroll_item_worker_compensation_exemption_KEYint (4)NOT NULLunique key
client_payroll_item_KEYint (4)NOT NULLclient payroll item this exemption is for
Primary key
NameColumnsDescription
PK_Payroll_Item_Worker_Compensation_Exemptionpayroll_item_worker_compensation_exemption_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Item_Worker_Compensation_Exemption$client_payroll_item_KEYclient_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Item_Worker_Compensation_Exemption__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Item_Worker_Compensation_Exemption_Detail__Payroll_Item_Worker_Compensation_Exemption__payroll_item_worker_compensatipayroll_item_worker_compensation_exemption_KEYPayroll_Item_Worker_Compensation_Exemption_Detail

Schema diagram