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