Difference between revisions of "SH.SUPPLEMENTARY DEMOGRAPHICS (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | SH.SUPPLEMENTARY_DEMOGRAPHICS |- |} {| border="1" cellpadding="5" cellspacin...) |
|||
| Line 27: | Line 27: | ||
|- | |- | ||
| EDUCATION | | EDUCATION | ||
| − | | VARCHAR2 | + | | VARCHAR2(21) |
| null | | null | ||
| | | | ||
| Line 34: | Line 34: | ||
|- | |- | ||
| OCCUPATION | | OCCUPATION | ||
| − | | VARCHAR2 | + | | VARCHAR2(21) |
| null | | null | ||
| | | | ||
| Line 41: | Line 41: | ||
|- | |- | ||
| HOUSEHOLD_SIZE | | HOUSEHOLD_SIZE | ||
| − | | VARCHAR2 | + | | VARCHAR2(21) |
| null | | null | ||
| | | | ||
| Line 55: | Line 55: | ||
|- | |- | ||
| AFFINITY_CARD | | AFFINITY_CARD | ||
| − | | NUMBER | + | | NUMBER(10, 0) |
| null | | null | ||
| | | | ||
| Line 62: | Line 62: | ||
|- | |- | ||
| BULK_PACK_DISKETTES | | BULK_PACK_DISKETTES | ||
| − | | NUMBER | + | | NUMBER(10, 0) |
| null | | null | ||
| | | | ||
| Line 69: | Line 69: | ||
|- | |- | ||
| FLAT_PANEL_MONITOR | | FLAT_PANEL_MONITOR | ||
| − | | NUMBER | + | | NUMBER(10, 0) |
| null | | null | ||
| | | | ||
| Line 76: | Line 76: | ||
|- | |- | ||
| HOME_THEATER_PACKAGE | | HOME_THEATER_PACKAGE | ||
| − | | NUMBER | + | | NUMBER(10, 0) |
| null | | null | ||
| | | | ||
| Line 83: | Line 83: | ||
|- | |- | ||
| BOOKKEEPING_APPLICATION | | BOOKKEEPING_APPLICATION | ||
| − | | NUMBER | + | | NUMBER(10, 0) |
| null | | null | ||
| | | | ||
| Line 90: | Line 90: | ||
|- | |- | ||
| PRINTER_SUPPLIES | | PRINTER_SUPPLIES | ||
| − | | NUMBER | + | | NUMBER(10, 0) |
| null | | null | ||
| | | | ||
| Line 97: | Line 97: | ||
|- | |- | ||
| Y_BOX_GAMES | | Y_BOX_GAMES | ||
| − | | NUMBER | + | | NUMBER(10, 0) |
| null | | null | ||
| | | | ||
| Line 104: | Line 104: | ||
|- | |- | ||
| OS_DOC_SET_KANJI | | OS_DOC_SET_KANJI | ||
| − | | NUMBER | + | | NUMBER(10, 0) |
| null | | null | ||
| | | | ||
| Line 111: | Line 111: | ||
|- | |- | ||
| COMMENTS | | COMMENTS | ||
| − | | VARCHAR2 | + | | VARCHAR2(4000) |
| null | | null | ||
| | | | ||
Revision as of 21:01, 24 August 2009
wikibot
| Table | SH.SUPPLEMENTARY_DEMOGRAPHICS |
| Column | Data Type | Nullable | Default | PK | Index |
| 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 | SUP_TEXT_IDX |
