Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDPROMOCD
This table contains promotion codes captured for an order.
Column Name Column Type Description ID BIGINT NOT NULL The primary key of this table. ORDERS_ID BIGINT NOT NULL Foreign key that references the ORDERS_ID column in the ORDERS table. CODE VARCHAR(128) NOT NULL The promotion code that is associated with this order. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030404330 ID Primary Key I0000418 ORDERS_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1076 ORDERS_ID ORDERS ORDERS_ID Cascade _vcc_freeselect_bottom_