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. |
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 |
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 |
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 |