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. |
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 |
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 |
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 |