MP_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: MP COMPONENT
Definition: Contains the components which are associated to MPage groups. Contains all of the necessary identifying information for a component.
Table Type: REFERENCE





Column Detail - MP_COMPONENT


Column Name Type Null? Definition
ARTIFACT_IDENT VARCHAR(128) N Corresponds to the Maven identifier for a maven artifact, in this case the component
FILTER_MEAN VARCHAR(30) Y Identifies the bedrock and prefMaint settings to the page that the component is on.
MP_COMPONENT_ID DOUBLE N PRIMARY KEY
MP_GROUP_ID DOUBLE N Foreign key value from the mp_group table.
TOKEN_IDENT VARCHAR(30) N A small string that is used to identify this component 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_COMPONENT


Child Column in MP_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: MP_GROUP_ID MP_GROUP MP_GROUP_ID




Parent Column in MP_COMPONENT (PK) Child Table Name Child Column Name
Children: MP_COMPONENT_ID MP_COMPONENT_COMPONENT_R CHILD_MP_COMPONENT_ID
MP_COMPONENT_COMPONENT_R MP_COMPONENT_ID
MP_COMPONENT_UTILITY_R MP_COMPONENT_ID


MP_COMPONENT_COMPONENT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: MP COMPONENT COMPONENT RELTN
Definition: Contains relationships between components of a group and the child components they require to run successfully.
Table Type: REFERENCE





Column Detail - MP_COMPONENT_COMPONENT_R


Column Name Type Null? Definition
CHILD_MP_COMPONENT_ID DOUBLE N A child Component value from the MP_COMPONENT table.
MP_COMPONENT_COMPONENT_R_ID DOUBLE N PRIMARY KEY
MP_COMPONENT_ID DOUBLE N The Parent Component in a component relationship. A value from the MP_COMPONENT table.
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_COMPONENT_COMPONENT_R


Child Column in MP_COMPONENT_COMPONENT_R(FK) Parent Table Name Parent Column Name
Parents: CHILD_MP_COMPONENT_ID MP_COMPONENT MP_COMPONENT_ID
MP_COMPONENT_ID MP_COMPONENT MP_COMPONENT_ID


MP_COMPONENT_UTILITY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: MP COMPONENT UTILITY RELTN
Definition: Contains relationships between components of a group and the utilties they require to run successfully.
Table Type: REFERENCE





Column Detail - MP_COMPONENT_UTILITY_R


Column Name Type Null? Definition
MP_COMPONENT_ID DOUBLE N Foreign key from the mp_component table.
MP_COMPONENT_UTILITY_R_ID DOUBLE N PRIMARY KEY
MP_UTILITY_ID DOUBLE N Foreign key value from the mp_utility table.
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_COMPONENT_UTILITY_R


Child Column in MP_COMPONENT_UTILITY_R(FK) Parent Table Name Parent Column Name
Parents: MP_COMPONENT_ID MP_COMPONENT MP_COMPONENT_ID
MP_UTILITY_ID MP_UTILITY MP_UTILITY_ID


MP_FILE



Column Section Top of Page


Table-level Detail

Description: MP FILE
Definition: Contains all of the necessary information to locate files of a particular group, component or utility.
Table Type: REFERENCE





Column Detail - MP_FILE


Column Name Type Null? Definition
CONTENT_TYPE VARCHAR(50) N Identifies the file type, see http://www.w3.org/Protocols/rfc1341/4_Content-Type.html
FILE_NAME VARCHAR(128) N The name of the file
MP_FILE_ID DOUBLE N PRIMARY KEY
PARENT_ENTITY_ID DOUBLE N A primary key value from either the mp_component or mp_utility table row that this file belongs to. The table name can be found in column PARENT_ENTITY_NAME.
PARENT_ENTITY_NAME VARCHAR(30) N Either MP_COMPONENT or MP_UTILITY corresponding to parent_entity_id
SUB_FOLDER_PATH VARCHAR(255) Y Identifies the cached folder that this file is under in the file system.
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.


MP_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MP GROUP
Definition: Defines the various groups which make up an MPages release or groups which are supplimentary to all MPages releases.
Table Type: REFERENCE





Column Detail - MP_GROUP


Column Name Type Null? Definition
ARTIFACT_IDENT VARCHAR(128) N Corresponds to the Maven identifier for a maven artifact, in this case the component
BASE_FOLDER VARCHAR(255) Y Identifies the cached folder that this file is under in the file system.
DESCRIPTION VARCHAR(255) Y Group Description
GROUP_IDENT VARCHAR(30) N A human-readable identifier for the mp_group row.
GROUP_TYPE VARCHAR(30) Y The type of Group
MP_GROUP_ID DOUBLE N PRIMARY KEY
MP_RELEASE_ID DOUBLE N Foreign key value from the mp_release table.
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) Y Group Version



Relationship Detail - MP_GROUP


Child Column in MP_GROUP(FK) Parent Table Name Parent Column Name
Parents: MP_RELEASE_ID MP_RELEASE MP_RELEASE_ID




Parent Column in MP_GROUP (PK) Child Table Name Child Column Name
Children: MP_GROUP_ID MP_COMPONENT MP_GROUP_ID
MP_GROUP_REFRESH_REQUEST MP_GROUP_ID
MP_GROUP_REFRESH_STATE MP_GROUP_ID
MP_UTILITY MP_GROUP_ID