WebSphere Commerce database table: BIDORDRREL

This table describes the relationship between bids and orders.

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235130270 ORDERS_ID+BID_ID Primary Key
I0000479 BID_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_121 BID_ID BID BID_ID Cascade
F_120 ORDERS_ID ORDERS ORDERS_ID Cascade
Related reference