SchemaSpy - View HLPDTEST.STATEGPS.T_PROJECT_DA

Generated by
SchemaSpy

Legend:

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

STATE_ID

number

√

null

T_GPS_WORKFLOW_STATES.STATE_ID

Implied Constraint R

TASK_ID

varchar2

2500

√

null

TASK_NAME

varchar2

2258

√

null

Analyzed at Wed Oct 20 01:06 IST 2021

View Definition:

(SELECT A.STATE_ID, A.TASK_ID, A.TASK_NAME || ' @ ' || B.STATE_NAME AS TASK_NAME FROM T_PROJECT_TASK A, T_GPS_WORKFLOW_STATES B WHERE A.TASK_NAME != B.STATE_NAME AND A.STATE_ID = B.STATE_ID) UNION (SELECT A.STATE_ID, A.TASK_ID, A.TASK_NAME FROM T_PROJECT_TASK A, T_GPS_WORKFLOW_STATES B WHERE A.TASK_NAME = B.STATE_NAME AND A.STATE_ID = B.STATE_ID)

Possibly Referenced Tables/Views:

T_GPS_WORKFLOW_STATES T_PROJECT_TASK