SchemaSpy - Table TBASE2.TBASE2.EXPLAIN_STREAM

Generated by
SchemaSpy

Legend:

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