View HLPDTEST.STATEGPS.T_GPS_APP_VIEW 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
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
APPLICATION_NAME varchar2 255  √  null
DESCRIPTION varchar2 4000  √  null

Analyzed at Sun Jan 24 01:06 IST 2021

View Definition:
( SELECT APPLICATION_ID,APPLICATION_NAME,DESCRIPTION FROM T_GPS_APPLICATIONS WHERE UPPER(VISIBLE_FLAG) = 'TRUE' )
 
Possibly Referenced Tables/Views:
T_GPS_APPLICATIONS 


Close relationships: