Table HLPDTEST.STATEGPS.T_REPORTING_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
TAG_ID number 22
T_PROJECT_CURRENT_PLAN_TAG_V.TAG_ID Implied Constraint R
T_PROJECT_PLAN_TAGS.TAG_ID T_PRJ_PLAN_TAG_ID_FK R
T_PROJECT_PLAN_TAGS_V.TAG_ID Implied Constraint R
T_REPORTING_PLAN_TASKS.TAG_ID T_REPORTING_PLAN_TASKS_FK R
TAG varchar2 255
DESCRIPTION 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 4 rows at Thu Oct 28 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name
TAG_ID Primary key Asc T_REPORTING_PLAN_TAGS_PK
TAG Must be unique Asc T_REPORTING_PLAN_TAGS_UQ

Close relationships  within of separation: