SchemaSpy - View HLPDTEST.STATEGPS.T_GPS_APP_WORKFLOW

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

APPLICATION_ID

number

T_GPS_APPLICATIONS.APPLICATION_ID

Implied Constraint R

APPLICATION_NAME

varchar2

255

√

null

WORKFLOW_TYPE_ID

number

T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID

Implied Constraint R

WORKFLOW_TYPE_NAME

varchar2

255

WORKFLOW_DESCRIPTION

varchar2

1000

√

null

Analyzed at Tue Aug 11 01:05 IST 2020

View Definition:

( SELECT T1.APPLICATION_ID,T1.APPLICATION_NAME,T2.WORKFLOW_TYPE_ID,T2.WORKFLOW_TYPE_NAME, T2.DESCRIPTION "WORKFLOW_DESCRIPTION" FROM T_GPS_APPLICATIONS T1,T_GPS_WORKFLOW_TYPES T2 WHERE T1.APPLICATION_ID = T2.APPLICATION_ID )

Possibly Referenced Tables/Views:

T_GPS_APPLICATIONS T_GPS_WORKFLOW_TYPES