Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDERMGP
This table is used to track the customer segments to which an Order is associated.
Column Name Column Type Description ORDERS_ID BIGINT NOT NULL Foreign key to the ORDERS table. MBRGRP_ID BIGINT NOT NULL Foreign key to the MBRGRP table. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030401560 ORDERS_ID+MBRGRP_ID Primary Key I0000650 MBRGRP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_510 MBRGRP_ID MBRGRP MBRGRP_ID Cascade F_511 ORDERS_ID ORDERS ORDERS_ID Cascade
Related reference
_vcc_freeselect_bottom_