Table HLPDTEST.STATEGPS.T_GPS_NODENAME_ORDERS 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
NODETYPE_STATE_ID number 22  √  null
T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID FK_T_GPS_NODENAME_ORDERS C
PROPERTY_ID number 22
T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID Implied Constraint R
PROPERTY_NAME varchar2 255  √  null

Table contained 28,301 rows at Wed May 25 01:05 IST 2022

Indexes:
Column(s) Type Sort Constraint Name
PROPERTY_ID Primary key Asc SYS_C0010040
NODETYPE_STATE_ID Performance Asc T_GPS_NNAME_ORDERS_ID_INDEX
NODETYPE_STATE_ID + PROPERTY_ID Performance Asc/Asc T_GPS_NODENAME_ORDERS_INDEX1

Close relationships  within of separation: