Table HLPDTEST.STATEGPS.T_GPS_CONDITIONAL_STATE_CHANGE 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
CHANGE_ID number 22
T_GPS_COND_ST_CHANGE_SETS.CHANGE_ID SYS_C0010359 C
T_GPS_NODE_FORMULA.CHANGE_ID SYS_C0010240 C
FROM_STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID SYS_C0010221 C
TO_STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID SYS_C0010220 C
APPLICATION_CLASS varchar2 255  √  null
NOTIFICATION_DETAILS_ID number 20  √  null
T_GPS_NOTIFICATION_DETAILS.NOTIFICATION_DETAILS_ID FK_NOTIFICATION_DETAILS_ID C

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

Indexes:
Column(s) Type Sort Constraint Name
CHANGE_ID Primary key Asc SYS_C0010007
FROM_STATE_ID + TO_STATE_ID Performance Asc/Asc T_GPS_COND_STATE_CHANGE_INDEX

Close relationships  within of separation: