From dbscript Online Help
wikibot[edit]
| Table
|
SH.SUPPLEMENTARY_DEMOGRAPHICS
|
Columns[edit]
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| CUST_ID
|
NUMBER
|
not null
|
|
|
| EDUCATION
|
VARCHAR2(21)
|
null
|
|
|
| OCCUPATION
|
VARCHAR2(21)
|
null
|
|
|
| HOUSEHOLD_SIZE
|
VARCHAR2(21)
|
null
|
|
|
| YRS_RESIDENCE
|
NUMBER
|
null
|
|
|
| AFFINITY_CARD
|
NUMBER(10, 0)
|
null
|
|
|
| BULK_PACK_DISKETTES
|
NUMBER(10, 0)
|
null
|
|
|
| FLAT_PANEL_MONITOR
|
NUMBER(10, 0)
|
null
|
|
|
| HOME_THEATER_PACKAGE
|
NUMBER(10, 0)
|
null
|
|
|
| BOOKKEEPING_APPLICATION
|
NUMBER(10, 0)
|
null
|
|
|
| PRINTER_SUPPLIES
|
NUMBER(10, 0)
|
null
|
|
|
| Y_BOX_GAMES
|
NUMBER(10, 0)
|
null
|
|
|
| OS_DOC_SET_KANJI
|
NUMBER(10, 0)
|
null
|
|
|
| COMMENTS
|
VARCHAR2(4000)
|
null
|
|
|
Indexes[edit]
| Index
|
Type
|
Columns
|
| SUP_TEXT_IDX
|
|
COMMENTS
|
Check Constraints[edit]
| Check Constraint
|
Expression
|
Description
|
| SYS_C005190
|
"CUST_ID" IS NOT NULL
|
|
