Table: dbo.State_Tax_Exemption
Columns
NameTypeConstraintsDescription
state_tax_exemption_KEYint (4)NOT NULLPrimary key for the State_Tax_Exemption table.
state_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_State_Tax_Exemptionstate_tax_exemption_KEY
Unique constraints
NameColumnsDescription
UK_State_Tax_Exemption$client_payroll_item_KEY$state_tax_exemption_type_KEYclient_payroll_item_KEY, state_tax_exemption_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_State_Tax_Exemption__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_State_Tax_Exemption__State_Tax_Exemption_Type__state_tax_exemption_type_KEYstate_tax_exemption_type_KEYState_Tax_Exemption_Type (state_tax_exemption_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_State_Tax_Exemption_Detail__State_Tax_Exemption__state_tax_exemption_KEYstate_tax_exemption_KEYState_Tax_Exemption_Detail

Schema diagram