OE.ORDERS (table)
From dbscript Online Help
Contents |
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
| 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 |
Dependencies
| Reference Type | Object Type | Referencing Object |
| Select | View | OE.OC_CORPORATE_CUSTOMERS |
| Select | View | OE.OC_CUSTOMERS |
| Select | View | OE.OC_ORDERS |
| Select | View | OE.ORDERS_VIEW |
| Insert | Trigger | OE.ORDERS_TRG |
