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
Name | Type | Constraints | Description
quick_books_online_integration_license_agreement_KEY | int (4) | NOT NULL | Primary 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_id | nvarchar (22) | NOT NULL | The staff ID of the staff member who accepted the license agreement.
first_name | nvarchar (60) | NOT NULL | The first name of the staff member who accepted the license agreement.
middle_name | nvarchar (60) | NOT NULL | The middle name of the staff member who accepted the license agreement.
last_name | nvarchar (60) | NOT NULL | The last name of the staff member who accepted the license agreement.
date_of_acceptance_utc | datetime (8, 3) | NOT NULL | The date of when a license agreement version was accepted. This date should be a UTC date and time.

Primary key
Name | Columns | Description
PK_Quick_Books_Online_Integration_License_Agreement | quick_books_online_integration_license_agreement_KEY |