SchemaSpy - Table HLPDTEST.STATEGPS.T_GPS

Generated by
SchemaSpy

Legend:

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

√

null

T_GPS_MODELS.MODEL_ID

SYS_C0010416 C

NODE_ID

number

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

√

null

POSITION_Y

number

√

null

ACD_FLAG

varchar2

255

√

null

Table contained 2,046,355 rows at Mon Mar 01 01:05 IST 2021

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