View HLPDTEST.STATEGPS.T_WIDGETS_ASSIGNMENT_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
USERID number 22
USERNAME varchar2 255
ROLE_NAME varchar2 255
OBJECT_ID number 22
T_GPS_ALL_OBJECTS.OBJECT_ID Implied Constraint R
APPLICATION_NAME varchar2 255  √  null
OBJECT_TYPE varchar2 255  √  null
OBJECT_NAME varchar2 2000  √  null
ORDERR varchar2 1  √  null
SUBSCRIPTION_ID number 22  √  null
T_GPS_OBJECT_SUBSCRIPTIONS.SUBSCRIPTION_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
OBJECTID number 22  √  null

Analyzed at Sun Nov 29 01:06 IST 2020

View Definition:
select "USERID","USERNAME","ROLE_NAME","OBJECT_ID","APPLICATION_NAME","OBJECT_TYPE","OBJECT_NAME","ORDERR","SUBSCRIPTION_ID","USER_ID","STATUS","DISPLAY_NAME","IS_FIXED_WIDGET","ORDER_ID","OBJECTID" from (select * from (select T_USERS.user_id USERID, T_USERS.user_name USERNAME, T_ROLES.Role_Name from TAS.T_USERS T_USERS, TAS.T_USER_ROLES, TAS.T_ROLES where t_users.user_id = t_user_roles.user_id and t_roles.role_id = t_user_roles.role_id and t_roles.role_name = 'EIS_EMPLOYEE') all_users, (select a.*, decode(a.object_name, 'Employee Happiness at Work', '1', 'Employee Happiness with his/her Performance', '2', 'Do you know that customers perceive TRINITI is weak in Project Management?', '3', 'Do you agree that TRINITI is weak in Project Management?', '4', 'Do you want to improve your project management skills so that we eliminate the perception that TRINITI is weak in project management?', '5') orderr from t_Gps_All_Objects a where a.object_type = 'Custom Module' and a.application_name = 'Triniti Corporation' and (a.object_name = 'Employee Happiness at Work' or a.object_name = 'Employee Happiness with his/her Performance' or a.object_name = 'Do you know that customers perceive TRINITI is weak in Project Management?' or a.object_name = 'Do you agree that TRINITI is weak in Project Management?' or a.object_name = 'Do you want to improve your project management skills so that we eliminate the perception that TRINITI is weak in project management?')) ) specific_objects, (SELECT T_GPS_OBJECT_SUBSCRIPTIONS.SUBSCRIPTION_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, T_GPS_OBJECT_SUBSCRIPTIONS.OBJECT_ID OBJECTID FROM STATEGPS.T_GPS_OBJECT_SUBSCRIPTIONS T_GPS_OBJECT_SUBSCRIPTIONS, STATEGPS.T_GPS_ALL_OBJECTS T_GPS_ALL_OBJECTS, tas.t_users t_users where T_GPS_OBJECT_SUBSCRIPTIONS.OBJECT_ID = T_GPS_ALL_OBJECTS.OBJECT_ID AND T_GPS_OBJECT_SUBSCRIPTIONS.USER_ID = T_USERS.USER_ID AND T_GPS_OBJECT_SUBSCRIPTIONS.STATUS = 'Subscribed') all_subscriptions where specific_objects.object_id = all_subscriptions.OBJECTID(+) and specific_objects.USERID = all_subscriptions.user_id(+) order by orderr desc
 
Possibly Referenced Tables/Views:


Close relationships: