Table: dbo.State_Tax_Exemption_Type
This table contains the list of state taxes defined in the Tax_Code_Type table. Is it used to determine tax exemptions.
Columns
Name | Type | Constraints | Description
state_tax_exemption_type_KEY | int (4) | NOT NULL | Primary key for the State_Tax_Exemption_List table.
employee__tax_code_type_KEY | int (4) |  | Employee tax code type
employer__tax_code_type_KEY | int (4) |  | Employer tax code type
sequence_number | tinyint (1) | NOT NULL | Sequence number of the state tax exemption.

Primary key
Name | Columns | Description
PK_State_Tax_Exemption_Type | state_tax_exemption_type_KEY |
Unique constraints
Name | Columns | Description
UK_State_Tax_Exemption_Type$sequence_number | sequence_number |

Foreign keys
Name | Columns | Referenced table | Description
FK_State_Tax_Exemption_Type__Tax_Code_Type__employee__tax_code_type_KEY | employee__tax_code_type_KEY | Tax_Code_Type (tax_code_type_KEY) |
FK_State_Tax_Exemption_Type__Tax_Code_Type__employer__tax_code_type_KEY | employer__tax_code_type_KEY | Tax_Code_Type (tax_code_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_State_Tax_Exemption__State_Tax_Exemption_Type__state_tax_exemption_type_KEY | state_tax_exemption_type_KEY | State_Tax_Exemption |