This table contains the history of changes made to an auction. The auction row is stored in this table before it is changed.
Column Name | Column Type | Column Description |
---|---|---|
ACTIONMSG | VARCHAR (254) NULL |
An explanation of the change made to the auction. |
ACTIONTIME | TIMESTAMP NOT NULL |
The date and time that the auction was changed. |
ACTIONTYPE | INTEGER NULL |
The type of change made to the auction. |
ADMIN_ID | BIGINT NULL |
The ID of the administrator who changed the auction. |
AUCMODE | CHARACTER (4) NULL |
Reserved for IBM internal use. |
AUCPAYINFO_ID | BIGINT NULL |
Reserved for IBM internal use. |
AUCT_ID | BIGINT NOT NULL |
Auction ID. AUCT_ID from AUCTION table. |
AUQUANT | DOUBLE NULL |
Quantity available on auction. |
AUSTATUS | CHARACTER (4) NULL |
Auction status. Valid values: BC=bidding closed, SC=settlement closed, C=current, F=future, and R=retracted or deleted. |
AUTYPE | CHARACTER (4) NULL |
Auction type. Valid values: O=open cry, SB=sealed bid, D=dutch. |
BESTBID_ID | BIGINT NULL |
ID of the best bid for this auction. Only used for open cry auctions. |
BIDRULE_ID | BIGINT NULL |
ID of the bid rule used for this auction. |
CATENTRY_ID | BIGINT NULL |
ID of the item that is on auction. |
CLOSEPR | CHARACTER (4) NULL |
Auction closing price rule. Valid values: D=discriminative, ND=non-discriminative. |
CLOSETYPE | INTEGER NULL |
Auction closing rule. Valid values: 1=at a fixed end time, 2=if a specified amount of time has elapsed since the last bid, 3=based on logical OR 1 and 2, 4=based on logical AND 1 and 2. |
CURRENCY | CHARACTER (4) NULL |
Auction currency. All bids must be in this currency. This is a currency code as per ISO 4217 standards. |
CURRPRICE | DECIMAL (20,5) NULL |
Current auction price. Used for Dutch auctions. |
CURRQUANT | DOUBLE NULL |
Current auction quantity. Used by Dutch auctions to track the available quantity. This quantity is reduced by each winning bid. |
DEPOSIT | DECIMAL (20,5) NULL |
The amount of deposit required for the auction. |
DURATION | TIMESTAMP NULL |
Auction duration. |
DURDAYS | INTEGER NULL |
Auction duration in days. |
DURLENGTH | INTEGER NULL |
Reserved for IBM internal use. |
ENDTIME | TIMESTAMP NULL |
Auction ending time. |
FFMCENTER_ID | INTEGER NULL |
Fulfillment center ID. The ID of the fulfillment center that provides the inventory for the auction. |
FIELD1 | BIGINT NULL |
Customizable. |
FIELD2 | BIGINT NULL |
Customizable. |
FIELD3 | DECIMAL (20,5) NULL |
Customizable. |
FIELD4 | DECIMAL (20,5) NULL |
Customizable. |
FIELD5 | VARCHAR (254) NULL |
Customizable. |
FIELD6 | VARCHAR (254) NULL |
Customizable. |
HIGHBID_ID | BIGINT NULL |
ID of the bid with the highest price. |
INVRSRVID | BIGINT NULL |
Inventory reservation ID. |
LASTBKTIME | TIMESTAMP NULL |
Updated when best bid is calculated by way of schedule task. |
LOCKFLAG | INTEGER NULL |
Lock flag. Valid values: 0=unlocked, 1=locked. |
MBRGRP_ID | BIGINT NULL |
Reserved for IBM internal use. |
OPENPRICE | DECIMAL (20,5) NULL |
Opening price. |
OWNER_ID | BIGINT NULL |
Owner of the auction. This the same as the owner of the CATENTRY that is on auction. |
PAYMETHODS | CHARACTER (254) NULL |
Allowable payment methods. |
PRECEDENCE | INTEGER NULL |
Reserved for IBM internal use. |
PRICELIMIT | DECIMAL (20,5) NULL |
Reserved for IBM internal use. |
QUANTLIMIT | DOUBLE NULL |
Reserved for IBM internal use. |
QUANTSCALE | INTEGER NULL |
Reserved for IBM internal use. |
REALENDTIME | TIMESTAMP NULL |
Ending date and time. |
REFCODE | CHARACTER (36) NULL |
Reference code. A unique code that identifies the auction. |
REFPRICE | DECIMAL (20,5) NULL |
Reserved for IBM internal use. |
RESRVPRICE | DECIMAL (20,5) NULL |
Reserve price. Bids below the reserve price will be ignored when winning bids are determined. |
RETRACT_BID | INTEGER NULL |
Reserved for IBM internal use. |
RULEPAGE | VARCHAR (254) NULL |
Rule page. The name of the JSP file that will be used to display the auction rules. |
STARTTIME | TIMESTAMP NULL |
Auction start time. |
STATE | INTEGER NULL |
Reserved for IBM internal use. |
SUPPLIER_ID | BIGINT NULL |
Reserved for IBM internal use. |
UPDATETIME | TIMESTAMP NULL |
Auction end time. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034839940 | AUCT_ID, ACTIONTIME | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_87 | AUCPAYINFO_ID | AUCPAYINFO | AUCPAYINFO_ID | Cascade |
F_88 | MBRGRP_ID | MBRGRP | MBRGRP_ID | Cascade |
F_89 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | Cascade |
F_90 | OWNER_ID | MEMBER | MEMBER_ID | Cascade |
F_91 | ADMIN_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|