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. |
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 |