Table: dbo.Report_Folder
Table that holds system and user-defined folders that house reports/financial statements/letters.["BR"]The last record has 999 for the PK value so we have a reserve int padding for future system defined folders.
Columns
NameTypeConstraintsDescription
report_folder_KEYint (4)NOT NULLPrimary Key for this table.
report_folder_type_KEYint (4)NOT NULLDesignates what kind category this folder will be stored under.
is_system_defined_folderbit (1)NOT NULLWas this a user-defined or system-defined folder?
sequence_number_sbprint (4)NOT NULLDetermines sort order among sibling folders. Since this sequence number value may not ["BR"]be unique across sibling folders, never sort by this column alone; always include the report_folder_KEY column as a secondary sort criteria
descriptionnvarchar (300)NOT NULLName of user-defined or system-defined folder.
sequence_number_non_sbprint (4)NOT NULLDetermines sort order among sibling folders for NON-SBPR. Since this sequence number value may not ["BR"]be unique across sibling folders, never sort by this column alone; always include the report_folder_KEY column as a secondary sort criteria
Primary key
NameColumnsDescription
PK_Report_Folderreport_folder_KEY
Unique constraints
NameColumnsDescription
UK_Report_Folder$report_folder_type_KEY$descriptionreport_folder_type_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_Report_Folder__Report_Folder_Type__report_folder_type_KEYreport_folder_type_KEYReport_Folder_Type (report_folder_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Report_Definition__Report_Folder__report_folder_KEYreport_folder_KEYReport_Definition
FK_Client_N_Report_Folder__Report_Folder__report_folder_KEYreport_folder_KEYClient_N_Report_Folder

Schema diagram