Database Table: BID

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

Column Name Column Type Column Description
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
NOT NULL
Auction ID. Foreign key to AUCTION table.
AUTOBID_ID BIGINT
NULL
Points to the AUTOBID table if this bid was created from an autobid.
BIDMODE CHARACTER (4)
NULL
Reserved for IBM internal use.
BIDMSG VARCHAR (254)
NULL
Message set by the bidder.
BIDPRICE DECIMAL (20,5)
NOT NULL
The bid price.
BIDQUANT DOUBLE
NOT NULL
Bid quantity.
BIDROOT BIGINT
NULL
Reserved for IBM internal use.
BIDSTATUS CHARACTER (4)
NOT NULL
The bid status. Valid values: 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, see logs for details.
BIDTIME TIMESTAMP
NOT NULL
The time the bid was placed.
BID_ID BIGINT
NOT NULL
Bid ID. Primary key to this table.
BILLADDR BIGINT
NULL
Billing address for the customer.
BKNAME VARCHAR (254)
NULL
Bank name.
DEVICE VARCHAR (64)
NOT NULL
Credit card number.
ENCRYPT INTEGER
NOT NULL
Indicates if the credit card number is encrypted or not. Valid values: 0 = not encrypted, 1 = encrypted.
EXPDATE TIMESTAMP
NOT NULL
Expiration date for the credit card.
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
NOT NULL
The user who submitted the bid.
PAYTYPE CHARACTER (64)
NOT NULL
Payment type. This is set to the value of the cardBrand payment parameter when the bid is submitted.
QUANTSCALE INTEGER
NULL
Reserved for IBM internal use.
REFCODE CHARACTER (36)
NOT NULL
Reference code. A unique code that identifies the auction.
SHIPMODE INTEGER
NULL
Shipping mode.
SHIPTO_ID BIGINT
NULL
Ship to address.
STORE_ID INTEGER
NULL
Store that is conducting the auction.
WINOPT CHARACTER (4)
NOT 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
Winning price for the bid based on the close price rule.
WINQUANT DOUBLE
NULL
Winning quantity.
Indexes:
Index Name Indexed Column Names Index Type
I0000041 REFCODE Unique Index
I0000042 AUTOBID_ID Non-Unique Index
I0000043 BIDQUANT Non-Unique Index
I0000044 BIDPRICE Non-Unique Index
I0000045 BIDSTATUS Non-Unique Index
SQL030416034842330 BID_ID Primary Key
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_113 STORE_ID STORE STORE_ID Cascade
F_114 OWNER_ID MEMBER MEMBER_ID Cascade
F_115 ADMIN_ID MEMBER MEMBER_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