Table HLPDTEST.STATEGPS.T_GPS_NODETYPE_STATES 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_ID number 22  √  null
T_GPS_NODETYPES.NODETYPE_ID FK_T_GPS_NODETYPE_STATES_NT C
STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID FK_T_GPS_NODETYPE_STATES_WS C
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID FK_T_GPS_NODETYPE_STATES_APP C
NODETYPE_STATE_ID number 22
GPS_NODE_PORPS_CONFIG_V.NODETYPE_STATE_ID Implied Constraint R
GPS_NODE_PROPS_VW.NODETYPE_STATE_ID Implied Constraint R
T_GPS_APPLICATION_NODE_TYPES.NODETYPE_STATE_ID Implied Constraint R
T_GPS_EXCLUSIVE_SETS.NODETYPE_STATE_ID FK_T_GPS_EXCLUSIVE_SETS C
T_GPS_GOOGLE_MAP_SETUP.NODETYPE_STATE_ID Implied Constraint R
T_GPS_NODENAME_ORDERS.NODETYPE_STATE_ID FK_T_GPS_NODENAME_ORDERS C
T_GPS_NT_STATE_CLASSES.NODETYPE_STATE_ID FK_T_GPS_NT_STATE_CLASSES C
T_GPS_PROPERTY_CHANGE_SETS.NODETYPE_STATE_ID FK_T_GPS_PROPERTY_CHANGE_SETS C
T_HTML_NODE_PROPSHEET_VERSION.NODETYPE_STATE_ID FK_VERSION_NODETYPE_STATE_ID C
T_PROJECTPLAN_CONFIG.NODETYPE_STATE_ID Implied Constraint R
EDYNAMO_CLASS varchar2 255
UPDATED_AT date 7  √  null
NODETYPE_ORDER number 22  √  null
USER_ID number 22  √  null
T_GPS_USERS.USER_ID Implied Constraint R
VISIBLE_FLAG varchar2 10  √  'true'
COPY_NODETYPE_STATE_ID number 22  √  null
UPDATED_BY varchar2 200  √  null
DISPLAY_FLAG varchar2 10  √  null

Table contained 18,437 rows at Sun Nov 29 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
NODETYPE_STATE_ID + NODETYPE_ORDER Performance Asc/Asc T_GPS_NODETYPE_STATES_INDEX
STATE_ID + USER_ID Performance Asc/Asc T_GPS_NODETYPE_STATES_INDEX1
VISIBLE_FLAG Performance Asc T_GPS_NODETYPE_STATES_VIS_CN1
NODETYPE_ID + APPLICATION_ID + USER_ID Performance Asc/Asc/Asc T_GPS_NT_STATES_APP_ID_INDEX
NODETYPE_ID + STATE_ID + USER_ID Performance Asc/Asc/Asc T_GPS_NT_STATES_STATE_ID_INDEX
APPLICATION_ID + USER_ID Performance Asc/Asc T_GPS_NT_STATES_USER_ID_INDEX

Close relationships  within of separation: