WebSphere Commerce database table: ORDPROMOCD

This table contains promotion codes captured for an order.

Column Descriptions

Column Name	Column Type	Description
ID	BIGINT NOT NULL	No ID external description assigned yet
ORDERS_ID	BIGINT NOT NULL	No ORDERS_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
SQL060903235222900	ID	Primary Key
I0000418	ORDERS_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1076	ORDERS_ID	ORDERS	ORDERS_ID	Cascade