Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CPENDORDER
Each row of this table indicates that an order is marked as current for a customer in a store, if its status is "P" (Pending).
Column Name Column Type Description STOREENT_ID INTEGER NOT NULL The ID that uniquely identifies the store from which the customer placed the order. ORDERS_ID BIGINT NOT NULL The ID that uniquely identifies the order. MEMBER_ID BIGINT NOT NULL The ID that uniquely identifies the customer of the order. FIELD1 INTEGER Customizable. FIELD2 VARCHAR(254) Customizable. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030319940 ORDERS_ID+MEMBER_ID Primary Key I0000542 STOREENT_ID Non-Unique Index I168207 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_259 MEMBER_ID MEMBER MEMBER_ID Cascade F_260 ORDERS_ID ORDERS ORDERS_ID Cascade F_258 STOREENT_ID STORE STORE_ID Cascade
Related reference
_vcc_freeselect_bottom_