Table: dbo.Client_Contact_Payroll_Administrator
This table contains the details of Payroll Administrator checkbox selected in Additional Contacts.
Columns
NameTypeConstraintsDescription
client_contact_payroll_administrator_KEYint (4)NOT NULLPrimary key.
client_KEYint (4)NOT NULLClient Key.
contact_KEYint (4)NOT NULLContact Key.
onvio_contact_payroll_idnvarchar (64)Onvio contact payroll admin identifier
Primary key
NameColumnsDescription
PK_Client_Contact_Payroll_Administratorclient_contact_payroll_administrator_KEY
Unique constraints
NameColumnsDescription
UK_Client_Contact_Payroll_Administrator$contact_KEYcontact_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Contact_Payroll_Administrator__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_Contact_Payroll_Administrator__Contact__contact_KEYcontact_KEYContact (contact_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Onvio_Payroll_Integration_Queue__Client_Contact_Payroll_Administrator__client_contact_payroll_administrator_KEYclient_contact_payroll_administrator_KEYOnvio_Payroll_Integration_Queue

Schema diagram