This table stores information about available auction styles.
Column Name | Column Type | Column Description |
---|---|---|
ADMIN_ID | BIGINT NULL |
The ID of the administrator who created the auction style. |
ASCUR | CHARACTER (4) NULL |
Currency code. This is a currency code as per ISO 4217 standards. |
ASDURATION | TIMESTAMP NULL |
Auction duration. |
ASNAME | CHARACTER (38) NOT NULL |
Auction style name. |
ASTYPE | CHARACTER (4) NOT NULL |
Auction type. Valid values: O=open cry, SB=sealed bid, D=dutch. |
AUQUANT | DOUBLE NOT NULL |
Auction quantity. |
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. |
DEPOSIT | DECIMAL (20,5) NULL |
Deposit amount required for the auction. |
DURDAYS | INTEGER NULL |
Auction duration in days. |
ENDDAYS | INTEGER NULL |
Reserved for IBM internal use. |
ENDTIME | TIMESTAMP NULL |
Auction ending date and time. |
ITEMPAGE | VARCHAR (254) NULL |
Name of the page used to display the item when it is on auction. |
OPENPRICE | DECIMAL (20,5) NULL |
Opening price. Used by Dutch auctions. |
OWNER_ID | BIGINT NOT NULL |
ID of the owner of the auction style. |
RESERVPRICE | DECIMAL (20,5) NULL |
Reserve price for the auction. |
RULEPAGE | VARCHAR (254) NULL |
Rule page. The name of the JSP file used to display the auction rules. |
RULE_ID | BIGINT NULL |
Bid control rule for this auction. Foreign key to the CONTRLRULE table. |
STARTDAYS | INTEGER NULL |
Reserved for IBM internal use. |
STARTTIME | TIMESTAMP NULL |
Auction starting time. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000033 | ASTYPE | Non-Unique Index |
SQL030416034840580 | OWNER_ID, ASNAME | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_94 | RULE_ID | CONTRLRULE | RULE_ID | Cascade |
F_95 | OWNER_ID | MEMBER | MEMBER_ID | Cascade |
F_96 | ADMIN_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|