Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| IDENTIFIER | BIGINT | 19 | √ | null |
|
|
||
| REV | BIGINT | 19 | √ | null |
|
|
||
| REVTYPE | TINYINT | 3 | √ | null |
|
|
||
| NAME | VARCHAR | 32 | √ | null |
|
|
||
| name_MOD | BIT | 1 | √ | null |
|
|
||
| TITLE | VARCHAR | 64 | √ | null |
|
|
||
| title_MOD | BIT | 1 | √ | null |
|
|
||
| TASK_TYPE | VARCHAR | 32 | √ | null |
|
|
||
| type_MOD | BIT | 1 | √ | null |
|
|
||
| SHORT_DESC | VARCHAR | 128 | √ | null |
|
|
||
| shortDescription_MOD | BIT | 1 | √ | null |
|
|
||
| LONG_DESC | TEXT | 65535 | √ | null |
|
|
||
| longDescription_MOD | BIT | 1 | √ | null |
|
|
||
| SOP_DOCUMENT_LINK | VARCHAR | 255 | √ | null |
|
|
||
| sopDocumentLink_MOD | BIT | 1 | √ | null |
|
|
||
| JSON_CONFIG | BIT | 1 | √ | null |
|
|
||
| jsonConfig_MOD | BIT | 1 | √ | null |
|
|
||
| CONFIG | TEXT | 65535 | √ | null |
|
|
||
| configuration_MOD | BIT | 1 | √ | null |
|
|
||
| STARTER_TASK | BIT | 1 | √ | null |
|
|
||
| starterTask_MOD | BIT | 1 | √ | null |
|
|
||
| WORKFLOW_ID | BIGINT | 19 | √ | null |
|
|
||
| workflow_MOD | BIT | 1 | √ | null |
|
|
||
| ACTIVITY_STATUS | VARCHAR | 32 | √ | null |
|
|
||
| activityStatus_MOD | BIT | 1 | √ | null |
|
|
||
| OPTIONAL | BIT | 1 | √ | null |
|
|
||
| optional_MOD | BIT | 1 | √ | null |
|
|
||
| ON_SKIP_ACTION | VARCHAR | 32 | √ | null |
|
|
||
| onSkipAction_MOD | BIT | 1 | √ | null |
|
|
||
| TEMPLATE_ID | BIGINT | 19 | √ | null |
|
|
||
| template_MOD | BIT | 1 | √ | null |
|
|
||
| inputs_MOD | BIT | 1 | √ | null |
|
|
||
| userGroups_MOD | BIT | 1 | √ | null |
|
|
||
| notifUserGroups_MOD | BIT | 1 | √ | null |
|
|
||
| OUT_ITEMS_WF_RULES | TEXT | 65535 | √ | null |
|
|
||
| outItemsWfRulesJson_MOD | BIT | 1 | √ | null |
|
|
||
| OUT_ITEMS_CART_RULES | TEXT | 65535 | √ | null |
|
|
||
| outItemsCartRulesJson_MOD | BIT | 1 | √ | null |
|
|
||
| OUT_ITEMS_RULES | TEXT | 65535 | √ | null |
|
|
||
| outItemsRulesJson_MOD | BIT | 1 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors