View HLPDTEST.STATEGPS.T_GPS_INSTANCE_FEEDBACK_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
QUESTION varchar2 500  √  null
QUESTION_TYPE varchar2 500  √  null
INSTANCE_ID number 22  √  null
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
WORKFLOW_TYPE_ID number 22
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Implied Constraint R
WORKFLOW_TYPE_NAME varchar2 255
STATE_ID number 22
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R
STATE_NAME varchar2 255  √  null
APPLICATION_ID number 22
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
APPLICATION_NAME varchar2 255  √  null
OWNER varchar2 500  √  null
FEEDBACK_ANSWER varchar2 4000  √  null
FEEDBACK_DATE date 7  √  null
INSTANCE_PRIMARY_ID number 22  √  null
T_GPS_INSTANCES.INSTANCE_PRIMARY_ID Implied Constraint R
QUESTION_ID number 22  √  null
T_GPS_WF_STATE_FEEDBACK_FORM.QUESTION_ID Implied Constraint R

Analyzed at Sun Nov 29 01:06 IST 2020

View Definition:
SELECT T_GPS_WF_STATE_FEEDBACK_FORM.QUESTION , T_GPS_WF_STATE_FEEDBACK_FORM.QUESTION_TYPE , T_GPS_INSTANCES.INSTANCE_ID , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME , T_GPS_WORKFLOW_STATES.STATE_ID , T_GPS_WORKFLOW_STATES.STATE_NAME , T_GPS_APPLICATIONS.APPLICATION_ID , T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_INSTANCES.OWNER , T_GPS_INSTANCE_FEEDBACK.FEEDBACK_ANSWER , T_GPS_INSTANCE_FEEDBACK.FEEDBACK_DATE , T_GPS_INSTANCE_FEEDBACK.INSTANCE_PRIMARY_ID , T_GPS_INSTANCE_FEEDBACK.QUESTION_ID FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS , STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES , STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES , STATEGPS.T_GPS_INSTANCES T_GPS_INSTANCES , STATEGPS.T_GPS_WF_STATE_FEEDBACK_FORM T_GPS_WF_STATE_FEEDBACK_FORM , STATEGPS.T_GPS_INSTANCE_FEEDBACK T_GPS_INSTANCE_FEEDBACK WHERE T_GPS_WORKFLOW_STATES.STATE_ID = T_GPS_WF_STATE_FEEDBACK_FORM.STATE_ID AND T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID AND T_GPS_INSTANCE_FEEDBACK.INSTANCE_PRIMARY_ID = T_GPS_INSTANCES.INSTANCE_PRIMARY_ID AND T_GPS_WORKFLOW_TYPES.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID AND T_GPS_WF_STATE_FEEDBACK_FORM.QUESTION_ID = T_GPS_INSTANCE_FEEDBACK.QUESTION_ID
 
Possibly Referenced Tables/Views:
T_GPS_APPLICATIONS T_GPS_INSTANCE_FEEDBACK T_GPS_INSTANCES T_GPS_WF_STATE_FEEDBACK_FORM T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_TYPES 


Close relationships: