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
NameTypeConstraintsDescription
skipped_check_number_KEYint (4)NOT NULLPrimary Key for this table.
checkbook_KEYint (4)NOT NULLCheckbook the skipped number is associated with.
numberint (4)NOT NULLThe number we skipped.
Primary key
NameColumnsDescription
PK_Skipped_Check_Numberskipped_check_number_KEY
Unique constraints
NameColumnsDescription
UK_Skipped_Check_Number$checkbook_KEY$numbercheckbook_KEY, number
Foreign keys
NameColumnsReferenced tableDescription
FK_Skipped_Check_Number__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)

Schema diagram