WebSphere Commerce database table: ORDITPROMOCD

This contains promotion codes that were captured with an order for the orderitems in the order.

Column Descriptions

Column Name	Column Type	Description
ID	BIGINT NOT NULL	No ID external description assigned yet
ORDERITEMS_ID	BIGINT NOT NULL	No ORDERITEMS_ID external description assigned yet
CODE	VARCHAR(128) NOT NULL	No CODE external description assigned yet
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235221670	ID	Primary Key
I0000419	ORDERITEMS_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1077	ORDERITEMS_ID	ORDERITEMS	ORDERITEMS_ID	Cascade