SchemaSpy - Table TBASE2.TBASE2.ADVISE

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

ID	Column	Type	Size	Nulls	Default
0	EXPLAIN_REQUESTER	varchar	128		''
1	EXPLAIN_TIME	timestamp	16,6		now
2	SOURCE_NAME	varchar	128		''
3	SOURCE_SCHEMA	varchar	128		''
4	SOURCE_VERSION	varchar	64		''
5	EXPLAIN_LEVEL	char	1		''
6	STMTNO	integer	4		0
7	SECTNO	integer	4		0
8	QUERYNO	integer	4		0
9	QUERYTAG	char	20		''
10	NAME	varchar	128
11	CREATOR	varchar	128		''
12	TBNAME	varchar	128
13	TBCREATOR	varchar	128		''
14	COLNAMES	clob	2097152
15	UNIQUERULE	char	1		''
16	COLCOUNT	smallint	2		0
17	IID	smallint	2		0
18	NLEAF	integer	4		0
19	NLEVELS	smallint	2		0
20	FIRSTKEYCARD	bigint	8		0
21	FULLKEYCARD	bigint	8		0
22	CLUSTERRATIO	smallint	2		0
23	CLUSTERFACTOR	double	8		0
24	USERDEFINED	smallint	2		0
25	SYSTEM_REQUIRED	smallint	2		0
26	CREATE_TIME	timestamp	16,6		now
27	STATS_TIME	timestamp	16,6	√	now
28	PAGE_FETCH_PAIRS	varchar	254		''
29	REMARKS	varchar	254	√	''
30	DEFINER	varchar	128		''
31	CONVERTED	char	1		''
32	SEQUENTIAL_PAGES	integer	4		0
33	DENSITY	integer	4		0
34	FIRST2KEYCARD	bigint	8		0
35	FIRST3KEYCARD	bigint	8		0
36	FIRST4KEYCARD	bigint	8		0
37	PCTFREE	smallint	2		-1
38	UNIQUE_COLCOUNT	smallint	2		-1
39	MINPCTUSED	smallint	2		0
40	REVERSE_SCANS	char	1		'N'
41	USE_INDEX	char	1	√	null
42	CREATION_TEXT	clob	2097152		''
43	PACKED_DESC	blob	1048576	√	null

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