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, -
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