Table: dbo.Check_Print_Run_N_Bank_Transaction
Dictionary table which links a print run and related bank transactions.
Columns
NameTypeConstraintsDescription
check_print_run_N_bank_transaction_KEYint (4)NOT NULLPrimary Key
check_print_run_KEYint (4)NOT NULLFK to Check_Print_Run
bank_transaction_KEYint (4)NOT NULLFK to Bank_Transaction
Primary key
NameColumnsDescription
PK_Check_Print_Run_N_Bank_Transactioncheck_print_run_N_bank_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Check_Print_Run_N_Bank_Transaction$check_print_run_KEY$bank_transaction_KEYcheck_print_run_KEY, bank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Check_Print_Run_N_Bank_Transaction__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Check_Print_Run_N_Bank_Transaction__Check_Print_Run__check_print_run_KEYcheck_print_run_KEYCheck_Print_Run (check_print_run_KEY)

Schema diagram