SH.SUPPLEMENTARY DEMOGRAPHICS (table)
From dbscript Online Help
Contents |
wikibot
| Table | SH.SUPPLEMENTARY_DEMOGRAPHICS |
Columns
| 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
| Index | Type | Columns |
| SUP_TEXT_IDX | COMMENTS |
Check Constraints
| Check Constraint | Expression | Description |
| SYS_C005190 | "CUST_ID" IS NOT NULL |
