OE.ORDER ITEMS (table)

From dbscript Online Help

Contents 1 wikibot 1.1 Columns 1.2 Primary Key 1.3 Indexes 1.4 Check Constraints 1.5 Foreign Keys 1.6 Dependencies

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