WebSphere Commerce database table: BIDLOG

This table tracks bid change history. The bid is written to the BIDLOG table before it is changed in the BID table.

Column Descriptions
Column Name Column Type Description
BID_ID BIGINT NOT NULL Bid ID.
ACTIONTIME TIMESTAMP NOT NULL Date and time that the bid was changed.
ACTIONTYPE INTEGER Type of change to the bid.
AUCPAYINFO_ID BIGINT Reserved for IBM internal use.
STORE_ID INTEGER Store that is conducting the auction.
OWNER_ID BIGINT ID of the customer who submitted the bid.
ADMIN_ID BIGINT ID of the administrator who retracted the autobid or bid.
ACTIONMSG VARCHAR(254) Reason the bid was changed.
REFCODE CHAR(36) Reference code. A unique code that identifies the auction.
AUCT_ID BIGINT Auction ID for the auction that the bid is based on.
BIDQUANT DOUBLE Bid quantity.
BIDPRICE DECIMAL (20,5) The bid price.
BIDTIME TIMESTAMP The time the bid was placed.
WINOPT CHAR(4) Indicates if bidder will accept partial quantity. Valid values are as follows:

  • A=bidder only accepts full

  • P=bidder will accept partial

BIDSTATUS CHAR(4) The bid status. Valid values are as follows:

  • A=active

  • R=retracted by customer

  • S=superceded

  • W=winning

  • D=delete by administrator

  • C=order completed successfully from this bid

  • WC=create order failed and see logs for details

PAYTYPE CHAR(64) Reserved for IBM internal use.
ENCRYPT INTEGER Indicates if credit card number is encrypted. Valid values: 0=not encrypted, 1=encrypted.
DEVICE VARCHAR(64) Credit card number.
EXPDATE TIMESTAMP Credit card expiration date.
QUANTSCALE INTEGER Reserved for IBM internal use.
AUTOBID_ID BIGINT ID of the autobid when the bid is generated from an autobid. Otherwise the field is empty.
BIDROOT BIGINT Reserved for IBM internal use.
BKNAME VARCHAR(254) Bank name.
SHIPTO_ID BIGINT Shipping address for the customer submitting the bid.
SHIPMODE INTEGER Shipping mode selected by the customer submitting the bid.
WINPRICE DECIMAL (20,5) The price the bidder will pay if the bid is a winner.
WINQUANT DOUBLE Quantity awarded to this bid if the bid is a winner.
BIDMSG VARCHAR(254) Reserved for IBM internal use.
FIELD1 BIGINT Customizable.
FIELD2 DECIMAL (20,5) Customizable.
FIELD3 VARCHAR(254) Customizable.
BILLADDR BIGINT Billing address of the customer submitting the bid.
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
SQL060903235130110 BID_ID+ACTIONTIME Primary Key
I0000476 STORE_ID Non-Unique Index
I0000477 ADMIN_ID Non-Unique Index
I0000478 OWNER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_116 AUCPAYINFO_ID AUCPAYINFO AUCPAYINFO_ID Cascade
F_117 OWNER_ID MEMBER MEMBER_ID Cascade
F_118 ADMIN_ID MEMBER MEMBER_ID Cascade
F_119 STORE_ID STORE STORE_ID Cascade
Related reference