Table: dbo.State_Tax_Exemption
Columns
Name | Type | Constraints | Description
state_tax_exemption_KEY | int (4) | NOT NULL | Primary key for the State_Tax_Exemption table.
state_tax_exemption_type_KEY | int (4) |  | Associated state tax exemption list item.
client_payroll_item_KEY | int (4) | NOT NULL | Associated client payroll item.

Primary key
Name | Columns | Description
PK_State_Tax_Exemption | state_tax_exemption_KEY |
Unique constraints
Name | Columns | Description
UK_State_Tax_Exemption$client_payroll_item_KEY$state_tax_exemption_type_KEY | client_payroll_item_KEY, state_tax_exemption_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_State_Tax_Exemption__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |
FK_State_Tax_Exemption__State_Tax_Exemption_Type__state_tax_exemption_type_KEY | state_tax_exemption_type_KEY | State_Tax_Exemption_Type (state_tax_exemption_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_State_Tax_Exemption_Detail__State_Tax_Exemption__state_tax_exemption_KEY | state_tax_exemption_KEY | State_Tax_Exemption_Detail |