SH SUPPLEMENTARY_DEMOGRAPHICS (table)

wikibot

TableSH.SUPPLEMENTARY_DEMOGRAPHICS

Columns

ColumnData TypeNullableDefaultDescription
CUST_IDNUMBERnot null  
EDUCATIONVARCHAR2(21)null  
OCCUPATIONVARCHAR2(21)null  
HOUSEHOLD_SIZEVARCHAR2(21)null  
YRS_RESIDENCENUMBERnull  
AFFINITY_CARDNUMBER(10, 0)null  
BULK_PACK_DISKETTESNUMBER(10, 0)null  
FLAT_PANEL_MONITORNUMBER(10, 0)null  
HOME_THEATER_PACKAGENUMBER(10, 0)null  
BOOKKEEPING_APPLICATIONNUMBER(10, 0)null  
PRINTER_SUPPLIESNUMBER(10, 0)null  
Y_BOX_GAMESNUMBER(10, 0)null  
OS_DOC_SET_KANJINUMBER(10, 0)null  
COMMENTSVARCHAR2(4000)null  

Indexes

IndexTypeColumns
SUP_TEXT_IDX COMMENTS

Check Constraints

Check ConstraintExpressionDescription
SYS_C005190"CUST_ID" IS NOT NULL