Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDITPROMOCD
This contains promotion codes that were captured with an order for the orderitems in the order. This table is intended for customization and is not used by default implementation.
Column Name Column 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030403230 ID Primary Key I0000419 ORDERITEMS_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1077 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade _vcc_freeselect_bottom_