Reference > Database > WebSphere Commerce database tables > B


WebSphere Commerce database table: BID

This table stores bid information. The information is updated when a customer submits a bid.

Column Name Column Type Description
BID_ID BIGINT NOT NULL Bid ID. Primary key to this table.
REFCODE CHAR(36) NOT NULL Reference code. A unique code that identifies the auction.
AUCPAYINFO_ID BIGINT Reserved for IBM internal use.
OWNER_ID BIGINT NOT NULL The user who submitted the bid.
STORE_ID INTEGER Store that is conducting the auction.
ADMIN_ID BIGINT ID of the administrator who retracted the autobid or bid.
AUCT_ID BIGINT NOT NULL Auction ID. Foreign key to AUCTION table.
BIDQUANT DOUBLE NOT NULL Bid quantity.
BIDPRICE DECIMAL (20,5) NOT NULL The bid price.
BIDTIME TIMESTAMP NOT NULL The time the bid was placed.
WINOPT CHAR(4) NOT NULL Indicates if bidder will accept partial quantity. Valid values are...

  • A=bidder only accepts full

  • P=bidder will accept partial

BIDSTATUS CHAR(4) NOT NULL The bid status. Valid values are...

  • A=active

  • R=retracted by customer

  • S=superceded

  • W=winning

  • D=delete by administrator

  • C=order completed successfully created from this bid

  • WC=create order failed and see logs for details.

PAYTYPE CHAR(64) NOT NULL Payment type. This is set to the value of the cardBrand payment parameter when the bid is submitted.
ENCRYPT INTEGER NOT NULL Indicates if the credit card number is encrypted or not. Valid values are...

  • 0=not encrypted

  • 1=encrypted

DEVICE VARCHAR(64) NOT NULL Credit card number.
EXPDATE TIMESTAMP NOT NULL Expiration date for the credit card.
QUANTSCALE INTEGER Reserved for IBM internal use.
AUTOBID_ID BIGINT Points to the AUTOBID table if this bid was created from an autobid.
BIDROOT BIGINT Reserved for IBM internal use.
BKNAME VARCHAR(254) Bank name.
SHIPTO_ID BIGINT Ship to address.
SHIPMODE INTEGER Ship mode.
WINPRICE DECIMAL (20,5) Win price for the bid based on the close price rule.
WINQUANT DOUBLE Win quantity.
BIDMSG VARCHAR(254) Message set by the bidder.
FIELD1 BIGINT Customizable.
FIELD2 DECIMAL (20,5) Customizable.
FIELD3 VARCHAR(254) Customizable.
BILLADDR BIGINT Billing address for the customer.
INITPRICE DECIMAL (20,5) Reserved for IBM internal use.
LIMITPRICE DECIMAL (20,5) Reserved for IBM internal use.
BIDMODE CHAR(4) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000041 REFCODE Unique Index
SQL100520030302380 BID_ID Primary Key
I0000042 AUTOBID_ID Non-Unique Index
I0000043 BIDQUANT Non-Unique Index
I0000044 BIDPRICE Non-Unique Index
I0000045 BIDSTATUS Non-Unique Index
I0000473 ADMIN_ID Non-Unique Index
I0000474 OWNER_ID Non-Unique Index
I0000475 STORE_ID Non-Unique Index
I0001243 AUCPAYINFO_ID Non-Unique Index
I0001244 AUCT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_111 AUCPAYINFO_ID AUCPAYINFO AUCPAYINFO_ID Cascade
F_112 AUCT_ID AUCTION AUCT_ID Cascade
F_114 OWNER_ID MEMBER MEMBER_ID Cascade
F_115 ADMIN_ID MEMBER MEMBER_ID Cascade
F_113 STORE_ID STORE STORE_ID Cascade

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_121 BID_ID BIDORDRREL BID_ID Cascade
F_123 BID_ID BIDPAYMENT BID_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search