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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Processing_Note__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Processing_Note__Engagement_Item_Note__engagement_item_note_KEY | engagement_item_note_KEY | Engagement_Item_Note (engagement_item_note_KEY) |
FK_Processing_Note__Processing_Note_Category__processing_note_category_KEY | processing_note_category_KEY | Processing_Note_Category (processing_note_category_KEY) |
FK_Processing_Note__Processing_Note_Type__processing_note_type_KEY | processing_note_type_KEY | Processing_Note_Type (processing_note_type_KEY) |
FK_Processing_Note__Staff__created_date__staff_KEY | created_date__staff_KEY | Staff (staff_KEY) |
FK_Processing_Note__Staff__edited_date__staff_KEY | edited_date__staff_KEY | Staff (staff_KEY) |