SchemaSpy - Table TBASE2.TBASE2.EXPLAIN_PREDICATE

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

SQL070118163138050

1

EXPLAIN_TIME

timestamp

16,6

EXPLAIN_STATEMENT.EXPLAIN_TIME

SQL070118163138050

2

SOURCE_NAME

varchar

128

EXPLAIN_STATEMENT.SOURCE_NAME

SQL070118163138050

3

SOURCE_SCHEMA

varchar

128

EXPLAIN_STATEMENT.SOURCE_SCHEMA

SQL070118163138050

4

SOURCE_VERSION

varchar

64

EXPLAIN_STATEMENT.SOURCE_VERSION

SQL070118163138050

5

EXPLAIN_LEVEL

char

1

EXPLAIN_STATEMENT.EXPLAIN_LEVEL

SQL070118163138050

6

STMTNO

integer

4

EXPLAIN_STATEMENT.STMTNO

SQL070118163138050

7

SECTNO

integer

4

EXPLAIN_STATEMENT.SECTNO

SQL070118163138050

8

OPERATOR_ID

integer

4

9

PREDICATE_ID

integer

4

10

HOW_APPLIED

char

5

11

WHEN_EVALUATED

char

3

12

RELOP_TYPE

char

2

13

SUBQUERY

char

1

14

FILTER_FACTOR

double

8

15

PREDICATE_TEXT

clob

2097152

√

null

Table contained 377 rows at Fri Nov 14 16:57 EST 2008