ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
SH.SUPPLEMENTARY_DEMOGRAPHICS_(table)
Print
RSS
Modified: 2010/06/24 06:53 by
wikibot
-
Uncategorized
(10)
»
public.assets_(table)
»
OE.OC_CUSTOMERS_(view)
»
SH.SUPPLEMENTARY_DEMOGRAPHICS_(table)
[X]
»
Sales.SalesOrderHeader_(table)
»
public.events_(table)
»
public.ipinterface_(table)
»
public.ifservices_(table)
»
Sales.SalesPerson_(table)
»
public.atinterface_(table)
»
Person.Address_(table)
»
public.assets_(table)
»
OE.OC_CUSTOMERS_(view)
»
SH.SUPPLEMENTARY_DEMOGRAPHICS_(table)
Edit
wikibot
Table
SH.SUPPLEMENTARY_DEMOGRAPHICS
Edit
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
Edit
Indexes
Index
Type
Columns
SUP_TEXT_IDX
COMMENTS
Edit
Check Constraints
Check Constraint
Expression
Description
SYS_C005190
"CUST_ID" IS NOT NULL
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.