Table HLPDTEST.STATEGPS.T_GPS_USER_OPERATIONS 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
USER_OPERATION_ID number 22
T_GPS_USER_APP_OPERATIONS.USER_OPERATION_ID Implied Constraint R
USER_STATE_ID number 22  √  null
T_GPS_USER_STATES.USER_STATE_ID CON_FK_USER_STATE_ID C
OPERATION_ID number 22  √  null
T_GPS_STATE_OPERATIONS.OPERATION_ID CON_FK_OPERATION_ID C

Table contained 221,525 rows at Sat Oct 31 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
USER_OPERATION_ID Primary key Asc CON_USER_OPERATION_ID
USER_STATE_ID Performance Asc T_GPS_USER_OPERATIONS_INDEX

Close relationships  within of separation: