OE.ORDER ITEMS (table)
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 |
