Table: dbo.Reprintable_Bank_Transaction
This table is the master list of all bank transactions that may be reprinted because they were stored for reprinting during their initial printing.
Columns
NameTypeConstraintsDescription
bank_transaction_KEYint (4)NOT NULLKey that uniquely identifies each row of the table and links to a record in table Bank_Transaction.
reprintable_print_job_KEYint (4)NOT NULLForeign key to table Reprintable_Print_Job that allows us to tie back to the staff who originally printed checks and also to the date of printing.
report_definition_KEYint (4)NOT NULLForeign key to table Report_Definition to identify the layout paired with the bank transaction during its initial printing.
original_report_definition_checksumdecimal (9)NOT NULLUse this to compare later to column checksum in table Report_Definition to see if the user changed the layout since the original print job.
Primary key
NameColumnsDescription
PK_Reprintable_Bank_Transaction$bank_transaction_KEYbank_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Reprintable_Bank_Transaction$bank_transaction_KEYbank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Reprintable_Bank_Transaction__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Reprintable_Bank_Transaction__Report_Definition__report_definition_KEYreport_definition_KEYReport_Definition (report_definition_KEY)
FK_Reprintable_Bank_Transaction__Reprintable_Print_Job__reprintable_print_job_KEYreprintable_print_job_KEYReprintable_Print_Job (print_job_KEY)

Schema diagram