Table Detail Report
MP_GROUP_REFRESH_REQUEST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MP GROUP REFRESH REQUEST |
Definition: | An activity table containing all of the refresh requests of the MPages Static Content Server. |
Table Type: | ACTIVITY |
Column Detail - MP_GROUP_REFRESH_REQUEST
Column Name | Type | Null? | Definition |
---|---|---|---|
BASE_FOLDER | VARCHAR(255) | N | The folder that will be refreshed. |
BASE_URL | VARCHAR(200) | N | An identifier for the WebSphere cluster on which the application is deployed. |
MP_GROUP_ID | DOUBLE | N | Foreign key value from the MP_GROUP table.The group id of the folder that will be refreshed - or 0 if the folder is specified in environment entries. |
MP_GROUP_REFRESH_REQUEST_ID | DOUBLE | N | PRIMARY KEY |
REQUEST_DT_TM | DATETIME | N | The date and time that the cached folder refresh request was created. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - MP_GROUP_REFRESH_REQUEST
Child Column in MP_GROUP_REFRESH_REQUEST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MP_GROUP_ID | MP_GROUP | MP_GROUP_ID |
MP_GROUP_REFRESH_STATE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MP GROUP REFRESH STATE |
Definition: | An activity table containing the current state of the caches in MPages Static Content Server |
Table Type: | ACTIVITY |
Column Detail - MP_GROUP_REFRESH_STATE
Column Name | Type | Null? | Definition |
---|---|---|---|
BASE_FOLDER | VARCHAR(255) | N | The folder that will be refreshed. |
BASE_URL | VARCHAR(200) | N | An identifier for the WebSphere cluster on which the application is deployed. |
DIAGNOSTIC_INFO_TXT | VARCHAR(255) | Y | Optional diagnostic description of why a cache refresh failed. |
IS_PRIMED_IND | DOUBLE | N | Specifies whether all the files below the base folder have been read and loaded into the raw file cache. |
IS_READABLE_IND | DOUBLE | N | Specifies whether the base folder is readable. |
IS_REFRESHING_IND | DOUBLE | N | Specifies whether the web app is currently primining or getting mappings for the cache for a base folder. |
MP_GROUP_ID | DOUBLE | N | Foreign key value from the MP_GROUP table.The group id of the folder that will be refreshed - or 0 if the folder is specified in environment entries. |
MP_GROUP_REFRESH_STATE_ID | DOUBLE | N | PRIMARY KEY |
REFRESH_END_DT_TM | DATETIME | Y | The time the last cache refresh for this base folder completed. |
REFRESH_START_DT_TM | DATETIME | Y | The time the last cache refresh for this base folder started. |
SERVER_UUID | VARCHAR(36) | N | A UUID that is used to correlate a cache on a server to a row in the database. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - MP_GROUP_REFRESH_STATE
Child Column in MP_GROUP_REFRESH_STATE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MP_GROUP_ID | MP_GROUP | MP_GROUP_ID |
MP_RELEASE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MP RELEASE |
Definition: | Defines the various MPages releases and their associated identifiers. The release identifier is used to associate groups to a specific release. |
Table Type: | REFERENCE |
Column Detail - MP_RELEASE
Column Name | Type | Null? | Definition |
---|---|---|---|
DESCRIPTION | VARCHAR(255) | Y | Release Description |
MP_RELEASE_ID | DOUBLE | N | PRIMARY KEY |
RELEASE_IDENT | VARCHAR(30) | N | Human-readable identifier for the mp_release row. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - MP_RELEASE
Parent Column in MP_RELEASE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MP_RELEASE_ID | MP_GROUP | MP_RELEASE_ID |
MP_UTILITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MP UTILITY |
Definition: | Contains the utilities which are associated to MPage groups. Contains all of the necessary identifying information for a utility. |
Table Type: | REFERENCE |
Column Detail - MP_UTILITY
Column Name | Type | Null? | Definition |
---|---|---|---|
ARTIFACT_IDENT | VARCHAR(128) | N | Corresponds to the Maven identifier for a maven artifact, in this case the component |
MP_GROUP_ID | DOUBLE | N | Foreign key value from the mp_group table. |
MP_UTILITY_ID | DOUBLE | N | PRIMARY KEY |
TOKEN_IDENT | VARCHAR(30) | Y | A small string that is used to identify this utility in a URL for the static content web app. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
VERSION_TXT | VARCHAR(30) | N | The maven artifact version string for this component. |
Relationship Detail - MP_UTILITY
Child Column in MP_UTILITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MP_GROUP_ID | MP_GROUP | MP_GROUP_ID |
Parent Column in MP_UTILITY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MP_UTILITY_ID | MP_COMPONENT_UTILITY_R | MP_UTILITY_ID |