Table: dbo.Folder
This table contains information needed for describing a folder in the engagement binder tree.
Columns
Name | Type | Constraints | Description
folder_KEY | int (4) | NOT NULL | Primary key. The column that identifies each folder record.
description | nvarchar (250) | NOT NULL | Folder description, the display name of the folder, cannot be null or empty.
engagement_binder_KEY | int (4) | NOT NULL | Foreign key. The link to the engagement binder this folder belongs to, cannot be null.
workpaper_reference_prefix | nvarchar (40) | NOT NULL | The default workpaper reference string. This value is used to generate unique references for workpapers added to this folder. ["BR"] This column acts as a prefix for the reference being generated and digits(the value from workpaper_reference_suffix_increment column)will be appended to the end to create a unique workpaper reference.
workpaper_reference_suffix_increment | int (4) | NOT NULL | This increment value will be added to the workpaper_reference_last_used_suffix value to determine the next suffix that will be appended to the workpaper_reference_prefix in order to generate a hopefully unique workpaper reference.
workpaper_reference_last_used_suffix | int (4) | NOT NULL | The hghest value by which the workpaper reference was incremented by.["BR"] This column always stores the last used suffix value. If the value is -1, it indicates a suffix value has not been used for this folder yet, no workpaper references were generated. ["BR"] A zero value means one workpaper reference was generated but without appending a suffix value (the workpaper_reference_prefix value was used as the workpaper’s reference.
engagement_folder_type_KEY | int (4) | NOT NULL | Determines which type of folder this record represents.

Primary key
Name | Columns | Description
PK_Folder | folder_KEY |
Unique constraints
Name | Columns | Description
UK_Folder$description$engagement_binder_KEY | description, engagement_binder_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Folder__Engagement_Binder__engagement_binder_KEY | engagement_binder_KEY | Engagement_Binder (engagement_binder_KEY) |
FK_Folder__Engagement_Folder_Type__engagement_folder_type_KEY | engagement_folder_type_KEY | Engagement_Folder_Type (engagement_folder_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Folder_N_Source_Document_Processing_Sort_Order__Folder__folder_KEY | folder_KEY | Folder_N_Source_Document_Processing_Sort_Order |
FK_Engagement_Item_Note__Folder__folder_KEY | folder_KEY | Engagement_Item_Note |
FK_Folder_N_Source_Document_Processing_Tax_Organizer_Sort_Order__Folder__folder_KEY | folder_KEY | Folder_N_Source_Document_Processing_Tax_Organizer_Sort_Order |
FK_Engagement_Binder_Tree_Item__Folder__folder_KEY | folder_KEY | Engagement_Binder_Tree_Item |