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
Name | Type | Constraints | Description
report_folder_KEY | int (4) | NOT NULL | Primary Key for this table.
report_folder_type_KEY | int (4) | NOT NULL | Designates what kind category this folder will be stored under.
is_system_defined_folder | bit (1) | NOT NULL | Was this a user-defined or system-defined folder?
sequence_number_sbpr | int (4) | NOT NULL | Determines 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
description | nvarchar (300) | NOT NULL | Name of user-defined or system-defined folder.
sequence_number_non_sbpr | int (4) | NOT NULL | Determines 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
Name | Columns | Description
PK_Report_Folder | report_folder_KEY |
Unique constraints
Name | Columns | Description
UK_Report_Folder$report_folder_type_KEY$description | report_folder_type_KEY, description |

Foreign keys
Name | Columns | Referenced table | Description
FK_Report_Folder__Report_Folder_Type__report_folder_type_KEY | report_folder_type_KEY | Report_Folder_Type (report_folder_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Report_Definition__Report_Folder__report_folder_KEY | report_folder_KEY | Report_Definition |
FK_Client_N_Report_Folder__Report_Folder__report_folder_KEY | report_folder_KEY | Client_N_Report_Folder |