Table HLPDTEST.STATEGPS.T_GPS_NODETYPES 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
GPS_NODE_PORPS_CONFIG_V.NODETYPE_ID Implied Constraint R
GPS_NODE_PROPS_VW.NODETYPE_ID Implied Constraint R
T_APP_NODETYPES_RELATIONSHIP.CHILD_NODETYPE_ID FK_T_APP_NT_REL_CHILD_NT_ID C
T_APP_NT_PARENT_RELATIONSHIP.PARENT_NODETYPE_ID FK_NT_PARENT_REL_NT_ID C
T_APP_ROOT_NODETYPES.ROOT_NODETYPE_ID FK_T_APP_ROOT_NT_ID C
T_GPS_APPLICATION_NODE_TYPES.NODETYPE_ID Implied Constraint R
T_GPS_MODEL_NODE_PROPS_COMP_V.NODETYPE_ID Implied Constraint R
T_GPS_NODETYPE_STATES.NODETYPE_ID FK_T_GPS_NODETYPE_STATES_NT C
T_GPS_ROLE_NODETYPE_STATES.NODETYPE_ID SYS_C0010235 C
T_GPS_ROLE_NODETYPES.NODETYPE_ID FK_T_GPS_ROLE_NODETYPES_NT C
T_GPS_USER_NODETYPE_STATES.NODETYPE_ID SYS_C0010391 C
T_GPS_USER_NODETYPES.NODETYPE_ID FK_T_GPS_USER_NT_ID C
T_TRI2_PRS2WF_NODE_MAPPING.PROCESS_NODETYPE_ID T_TRI2_PRS2WF_NODE_MAPPIN_FK1 R
T_TRI2_PRS2WF_NODE_MAPPING.WORKFLOW_NODETYPE_ID T_TRI2_PRS2WF_NODE_MAPPIN_FK2 C
NODETYPE varchar2 255  √  null
ICON_FILE varchar2 255
PANEL_FILE varchar2 255  √  null
DESCRIPTION varchar2 1000  √  null
CONNECTOR_COLOR varchar2 100  √  null
EXPLODE_CAPABILITY varchar2 10  √  null
CONNECTOR varchar2 255  √  null
OR_TYPE varchar2 255  √  null
BEHAVIOUR varchar2 20  √  null
EXPLOSION_STOPPER varchar2 5  √  null
FLAG varchar2 10  √  null
NODEGROUP varchar2 4000  √  null
GOOGLE_MAPS_INTEGRATION varchar2 4000  √  null

Table contained 279 rows at Sun Jan 24 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
NODETYPE_ID Primary key Asc SYS_C0010043  
NODETYPE Must be unique Asc SYS_C0010044 This unique column is also nullable

Close relationships  within of separation: