WebSphere Commerce database table: AUCTIONLOG

This table contains the history of changes made to an auction. The auction row is stored in this table before it is changed.

Column Descriptions
Column Name Column Type Description
AUCT_ID BIGINT NOT NULL Auction ID. This is the same as the AUCT_ID in the AUCTION table.
ACTIONTIME TIMESTAMP NOT NULL The date and time that the auction was changed.
ACTIONTYPE INTEGER The type of change made to the auction.
AUCPAYINFO_ID BIGINT Reserved for IBM internal use.
OWNER_ID BIGINT Owner of the auction. This the same as the owner of the CATENTRY that is on auction.
ADMIN_ID BIGINT The ID of the administrator who changed the auction.
MBRGRP_ID BIGINT Reserved for IBM internal use.
FFMCENTER_ID INTEGER Fulfillment center ID. The ID of the fulfillment center that provides the inventory for the auction.
ACTIONMSG VARCHAR(254) An explanation of the change made to the auction.
REFCODE CHAR(36) Reference code. A unique code that identifies the auction.
CATENTRY_ID BIGINT ID of the item that is on auction.
AUTYPE CHAR(4) Auction type. Valid values are as follows:

  • O=open cry

  • SB=sealed bid

  • D=dutch

AUSTATUS CHAR(4) Auction status. Valid values are as follows:

  • BC=bidding closed

  • SC=settlement closed

  • C=current

  • F=future

  • R=retracted or deleted

AUQUANT DOUBLE Quantity available on auction.
BIDRULE_ID BIGINT ID of the bid rule used for this auction.
QUANTSCALE INTEGER Reserved for IBM internal use.
RESRVPRICE DECIMAL (20,5) Reserve price. Bids below the reserve price will be ignored when winning bids are determined.
OPENPRICE DECIMAL (20,5) Opening price of the auctioned item.
CURRPRICE DECIMAL (20,5) Current auction price. Used for Dutch auctions.
CURRQUANT DOUBLE Current auction quantity. Used by Dutch auctions to track the available quantity. This quantity is reduced by each winning bid.
CLOSEPR CHAR(4) Auction closing price rule. Valid values are as follows:

  • D=discriminative

  • ND=non-discriminative

CURRENCY CHAR(4) Auction currency. All bids must be in this currency. This is a currency code as per ISO 4217 standards.
PAYMETHODS CHAR(254) Allowable payment methods.
CLOSETYPE INTEGER Auction closing rule. Valid values are as follows:

  • 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

RULEPAGE VARCHAR(254) Rule page. The name of the JSP file that will be used to display the auction rules.
STARTTIME TIMESTAMP Auction start time.
ENDTIME TIMESTAMP Auction ending time.
DURATION TIMESTAMP Auction duration.
DEPOSIT DECIMAL (20,5) The amount of deposit required for the auction.
BESTBID_ID BIGINT ID of the best bid for this auction. Only used for open cry auctions.
LOCKFLAG INTEGER Lock flag. Valid values are as follows:

  • 0=unlocked

  • 1=locked

HIGHBID_ID BIGINT ID of the bid with the highest price.
UPDATETIME TIMESTAMP Auction end time.
LASTBKTIME TIMESTAMP Updated when best bid is calculated by way of schedule task.
REALENDTIME TIMESTAMP Auction ending date and time.
PRECEDENCE INTEGER Reserved for IBM internal use.
FIELD1 BIGINT Customizable.
RETRACT_BID INTEGER Reserved for IBM internal use.
FIELD2 BIGINT Customizable.
FIELD3 DECIMAL (20,5) Customizable.
FIELD4 DECIMAL (20,5) Customizable.
FIELD5 VARCHAR(254) Customizable.
FIELD6 VARCHAR(254) Customizable.
SUPPLIER_ID BIGINT Reserved for IBM internal use.
DURDAYS INTEGER Auction duration in days.
REFPRICE DECIMAL (20,5) Reserved for IBM internal use.
STATE INTEGER Reserved for IBM internal use.
INVRSRVID BIGINT Inventory reservation ID.
AUCMODE CHAR(4) Reserved for IBM internal use.
PRICELIMIT DECIMAL (20,5) Reserved for IBM internal use.
QUANTLIMIT DOUBLE Reserved for IBM internal use.
DURLENGTH INTEGER Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235128670 AUCT_ID+ACTIONTIME Primary Key
I0000461 ADMIN_ID Non-Unique Index
I0000462 FFMCENTER_ID Non-Unique Index
I0000463 OWNER_ID Non-Unique Index
I0000464 MBRGRP_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_87 AUCPAYINFO_ID AUCPAYINFO AUCPAYINFO_ID Cascade
F_89 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
F_88 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_90 OWNER_ID MEMBER MEMBER_ID Cascade
F_91 ADMIN_ID MEMBER MEMBER_ID Cascade
Related reference