Table: dbo.Skipped_Check_Number | |||
Each record lists a number that we tried to use but for some reason were not able to, and we choose not to return to the pool of available numbers. | |||
Columns | |||
Name | Type | Constraints | Description |
skipped_check_number_KEY | int (4) | NOT NULL | Primary Key for this table. |
checkbook_KEY | int (4) | NOT NULL | Checkbook the skipped number is associated with. |
number | int (4) | NOT NULL | The number we skipped. |
Primary key | |||
Name | Columns | Description | |
PK_Skipped_Check_Number | skipped_check_number_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Skipped_Check_Number$checkbook_KEY$number | checkbook_KEY, number |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Skipped_Check_Number__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |