OE.ORDERS (table)

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