Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
SH SUPPLEMENTARY_DEMOGRAPHICS (table)
Print
RSS
Modified on 2011/08/27 12:11
by
wikibot
Categorized as
Uncategorized
dbo Name (type)
Person (schema)
Purchasing VendorAddress (table)
Sales CustomerAddress (table)
Sales vIndividualCustomer (view)
Sales vStoreWithDemographics (view)
public notifications (table)
dbo Name (type)
Person (schema)
Purchasing VendorAddress (table)
Sales CustomerAddress (table)
Sales vIndividualCustomer (view)
Sales vStoreWithDemographics (view)
public notifications (table)
»
public usersnotified (table)
»
Person AddressType (table)
»
SH SUPPLEMENTARY_DEMOGRAPHICS (table)
[X]
»
public usersnotified (table)
»
Person AddressType (table)
»
SH SUPPLEMENTARY_DEMOGRAPHICS (table)
wikibot
¶
Table
SH.SUPPLEMENTARY_DEMOGRAPHICS
Columns
¶
Column
Data Type
Nullable
Default
Description
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
Indexes
¶
Index
Type
Columns
SUP_TEXT_IDX
COMMENTS
Check Constraints
¶
Check Constraint
Expression
Description
SYS_C005190
"CUST_ID" IS NOT NULL
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.