Table: dbo.Quick_Books_Online_Integration_License_Agreement
this table tells records the staff id and staff name of the staff member that accepted a version of the quickbooks online integration license agreement. Firms that use quickbooks online integration will need a record in this table for the current license agreement and the primary key constant that matches the current license agreement. Firms that do not use quickbooks online integration will not have a record in this table. Updates to the license agreement would result in new records being added to this table with a new primary key constant for the firms using quickbooks online integration, once a staff member accepts the new version of the license agreement.
Columns
NameTypeConstraintsDescription
quick_books_online_integration_license_agreement_KEYint (4)NOT NULLPrimary Key for this table. Each license agreement key needs to be paired with a version of the license agreement text. The key value currently in use for this table for a new record always comes from a constant stored in the code that is paired with the current license agreement text. We will start with one and increment by one if and when the license agreement is updated, which would require a new record in this table for firms using quickbooks online integration.
staff_idnvarchar (22)NOT NULLThe staff ID of the staff member who accepted the license agreement.
first_namenvarchar (60)NOT NULLThe first name of the staff member who accepted the license agreement.
middle_namenvarchar (60)NOT NULLThe middle name of the staff member who accepted the license agreement.
last_namenvarchar (60)NOT NULLThe last name of the staff member who accepted the license agreement.
date_of_acceptance_utcdatetime (8, 3)NOT NULLThe date of when a license agreement version was accepted. This date should be a UTC date and time.
Primary key
NameColumnsDescription
PK_Quick_Books_Online_Integration_License_Agreementquick_books_online_integration_license_agreement_KEY

Schema diagram