Table: dbo.Benefit_Item_Worker_Compensation_Exemption | |||
Columns | |||
Name | Type | Constraints | Description |
benefit_item_worker_compensation_exemption_KEY | int (4) | NOT NULL | unique key |
client_benefit_KEY | int (4) | NOT NULL | benefit item this exemption is for |
Primary key | |||
Name | Columns | Description | |
PK_Benefit_Item_Worker_Compensation_Exemption | benefit_item_worker_compensation_exemption_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Benefit_Item_Worker_Compensation_Exemption$client_benefit_KEY | client_benefit_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Benefit_Item_Worker_Compensation_Exemption__Client_Benefit__client_benefit_KEY | client_benefit_KEY | Client_Benefit (client_benefit_KEY) |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Benefit_Item_Worker_Compensation_Exemption_Detail__Benefit_Item_Worker_Compensation_Exemption__benefit_item_worker_compensati | benefit_item_worker_compensation_exemption_KEY | Benefit_Item_Worker_Compensation_Exemption_Detail |