Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: SH SUPPLEMENTARY_DEMOGRAPHICS (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/02/11 09:20


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.