Share this page
ALM Project Database Reference
td.ANALYSIS_ITEM_FOLDERS Table
Description
Folders for reports and graphs.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | AIF_ID | The record ID. | int | 4 | |||
| AIF_PARENT_ID | If top-level folder, 0. Otherwise the AIF_ID of the parent folder. | int | 4 | ||||
| AIF_NAME | The folder name. | varchar | 255 | ||||
| AIF_LOGICAL_NAME | A name, unique in the scope of this table, that refers to this record. | varchar | 64 | ||||
| AIF_DESCRIPTION | The folder description. | varchar | 16 |  | |||
| AIF_PATH | The position in the tree. The format is AAAAA, AAAAB, and so on. The characters V and W are not used. | varchar | 255 | ||||
| AIF_IS_PUBLIC | If Y, the folder is public. If N, the folder is private. | varchar | 1 | | |||
| AIF_OWNER | For public folders, the user name who created the item. For private folders, the user name of the current owner. | varchar | 60 | ||||
| AIF_VER_STAMP | The version of the item. | int | 4 | ||||
| AIF_SEGMENT_ID | The ANALYSIS_SEGMENTS.AS_ID of the segment in which this item is presented in the user interface. | int | 4 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| AI_FOLDERS_UNIQUE_NAME | | ||
| ANALYSIS_ITEM_FOLDERS_LWR_UIX1 | | ||
| ANALYSIS_ITEM_FOLDERS_PK | | | |
| ANALYSIS_ITEM_FOLDERS_UIX2 | |
See Also
Related Objects
