| Table: dbo.Payroll_Item_Worker_Compensation_Exemption | |||
| Columns | |||
| Name | Type | Constraints | Description |
| payroll_item_worker_compensation_exemption_KEY | int (4) | NOT NULL | unique key |
| client_payroll_item_KEY | int (4) | NOT NULL | client payroll item this exemption is for |
| Primary key | |||
| Name | Columns | Description | |
| PK_Payroll_Item_Worker_Compensation_Exemption | payroll_item_worker_compensation_exemption_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Payroll_Item_Worker_Compensation_Exemption$client_payroll_item_KEY | client_payroll_item_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Payroll_Item_Worker_Compensation_Exemption__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) | |
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| FK_Payroll_Item_Worker_Compensation_Exemption_Detail__Payroll_Item_Worker_Compensation_Exemption__payroll_item_worker_compensati | payroll_item_worker_compensation_exemption_KEY | Payroll_Item_Worker_Compensation_Exemption_Detail | |