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 Column Description
FIELD1 INTEGER
NULL
Customizable.
FIELD2 VARCHAR (254)
NULL
Customizable.
MEMBER_ID BIGINT
NOT NULL
The ID that uniquely identifies the customer of the order.
ORDERS_ID BIGINT
NOT NULL
The ID that uniquely identifies the order.
STOREENT_ID INTEGER
NOT NULL
The ID that uniquely identifies the store from which the customer placed the order.
Indexes:
Index Name Indexed Column Names Index Type
I168207 MEMBER_ID Non-Unique Index
SQL030416034913720 ORDERS_ID, MEMBER_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_258 STOREENT_ID STORE STORE_ID Cascade
F_259 MEMBER_ID MEMBER MEMBER_ID Cascade
F_260 ORDERS_ID ORDERS ORDERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable