Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| REV | BIGINT | 19 | √ | null |
|
|
||
| REVTYPE | SMALLINT | 5 | √ | null |
|
|
||
| IDENTIFIER | BIGINT | 19 | √ | null |
|
|
||
| QUERY_MODEL_TYPE | VARCHAR | 32 | √ | null |
|
|
||
| queryModelType_MOD | BIT | 1 | √ | null |
|
|
||
| SPMN_DB_TYPE | VARCHAR | 32 | √ | null |
|
|
||
| specimenDatabaseType_MOD | BIT | 1 | √ | null |
|
|
||
| TITLE | VARCHAR | 64 | √ | null |
|
|
||
| title_MOD | BIT | 1 | √ | null |
|
|
||
| DESCRIPTION | VARCHAR | 255 | √ | null |
|
|
||
| description_MOD | BIT | 1 | √ | null |
|
|
||
| QUERY_ID | BIGINT | 19 | √ | null |
|
|
||
| query_MOD | BIT | 1 | √ | null |
|
|
||
| DEF_COLUMNS | TEXT | 65535 | √ | null |
|
|
||
| defaultColumnsJson_MOD | BIT | 1 | √ | null |
|
|
||
| REQ_QUERY_ID | BIGINT | 19 | √ | null |
|
|
||
| requestQuery_MOD | BIT | 1 | √ | null |
|
|
||
| REQ_FORM_ID | BIGINT | 19 | √ | null |
|
|
||
| requestForm_MOD | BIT | 1 | √ | null |
|
|
||
| REQUIRES_SIGN_IN | BIT | 1 | √ | null |
|
|
||
| requiresSignIn_MOD | BIT | 1 | √ | null |
|
|
||
| SHOW_DASHBOARD | BIT | 1 | √ | null |
|
|
||
| showDashboard_MOD | BIT | 1 | √ | null |
|
|
||
| SHOW_APP_BUTTONS | BIT | 1 | √ | null |
|
|
||
| showAppButtons_MOD | BIT | 1 | √ | null |
|
|
||
| UPDATED_BY | BIGINT | 19 | √ | null |
|
|
||
| updatedBy_MOD | BIT | 1 | √ | null |
|
|
||
| UPDATE_TIME | TIMESTAMP | 19 | √ | null |
|
|
||
| updateTime_MOD | BIT | 1 | √ | null |
|
|
||
| ACTIVITY_STATUS | VARCHAR | 16 | √ | null |
|
|
||
| activityStatus_MOD | BIT | 1 | √ | null |
|
|
||
| requestManagers_MOD | BIT | 1 | √ | null |
|
|
||
| userGroups_MOD | BIT | 1 | √ | null |
|
|
||
| resources_MOD | BIT | 1 | √ | null |
|
|
||
| cps_MOD | BIT | 1 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors