Project Data Tables Database > td Schema : td.BPM_MODEL_FOLDERS Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
BPMF_ID | The record ID. | int | 4 | ||||
BPMF_PARENT_ID | The BPMF_ID of the containing folder. Top-level folders have a parent ID of -1. | int | 4 | ||||
BPMF_NAME | The folder name. | varchar | 255 | ||||
BPMF_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 | ||||
BPMF_DESCRIPTION | A free text description of this item. | varchar | 16 | ||||
BPMF_VTS | The version time stamp. | varchar | 20 | ||||
BPMF_VER_STAMP | The version number of this record. | int | 4 | ||||
BPMF_HAS_ATTACHMENTS | Y if this item has attachments. | varchar | 1 | ||||
BPMF_USER_01 | User-defined field. | varchar | 40 |
Index | Description | Primary | Unique |
---|---|---|---|
BPMF_PATH_IDX | |||
BPMF_PRIMARYKEY | |||
BPMF_UNIQUE_NAME_IDX |