Table: dbo.Tax_Code_Type
This table stores the various tax code types in the system that serve as tax categories. This table also stores the FAKE tax code types. Those FAKEs are added in to serve as placeholders that signify multiple tax code types and the multiple types are defined in the code. Local_Tax_Exemption_Type basically has a one to one relationship with Tax_Code_Type in the database and for certain exemption selections this needs to be one-to-many and the FAKEs allow the many to be specified in the code.
Columns
NameTypeConstraintsDescription
tax_code_type_KEYint (4)NOT NULLPrimary key for this table
tax_codenvarchar (20)NOT NULLTax code
descriptionnvarchar (100)NOT NULLDescription
long_descriptionnvarchar (100)NOT NULLLong description
Primary key
NameColumnsDescription
PK_Tax_Code_Typetax_code_type_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Local_Tax_Exemption_Type__Tax_Code_Type__employee__tax_code_type_KEYemployee__tax_code_type_KEYLocal_Tax_Exemption_Type
FK_Local_Tax_Exemption_Type__Tax_Code_Type__employer__tax_code_type_KEYemployer__tax_code_type_KEYLocal_Tax_Exemption_Type
FK_State_Tax_Exemption_Type__Tax_Code_Type__employee__tax_code_type_KEYemployee__tax_code_type_KEYState_Tax_Exemption_Type
FK_State_Tax_Exemption_Type__Tax_Code_Type__employer__tax_code_type_KEYemployer__tax_code_type_KEYState_Tax_Exemption_Type
FK_Federal_Tax_Exemption_Type__Tax_Code_Type__employee__tax_code_type_KEYemployee__tax_code_type_KEYFederal_Tax_Exemption_Type
FK_Federal_Tax_Exemption_Type__Tax_Code_Type__employer__tax_code_type_KEYemployer__tax_code_type_KEYFederal_Tax_Exemption_Type

Schema diagram