Table: dbo.Folder
This table contains information needed for describing a folder in the engagement binder tree.
Columns
NameTypeConstraintsDescription
folder_KEYint (4)NOT NULLPrimary key. The column that identifies each folder record.
descriptionnvarchar (250)NOT NULLFolder description, the display name of the folder, cannot be null or empty.
engagement_binder_KEYint (4)NOT NULLForeign key. The link to the engagement binder this folder belongs to, cannot be null.
workpaper_reference_prefixnvarchar (40)NOT NULLThe 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_incrementint (4)NOT NULLThis 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_suffixint (4)NOT NULLThe 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_KEYint (4)NOT NULLDetermines which type of folder this record represents.
Primary key
NameColumnsDescription
PK_Folderfolder_KEY
Unique constraints
NameColumnsDescription
UK_Folder$description$engagement_binder_KEYdescription, engagement_binder_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Folder__Engagement_Binder__engagement_binder_KEYengagement_binder_KEYEngagement_Binder (engagement_binder_KEY)
FK_Folder__Engagement_Folder_Type__engagement_folder_type_KEYengagement_folder_type_KEYEngagement_Folder_Type (engagement_folder_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Folder_N_Source_Document_Processing_Sort_Order__Folder__folder_KEYfolder_KEYFolder_N_Source_Document_Processing_Sort_Order
FK_Engagement_Item_Note__Folder__folder_KEYfolder_KEYEngagement_Item_Note
FK_Engagement_Binder_Tree_Item__Folder__folder_KEYfolder_KEYEngagement_Binder_Tree_Item
FK_Folder_N_Source_Document_Processing_Tax_Organizer_Sort_Order__Folder__folder_KEYfolder_KEYFolder_N_Source_Document_Processing_Tax_Organizer_Sort_Order

Schema diagram