ScrewTurn Wiki

Edit

wikibot

TableOE.ORDER_ITEMS
DescriptionExample of many-to-many resolution.

Edit

Columns

ColumnData TypeNullableDefaultDescription
ORDER_IDNUMBER(12, 0)not null Part of concatenated primary key, references orders.order_id.
LINE_ITEM_IDNUMBER(3, 0)not null Part of concatenated primary key.
PRODUCT_IDNUMBER(6, 0)not null References product_information.product_id.
UNIT_PRICENUMBER(8, 2)null  
QUANTITYNUMBER(8, 0)null  

Edit

Primary Key

Primary KeyColumns
ORDER_ITEMS_PKORDER_ID, LINE_ITEM_ID

Edit

Indexes

IndexTypeColumns
ITEM_ORDER_IX ORDER_ID
ITEM_PRODUCT_IX PRODUCT_ID
ORDER_ITEMS_UK ORDER_ID, PRODUCT_ID

Edit

Check Constraints

Check ConstraintExpressionDescription
SYS_C005039"LINE_ITEM_ID" IS NOT NULL 
SYS_C005040"PRODUCT_ID" IS NOT NULL 

Edit

Foreign Keys

RelationColumnReferenced Column
OE.ORDERSORDER_IDORDER_ID
OE.PRODUCT_INFORMATIONPRODUCT_IDPRODUCT_ID

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.