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.ORDERS_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
(6)
»
public.service_(table)
»
AdventureWorks 2008-05 OLTP
»
OE.ORDERS_(table)
[X]
»
HumanResources.EmployeePayHistory_(table)
»
OE.ORDER_ITEMS_(table)
»
Purchasing.VendorAddress_(table)
»
public.service_(table)
»
AdventureWorks 2008-05 OLTP
»
OE.ORDERS_(table)
Edit
wikibot
Table
OE.ORDERS
Column
Data Type
Nullable
Default
PK
Index
ORDER_ID
NUMBER(12, 0)
not null
ORDER_PK
ORDER_DATE
TIMESTAMP(6) WITH LOCAL TIME ZONE
not null
ORD_ORDER_DATE_IX
ORDER_MODE
VARCHAR2(8)
null
CUSTOMER_ID
NUMBER(6, 0)
not null
ORD_CUSTOMER_IX
ORDER_STATUS
NUMBER(2, 0)
null
ORDER_TOTAL
NUMBER(8, 2)
null
SALES_REP_ID
NUMBER(6, 0)
null
ORD_SALES_REP_IX
PROMOTION_ID
NUMBER(6, 0)
null
Relation
Column
Referenced Column
OE.CUSTOMERS
CUSTOMER_ID
CUSTOMER_ID
HR.EMPLOYEES
SALES_REP_ID
EMPLOYEE_ID
Detail Table
Column
Referencing Column
OE.ORDER_ITEMS
ORDER_ID
ORDER_ID
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.