Table: dbo.Processing_Note
Columns
NameTypeConstraintsDescription
processing_note_KEYint (4)NOT NULLPrimary key for the Processing_Note table
client_KEYint (4)NOT NULLKey to associated client.
notenvarchar (8000)NOT NULLXML text representing the processing note with formatting included.
created_datedatetime (8, 3)NOT NULLThe date the note was originally created.
created_date__staff_KEYint (4)The staff ID of the user who created the note.
edited_datedatetime (8, 3)NOT NULLThe date the note was last edited.
edited_date__staff_KEYint (4)The staff ID of the user who last edited the note.
processing_note_category_KEYint (4)NOT NULLKey to type of note.
engagement_item_note_KEYint (4)The foreign key to the engagement_item_note table.
processing_note_type_KEYint (4)NOT NULLThe type of note this record is for
sequence_numberint (4)NOT NULLThe placement of this note relative to other notes of the same type
Primary key
NameColumnsDescription
PK_Processing_Noteprocessing_note_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Processing_Note__Client__client_KEYclient_KEYClient (client_KEY)
FK_Processing_Note__Engagement_Item_Note__engagement_item_note_KEYengagement_item_note_KEYEngagement_Item_Note (engagement_item_note_KEY)
FK_Processing_Note__Processing_Note_Category__processing_note_category_KEYprocessing_note_category_KEYProcessing_Note_Category (processing_note_category_KEY)
FK_Processing_Note__Processing_Note_Type__processing_note_type_KEYprocessing_note_type_KEYProcessing_Note_Type (processing_note_type_KEY)
FK_Processing_Note__Staff__created_date__staff_KEYcreated_date__staff_KEYStaff (staff_KEY)
FK_Processing_Note__Staff__edited_date__staff_KEYedited_date__staff_KEYStaff (staff_KEY)

Schema diagram