Table HLPDTEST.STATEGPS.T_GPS_INSTANCE_MOVETO_TRACKING 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
TRACKING_ID number 22
T_GPS_INSTANCE_ACTIVE_TRACKING.TRACKING_ID Implied Constraint R
INSTANCE_ID number 22  √  null
T_INSTANCES.INSTANCE_ID MOVETO_INSTANCE_ID_FK C
FROM_STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID MOVETO_FROMSTATEID_FK C
TO_STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID MOVETO_TOSTATEID_FK C
MOVED_BY varchar2 255  √  null
MOVED_OUT_DATE date 7  √  null
COMMENTS varchar2 255  √  null

Table contained 18,900 rows at Tue Jan 26 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name
TRACKING_ID Primary key Asc SYS_C0016322

Close relationships  within of separation: