Table TBASE2.TBASE2.EXPLAIN_STREAM Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
ID Column Type Size Nulls Auto Default Children Parents Comments
0 EXPLAIN_REQUESTER varchar 128
EXPLAIN_STATEMENT.EXPLAIN_REQUESTER SQL070118163138080
1 EXPLAIN_TIME timestamp 16,6
EXPLAIN_STATEMENT.EXPLAIN_TIME SQL070118163138080
2 SOURCE_NAME varchar 128
EXPLAIN_STATEMENT.SOURCE_NAME SQL070118163138080
3 SOURCE_SCHEMA varchar 128
EXPLAIN_STATEMENT.SOURCE_SCHEMA SQL070118163138080
4 SOURCE_VERSION varchar 64
EXPLAIN_STATEMENT.SOURCE_VERSION SQL070118163138080
5 EXPLAIN_LEVEL char 1
EXPLAIN_STATEMENT.EXPLAIN_LEVEL SQL070118163138080
6 STMTNO integer 4
EXPLAIN_STATEMENT.STMTNO SQL070118163138080
7 SECTNO integer 4
EXPLAIN_STATEMENT.SECTNO SQL070118163138080
8 STREAM_ID integer 4
9 SOURCE_TYPE char 1
10 SOURCE_ID integer 4
11 TARGET_TYPE char 1
12 TARGET_ID integer 4
13 OBJECT_SCHEMA varchar 128  √  null
14 OBJECT_NAME varchar 128  √  null
15 STREAM_COUNT double 8
16 COLUMN_COUNT smallint 2
17 PREDICATE_ID integer 4
18 COLUMN_NAMES clob 2097152  √  null
19 PMID smallint 2
20 SINGLE_NODE char 5  √  null
21 PARTITION_COLUMNS clob 2097152  √  null

Table contained 10,540 rows at Fri Nov 14 16:57 EST 2008


Close relationships  within of separation: