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 Name Column Type Column Description
ACTIONMSG VARCHAR (254)
NULL
Reason the bid was changed.
ACTIONTIME TIMESTAMP
NOT NULL
Date and time that the bid was changed.
ACTIONTYPE INTEGER
NULL
Type of change to the bid.
ADMIN_ID BIGINT
NULL
ID of the administrator who retracted the autobid or bid.
AUCPAYINFO_ID BIGINT
NULL
Reserved for IBM internal use.
AUCT_ID BIGINT
NULL
Auction ID for the auction that the bid is based on.
AUTOBID_ID BIGINT
NULL
ID of the autobid when the bid is generated from an autobid. Otherwise the field is empty.
BIDMODE CHARACTER (4)
NULL
Reserved for IBM internal use.
BIDMSG VARCHAR (254)
NULL
Reserved for IBM internal use.
BIDPRICE DECIMAL (20,5)
NULL
The bid price.
BIDQUANT DOUBLE
NULL
Bid quantity.
BIDROOT BIGINT
NULL
Reserved for IBM internal use.
BIDSTATUS CHARACTER (4)
NULL
The bid status. Valid values: 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, see logs for details.
BIDTIME TIMESTAMP
NULL
The time the bid was placed.
BID_ID BIGINT
NOT NULL
Bid ID.
BILLADDR BIGINT
NULL
Billing address of the customer submitting the bid.
BKNAME VARCHAR (254)
NULL
Bank name.
DEVICE VARCHAR (64)
NULL
Credit card number.
ENCRYPT INTEGER
NULL
Indicates if credit card number is encrypted. Valid values: 0=not encrypted, 1=encrypted.
EXPDATE TIMESTAMP
NULL
Credit card expiration date.
FIELD1 BIGINT
NULL
Customizable.
FIELD2 DECIMAL (20,5)
NULL
Customizable.
FIELD3 VARCHAR (254)
NULL
Customizable.
INITPRICE DECIMAL (20,5)
NULL
Reserved for IBM internal use.
LIMITPRICE DECIMAL (20,5)
NULL
Reserved for IBM internal use.
OWNER_ID BIGINT
NULL
ID of the customer who submitted the bid.
PAYTYPE CHARACTER (64)
NULL
Reserved for IBM internal use.
QUANTSCALE INTEGER
NULL
Reserved for IBM internal use.
REFCODE CHARACTER (36)
NULL
Reference code. A unique code that identifies the auction.
SHIPMODE INTEGER
NULL
Shipping mode selected by the customer submitting the bid.
SHIPTO_ID BIGINT
NULL
Shipping address for the customer submitting the bid.
STORE_ID INTEGER
NULL
Store that is conducting the auction.
WINOPT CHARACTER (4)
NULL
Indicates if bidder will accept partial quantity. Valid values: A=bidder only accepts full, P=bidder will accept partial.
WINPRICE DECIMAL (20,5)
NULL
The price the bidder will pay if the bid is a winner.
WINQUANT DOUBLE
NULL
Quantity awarded to this bid if the bid is a winner.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034842670 BID_ID, ACTIONTIME Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable