Table: dbo.Processing_Note | |||
Columns | |||
Name | Type | Constraints | Description |
processing_note_KEY | int (4) | NOT NULL | Primary key for the Processing_Note table |
client_KEY | int (4) | NOT NULL | Key to associated client. |
note | nvarchar (8000) | NOT NULL | XML text representing the processing note with formatting included. |
created_date | datetime (8, 3) | NOT NULL | The date the note was originally created. |
created_date__staff_KEY | int (4) | The staff ID of the user who created the note. | |
edited_date | datetime (8, 3) | NOT NULL | The date the note was last edited. |
edited_date__staff_KEY | int (4) | The staff ID of the user who last edited the note. | |
processing_note_category_KEY | int (4) | NOT NULL | Key to type of note. |
engagement_item_note_KEY | int (4) | The foreign key to the engagement_item_note table. | |
processing_note_type_KEY | int (4) | NOT NULL | The type of note this record is for |
sequence_number | int (4) | NOT NULL | The placement of this note relative to other notes of the same type |
Primary key | |||
Name | Columns | Description | |
PK_Processing_Note | processing_note_KEY |