Table: dbo.Federal_Tax_Exemption
Columns
NameTypeConstraintsDescription
federal_tax_exemption_KEYint (4)NOT NULLPrimary key for the Federal_Tax_Exemption table.
federal_tax_exemption_type_KEYint (4)Associated federal tax exemption list item.
client_payroll_item_KEYint (4)NOT NULLAssociated client payroll item.
Primary key
NameColumnsDescription
PK_Federal_Tax_Exemptionfederal_tax_exemption_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Federal_Tax_Exemption__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Federal_Tax_Exemption__Federal_Tax_Exemption_Type__federal_tax_exemption_type_KEYfederal_tax_exemption_type_KEYFederal_Tax_Exemption_Type (federal_tax_exemption_type_KEY)

Schema diagram