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 Pending.
Column Descriptions
| 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 |
| SQL060903235146250
| 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