| 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 | ||
| 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 | |