SH.SUPPLEMENTARY DEMOGRAPHICS (table)

From dbscript Online Help
Jump to: navigation, search

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