SchemaSpy - Table HLPDTEST.STATEGPS.T_GPS_ROLE_NODETYPE

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

ROLE_NODETYPE_ID

number

GPS_NODE_PORPS_CONFIG_V.ROLE_NODETYPE_ID	Implied Constraint R
GPS_NODE_PROPS_VW.ROLE_NODETYPE_ID	Implied Constraint R
T_GPS_ROLE_NODETYPES.ROLE_NODETYPE_ID	Implied Constraint R

ROLE_STATE_ID

number

√

null

T_GPS_ROLE_STATES.ROLE_STATE_ID

FK_ROLE_STATE_ID C

NODETYPE_ID

number

√

null

T_GPS_NODETYPES.NODETYPE_ID

SYS_C0010235 C

Table contained 14,609 rows at Sun Jan 17 01:06 IST 2021

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
ROLE_NODETYPE_ID	Primary key	Asc	SYS_C0010085
ROLE_STATE_ID + NODETYPE_ID	Must be unique	Asc/Asc	SYS_C0013689	These unique columns are also nullable
ROLE_STATE_ID	Performance	Asc	T_GPS_ROLE_NT_STATES_INDEX