View HLPDTEST.STATEGPS.T_GPS_OBJECTS_UNSUBSCRIBE_VW 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_OBJECT_SUBSCRIPTIONS.SUBSCRIPTION_ID Implied Constraint R
OBJECT_ID number 22  √  null
T_GPS_ALL_OBJECTS.OBJECT_ID Implied Constraint R
USER_ID number 22  √  null
T_GPS_USERS.USER_ID Implied Constraint R
STATUS varchar2 20  √  null
DISPLAY_NAME varchar2 2000  √  null
IS_FIXED_WIDGET varchar2 10  √  null
ORDER_ID number 22  √  null

Analyzed at Sat Oct 31 01:06 IST 2020

View Definition:
select T_GPS_OBJECT_SUBSCRIPTIONS."SUBSCRIPTION_ID",T_GPS_OBJECT_SUBSCRIPTIONS."OBJECT_ID",T_GPS_OBJECT_SUBSCRIPTIONS."USER_ID",T_GPS_OBJECT_SUBSCRIPTIONS."STATUS",T_GPS_OBJECT_SUBSCRIPTIONS."DISPLAY_NAME",T_GPS_OBJECT_SUBSCRIPTIONS."IS_FIXED_WIDGET",T_GPS_OBJECT_SUBSCRIPTIONS."ORDER_ID" from (select T_USERS.User_Id from TAS.T_ROLES T_ROLES,TAS.T_USERS T_USERS,TAS.T_USER_ROLES where T_USERS.user_id = T_USER_ROLES.user_id and T_ROLES.role_id = T_USER_ROLES.role_id and T_USERS.User_Id NOT IN (1004,3057,2207,433,382,1905,1037,412,385) and t_roles.role_name = 'EIS_EMPLOYEE') Users, T_GPS_OBJECT_SUBSCRIPTIONS T_GPS_OBJECT_SUBSCRIPTIONS where T_GPS_OBJECT_SUBSCRIPTIONS.Object_Id in (61,47,1) AND T_GPS_OBJECT_SUBSCRIPTIONS.user_id= Users.user_id
 
Possibly Referenced Tables/Views:


Close relationships: