| Table: dbo.Employee_Worker_Compensation_Item | |||
| Columns | |||
| Name | Type | Constraints | Description |
| employee_worker_compensation_item_KEY | int (4) | NOT NULL | unique key |
| employee_KEY | int (4) | NOT NULL | employee this state/class code worker comp info is for |
| worker_compensation_KEY | int (4) | NOT NULL | client worker compensation info this is for |
| is_exempt_from_worker_compensation | bit (1) | NOT NULL | T/F: Is this employee exempt from worker compensation for this state/worker comp class code |
| Primary key | |||
| Name | Columns | Description | |
| PK_Employee_Worker_Compensation_Item | employee_worker_compensation_item_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Employee_Worker_Compensation_Item$employee_KEY$worker_compensation_KEY | employee_KEY, worker_compensation_KEY | ||
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| FK_Employee_Worker_Compensation_Item_Distribution__Employee_Worker_Compensation_Item__employee_worker_compensation_item_KEY | employee_worker_compensation_item_KEY | Employee_Worker_Compensation_Item_Distribution | |