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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Worker_Compensation_Item__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Employee_Worker_Compensation_Item__Worker_Compensation__worker_compensation_KEY | worker_compensation_KEY | Worker_Compensation (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 |