Project Data Tables Database > td Schema : td.BPM_PATHS Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
BPMP_ID | The record ID. | int | 4 | ||||
BPMP_PARENT_ID | The BPM_MODELS.BPMM_ID of the model the path belongs to. | int | 4 | ||||
BPMP_NAME | The name of the item. | varchar | 255 | ||||
BPMP_CHECKSUM | Checksum generated according to the elements included in the path. | int | 4 | ||||
BPMP_STATUS | The path status. One of: | varchar | 40 | ||||
BPMP_PRIORITY | The Model path priority. | int | 4 | ||||
BPMP_DESCRIPTION | A free text description of this item. | varchar | 16 | ||||
BPMP_COMMENTS | Comments. | varchar | 16 | ||||
BPMP_CREATION_DATE | The server date when this item was created. | datetime | 4 | ||||
BPMP_CREATED_BY | The user name of the user who created this item. | varchar | 60 | ||||
BPMP_PATH_DESCRIPTION | A free text description of this item. | varchar | 16 | ||||
BPMP_REP_REQ_ID | The requirement ID that represents the imported path. The requirement is created as part of the path’s import. | int | 4 | ||||
BPMP_TEXT_SYNC | For internal use. Do not change data. | varchar | 1 | ||||
BPMP_VTS | The version time stamp. | varchar | 20 | ||||
BPMP_VER_STAMP | The version number of this record. | int | 4 | ||||
BPMP_HAS_ATTACHMENTS | Y if this item has attachments. | varchar | 1 | ||||
BPMP_USER_01 | User-defined field. | varchar | 40 | ||||
BPMP_VC_CHECKOUT_USER_NAME | The user who checked out the item under version control. If the item is not checked out, this field is blank. | varchar | 60 |
Index | Description | Primary | Unique |
---|---|---|---|
BPMP_CHECKSUM_IX2 | |||
BPMP_NAME_IX1 | |||
BPMP_PRIMARYKEY |