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 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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034839940 AUCT_ID, ACTIONTIME Primary Key
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable