Difference between revisions of "OE.ORDER ITEMS (table)"

From dbscript Online Help
Jump to: navigation, search
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| OE.ORDER_ITEMS
 
| OE.ORDER_ITEMS
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Example of many-to-many resolution.
 
| Example of many-to-many resolution.
|-
 
 
|}
 
|}
 
  
 
=== Columns ===
 
=== Columns ===
Line 20: Line 18:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| ORDER_ID
 
| ORDER_ID
 
| NUMBER(12, 0)
 
| NUMBER(12, 0)
Line 27: Line 25:
 
|  
 
|  
 
| Part of concatenated primary key, references orders.order_id.
 
| Part of concatenated primary key, references orders.order_id.
|-
+
|- valign="top"
 
| LINE_ITEM_ID
 
| LINE_ITEM_ID
 
| NUMBER(3, 0)
 
| NUMBER(3, 0)
Line 33: Line 31:
 
|  
 
|  
 
| Part of concatenated primary key.
 
| Part of concatenated primary key.
|-
+
|- valign="top"
 
| PRODUCT_ID
 
| PRODUCT_ID
 
| NUMBER(6, 0)
 
| NUMBER(6, 0)
Line 39: Line 37:
 
|  
 
|  
 
| References product_information.product_id.
 
| References product_information.product_id.
|-
+
|- valign="top"
 
| UNIT_PRICE
 
| UNIT_PRICE
 
| NUMBER(8, 2)
 
| NUMBER(8, 2)
Line 45: Line 43:
 
|  
 
|  
 
|  
 
|  
|-
+
|- valign="top"
 
| QUANTITY
 
| QUANTITY
 
| NUMBER(8, 0)
 
| NUMBER(8, 0)
Line 58: Line 56:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
|-
+
|- valign="top"
 
| ORDER_ITEMS_PK
 
| ORDER_ITEMS_PK
 
| ORDER_ID, LINE_ITEM_ID
 
| ORDER_ID, LINE_ITEM_ID
Line 69: Line 67:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
+
 
|-
+
|- valign="top"
 
| ITEM_ORDER_IX
 
| ITEM_ORDER_IX
 
|  
 
|  
 
| ORDER_ID
 
| ORDER_ID
|-
+
|- valign="top"
 
| ITEM_PRODUCT_IX
 
| ITEM_PRODUCT_IX
 
|  
 
|  
 
| PRODUCT_ID
 
| PRODUCT_ID
|-
+
|- valign="top"
 
| ORDER_ITEMS_UK
 
| ORDER_ITEMS_UK
 
|  
 
|  
Line 90: Line 88:
 
| '''Expression
 
| '''Expression
 
| '''Description
 
| '''Description
+
 
|-
+
|- valign="top"
 
| SYS_C005039
 
| SYS_C005039
 
| "LINE_ITEM_ID" IS NOT NULL
 
| "LINE_ITEM_ID" IS NOT NULL
 
|  
 
|  
|-
+
|- valign="top"
 
| SYS_C005040
 
| SYS_C005040
 
| "PRODUCT_ID" IS NOT NULL
 
| "PRODUCT_ID" IS NOT NULL
Line 107: Line 105:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
+
 
|-
+
|- valign="top"
 
| [[OE.ORDERS_(table)|OE.ORDERS]]
 
| [[OE.ORDERS_(table)|OE.ORDERS]]
 
| ORDER_ID
 
| ORDER_ID
 
| ORDER_ID
 
| ORDER_ID
|-
+
|- valign="top"
 
| [[OE.PRODUCT_INFORMATION_(table)|OE.PRODUCT_INFORMATION]]
 
| [[OE.PRODUCT_INFORMATION_(table)|OE.PRODUCT_INFORMATION]]
 
| PRODUCT_ID
 
| PRODUCT_ID
Line 125: Line 123:
 
| '''Referencing Object
 
| '''Referencing Object
  
|-
+
|- valign="top"
 
| Select
 
| Select
 
| View
 
| View
 
| [[OE.OC_CORPORATE_CUSTOMERS_(view)|OE.OC_CORPORATE_CUSTOMERS]]
 
| [[OE.OC_CORPORATE_CUSTOMERS_(view)|OE.OC_CORPORATE_CUSTOMERS]]
  
|-
+
|- valign="top"
 
| Select
 
| Select
 
| View
 
| View
 
| [[OE.OC_CUSTOMERS_(view)|OE.OC_CUSTOMERS]]
 
| [[OE.OC_CUSTOMERS_(view)|OE.OC_CUSTOMERS]]
  
|-
+
|- valign="top"
 
| Select
 
| Select
 
| View
 
| View
 
| [[OE.OC_ORDERS_(view)|OE.OC_ORDERS]]
 
| [[OE.OC_ORDERS_(view)|OE.OC_ORDERS]]
  
|-
+
|- valign="top"
 
| Select
 
| Select
 
| Trigger
 
| Trigger
| [[OE.INSERT_ORD_LINE|OE.INSERT_ORD_LINE]]
+
| [[OE.INSERT_ORD_LINE_()|OE.INSERT_ORD_LINE]]
  
 
|}
 
|}

Revision as of 06:15, 24 June 2010

wikibot

Table OE.ORDER_ITEMS
Description Example of many-to-many resolution.

Columns

Column Data Type Nullable Default Description
ORDER_ID NUMBER(12, 0) not null Part of concatenated primary key, references orders.order_id.
LINE_ITEM_ID NUMBER(3, 0) not null Part of concatenated primary key.
PRODUCT_ID NUMBER(6, 0) not null References product_information.product_id.
UNIT_PRICE NUMBER(8, 2) null
QUANTITY NUMBER(8, 0) null

Primary Key

Primary Key Columns
ORDER_ITEMS_PK ORDER_ID, LINE_ITEM_ID

Indexes

Index Type Columns
ITEM_ORDER_IX ORDER_ID
ITEM_PRODUCT_IX PRODUCT_ID
ORDER_ITEMS_UK ORDER_ID, PRODUCT_ID

Check Constraints

Check Constraint Expression Description
SYS_C005039 "LINE_ITEM_ID" IS NOT NULL
SYS_C005040 "PRODUCT_ID" IS NOT NULL

Foreign Keys

Relation Column Referenced Column
OE.ORDERS ORDER_ID ORDER_ID
OE.PRODUCT_INFORMATION PRODUCT_ID PRODUCT_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 Trigger OE.INSERT_ORD_LINE