| Table: dbo.Skipped_Direct_Deposit_Voucher_Id | |||
| Each record lists a voucher id that we tried to use but for some reason were not able to, and we choose not to return to the pool of available voucher ids. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| skipped_direct_deposit_voucher_id_KEY | int (4) | NOT NULL | Primary Key for this table. |
| checkbook_KEY | int (4) | NOT NULL | Checkbook the skipped number is associated with. |
| number | decimal (9) | NOT NULL | The numeric portion of the voucher id we skipped. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Skipped_Direct_Deposit_Voucher_Id | skipped_direct_deposit_voucher_id_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Skipped_Direct_Deposit_Voucher_Id__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) | |