OE ORDERS (table)

wikibot

TableOE.ORDERS
DescriptionContains orders entered by a salesperson as well as over the Web.

Columns

ColumnData TypeNullableDefaultDescription
ORDER_IDNUMBER(12, 0)not null PRIMARY KEY column.
ORDER_DATETIMESTAMP(6) WITH LOCAL TIME ZONEnot null TIMESTAMP WITH LOCAL TIME ZONE column, NOT NULL constraint.
ORDER_MODEVARCHAR2(8)null CHECK constraint.
CUSTOMER_IDNUMBER(6, 0)not null  
ORDER_STATUSNUMBER(2, 0)null 0: Not fully entered, 1: Entered, 2: Canceled - bad credit, -
ORDER_TOTALNUMBER(8, 2)null CHECK constraint.
SALES_REP_IDNUMBER(6, 0)null References hr.employees.employee_id.
PROMOTION_IDNUMBER(6, 0)null Sales promotion ID. Used in SH schema

Primary Key

Primary KeyColumns
ORDER_PKORDER_ID

Indexes

IndexTypeColumns
ORD_CUSTOMER_IX CUSTOMER_ID
ORD_ORDER_DATE_IX ORDER_DATE
ORD_SALES_REP_IX SALES_REP_ID

Check Constraints

Check ConstraintExpressionDescription
ORDER_CUSTOMER_ID_NN"CUSTOMER_ID" IS NOT NULL 
ORDER_DATE_NN"ORDER_DATE" IS NOT NULL 
ORDER_MODE_LOVorder_mode in ('direct','online') 
ORDER_TOTAL_MINorder_total >= 0 

Foreign Keys

RelationColumnReferenced Column
OE.CUSTOMERSCUSTOMER_IDCUSTOMER_ID
HR.EMPLOYEESSALES_REP_IDEMPLOYEE_ID

Detail Tables

Detail TableColumnReferencing Column
OE.ORDER_ITEMSORDER_IDORDER_ID