Welcome Guest, you are in: • Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

SH SUPPLEMENTARY_DEMOGRAPHICS (table)

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

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 

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.