Project Data Tables Database > td Schema : td.ANALYSIS_ITEM_FOLDERS Table |
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 |
Index | Description | Primary | Unique |
---|---|---|---|
AI_FOLDERS_UNIQUE_NAME | |||
ANALYSIS_ITEM_FOLDERS_LWR_UIX1 | |||
ANALYSIS_ITEM_FOLDERS_PK | |||
ANALYSIS_ITEM_FOLDERS_UIX2 |