OE.ORDERS (table)

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_CUSTOMER_IX		CUSTOMER_ID
ORD_ORDER_DATE_IX		ORDER_DATE
ORD_SALES_REP_IX		SALES_REP_ID

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

Relation	Column	Referenced Column
OE.CUSTOMERS	CUSTOMER_ID	CUSTOMER_ID
HR.EMPLOYEES	SALES_REP_ID	EMPLOYEE_ID

Detail Tables

Detail Table	Column	Referencing Column
OE.ORDER_ITEMS	ORDER_ID	ORDER_ID