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.
|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_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.
|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|