This table stores bid information. The information is updated when a customer submits a bid.
Column Description(s):
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 as follows:
- A=bidder only accepts full
- P=bidder will accept partial
|
BIDSTATUS |
CHAR(4) NOT NULL |
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 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 as follows:
- 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 |
Shipping mode. |
WINPRICE |
DECIMAL (20,5) |
Winning price for the bid based on the close price rule. |
WINQUANT |
DOUBLE |
Winning 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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000041 |
REFCODE |
Unique Index |
SQL050212031200960 |
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 |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 Name(s) | Constraint Type |
F_121 |
BID_ID |
BIDORDRREL |
BID_ID |
Cascade |
F_123 |
BID_ID |
BIDPAYMENT |
BID_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.