This table contains details about how promotions
are applied to an order.
Column Descriptions:
| Name | Type | Description |
| ORDERS_ID | BIGINT NOT NULL | Foreign key to ORDERS table. This is the ID of an
order to which promotions were applied. |
| DETAIL | CLOB (1000000) | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | ORDERS_ID | Primary Key |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_1051 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |