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 |