WebSphere Commerce database table: BIDORDRREL

This table describes the relationship between bids and orders.


Column Description(s):
Column NameColumn TypeDescription
BID_ID BIGINT NOT NULL Bid ID.
CREATETIME TIMESTAMP Date and time this entry is created.
STATUS CHAR(4) Order status. Valid values are as follows:
  • C=complete
  • P=pending
COMMENTS VARCHAR(254) Comments about the order.
ORDERS_ID BIGINT NOT NULL The order ID that corresponds to the bid.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031201270 ORDERS_ID+BID_ID Primary Key
I0000479 BID_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_121 BID_ID BID BID_ID Cascade
F_120 ORDERS_ID ORDERS ORDERS_ID Cascade

Feedback