Table: dbo.Quick_Books_Account_N_Checkbook
This table will have an entry for every quickbooks gl account of type Bank that is mapped to an acs checking account.
Columns
NameTypeConstraintsDescription
quick_books_account_KEYint (4)NOT NULLThe key which links us to a quickbooks account table record.
checkbook_KEYint (4)NOT NULLThe key which links us to a checkbook table record.
Primary key
NameColumnsDescription
PK_Quick_Books_Account_N_Checkbook$quick_books_account_KEYquick_books_account_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Account_N_Checkbook__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)
FK_Quick_Books_Account_N_Checkbook__Quick_Books_Account__quick_books_account_KEYquick_books_account_KEYQuick_Books_Account (quick_books_account_KEY)

Schema diagram