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

From dbscript Online Help
Jump to: navigation, search
Line 3: Line 3:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|-
 
|-
−
| '''table
+
| '''Table
 
| OE.ORDER_ITEMS
 
| OE.ORDER_ITEMS
 
|-
 
|-
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''PK
 +
| '''Index
 +
 +
|-
 +
| ORDER_ID
 +
| NUMBER(12, 0)
 +
| not null
 +
|
 +
| ORDER_ITEMS_PK
 +
| ITEM_ORDER_IXORDER_ITEMS_UK
 +
|-
 +
| LINE_ITEM_ID
 +
| NUMBER(3, 0)
 +
| not null
 +
|
 +
| ORDER_ITEMS_PK
 +
|
 +
|-
 +
| PRODUCT_ID
 +
| NUMBER(6, 0)
 +
| not null
 +
|
 +
|
 +
| ITEM_PRODUCT_IXORDER_ITEMS_UK
 +
|-
 +
| UNIT_PRICE
 +
| NUMBER(8, 2)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| QUANTITY
 +
| NUMBER(8, 0)
 +
| null
 +
|
 +
|
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[OE.ORDERS_(table)|OE.ORDERS]]
 +
| ORDER_ID
 +
| ORDER_ID
 +
|-
 +
| [[OE.PRODUCT_INFORMATION_(table)|OE.PRODUCT_INFORMATION]]
 +
| PRODUCT_ID
 +
| PRODUCT_ID
 
|}
 
|}

Revision as of 20:00, 24 August 2009

wikibot

Table OE.ORDER_ITEMS


Column Data Type Nullable Default PK Index
ORDER_ID NUMBER(12, 0) not null ORDER_ITEMS_PK ITEM_ORDER_IXORDER_ITEMS_UK
LINE_ITEM_ID NUMBER(3, 0) not null ORDER_ITEMS_PK
PRODUCT_ID NUMBER(6, 0) not null ITEM_PRODUCT_IXORDER_ITEMS_UK
UNIT_PRICE NUMBER(8, 2) null
QUANTITY NUMBER(8, 0) null


Relation Column Referenced Column
OE.ORDERS ORDER_ID ORDER_ID
OE.PRODUCT_INFORMATION PRODUCT_ID PRODUCT_ID
Retrieved from "http://dbshelp.devio.at/index.php?title=OE.ORDER_ITEMS_(table)&oldid=874"