View HLPDTEST.STATEGPS.GPS_EWKS_NODE_PROPS_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
APPLICATION_NAME varchar2 255  √  null
APPLICATION_ID number 22
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
ROLE_APP_ID number 22
T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID Implied Constraint R
SET_NAME varchar2 255  √  null
SET_ID number 22
T_GPS_COND_ST_CHANGE_SETS.SET_ID Implied Constraint R
FORM_NAME varchar2 255  √  null
VIEWER_INSTANCES_ID number 22
T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID Implied Constraint R
CLASS_NAME varchar2 255
CLASS_ID number 22
T_GPS_RELATION_CLASSES.CLASS_ID Implied Constraint R
PROPERTY_NAME varchar2 255
ALIAS_NAME varchar2 255  √  null
PROPERTY_ID number 22
T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID Implied Constraint R
DISPLAY varchar2 10  √  null
EDIT varchar2 5  √  null
INSERT_FLAG varchar2 10  √  null
ROLE_NAME varchar2 255  √  null
ROLE_ID number 22
T_GPS_ROLES.ROLE_ID Implied Constraint R

Analyzed at Sun Nov 29 01:06 IST 2020

View Definition:
select t_gps_applications.application_name, t_gps_applications.application_id, T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID, t_gps_viewer_instances_set.set_name, t_gps_viewer_instances_set.set_id, t_gps_viewer_instances.form_name, t_gps_viewer_instances.viewer_instances_id, t_gps_viewer_instances_classes.class_name, t_gps_viewer_instances_classes.class_id, t_gps_viewer_inst_class_props.property_name, t_gps_viewer_inst_class_props.alias_name, t_gps_viewer_inst_class_props.property_id, t_gps_viewer_inst_class_props.display, t_gps_viewer_inst_class_props.edit, t_gps_viewer_inst_class_props.insert_flag, T_GPS_ROLES.ROLE_NAME, T_GPS_ROLES.ROLE_ID from stategps.t_gps_applications t_gps_applications, stategps.t_gps_viewer_instances_set t_gps_viewer_instances_set, stategps.t_gps_viewer_instances t_gps_viewer_instances, stategps.t_gps_viewer_instances_classes t_gps_viewer_instances_classes, stategps.t_gps_viewer_inst_class_props t_gps_viewer_inst_class_props , STATEGPS.T_GPS_ROLE_APPLICATIONS T_GPS_ROLE_APPLICATIONS, STATEGPS.T_GPS_ROLES T_GPS_ROLES, STATEGPS.t_Gps_Role_Viewer_Sets t_Gps_Role_Viewer_Sets, STATEGPS.t_Gps_Role_Viewer_Instances t_Gps_Role_Viewer_Instances WHERE t_gps_applications.Application_Id = t_gps_viewer_instances_set.Application_Id AND T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_ROLE_APPLICATIONS.APPLICATION_ID AND T_GPS_ROLES.ROLE_ID = T_GPS_ROLE_APPLICATIONS.ROLE_ID AND t_gps_viewer_instances_set.Set_Id = t_gps_viewer_instances.Set_Id AND t_gps_viewer_instances.Viewer_Instances_Id = t_gps_viewer_instances_classes.Viewer_Instances_Id AND t_gps_viewer_instances_classes.Class_Id = t_gps_viewer_inst_class_props.Class_Id AND t_Gps_Role_Viewer_Sets.Role_App_Id = T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID AND t_Gps_Role_Viewer_Sets.Set_Id = t_gps_viewer_instances_set.Set_Id AND t_Gps_Role_Viewer_Instances.Role_Viewerset_Id =t_Gps_Role_Viewer_Sets.Role_Viewerset_Id AND t_Gps_Role_Viewer_Instances.Viewer_Instance_Id = t_gps_viewer_instances.Viewer_Instances_Id AND t_gps_viewer_inst_class_props.PROPERTY_NAME NOT LIKE 'TRINITI%' AND T_GPS_VIEWER_INSTANCES.VISIBLE_FLAG = 'true' AND T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true'
 
Possibly Referenced Tables/Views:


Close relationships: