Contains the information for managing folders
Data model
Fields
| Field | Type | Description |
|---|---|---|
| folder_id* | INT | Folder ID, table reference ASMS_FOLDER.ctg_index |
| item_id* | INT | Item Type Identifier (Service, Item, CI) |
| type_id* | INT | Folder ID, reference the ASMS_TYPES.id table |
Primary Key
| PK_ASMS_FOLDER_ITEM |
|---|
| type_id, folder_id, item_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| folder_id* | dbo.ASMS_FOLDER | ctg_index | FK02_ASMS_FOLDER_ITEM |
| type_id* | dbo.ASMS_TYPES | id | FK01_ASMS_FOLDER_ITEM |