This table contains details about how promotions are applied to an order.
Column Description(s):
Column Name | Column Type | Description |
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 Name | Indexed Column Names | Index Type |
SQL050212031301500 |
ORDERS_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1051 |
ORDERS_ID |
ORDERS |
ORDERS_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.