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
OE.CUSTOMERS_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
(7)
»
Sales.SalesTerritory_(table)
»
Purchasing.VendorContact_(table)
»
OE.CUSTOMERS_(table)
[X]
»
SH.DR$SUP_TEXT_IDX$R_(table)
»
OE.WAREHOUSES_(table)
»
IX.AQ$ORDERS_QUEUETABLE_S_(view)
»
Sales.SpecialOffer_(table)
»
Sales.SalesTerritory_(table)
»
Purchasing.VendorContact_(table)
»
OE.CUSTOMERS_(table)
Edit
wikibot
Table
OE.CUSTOMERS
Column
Data Type
Nullable
Default
PK
Index
CUSTOMER_ID
NUMBER(6, 0)
not null
CUSTOMERS_PK
CUST_FIRST_NAME
VARCHAR2(20)
not null
CUST_LAST_NAME
VARCHAR2(20)
not null
CUST_LNAME_IX
CUST_ADDRESS
OE.CUST_ADDRESS_TYP
null
PHONE_NUMBERS
OE.PHONE_LIST_TYP
null
NLS_LANGUAGE
VARCHAR2(3)
null
NLS_TERRITORY
VARCHAR2(30)
null
CREDIT_LIMIT
NUMBER(9, 2)
null
CUST_EMAIL
VARCHAR2(30)
null
CUST_EMAIL_IX
ACCOUNT_MGR_ID
NUMBER(6, 0)
null
CUST_ACCOUNT_MANAGER_IX
CUST_GEO_LOCATION
MDSYS.SDO_GEOMETRY
null
DATE_OF_BIRTH
DATE(7)
null
MARITAL_STATUS
VARCHAR2(20)
null
GENDER
VARCHAR2(1)
null
INCOME_LEVEL
VARCHAR2(20)
null
Relation
Column
Referenced Column
HR.EMPLOYEES
ACCOUNT_MGR_ID
EMPLOYEE_ID
Detail Table
Column
Referencing Column
OE.ORDERS
CUSTOMER_ID
CUSTOMER_ID
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.