Table: dbo.GL_Transaction_Note
Columns
NameTypeConstraintsDescription
gl_transaction_note_KEYint (4)NOT NULLPrimary key
gl_transaction_KEYint (4)NOT NULLForeign key to the bank transaction table
is_accountant_notebit (1)NOT NULLBoolean that indicates if the note is for the accountant
notenvarchar (2048)NOT NULLThe actual note text
Primary key
NameColumnsDescription
PK_GL_Transaction_Notegl_transaction_note_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Transaction_Note__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction (gl_transaction_KEY)

Schema diagram