View HLPDTEST.STATEGPS.T_GPS_INSTANCE_FEEDBACK_V | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Wed May 25 01:05 IST 2022 |
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:
![]() ![]() |