View HLPDTEST.STATEGPS.T_GPS_MODELS_HIERARCHY_V 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
PARENT_MODEL varchar2 255  √  null
CHILD_MODEL varchar2 255  √  null
NODE_NAME varchar2 255  √  null
PARENT_ID number 22  √  null
MODEL_ID number 22  √  null
T_GPS_MODELS.MODEL_ID Implied Constraint R
CATEGORY_NAME varchar2 255  √  null
CATEGORY_ID number 22  √  null
T_CATEGORIES.CATEGORY_ID Implied Constraint R

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
(--To fetch linked model details SELECT T_GPS_MODELS.MODEL_NAME PARENT_MODEL, T_GPS_MODELS1.MODEL_NAME CHILD_MODEL, T_GPS_NODES.NODE_NAME, T_GPS_MODELS.MODEL_ID PARENT_ID, T_GPS_NODE_MODEL_RELATIONS.MODEL_ID, T_CATEGORIES.CATEGORY_NAME, T_CATEGORIES.CATEGORY_ID FROM STATEGPS.T_GPS_MODELS T_GPS_MODELS, STATEGPS.T_GPS_NODES T_GPS_NODES, STATEGPS.T_GPS_NODE_MODEL_RELATIONS T_GPS_NODE_MODEL_RELATIONS, STATEGPS.T_GPS_MODELS T_GPS_MODELS1, STATEGPS.T_GPS_MASTER_MODELS T_GPS_MASTER_MODELS, STATEGPS.T_CATEGORIES T_CATEGORIES WHERE T_GPS_MODELS.MODEL_ID = T_GPS_NODES.MODEL_ID AND T_GPS_NODE_MODEL_RELATIONS.NODE_ID = T_GPS_NODES.NODE_ID AND T_GPS_MODELS1.MODEL_ID = T_GPS_NODE_MODEL_RELATIONS.MODEL_ID AND T_GPS_MODELS.MODEL_ID = T_GPS_MASTER_MODELS.MODEL_ID AND T_CATEGORIES.CATEGORY_ID = T_GPS_MASTER_MODELS.CATEGORY_ID UNION --To fetch drawn model details SELECT T_GPS_MODELS.MODEL_NAME PARENT_MODEL, T_GPS_MODELS1.MODEL_NAME CHILD_MODEL, T_GPS_NODES.NODE_NAME, T_GPS_MODELS.MODEL_ID PARENT_ID, T_GPS_MODELS1.MODEL_ID, T_CATEGORIES.CATEGORY_NAME, T_CATEGORIES.CATEGORY_ID FROM STATEGPS.T_GPS_MODELS T_GPS_MODELS, STATEGPS.T_GPS_NODES T_GPS_NODES, STATEGPS.T_GPS_MODELS T_GPS_MODELS1, STATEGPS.T_GPS_MASTER_MODELS T_GPS_MASTER_MODELS, STATEGPS.T_CATEGORIES T_CATEGORIES WHERE T_GPS_MODELS.MODEL_ID = T_GPS_NODES.MODEL_ID AND T_GPS_MODELS1.NODE_ID = T_GPS_NODES.NODE_ID AND T_GPS_MODELS.MODEL_ID = T_GPS_MASTER_MODELS.MODEL_ID AND T_CATEGORIES.CATEGORY_ID = T_GPS_MASTER_MODELS.CATEGORY_ID)
 
Possibly Referenced Tables/Views:


Close relationships: