Table HLPDTEST.STATEGPS.T_GPS_OBJECT_SUBSCRIPTIONS 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
SUBSCRIPTION_ID number 22
T_GPS_OBJECTS_UNSUBSCRIBE_VW.SUBSCRIPTION_ID Implied Constraint R
T_WIDGETS_ASSIGNMENT_VW.SUBSCRIPTION_ID Implied Constraint R
OBJECT_ID number 22  √  null
T_GPS_ALL_OBJECTS.OBJECT_ID OBJECT_ID_FOREIGN_KEY C
USER_ID number 22  √  null
T_USERS.USER_ID FK_T_USERS C
STATUS varchar2 20  √  null
DISPLAY_NAME varchar2 2000  √  null
IS_FIXED_WIDGET varchar2 10  √  null
ORDER_ID number 22  √  null
GROUP_NAME varchar2 255  √  null

Table contained 3,560 rows at Thu Oct 28 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
SUBSCRIPTION_ID Primary key Asc PK_T_GPS_OBJECT_SUBSCRIPTIONS  
OBJECT_ID + USER_ID Must be unique Asc/Asc OBJECT_ID_USER_ID These unique columns are also nullable

Close relationships  within of separation: