From dbscript Online Help
wikibot
| Table
|
OE.ORDERS
|
| Description
|
Contains orders entered by a salesperson as well as over the Web.
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| ORDER_ID
|
NUMBER(12, 0)
|
not null
|
|
PRIMARY KEY column.
|
| ORDER_DATE
|
TIMESTAMP(6) WITH LOCAL TIME ZONE
|
not null
|
|
TIMESTAMP WITH LOCAL TIME ZONE column, NOT NULL constraint.
|
| ORDER_MODE
|
VARCHAR2(8)
|
null
|
|
CHECK constraint.
|
| CUSTOMER_ID
|
NUMBER(6, 0)
|
not null
|
|
|
| ORDER_STATUS
|
NUMBER(2, 0)
|
null
|
|
0: Not fully entered, 1: Entered, 2: Canceled - bad credit, -
3: Canceled - by customer, 4: Shipped - whole order, -
5: Shipped - replacement items, 6: Shipped - backlog on items, -
7: Shipped - special delivery, 8: Shipped - billed, 9: Shipped - payment plan,-
10: Shipped - paid
|
| ORDER_TOTAL
|
NUMBER(8, 2)
|
null
|
|
CHECK constraint.
|
| SALES_REP_ID
|
NUMBER(6, 0)
|
null
|
|
References hr.employees.employee_id.
|
| PROMOTION_ID
|
NUMBER(6, 0)
|
null
|
|
Sales promotion ID. Used in SH schema
|
Primary Key
| Primary Key
|
Columns
|
| ORDER_PK
|
ORDER_ID
|
Indexes
| Index
|
Type
|
Columns
|
| ORD_SALES_REP_IX
|
|
SALES_REP_ID
|
| ORD_CUSTOMER_IX
|
|
CUSTOMER_ID
|
| ORD_ORDER_DATE_IX
|
|
ORDER_DATE
|
Check Constraints
| Check Constraint
|
Expression
|
Description
|
| ORDER_CUSTOMER_ID_NN
|
"CUSTOMER_ID" IS NOT NULL
|
|
| ORDER_DATE_NN
|
"ORDER_DATE" IS NOT NULL
|
|
| ORDER_MODE_LOV
|
order_mode in ('direct','online')
|
|
| ORDER_TOTAL_MIN
|
order_total >= 0
|
|
Foreign Keys
Detail Tables
| Detail Table
|
Column
|
Referencing Column
|
| OE.ORDER_ITEMS
|
ORDER_ID
|
ORDER_ID
|
Dependencies
