Contains the information for managing folders
Data model
Fields
| Field |
Type |
Description |
| ctg_caption |
NVARCHAR (200) |
Represents the name of the folder |
| ctg_imageindex |
INT |
Icon ID related to the folder |
| ctg_index* |
INT |
Unique identifier of folders |
| ctg_parent |
INT |
Parent folder ID, table reference ASMS_FOLDER.ctg_index |
| ctg_project_id |
INT |
Associated project ID, reference table ASMS_PROJECTS.proj_id |
| fl_int_image_id |
INT |
Identifier of the image related to the folder |
| fl_int_status_id |
INT |
Determines the status of the folder (Active = 1, Inactive = 0) |
| fl_str_description |
NVARCHAR (MAX) |
Folder description |
| fl_str_hierarchy |
NVARCHAR (4000) |
Represents the Hierarchy of the folder |
| fl_str_image |
NVARCHAR (MAX) |
Folder image name |
Primary Key
References
