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
HR ADD_JOB_HISTORY (procedure)
HR COUNTRIES (table)
HR DEPARTMENTS (table)
HR DEPARTMENTS_SEQ (sequence)
HR EMP_DETAILS_VIEW (view)
HR EMPLOYEES (table)
HR EMPLOYEES_SEQ (sequence)
HR JOB_HISTORY (table)
HR JOBS (table)
HR LOCATIONS (table)
HR LOCATIONS_SEQ (sequence)
HR REGIONS (table)
HR SECURE_DML (procedure)
IX AQ$_ORDERS_QUEUETABLE_G (table)
IX AQ$_ORDERS_QUEUETABLE_H (table)
IX AQ$_ORDERS_QUEUETABLE_I (table)
IX AQ$_ORDERS_QUEUETABLE_N (sequence)
IX AQ$_ORDERS_QUEUETABLE_S (table)
IX AQ$_ORDERS_QUEUETABLE_T (table)
IX AQ$_STREAMS_QUEUE_TABLE_G (table)
IX AQ$_STREAMS_QUEUE_TABLE_H (table)
IX AQ$_STREAMS_QUEUE_TABLE_I (table)
IX AQ$_STREAMS_QUEUE_TABLE_N (sequence)
IX AQ$_STREAMS_QUEUE_TABLE_S (table)
IX AQ$_STREAMS_QUEUE_TABLE_T (table)
IX AQ$ORDERS_QUEUETABLE (view)
IX AQ$ORDERS_QUEUETABLE_R (view)
IX AQ$ORDERS_QUEUETABLE_S (view)
IX AQ$STREAMS_QUEUE_TABLE (view)
IX AQ$STREAMS_QUEUE_TABLE_R (view)
IX AQ$STREAMS_QUEUE_TABLE_S (view)
IX ORDER_EVENT_TYP (type)
IX ORDERS_QUEUETABLE (table)
IX STREAMS_QUEUE_TABLE (table)
IX SYS_IOT_OVER_49905 (table)
IX SYS_IOT_OVER_49922 (table)
OE ACCOUNT_MANAGERS (view)
OE BOMBAY_INVENTORY (view)
OE CATALOG_TYP (type)
OE CATEGORIES_TAB (table)
OE CATEGORY_TYP (type)
OE COMPOSITE_CATEGORY_TYP (type)
OE CORPORATE_CUSTOMER_TYP (type)
OE CUST_ADDRESS_TYP (type)
OE CUSTOMER_TYP (type)
OE CUSTOMERS (table)
OE CUSTOMERS_VIEW (view)
OE DEPTVIEW (view)
OE GET_PHONE_NUMBER_F (function)
OE INVENTORIES (table)
OE INVENTORY_LIST_TYP (type)
OE INVENTORY_TYP (type)
OE LEAF_CATEGORY_TYP (type)
OE OC_CORPORATE_CUSTOMERS (view)
OE OC_CUSTOMERS (view)
OE OC_INVENTORIES (view)
OE OC_ORDERS (view)
OE OC_PRODUCT_INFORMATION (view)
OE ORDER_ITEM_LIST_TYP (type)
OE ORDER_ITEM_TYP (type)
OE ORDER_ITEMS (table)
OE ORDER_LIST_TYP (type)
OE ORDER_TYP (type)
OE ORDERS (table)
OE ORDERS_SEQ (sequence)
OE ORDERS_VIEW (view)
OE PHONE_LIST_TYP (type)
OE PRODUCT_DESCRIPTIONS (table)
OE PRODUCT_INFORMATION (table)
OE PRODUCT_INFORMATION_TYP (type)
OE PRODUCT_PRICES (view)
OE PRODUCT_REF_LIST_NESTEDTAB (table)
OE PRODUCT_REF_LIST_TYP (type)
OE PRODUCTS (view)
OE PROMOTIONS (table)
OE PURCHASEORDERS (table)
OE STYLESHEET_TAB (table)
OE SUBCATEGORY_REF_LIST_NESTEDTAB (table)
OE SUBCATEGORY_REF_LIST_TYP (type)
OE SYDNEY_INVENTORY (view)
OE SYS_YOID0000050342$ (type)
OE SYS_YOID0000050344$ (type)
OE SYS_YOID0000050346$ (type)
OE SYS_YOID0000050348$ (type)
OE SYS_YOID0000050350$ (type)
OE TORONTO_INVENTORY (view)
OE WAREHOUSE_TYP (type)
OE WAREHOUSES (table)
OE XDBPO_ACTION_COLLECTION (type)
OE XDBPO_ACTION_TYPE (type)
OE XDBPO_ACTIONS_TYPE (type)
OE XDBPO_LINEITEM_COLLECTION (type)
OE XDBPO_LINEITEM_TYPE (type)
OE XDBPO_LINEITEMS_TYPE (type)
OE XDBPO_PART_TYPE (type)
OE XDBPO_REJECTION_TYPE (type)
OE XDBPO_SHIPINSTRUCTIONS_TYPE (type)
OE XDBPO_TYPE (type)
PM ADHEADER_TYP (type)
PM ONLINE_MEDIA (table)
PM PRINT_MEDIA (table)
PM TEXTDOC_TAB (type)
PM TEXTDOC_TYP (type)
PM TEXTDOCS_NESTEDTAB (table)
SH CAL_MONTH_SALES_MV (table)
SH CHANNELS (table)
SH COSTS (table)
SH COUNTRIES (table)
SH CUSTOMERS (table)
SH DR$SUP_TEXT_IDX$I (table)
SH DR$SUP_TEXT_IDX$K (table)
SH DR$SUP_TEXT_IDX$N (table)
SH DR$SUP_TEXT_IDX$R (table)
SH FWEEK_PSCAT_SALES_MV (table)
SH MVIEW$_EXCEPTIONS (table)
SH PRODUCTS (table)
SH PROFITS (view)
SH PROMOTIONS (table)
SH SALES (table)
SH SALES_TRANSACTIONS_EXT (table)
SH SUPPLEMENTARY_DEMOGRAPHICS (table)
SH TIMES (table)
Production Product (table)
Production ProductListPriceHistory (table)
Sales (schema)
Sales Store (table)
HumanResources (schema)
HumanResources JobCandidate (table)
Database Objects AdventureWorks
Database Objects OpenNMS
Database Objects Oracle Demo Schema
SnippetsAndTemplates
WikiMarkup
WikiMarkup-Pictures
WikiMarkup-Tables
HR ADD_JOB_HISTORY (procedure)
HR COUNTRIES (table)
HR DEPARTMENTS (table)
HR DEPARTMENTS_SEQ (sequence)
HR EMP_DETAILS_VIEW (view)
HR EMPLOYEES (table)
HR EMPLOYEES_SEQ (sequence)
HR JOB_HISTORY (table)
HR JOBS (table)
HR LOCATIONS (table)
HR LOCATIONS_SEQ (sequence)
HR REGIONS (table)
HR SECURE_DML (procedure)
IX AQ$_ORDERS_QUEUETABLE_G (table)
IX AQ$_ORDERS_QUEUETABLE_H (table)
IX AQ$_ORDERS_QUEUETABLE_I (table)
IX AQ$_ORDERS_QUEUETABLE_N (sequence)
IX AQ$_ORDERS_QUEUETABLE_S (table)
IX AQ$_ORDERS_QUEUETABLE_T (table)
IX AQ$_STREAMS_QUEUE_TABLE_G (table)
IX AQ$_STREAMS_QUEUE_TABLE_H (table)
IX AQ$_STREAMS_QUEUE_TABLE_I (table)
IX AQ$_STREAMS_QUEUE_TABLE_N (sequence)
IX AQ$_STREAMS_QUEUE_TABLE_S (table)
IX AQ$_STREAMS_QUEUE_TABLE_T (table)
IX AQ$ORDERS_QUEUETABLE (view)
IX AQ$ORDERS_QUEUETABLE_R (view)
IX AQ$ORDERS_QUEUETABLE_S (view)
IX AQ$STREAMS_QUEUE_TABLE (view)
IX AQ$STREAMS_QUEUE_TABLE_R (view)
IX AQ$STREAMS_QUEUE_TABLE_S (view)
IX ORDER_EVENT_TYP (type)
IX ORDERS_QUEUETABLE (table)
IX STREAMS_QUEUE_TABLE (table)
IX SYS_IOT_OVER_49905 (table)
IX SYS_IOT_OVER_49922 (table)
OE ACCOUNT_MANAGERS (view)
OE BOMBAY_INVENTORY (view)
OE CATALOG_TYP (type)
OE CATEGORIES_TAB (table)
OE CATEGORY_TYP (type)
OE COMPOSITE_CATEGORY_TYP (type)
OE CORPORATE_CUSTOMER_TYP (type)
OE CUST_ADDRESS_TYP (type)
OE CUSTOMER_TYP (type)
OE CUSTOMERS (table)
OE CUSTOMERS_VIEW (view)
OE DEPTVIEW (view)
OE GET_PHONE_NUMBER_F (function)
OE INVENTORIES (table)
OE INVENTORY_LIST_TYP (type)
OE INVENTORY_TYP (type)
OE LEAF_CATEGORY_TYP (type)
OE OC_CORPORATE_CUSTOMERS (view)
OE OC_CUSTOMERS (view)
OE OC_INVENTORIES (view)
OE OC_ORDERS (view)
OE OC_PRODUCT_INFORMATION (view)
OE ORDER_ITEM_LIST_TYP (type)
OE ORDER_ITEM_TYP (type)
OE ORDER_ITEMS (table)
OE ORDER_LIST_TYP (type)
OE ORDER_TYP (type)
OE ORDERS (table)
OE ORDERS_SEQ (sequence)
OE ORDERS_VIEW (view)
OE PHONE_LIST_TYP (type)
OE PRODUCT_DESCRIPTIONS (table)
OE PRODUCT_INFORMATION (table)
OE PRODUCT_INFORMATION_TYP (type)
OE PRODUCT_PRICES (view)
OE PRODUCT_REF_LIST_NESTEDTAB (table)
OE PRODUCT_REF_LIST_TYP (type)
OE PRODUCTS (view)
OE PROMOTIONS (table)
OE PURCHASEORDERS (table)
OE STYLESHEET_TAB (table)
OE SUBCATEGORY_REF_LIST_NESTEDTAB (table)
OE SUBCATEGORY_REF_LIST_TYP (type)
OE SYDNEY_INVENTORY (view)
OE SYS_YOID0000050342$ (type)
OE SYS_YOID0000050344$ (type)
OE SYS_YOID0000050346$ (type)
OE SYS_YOID0000050348$ (type)
OE SYS_YOID0000050350$ (type)
OE TORONTO_INVENTORY (view)
OE WAREHOUSE_TYP (type)
OE WAREHOUSES (table)
OE XDBPO_ACTION_COLLECTION (type)
OE XDBPO_ACTION_TYPE (type)
OE XDBPO_ACTIONS_TYPE (type)
OE XDBPO_LINEITEM_COLLECTION (type)
OE XDBPO_LINEITEM_TYPE (type)
OE XDBPO_LINEITEMS_TYPE (type)
OE XDBPO_PART_TYPE (type)
OE XDBPO_REJECTION_TYPE (type)
OE XDBPO_SHIPINSTRUCTIONS_TYPE (type)
OE XDBPO_TYPE (type)
PM ADHEADER_TYP (type)
PM ONLINE_MEDIA (table)
PM PRINT_MEDIA (table)
PM TEXTDOC_TAB (type)
PM TEXTDOC_TYP (type)
PM TEXTDOCS_NESTEDTAB (table)
SH CAL_MONTH_SALES_MV (table)
SH CHANNELS (table)
SH COSTS (table)
SH COUNTRIES (table)
SH CUSTOMERS (table)
SH DR$SUP_TEXT_IDX$I (table)
SH DR$SUP_TEXT_IDX$K (table)
SH DR$SUP_TEXT_IDX$N (table)
SH DR$SUP_TEXT_IDX$R (table)
SH FWEEK_PSCAT_SALES_MV (table)
SH MVIEW$_EXCEPTIONS (table)
SH PRODUCTS (table)
SH PROFITS (view)
SH PROMOTIONS (table)
SH SALES (table)
SH SALES_TRANSACTIONS_EXT (table)
SH SUPPLEMENTARY_DEMOGRAPHICS (table)
SH TIMES (table)
Production Product (table)
Production ProductListPriceHistory (table)
(6)
»
dbo ufnGetProductListPrice (function)
»
Database Objects Oracle Demo Schema
»
SH SUPPLEMENTARY_DEMOGRAPHICS (table)
[X]
»
Main Page
»
HumanResources vJobCandidateEducation (view)
»
Sales StoreSurveySchemaCollection (xml schema collection)
»
dbo ufnGetProductListPrice (function)
»
Database Objects Oracle Demo Schema
»
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
.