Table: dbo.Report_Folder_Type
Table that houses the different system folder types that will be used.
Columns
NameTypeConstraintsDescription
report_folder_type_KEYint (4)NOT NULLPrimary Key for this table.
descriptionnvarchar (40)NOT NULLUnique description of each report folder type.
Primary key
NameColumnsDescription
PK_Report_Folder_Typereport_folder_type_KEY
Unique constraints
NameColumnsDescription
UK_Report_Folder_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Report_Folder__Report_Folder_Type__report_folder_type_KEYreport_folder_type_KEYReport_Folder

Schema diagram