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
Name | Type | Constraints | Description
checkbook_KEY | int (4) | NOT NULL | The key of the parent checkbook record (Once, but no longer, composite primary key with staff_KEY).
staff_KEY | int (4) | NOT NULL | The 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_KEY | int (4) | NOT NULL | The 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
Name | Columns | Description
PK_Staff_With_Access_To_Checkbook | staff_with_access_to_checkbook_KEY |
Unique constraints
Name | Columns | Description
UK_Staff_With_Access_To_Checkbook$checkbook_KEY$staff_KEY | checkbook_KEY, staff_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Staff_With_Access_To_Checkbook__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Staff_With_Access_To_Checkbook__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |