Description
Test Plan folders.
Remarks
For other system and custom lists and folder trees, see the LISTS table.
Folder structures are recreated with a self-join of ALL_LISTS parent and ALL_LISTS child where child.AL_FATHER_ID = parent.AL_ITEM_ID. For top level nodes, AL_FATHER_ID = 0.
In addition, each child node inherits the AL_ABSOLUTE_PATH of its parent node and appends three more characters. For example, the children of the node with path AAA have paths AAAAAA, AAAAAB, AAAAAC, and so on.
The characters V and W are not used.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | AL_ITEM_ID | The record ID. | int | 4 | |||
| AL_FATHER_ID | The ID of the parent folder, list, or list item. Tree and list roots have AL_FATHER_ID = 0. | int | 4 |  | |||
| AL_DESCRIPTION | The item description. | varchar | 255 | | |||
| AL_NO_OF_SONS | Obsolete. | int | 4 | | |||
| AL_SYSTEM | The permissions for the item: R - read-only but can add sub-folders. S - system field (ALM does not permit changes to this field). A - all actions are available. C - can change but not delete. | varchar | 1 | | |||
| AL_ABSOLUTE_PATH | An alphabetic code showing the tree structure. The characters V and W are not used. | varchar | 255 | ||||
| AL_VIEW_ORDER | For internal use. | int | 4 | | |||
| AL_MEMO | A descriptive comment. | varchar | 16 | | |||
| AL_ATTACHMENT | A Value of Y indicates that the item has at least one attachment. | varchar | 1 | | |||
| AL_ITEM_VERSION | For backward compatibility. Field may be removed in future version. | int | 4 | | |||
| AL_VER_STAMP | The revision number of this item. Increments each time the record is updated. | int | 4 | | |||
| AL_VTS | The version time stamp. Indicates the database-server time the record was last changed. | varchar | 20 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| AL_ABSOLUTE_PATH_IDX | | ||
| AL_FATHER_DESC_LWR_IDX | | ||
| AL_PRIMARYKEY | | |
See Also