Description
The test set folder tree.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | CF_ITEM_ID | The record ID. | int | 4 | |||
| CF_ITEM_NAME | The folder name. | varchar | 255 |  | |||
| CF_ITEM_PATH | The highest level node has path AAA. Each child node down the tree inherits the parent path and adds three letters,where the current level numeration is concatenated to the inherited path. For example, the child requirements of the first node (AAA) have paths of AAAAAA, AAAAAB, AAAAAC, and so on. The characters V and W are not used. | varchar | 255 | ||||
| CF_FATHER_ID | The CF_ITEM_ID of the folder containing this item. Root folders have CF_FATHER_ID = 0. | int | 4 | | |||
| CF_VIEW_ORDER | The order in which the folder appears among other children of the same parent folder. | int | 4 | | |||
| CF_WORKFLOW | For backward compatibility. Field may be removed in future version. | varchar | 16 | | |||
| CF_ATTACHMENT | A value of Y indicates that the folder has at least one attachment. | varchar | 1 | | |||
| CF_VER_STAMP | The revision number of this record. Increments each time the record is updated. | int | 4 | | |||
| CF_VTS | The version time stamp. The time the record was last changed according the the database server clock. | varchar | 20 | | |||
| CF_DESCR | A description of the folder. | varchar | 16 | | |||
| CF_NO_OF_SONS | Not use from ALM 11.00. | int | 4 | | |||
| CF_ASSIGN_RCYC | The RELEASE_CYCLES.RCYC_ID of the release cycle with which the folder is associated. | int | 4 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| CF_FATHER_NAME_ID | | ||
| CF_ITEM_PATH_IDX | | ||
| CF_PRIMARYKEY | | |
See Also