Difference between revisions of "OE.ORDERS (table)"
| Line 90: | Line 90: | ||
| '''Columns | | '''Columns | ||
| − | |||
| − | |||
| − | |||
| − | |||
|- valign="top" | |- valign="top" | ||
| ORD_CUSTOMER_IX | | ORD_CUSTOMER_IX | ||
| Line 102: | Line 98: | ||
| | | | ||
| ORDER_DATE | | ORDER_DATE | ||
| + | |- valign="top" | ||
| + | | ORD_SALES_REP_IX | ||
| + | | | ||
| + | | SALES_REP_ID | ||
|} | |} | ||
| Line 157: | Line 157: | ||
| ORDER_ID | | ORDER_ID | ||
| ORDER_ID | | ORDER_ID | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
Latest revision as of 10:35, 27 August 2011
Contents
wikibot[edit]
| Table | OE.ORDERS |
| Description | Contains orders entered by a salesperson as well as over the Web. |
Columns[edit]
| 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[edit]
| Primary Key | Columns |
| ORDER_PK | ORDER_ID |
Indexes[edit]
| Index | Type | Columns |
| ORD_CUSTOMER_IX | CUSTOMER_ID | |
| ORD_ORDER_DATE_IX | ORDER_DATE | |
| ORD_SALES_REP_IX | SALES_REP_ID |
Check Constraints[edit]
| 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[edit]
| Relation | Column | Referenced Column |
| OE.CUSTOMERS | CUSTOMER_ID | CUSTOMER_ID |
| HR.EMPLOYEES | SALES_REP_ID | EMPLOYEE_ID |
Detail Tables[edit]
| Detail Table | Column | Referencing Column |
| OE.ORDER_ITEMS | ORDER_ID | ORDER_ID |
