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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034842670 | BID_ID, ACTIONTIME | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|