Reference > Database > WebSphere Commerce database tables > B

WebSphere Commerce database table: BIDORDRREL

This table describes the relationship between bids and orders.

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... 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
SQL100520030302710	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

• Win bids data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search