Table HLPDTEST.STATEGPS.T_PROJECT_PLAN_TAGS Generated by
SchemaSpy
Legend: SourceForge.net
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
PROJECT_TAG_ID number 22
T_GPS_WORKFLOW_STATES.PROJECT_TAG_ID WORKFLOW_STATES_PROJECT_TAG_FG R
TAG_ID number 22
T_REPORTING_PLAN_TAGS.TAG_ID T_PRJ_PLAN_TAG_ID_FK R
PROJECT_ID number 22
T_GPS_APPLICATIONS.APPLICATION_ID T_PRJ_PLAN_PROJECT_ID_FK R
ESTIMATED_DURATION number 22  √  null
PERCENTAGE number 22  √  null
TAG_ORDER number 22  √  null
PREDECESSOR varchar2 255  √  null
START_DATE timestamp(6) 11,6 current_timestamp
END_DATE timestamp(6) 11,6 current_timestamp
ACTIVE varchar2 255  √  null
CREATED_BY varchar2 255
CREATED_DATE timestamp(6) 11,6 current_timestamp
UPDATED_BY varchar2 255
UPDATED_DATE timestamp(6) 11,6 current_timestamp

Table contained 8 rows at Mon Apr 12 01:05 IST 2021

Indexes:
Column(s) Type Sort Constraint Name
PROJECT_TAG_ID Primary key Asc T_PROJECT_PLAN_TAGS_PK
TAG_ID + PROJECT_ID Must be unique Asc/Asc T_PROJECT_PLAN_TAGS_UQ

Close relationships  within of separation: