Table: dbo.Transaction_Template_Note
This table is used to store a note associated with a transaction template. A transaction template may have multiple notes associated with it.
Columns
NameTypeConstraintsDescription
transaction_template_note_KEYint (4)NOT NULLPrimary key for this table.
transaction_template_KEYint (4)NOT NULLA key linking this note to a transaction template.
notenvarchar (2048)NOT NULLThe note to be stored for the transaction template.
Primary key
NameColumnsDescription
PK_Transaction_Template_Notetransaction_template_note_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Transaction_Template_Note__Transaction_Template__transaction_template_KEYtransaction_template_KEYTransaction_Template (transaction_template_KEY)

Schema diagram