View HLPDTEST.STATEGPS.T_GPS_USER_LOGIN_ANALYSIS 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_NAME varchar2 255  √  null
APPLICATION_NAME varchar2 255  √  null
OBJECT_TYPE varchar2 255  √  null
OBJECT_NAME varchar2 2000  √  null
ACCESSED_TIME date 7  √  null
COUNT char 1  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
SELECT T_USERS.USER_NAME , NULL APPLICATION_NAME , NULL OBJECT_TYPE , NULL OBJECT_NAME , TRUNC(T_USER_LOGIN_INFO.LOGIN_TIME) ACCESSED_TIME, '1' COUNT FROM TAS.T_USER_LOGIN_INFO T_USER_LOGIN_INFO , TAS.T_USERS T_USERS WHERE T_USERS.USER_ID = T_USER_LOGIN_INFO.USER_ID UNION ALL SELECT T_USERS.USER_NAME , T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_FAVOURITES_HISTORY.OBJECT_TYPE , T_GPS_FAVOURITES_HISTORY.OBJECT_NAME , TRUNC(T_GPS_FAVOURITES_HISTORY.ACCESSED_TIME) ACCESSED_TIME, '1' COUNT FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS , STATEGPS.T_GPS_FAVOURITES_HISTORY T_GPS_FAVOURITES_HISTORY , TAS.T_USERS T_USERS WHERE T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_FAVOURITES_HISTORY.APPLICATION_ID AND T_USERS.USER_ID = T_GPS_FAVOURITES_HISTORY.DBV_USER_ID
 
Possibly Referenced Tables/Views: