View HLPDTEST.STATEGPS.T_GPS_POPULAR_V 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
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
APPLICATION_NAME varchar2 255  √  null
OBJECT_TYPE varchar2 255  √  null
OBJECT_NAME varchar2 2000  √  null
COUNT number 22  √  null
ROW_NUM number 22  √  null

Analyzed at Sun Oct 18 01:05 IST 2020

View Definition:
SELECT T_GPS_FAVOURITES_HISTORY.APPLICATION_ID, T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_FAVOURITES_HISTORY.OBJECT_TYPE, T_GPS_FAVOURITES_HISTORY.OBJECT_NAME, COUNT(1) COUNT, ROW_NUMBER() OVER (ORDER BY COUNT(1) DESC) AS ROW_NUM FROM STATEGPS.T_GPS_FAVOURITES_HISTORY T_GPS_FAVOURITES_HISTORY,STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS WHERE T_GPS_FAVOURITES_HISTORY.OBJECT_NAME IS NOT NULL AND T_GPS_FAVOURITES_HISTORY.APPLICATION_ID=T_GPS_APPLICATIONS.APPLICATION_ID AND T_GPS_APPLICATIONS.visible_flag='true' GROUP BY T_GPS_FAVOURITES_HISTORY.APPLICATION_ID, T_GPS_APPLICATIONS.APPLICATION_NAME, T_GPS_FAVOURITES_HISTORY.OBJECT_TYPE, T_GPS_FAVOURITES_HISTORY.OBJECT_NAME
 
Possibly Referenced Tables/Views:


Close relationships: