Table: dbo.Bank_Feeds_License_Agreement
this table tells records the staff id and staff name of the staff member that accepted a version of the bank feeds license agreement. Firms that use bank feeds 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 bank feeds 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 bank feeds, once a staff member accepts the new version of the license agreement.
Columns
NameTypeConstraintsDescription
bank_feeds_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 bank feeds.
date_of_acceptancesmalldatetime (4)NOT NULLThe date of when a license agreement version was accepted.
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.
Primary key
NameColumnsDescription
PK_Bank_Feeds_License_Agreementbank_feeds_license_agreement_KEY

Schema diagram