Project Data Tables Database > td Schema : td.COMPONENT_FOLDER Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
FC_ID | The record ID. | int | 4 | ||||
FC_FATHER_ID | The FC_ID of the folder containing this folder. The initial folders created automatically with a new project have an FC_FATHER_ID of 0. | int | 4 | ||||
FC_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 | ||||
FC_NAME | The folder name. | varchar | 255 | ||||
FC_DESC | The folder description. | varchar | 16 | ||||
FC_LOGICAL_PATH | For future use. | varchar | 255 | ||||
FC_VER_STAMP | Increments each time the record is changed. | int | 4 |
Index | Description | Primary | Unique |
---|---|---|---|
FC_FATHER_NAME_IDX | |||
FC_PATH_IDX | |||
FW_FC_PRIMARYKEY |