Table HLPDTEST.STATEGPS.T_GPS_GOOGLE_MAP_SETUP 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
GOOGLE_MAP_SETUP_ID number 22
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
APPLICATION_NAME varchar2 200  √  null
WORKFLOWFLOW_TYPE_ID number 22  √  null
WORKFLOW_TYPE_NAME varchar2 200  √  null
STATE_NAME varchar2 200  √  null
STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R
NODETYPE varchar2 200  √  null
NODETYPE_ID varchar2 200  √  null
NODETYPE_STATE_ID number 22  √  null
T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID Implied Constraint R
GOOGLE_MAP_COMPONENT varchar2 200  √  null
IF_CLASS_ID number 22  √  null
IF_CLASS_NAME varchar2 200  √  null
IF_CHILD_PROPERTY_NAME varchar2 200  √  null
IF_CHILD_PROPERTY_ID number 22  √  null
T_GPS_NT_ST_CLASS_PROPS.PROPERTY_ID SYS_C0033228 R
CONTAINS_VALUE varchar2 200  √  null
DEST_CHILD_PROPERTY_ID number 22  √  null
DEST_CHILD_PROPERTY_NAME varchar2 200  √  null
FROM_PROPERTY_ID number 22  √  null
FROM_PROPERTY_NAME varchar2 200  √  null
PARENT_CLASS_ID number 22  √  null
PARENT_CLASS_NAME varchar2 200  √  null
SELECTED_MAP_PROPERTY_ID number 22  √  null
SELECTED_MAP_PROPERTY_NAME varchar2 200  √  null

Table contained 0 rows at Sun Nov 29 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
GOOGLE_MAP_SETUP_ID Primary key Asc SYS_C0033227

Close relationships  within of separation: