SH.DR$SUP TEXT IDX$I (table)

From dbscript Online Help
Revision as of 08:29, 11 February 2010 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table SH.DR$SUP_TEXT_IDX$I


Columns

Column Data Type Nullable Default Description
TOKEN_TEXT VARCHAR2(64) not null
TOKEN_TYPE NUMBER(3, 0) not null
TOKEN_FIRST NUMBER(10, 0) not null
TOKEN_LAST NUMBER(10, 0) not null
TOKEN_COUNT NUMBER(10, 0) not null
TOKEN_INFO BLOB(4000) null

Indexes

Index Type Columns
DR$SUP_TEXT_IDX$X TOKEN_TEXT, TOKEN_TYPE, TOKEN_FIRST, TOKEN_LAST, TOKEN_COUNT

Check Constraints

Check Constraint Expression Description
SYS_C005233 "TOKEN_TEXT" IS NOT NULL
SYS_C005234 "TOKEN_TYPE" IS NOT NULL
SYS_C005235 "TOKEN_FIRST" IS NOT NULL
SYS_C005236 "TOKEN_LAST" IS NOT NULL
SYS_C005237 "TOKEN_COUNT" IS NOT NULL