View HLPDTEST.STATEGPS.PROJECT_CREATION_STATS_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
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
APPLICATION_NAME varchar2 255  √  null
IMAGE_FILE varchar2 255  √  null
DESCRIPTION varchar2 4000  √  null
DEFAULT_GETCONTROLLERS varchar2 255  √  null
DEFAULT_PUTCONTROLLERS varchar2 255  √  null
VISIBLE_FLAG varchar2 255  √  null
CYCLE_TIME_ENABLED_FLAG varchar2 3  √  null
APPLICATION_ORDER number 22  √  null
CREATION_DATE date 7  √  null
LAST_UPDATED_DATE date 7  √  null
LAST_UPDATED_BY varchar2 50  √  null
CREATED_BY varchar2 50  √  null
DISPLAYNAME varchar2 255  √  null
APPLICATION_URL varchar2 255  √  null
APPLICATION_URL_DISPLAY_ON varchar2 255  √  null
APPLICATION_IMAGE varchar2 255  √  null
APPLICATION_COUNT char 1  √  null
START_DATE char 15  √  null

Analyzed at Sun Jan 24 01:06 IST 2021

View Definition:
SELECT T_GPS_APPLICATIONS."APPLICATION_ID",T_GPS_APPLICATIONS."APPLICATION_NAME",T_GPS_APPLICATIONS."IMAGE_FILE",T_GPS_APPLICATIONS."DESCRIPTION",T_GPS_APPLICATIONS."DEFAULT_GETCONTROLLERS",T_GPS_APPLICATIONS."DEFAULT_PUTCONTROLLERS",T_GPS_APPLICATIONS."VISIBLE_FLAG",T_GPS_APPLICATIONS."CYCLE_TIME_ENABLED_FLAG",T_GPS_APPLICATIONS."APPLICATION_ORDER",T_GPS_APPLICATIONS."CREATION_DATE",T_GPS_APPLICATIONS."LAST_UPDATED_DATE",T_GPS_APPLICATIONS."LAST_UPDATED_BY",T_GPS_APPLICATIONS."CREATED_BY",T_GPS_APPLICATIONS."DISPLAYNAME",T_GPS_APPLICATIONS."APPLICATION_URL",T_GPS_APPLICATIONS."APPLICATION_URL_DISPLAY_ON",T_GPS_APPLICATIONS."APPLICATION_IMAGE", '1' APPLICATION_COUNT, 'No. Of Projects' START_DATE FROM T_GPS_APPLICATIONS T_GPS_APPLICATIONS, T_GPS_APP_PROPERTIES T_GPS_APP_PROPERTIES WHERE T_GPS_APP_PROPERTIES.PROPERTY_NAME = 'PROJECTPLAN_APPLICATION' AND T_GPS_APP_PROPERTIES.PROPERTY_VALUE = 'TRUE' AND T_GPS_APP_PROPERTIES.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID AND T_GPS_APPLICATIONS.CREATION_DATE IS NOT NULL AND UPPER(T_GPS_APPLICATIONS.VISIBLE_FLAG) = 'TRUE'
 
Possibly Referenced Tables/Views:
T_GPS_APP_PROPERTIES T_GPS_APPLICATIONS 


Close relationships: