OE.ORDERS (table) - Revision history

Bot at 09:35, 27 August 2011

2011-08-27T09:35:06Z

Bot at 05:15, 24 June 2010

2010-06-24T05:15:38Z

Bot at 07:28, 11 February 2010

2010-02-11T07:28:22Z

Bot at 19:00, 24 August 2009

2009-08-24T19:00:58Z

Bot: Replacing page with '== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''table | OE.ORDERS |- |}'

2009-08-24T18:57:15Z

Replacing page with '== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''table | OE.ORDERS |- |}'

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | OE.ORDERS |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-...

2009-05-02T17:06:03Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | OE.ORDERS |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| OE.ORDERS
|-
|}

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

|-
| ORDER_ID
| NUMBER
| not null
|
| ORDER_PK
|
|-
| ORDER_DATE
| TIMESTAMP(6) WITH LOCAL TIME ZONE
| not null
|
|
| ORD_ORDER_DATE_IX
|-
| ORDER_MODE
| VARCHAR2
| null
|
|
|
|-
| CUSTOMER_ID
| NUMBER
| not null
|
|
| ORD_CUSTOMER_IX
|-
| ORDER_STATUS
| NUMBER
| null
|
|
|
|-
| ORDER_TOTAL
| NUMBER
| null
|
|
|
|-
| SALES_REP_ID
| NUMBER
| null
|
|
| ORD_SALES_REP_IX
|-
| PROMOTION_ID
| NUMBER
| null
|
|
|
|}

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

|-
| [[OE.CUSTOMERS_(table)|OE.CUSTOMERS]]
| CUSTOMER_ID
| CUSTOMER_ID
|-
| [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
| SALES_REP_ID
| EMPLOYEE_ID
|}

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

|-
| [[OE.ORDER_ITEMS_(table)|OE.ORDER_ITEMS]]
| ORDER_ID
| ORDER_ID
|}

@@ Line 90: / Line 90: @@
 | '''Columns
 |- valign="top"
 | ORD_CUSTOMER_IX
@@ Line 102: / Line 98: @@
+|
 | ORDER_DATE
 |}
@@ Line 157: / Line 157: @@
 | ORDER_ID
 | ORDER_ID
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | OE.ORDERS
@@ Line 8: / Line 8: @@
 | '''Description
 | Contains orders entered by a salesperson as well as over the Web.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
-|-
+|- valign="top"
 | ORDER_ID
 | NUMBER(12, 0)
@@ Line 27: / Line 25: @@
+|
 | PRIMARY KEY column.
-|-
+|- valign="top"
 | ORDER_DATE
 | TIMESTAMP(6) WITH LOCAL TIME ZONE
@@ Line 33: / Line 31: @@
+|
 | TIMESTAMP WITH LOCAL TIME ZONE column, NOT NULL constraint.
-|-
+|- valign="top"
 | ORDER_MODE
 | VARCHAR2(8)
@@ Line 39: / Line 37: @@
+|
 | CHECK constraint.
-|-
+|- valign="top"
 | CUSTOMER_ID
 | NUMBER(6, 0)
@@ Line 45: / Line 43: @@
+|
+|
-|-
+|- valign="top"
 | ORDER_STATUS
 | NUMBER(2, 0)
@@ Line 55: / Line 53: @@
 : Shipped - special delivery, 8: Shipped - billed, 9: Shipped - payment plan,-
 : Shipped - paid
-|-
+|- valign="top"
 | ORDER_TOTAL
 | NUMBER(8, 2)
@@ Line 61: / Line 59: @@
+|
 | CHECK constraint.
-|-
+|- valign="top"
 | SALES_REP_ID
 | NUMBER(6, 0)
@@ Line 67: / Line 65: @@
+|
 | References hr.employees.employee_id.
-|-
+|- valign="top"
 | PROMOTION_ID
 | NUMBER(6, 0)
@@ Line 80: / Line 78: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | ORDER_PK
 | ORDER_ID
@@ Line 91: / Line 89: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | ORD_SALES_REP_IX
+|
 | SALES_REP_ID
-|-
+|- valign="top"
 | ORD_CUSTOMER_IX
+|
 | CUSTOMER_ID
-|-
+|- valign="top"
 | ORD_ORDER_DATE_IX
+|
@@ Line 112: / Line 110: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | ORDER_CUSTOMER_ID_NN
 | "CUSTOMER_ID" IS NOT NULL
+|
-|-
+|- valign="top"
 | ORDER_DATE_NN
 | "ORDER_DATE" IS NOT NULL
+|
-|-
+|- valign="top"
 | ORDER_MODE_LOV
 | order_mode in ('direct','online')
+|
-|-
+|- valign="top"
 | ORDER_TOTAL_MIN
 | order_total >= 0
@@ Line 137: / Line 135: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[OE.CUSTOMERS_(table)|OE.CUSTOMERS]]
 | CUSTOMER_ID
 | CUSTOMER_ID
-|-
+|- valign="top"
 | [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
 | SALES_REP_ID
@@ Line 154: / Line 152: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[OE.ORDER_ITEMS_(table)|OE.ORDER_ITEMS]]
 | ORDER_ID
@@ Line 168: / Line 166: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View
 | [[OE.OC_CORPORATE_CUSTOMERS_(view)|OE.OC_CORPORATE_CUSTOMERS]]
-|-
+|- valign="top"
 | Select
 | View
 | [[OE.OC_CUSTOMERS_(view)|OE.OC_CUSTOMERS]]
-|-
+|- valign="top"
 | Select
 | View
 | [[OE.OC_ORDERS_(view)|OE.OC_ORDERS]]
-|-
+|- valign="top"
 | Select
 | View
 | [[OE.ORDERS_VIEW_(view)|OE.ORDERS_VIEW]]
-|-
+|- valign="top"
 | Insert
 | Trigger
-| [[OE.ORDERS_TRG|OE.ORDERS_TRG]]
+| [[OE.ORDERS_TRG_()|OE.ORDERS_TRG]]
 |}