OE.ORDER ITEMS (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

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

Columns[edit]

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[edit]

Primary Key Columns
ORDER_ITEMS_PK ORDER_ID, LINE_ITEM_ID

Indexes[edit]

Index Type Columns
ITEM_ORDER_IX ORDER_ID
ITEM_PRODUCT_IX PRODUCT_ID
ORDER_ITEMS_UK ORDER_ID, PRODUCT_ID

Check Constraints[edit]

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

Foreign Keys[edit]

Relation Column Referenced Column
OE.ORDERS ORDER_ID ORDER_ID
OE.PRODUCT_INFORMATION PRODUCT_ID PRODUCT_ID