WebSphere Commerce database table: PX_PROMOARG

This table contains details about how promotions are applied to an order.


Column Description(s):
Column NameColumn TypeDescription
ORDERS_ID BIGINT NOT NULL Foreign key to ORDERS table. This is the ID of an order to which promtions were applied.
DETAIL CLOB Details of how promotions are applied to an order. The size of this column is currently set to 4M, which will support approximately 3400 discounts applied to a single order. In the case of where it is possible to have more discounts applied to a single order, the limit can be increased. No other code change is needed. For each 1M limit added to the limit, approximately 850 additional discounts can be supported in an order.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031301500 ORDERS_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1051 ORDERS_ID ORDERS ORDERS_ID Cascade

Feedback