Database Table: AUCTSTYLE

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000033 ASTYPE Non-Unique Index
SQL030416034840580 OWNER_ID, ASNAME Primary Key
Constraints:
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

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