Table: dbo.Local_Tax_Exemption
Columns
NameTypeConstraintsDescription
local_tax_exemption_KEYint (4)NOT NULLPrimary key for the Local_Tax_Exemption table.
local_tax_exemption_type_KEYint (4)Associated state tax exemption list item.
client_payroll_item_KEYint (4)NOT NULLAssociated client payroll item.
Primary key
NameColumnsDescription
PK_Local_Tax_Exemptionlocal_tax_exemption_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Local_Tax_Exemption__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Local_Tax_Exemption__Local_Tax_Exemption_Type__local_tax_exemption_type_KEYlocal_tax_exemption_type_KEYLocal_Tax_Exemption_Type (local_tax_exemption_type_KEY)

Schema diagram