Table: dbo.Client_Contact_Payroll_Tax_Information
The prescence of a record in this table for a given client contact indicates that the contact is the client payroll tax form signer.
Columns
NameTypeConstraintsDescription
client_contact_payroll_tax_information_KEYint (4)NOT NULLTable primary key
client_KEYint (4)NOT NULLForeign key to the Client table to enforce constraint that every entry needs be associated with a Client 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_Client_Contact_Payroll_Tax_Informationclient_contact_payroll_tax_information_KEY
Unique constraints
NameColumnsDescription
UK_Client_Contact_Payroll_Tax_Information$contact_KEYcontact_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Contact_Payroll_Tax_Information__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_Contact_Payroll_Tax_Information__Contact__contact_KEYcontact_KEYContact (contact_KEY)

Schema diagram