Database Table: AUCTION

This table contains the information required for each auction, such as catalog entry (item), closing rules, pricing rules, deposit amount, and bid rules.

Column Name Column Type Column Description
ADMIN_ID BIGINT
NULL
Administrator ID. The ID of the administrator that created or modified 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
Unique key to identify the auction.
AUQUANT DOUBLE
NOT NULL
The total quantity of items up for auction.
AUSTATUS CHARACTER (4)
NOT NULL
Auction status. Valid values: BC=bidding closed, SC=settlement closed, C=current, F=future, R=retracted or deleted.
AUTYPE CHARACTER (4)
NOT NULL
Auction type. Valid values: O=open cry, SB=sealed bid, D=dutch.
BESTBID_ID BIGINT
NULL
Best bid ID. The ID of the current lowest winning bid.
BIDRULE_ID BIGINT
NULL
Bid rule ID. The ID of the bid rule used for this auction.
CATENTRY_ID BIGINT
NOT NULL
CatalogEntry ID. The ID of the item on auction.
CLOSEPR CHARACTER (4)
NULL
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 price. Used in Dutch auctions.
CURRQUANT DOUBLE
NULL
Current quantity. Used by Dutch auctions to track the quantity available. This quantity is reduced by each winning bid.
DEPOSIT DECIMAL (20,5)
NULL
Deposit amount required for this auction.
DURATION TIMESTAMP
NULL
Auction duration in time.
DURDAYS INTEGER
NULL
Auction duration in days.
DURLENGTH INTEGER
NULL
Reserved for IBM internal use.
ENDTIME TIMESTAMP
NULL
Ending date and time for the auction.
FFMCENTER_ID INTEGER
NULL
Fulfillment center ID. The ID of the fulfillment center that will provide 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
The 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
NOT NULL
Reserved for IBM internal use.
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)
NOT 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
Starting date and time.
STATE INTEGER
NULL
Reserved for IBM internal use.
SUPPLIER_ID BIGINT
NULL
Reserved for IBM use.
UPDATETIME TIMESTAMP
NULL
Update date and time.
Indexes:
Index Name Indexed Column Names Index Type
I0000022 REFCODE Unique Index
I0000023 ENDTIME Non-Unique Index
I0000024 REFPRICE Non-Unique Index
I0000025 STATE Non-Unique Index
I0000026 AUTYPE Non-Unique Index
I0000027 AUSTATUS Non-Unique Index
I0000028 LOCKFLAG Non-Unique Index
I0000029 UPDATETIME Non-Unique Index
I0000030 LASTBKTIME Non-Unique Index
I0000031 STARTTIME Non-Unique Index
SQL030416034839610 AUCT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_80 AUCPAYINFO_ID AUCPAYINFO AUCPAYINFO_ID Cascade
F_81 BIDRULE_ID CONTRLRULE RULE_ID Cascade
F_82 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_83 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_84 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
F_85 OWNER_ID MEMBER MEMBER_ID Cascade
F_86 ADMIN_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_112 AUCT_ID BID AUCT_ID Cascade
F_457 AUCT_ID MEMBRAUCT AUCT_ID Cascade
F_78 AUCT_ID AUCTDESC AUCT_ID Cascade
F_92 AUCT_ID AUCTSTRREL AUCT_ID Cascade
F_98 AUCT_ID AUTOBID AUCT_ID Cascade