Table: dbo.Engagement_Item_Note
This table stores the information about the association of notes with either the binder, the folder or the workpaper.
Columns
NameTypeConstraintsDescription
engagement_item_note_KEYint (4)NOT NULLPrimary key. This points to record in the Processing_Note table.
engagement_binder_KEYint (4)Foreign key. This points to record in the Binder table. This note exists at the binder level
folder_KEYint (4)Foreign key. This points to record in the folder table. This note is present in the folder.
workpaper_KEYint (4)Foreign key. This points to record in the workpaper table. The note is present at the workpaper level.
engagement_item_note_status_KEYint (4)NOT NULLThis is the status of the note, which is either cleared, open or reviewed.
priority_KEYint (4)NOT NULLThis indicates if the note priority.
assigned_to__staff_KEYint (4)This is the staff the note is assigned to.
note_subjectnvarchar (100)NOT NULLThis has the subject of the note.
sequence_numberint (4)NOT NULL
created_datedatetime (8, 3)NOT NULLThe date the note was created.
created_date__staff_KEYint (4)The ID of the staff who created the note.
Primary key
NameColumnsDescription
PK_Engagement_Item_Noteengagement_item_note_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Engagement_Item_Note__Engagement_Binder__engagement_binder_KEYengagement_binder_KEYEngagement_Binder (engagement_binder_KEY)
FK_Engagement_Item_Note__Engagement_Item_Note_Status__engagement_item_note_status_KEYengagement_item_note_status_KEYEngagement_Item_Note_Status (engagement_item_note_status_KEY)
FK_Engagement_Item_Note__Folder__folder_KEYfolder_KEYFolder (folder_KEY)
FK_Engagement_Item_Note__Priority__priority_KEYpriority_KEYPriority (priority_KEY)
FK_Engagement_Item_Note__Staff__assigned_to__staff_KEYassigned_to__staff_KEYStaff (staff_KEY)
FK_Engagement_Item_Note__Staff__created_date__staff_KEYcreated_date__staff_KEYStaff (staff_KEY)
FK_Engagement_Item_Note__Workpaper__workpaper_KEYworkpaper_KEYWorkpaper (workpaper_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Processing_Note__Engagement_Item_Note__engagement_item_note_KEYengagement_item_note_KEYProcessing_Note

Schema diagram