SH SUPPLEMENTARY_DEMOGRAPHICS (table)

Modified on 2011/08/27 12:11 by wikibot Categorized as Uncategorized

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| SH.SUPPLEMENTARY_DEMOGRAPHICS
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| CUST_ID
| NUMBER
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| EDUCATION
| VARCHAR2(21)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| OCCUPATION
| VARCHAR2(21)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| HOUSEHOLD_SIZE
| VARCHAR2(21)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| YRS_RESIDENCE
| NUMBER
| null
| &nbsp;
| &nbsp;
|- valign="top"
| AFFINITY_CARD
| NUMBER(10, 0)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| BULK_PACK_DISKETTES
| NUMBER(10, 0)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| FLAT_PANEL_MONITOR
| NUMBER(10, 0)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| HOME_THEATER_PACKAGE
| NUMBER(10, 0)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| BOOKKEEPING_APPLICATION
| NUMBER(10, 0)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| PRINTER_SUPPLIES
| NUMBER(10, 0)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| Y_BOX_GAMES
| NUMBER(10, 0)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| OS_DOC_SET_KANJI
| NUMBER(10, 0)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| COMMENTS
| VARCHAR2(4000)
| null
| &nbsp;
| &nbsp;
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index'''
| '''Type'''
| '''Columns'''

|- valign="top"
| SUP_TEXT_IDX
| &nbsp;
| COMMENTS
|}

=== Check Constraints ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Check Constraint'''
| '''Expression'''
| '''Description'''

|- valign="top"
| SYS_C005190
| "CUST_ID" IS NOT NULL
| &nbsp;
|}

devio dbscript ScrewTurn Wiki

Navigation¶

SH SUPPLEMENTARY_DEMOGRAPHICS (table)