Table HLPDTEST.STATEGPS.T_GPS_NODES 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
MODEL_ID number 22  √  null
T_GPS_MODELS.MODEL_ID SYS_C0010416 C
NODE_ID number 22
T_BPM_MODEL_NODE_PROPS_PIVOT_V.NODE_ID Implied Constraint R
T_GPS_ALTERNATE_NODES.ALTERNATE_NODE_ID SYS_C0010413 C
T_GPS_ALTERNATE_NODES.NODE_ID SYS_C0010414 C
T_GPS_CHILD_NODES.CHILD_NODE_ID SYS_C0010229 C
T_GPS_CHILD_NODES.NODE_ID SYS_C0010230 C
T_GPS_CLASS_RELATIONS.NODE_ID SYS_C0010341 C
T_GPS_COMPRESSED_PATH_PROPS.NODE_ID SYS_C0010376 C
T_GPS_CONNECTOR_ELBOWPOINTS.NODE_ID FK_T_GPS_NODE_ID C
T_GPS_INDENTED_MODELS_V.NODE_ID Implied Constraint R
T_GPS_MODEL_NODE_PROPS_COMP_V.NODE_ID Implied Constraint R
T_GPS_MODELS.NODE_ID FK_T_GPS_MODEL_NODE_ID C
T_GPS_MODELS_HIERARCHY.NODE_ID Implied Constraint R
T_GPS_NEXT_NODES.NEXT_NODE_ID FK_T_GPS_NEXT_NODES_2 C
T_GPS_NEXT_NODES.NODE_ID FK_T_GPS_NEXT_NODES_1 C
T_GPS_NODE_CLASS_PROPERTIES.NODE_ID SYS_C0010336 C
T_GPS_NODE_CLASSES.NODE_ID SYS_C0010375 C
T_GPS_NODE_MODEL_RELATIONS.NODE_ID SYS_C0010407 C
T_GPS_NODE_RA_PROPERTIES.NODE_ID FK_T_GPS_NODE_RA_PROEPRTIES C
T_GPS_PARENT_NODES.NODE_ID SYS_C0010357 C
T_GPS_PARENT_NODES.PARENT_NODE_ID SYS_C0010356 C
T_GPS_PATH_LEVEL_LEG.NODE_ID SYS_C0010300 C
T_GPS_PREVIOUS_NODES.NODE_ID FK_T_GPS_PREVIOUS_NODES_1 C
T_GPS_PREVIOUS_NODES.PREVIOUS_NODE_ID FK_T_GPS_PREVIOUS_NODES_2 C
NODE_NAME varchar2 255  √  null
RELATION_NAME varchar2 255  √  null
NODE_TYPE varchar2 255  √  null
POSITION_X number 22  √  null
POSITION_Y number 22  √  null
ACD_FLAG varchar2 255  √  null

Table contained 2,057,977 rows at Sun Sep 27 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
NODE_ID Primary key Asc SYS_C0010041
MODEL_ID + NODE_ID Performance Asc/Asc T_GPS_NODES_INDEX
NODE_TYPE Performance Asc T_GPS_NODES_INDEX_N1
MODEL_ID Performance Asc T_GPS_NODES_INDEX_N2

Close relationships  within of separation: