SchemaSpy - View HLPDTEST.STATEGPS.T_INSTANCE_OWNER

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

OWNER

varchar2

500

√

null

INSTANCE_ID

number

√

null

T_INSTANCES.INSTANCE_ID

Implied Constraint R

CURRENT_STATE_ID

number

√

null

CREATED_DATE

date

√

null

Analyzed at Wed Oct 20 01:06 IST 2021

View Definition:

SELECT A.OWNER,A.INSTANCE_ID,A.CURRENT_STATE_ID,A.CREATED_DATE FROM T_GPS_INSTANCES A WHERE A.CREATED_DATE = (SELECT MIN(Y.CREATED_DATE) FROM T_GPS_INSTANCES Y WHERE A.INSTANCE_ID = Y.INSTANCE_ID AND Y.CURRENT_STATE_ID = (SELECT MIN(X.CURRENT_STATE_ID) FROM T_GPS_INSTANCES X WHERE A.INSTANCE_ID = X.INSTANCE_ID))

Possibly Referenced Tables/Views:

T_GPS_INSTANCES