Table HLPDTEST.STATEGPS.T_PLANNED_ACCOMPLISHED 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
PA_ID number 22
INSTANCE_ID number 22
T_INSTANCES.INSTANCE_ID PA_INSTANCE_ID_FK R
STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID PA_STATE_ID_FK R
PLANNED varchar2 4  √  null
ACCOMPLISHED varchar2 4  √  null
NOTES varchar2 4000  √  null
WEEK_DATE date 7

Table contained 266 rows at Sat Dec 05 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
PA_ID Primary key Asc PA_ID_PK

Close relationships  within of separation: