View HLPDTEST.STATEGPS.T_GPS_MODELS_HIERARCHY Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
CATEGORY_ID number 22
T_CATEGORIES.CATEGORY_ID Implied Constraint R
CATEGORY_NAME varchar2 255  √  null
PARENT_ID number 22
PARENT_MODEL varchar2 255
PARENT_VERSION number 4  √  null
MODEL_NODE_ID number 22  √  null
NODE_ID number 22
T_GPS_NODES.NODE_ID Implied Constraint R
NODE_NAME varchar2 255  √  null
CHILD_CATEGORY_ID number 22  √  null
CHILD_CATEGORY_NAME varchar2 255  √  null
CHILD_MODEL_ID number 22  √  null
MODEL_ID number 22  √  null
T_GPS_MODELS.MODEL_ID Implied Constraint R
CHILD_MODEL varchar2 255  √  null
CHILD_MODEL_VERSION number 4  √  null
CHILD_NODE_ID number 22  √  null
POSITION_X number 22  √  null
POSITION_Y number 22  √  null

Analyzed at Thu Aug 13 01:05 IST 2020

View Definition:
select PARENT_CATEGORIES.CATEGORY_ID, PARENT_CATEGORIES.CATEGORY_NAME, T_GPS_MODELS.MODEL_ID PARENT_ID, T_GPS_MODELS.MODEL_NAME PARENT_MODEL, T_GPS_MODELS.MODEL_STATUS PARENT_VERSION, T_GPS_MODELS.NODE_ID MODEL_NODE_ID, T_GPS_NODES.NODE_ID, T_GPS_NODES.NODE_NAME, ALL_SUB_MODELS.CATEGORY_ID CHILD_CATEGORY_ID, ALL_SUB_MODELS.CATEGORY_NAME CHILD_CATEGORY_NAME, ALL_SUB_MODELS.MODEL_ID CHILD_MODEL_ID, ALL_SUB_MODELS.MODEL_ID MODEL_ID, ALL_SUB_MODELS.MODEL_NAME CHILD_MODEL, ALL_SUB_MODELS.MODEL_STATUS CHILD_MODEL_VERSION, ALL_SUB_MODELS.node_id child_node_id, T_GPS_NODES.Position_x, T_GPS_NODES.Position_y FROM STATEGPS.T_CATEGORIES PARENT_CATEGORIES, STATEGPS.T_GPS_MODELS T_GPS_MODELS, (STATEGPS.T_GPS_NODES T_GPS_NODES LEFT OUTER JOIN (select relation.node_id, relation.model_id, CHILD_MODEL.model_name,CHILD_MODEL.MODEL_STATUS, CHILD_MODEL.CATEGORY_ID, CHILD_CATEGORIES.CATEGORY_NAME from (select node_id, model_id from T_GPS_NODE_MODEL_RELATIONS union --all select node_id, model_id from T_GPS_MODELs) relation INNER JOIN (T_GPS_MODELS CHILD_MODEL INNER JOIN T_CATEGORIES CHILD_CATEGORIES ON CHILD_MODEL.CATEGORY_ID = CHILD_CATEGORIES.CATEGORY_ID ) ON relation.MODEL_ID = CHILD_MODEL.MODEL_ID ) ALL_SUB_MODELS ON T_GPS_NODES.NODE_ID = ALL_SUB_MODELS.NODE_ID) where PARENT_CATEGORIES.CATEGORY_ID = T_GPS_MODELS.Category_Id AND T_GPS_MODELS.MODEL_ID = T_GPS_NODES.MODEL_ID and T_GPS_NODES.node_type = 'TRI2_BPM_SUBPROCESS' -- and T_GPS_MODELS.MODEL_ID = 62555
 
Possibly Referenced Tables/Views:


Close relationships: