Table: dbo.Staff_With_Access_To_Checkbook
This table lists the staff allowed to access a checkbook. If there are no records in this table for a checkbook, then, all["BR"] staff with access to the checkbook's client will have access to the checkbook. If there are records in this table, then only those["BR"] staff will have access to the checkbook.
Columns
NameTypeConstraintsDescription
checkbook_KEYint (4)NOT NULLThe key of the parent checkbook record (Once, but no longer, composite primary key with staff_KEY).
staff_KEYint (4)NOT NULLThe key of the parent staff record that has access to the associated checkbook (Once, but no longer, composite primary key with checkbook_KEY).
staff_with_access_to_checkbook_KEYint (4)NOT NULLThe frustratingly needed surrogate key to avoid a bug in CDAL T-SQL generation related to deletion of rows from tables with multi-column keys
Primary key
NameColumnsDescription
PK_Staff_With_Access_To_Checkbookstaff_with_access_to_checkbook_KEY
Unique constraints
NameColumnsDescription
UK_Staff_With_Access_To_Checkbook$checkbook_KEY$staff_KEYcheckbook_KEY, staff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_With_Access_To_Checkbook__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)
FK_Staff_With_Access_To_Checkbook__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram