Table: dbo.Local_Tax_Exemption_Type
This table contains the list of local taxes defined in the Tax_Code_Type table. Is it used to determine tax exemptions.
Columns
NameTypeConstraintsDescription
local_tax_exemption_type_KEYint (4)NOT NULLPrimary key for the Local_Tax_Exemption_List table.
employee__tax_code_type_KEYint (4)Employee tax code type
employer__tax_code_type_KEYint (4)Employer tax code type
Primary key
NameColumnsDescription
PK_Local_Tax_Exemption_Typelocal_tax_exemption_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Local_Tax_Exemption_Type__Tax_Code_Type__employee__tax_code_type_KEYemployee__tax_code_type_KEYTax_Code_Type (tax_code_type_KEY)
FK_Local_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_Local_Tax_Exemption__Local_Tax_Exemption_Type__local_tax_exemption_type_KEYlocal_tax_exemption_type_KEYLocal_Tax_Exemption

Schema diagram