OE ORDERS (table)

Modified on 2011/08/27 12:10 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| OE.ORDERS
|- valign="top"
| '''Description'''
| Contains orders entered by a salesperson as well as over the Web.
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| ORDER_ID
| NUMBER(12, 0)
| not null
| &nbsp;
| PRIMARY KEY column.
|- valign="top"
| ORDER_DATE
| TIMESTAMP(6) WITH LOCAL TIME ZONE
| not null
| &nbsp;
| TIMESTAMP WITH LOCAL TIME ZONE column, NOT NULL constraint.
|- valign="top"
| ORDER_MODE
| VARCHAR2(8)
| null
| &nbsp;
| CHECK constraint.
|- valign="top"
| CUSTOMER_ID
| NUMBER(6, 0)
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| ORDER_STATUS
| NUMBER(2, 0)
| null
| &nbsp;
| 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
|- valign="top"
| ORDER_TOTAL
| NUMBER(8, 2)
| null
| &nbsp;
| CHECK constraint.
|- valign="top"
| SALES_REP_ID
| NUMBER(6, 0)
| null
| &nbsp;
| References hr.employees.employee_id.
|- valign="top"
| PROMOTION_ID
| NUMBER(6, 0)
| null
| &nbsp;
| Sales promotion ID. Used in SH schema
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key'''
| '''Columns'''
|- valign="top"
| ORDER_PK
| ORDER_ID
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index'''
| '''Type'''
| '''Columns'''

|- valign="top"
| ORD_CUSTOMER_IX
| &nbsp;
| CUSTOMER_ID
|- valign="top"
| ORD_ORDER_DATE_IX
| &nbsp;
| ORDER_DATE
|- valign="top"
| ORD_SALES_REP_IX
| &nbsp;
| SALES_REP_ID
|}

=== Check Constraints ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Check Constraint'''
| '''Expression'''
| '''Description'''

|- valign="top"
| ORDER_CUSTOMER_ID_NN
| "CUSTOMER_ID" IS NOT NULL
| &nbsp;
|- valign="top"
| ORDER_DATE_NN
| "ORDER_DATE" IS NOT NULL
| &nbsp;
|- valign="top"
| ORDER_MODE_LOV
| order_mode in ('direct','online')
| &nbsp;
|- valign="top"
| ORDER_TOTAL_MIN
| order_total >= 0
| &nbsp;
|}

=== Foreign Keys ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation'''
| '''Column'''
| '''Referenced Column'''

|- valign="top"
| [[OE CUSTOMERS (table)|OE.CUSTOMERS]]
| CUSTOMER_ID
| CUSTOMER_ID
|- valign="top"
| [[HR EMPLOYEES (table)|HR.EMPLOYEES]]
| SALES_REP_ID
| EMPLOYEE_ID
|}

=== Detail Tables ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table'''
| '''Column'''
| '''Referencing Column'''

|- valign="top"
| [[OE ORDER_ITEMS (table)|OE.ORDER_ITEMS]]
| ORDER_ID
| ORDER_ID
|}
devio dbscript ScrewTurn Wiki

Navigation¶

OE ORDERS (table)
