SchemaSpy - View HLPDTEST.STATEGPS.V_INSTANCE

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

INSTANCE_ID

number

T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID

Implied Constraint R

PRIORITY

number

√

null

IA_ISSUE_NUMBER

varchar2

4000

√

null

IA_ISSUE_TITLE

varchar2

4000

√

null

Analyzed at Wed May 25 01:05 IST 2022

View Definition:

select i.instance_id, i.priority, property_value AS IA_ISSUE_NUMBER, (select property_value from t_gps_instance_properties where instance_id = ip.instance_id and property_name = 'tri2.SG_TRI2_ENTITY.IA_ISSUE_TITLE') IA_ISSUE_TITLE from t_gps_instance_properties ip, t_instances i where ip.instance_id = i.instance_id and property_name = 'tri2.SG_TRI2_ENTITY.IA_ISSUE_NUMBER' and property_value is not null

Possibly Referenced Tables/Views:

T_GPS_INSTANCE_PROPERTIES T_INSTANCES