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
NameTypeConstraintsDescription
state_tax_exemption_type_KEYint (4)NOT NULLPrimary key for the State_Tax_Exemption_List table.
employee__tax_code_type_KEYint (4)Employee tax code type
employer__tax_code_type_KEYint (4)Employer tax code type
sequence_numbertinyint (1)NOT NULLSequence number of the state tax exemption.
Primary key
NameColumnsDescription
PK_State_Tax_Exemption_Typestate_tax_exemption_type_KEY
Unique constraints
NameColumnsDescription
UK_State_Tax_Exemption_Type$sequence_numbersequence_number
Foreign keys
NameColumnsReferenced tableDescription
FK_State_Tax_Exemption_Type__Tax_Code_Type__employee__tax_code_type_KEYemployee__tax_code_type_KEYTax_Code_Type (tax_code_type_KEY)
FK_State_Tax_Exemption_Type__Tax_Code_Type__employer__tax_code_type_KEYemployer__tax_code_type_KEYTax_Code_Type (tax_code_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_State_Tax_Exemption__State_Tax_Exemption_Type__state_tax_exemption_type_KEYstate_tax_exemption_type_KEYState_Tax_Exemption

Schema diagram