Table: dbo.Check_Print_Run
Columns
NameTypeConstraintsDescription
check_print_run_KEYint (4)NOT NULLPrimary key
print_datedatetime (8, 3)NOT NULLThe date the print run was completed.
staff_KEYint (4)NOT NULLPK of staff who initiated the print job
check_print_run_guiduniqueidentifier (16)NOT NULLA unique identifer for each check print run row.
Primary key
NameColumnsDescription
PK_Check_Print_Runcheck_print_run_KEY
Unique constraints
NameColumnsDescription
UK_Check_Print_Run$check_print_run_guidcheck_print_run_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Check_Print_Run__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Check_Print_Run_N_Bank_Transaction__Check_Print_Run__check_print_run_KEYcheck_print_run_KEYCheck_Print_Run_N_Bank_Transaction
FK_Billable_Item_N_Check_Print_Run__Check_Print_Run__check_print_run_KEYcheck_print_run_KEYBillable_Item_N_Check_Print_Run
FK_Print_Payable_Transaction_Selection__Check_Print_Run__check_print_run_KEYcheck_print_run_KEYPrint_Payable_Transaction_Selection
FK_Print_Check_Selection__Check_Print_Run__check_print_run_KEYcheck_print_run_KEYPrint_Check_Selection

Schema diagram