This contains promotion codes that were captured
with an order for the order items in the order. This table is
intended for customization and is not used by default
implementation.
Column Descriptions:
Name | Type | Description |
ID | BIGINT NOT NULL | The primary key of the table. |
ORDERITEMS_ID | BIGINT NOT NULL | Foreign key to the ORDERITEMS table. |
CODE | VARCHAR (128) NOT NULL | The promotion code that is associated with the
orderitem. |
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> | ID | Primary Key |
I0000419 | ORDERITEMS_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_1077 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |