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
Name | Type | Constraints | Description
engagement_item_note_KEY | int (4) | NOT NULL | Primary key. This points to record in the Processing_Note table.
engagement_binder_KEY | int (4) |  | Foreign key. This points to record in the Binder table. This note exists at the binder level
folder_KEY | int (4) |  | Foreign key. This points to record in the folder table. This note is present in the folder.
workpaper_KEY | int (4) |  | Foreign key. This points to record in the workpaper table. The note is present at the workpaper level.
engagement_item_note_status_KEY | int (4) | NOT NULL | This is the status of the note, which is either cleared, open or reviewed.
priority_KEY | int (4) | NOT NULL | This indicates if the note priority.
assigned_to__staff_KEY | int (4) |  | This is the staff the note is assigned to.
note_subject | nvarchar (100) | NOT NULL | This has the subject of the note.
sequence_number | int (4) | NOT NULL |
created_date | datetime (8, 3) | NOT NULL | The date the note was created.
created_date__staff_KEY | int (4) |  | The ID of the staff who created the note.

Primary key
Name | Columns | Description
PK_Engagement_Item_Note | engagement_item_note_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Engagement_Item_Note__Engagement_Binder__engagement_binder_KEY | engagement_binder_KEY | Engagement_Binder (engagement_binder_KEY) |
FK_Engagement_Item_Note__Engagement_Item_Note_Status__engagement_item_note_status_KEY | engagement_item_note_status_KEY | Engagement_Item_Note_Status (engagement_item_note_status_KEY) |
FK_Engagement_Item_Note__Folder__folder_KEY | folder_KEY | Folder (folder_KEY) |
FK_Engagement_Item_Note__Priority__priority_KEY | priority_KEY | Priority (priority_KEY) |
FK_Engagement_Item_Note__Staff__assigned_to__staff_KEY | assigned_to__staff_KEY | Staff (staff_KEY) |
FK_Engagement_Item_Note__Staff__created_date__staff_KEY | created_date__staff_KEY | Staff (staff_KEY) |
FK_Engagement_Item_Note__Workpaper__workpaper_KEY | workpaper_KEY | Workpaper (workpaper_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Processing_Note__Engagement_Item_Note__engagement_item_note_KEY | engagement_item_note_KEY | Processing_Note |