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 | |||
Name | Type | Constraints | Description |
transaction_template_note_KEY | int (4) | NOT NULL | Primary key for this table. |
transaction_template_KEY | int (4) | NOT NULL | A key linking this note to a transaction template. |
note | nvarchar (2048) | NOT NULL | The note to be stored for the transaction template. |
Primary key | |||
Name | Columns | Description | |
PK_Transaction_Template_Note | transaction_template_note_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Transaction_Template_Note__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Transaction_Template (transaction_template_KEY) |