Table: dbo.Firm_Contact_Payroll_Tax_Information
Columns
NameTypeConstraintsDescription
firm_contact_payroll_tax_information_KEYint (4)NOT NULLTable primary key
firm_KEYint (4)NOT NULLForeign key to the Firm table to enforce constraint that every entry needs be associated with a Firm and so that associated client can be easily found if needed
contact_KEYint (4)NOT NULLForeign key to the Contact table
Primary key
NameColumnsDescription
PK_Firm_Contact_Payroll_Tax_Informationfirm_contact_payroll_tax_information_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Firm_Contact_Payroll_Tax_Information__Contact__contact_KEYcontact_KEYContact (contact_KEY)
FK_Firm_Contact_Payroll_Tax_Information__Firm__firm_KEYfirm_KEYFirm (firm_KEY)

Schema diagram