Table HLPDTEST.STATEGPS.PLAN_TABLE 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
STATEMENT_ID varchar2 30  √  null
TIMESTAMP date 7  √  null
REMARKS varchar2 80  √  null
OPERATION varchar2 30  √  null
OPTIONS varchar2 30  √  null
OBJECT_NODE varchar2 128  √  null
OBJECT_OWNER varchar2 30  √  null
OBJECT_NAME varchar2 30  √  null
OBJECT_INSTANCE number 22  √  null
OBJECT_TYPE varchar2 30  √  null
OPTIMIZER varchar2 255  √  null
SEARCH_COLUMNS number 22  √  null
ID number 22  √  null
T_DELETE_ROW_ACTION_UPDATE.ID Implied Constraint R
PARENT_ID number 22  √  null
POSITION number 22  √  null
COST number 22  √  null
CARDINALITY number 22  √  null
BYTES number 22  √  null
OTHER_TAG varchar2 255  √  null
PARTITION_START varchar2 255  √  null
PARTITION_STOP varchar2 255  √  null
PARTITION_ID number 22  √  null
OTHER long 0  √  null
DISTRIBUTION varchar2 30  √  null
CPU_COST number 22  √  null
IO_COST number 22  √  null
TEMP_SPACE number 22  √  null

Table contained 0 rows at Thu Dec 09 01:06 IST 2021


Close relationships: