auction Table¶
Active auctions on the world auction houses. Rows are removed when an auction expires or is cancelled.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
id |
int(11) unsigned | PRI | NO | 0 | |
house_id |
int(11) unsigned | NO | 0 | ||
item_guid |
int(11) unsigned | UNI | NO | 0 | |
item_id |
int(11) unsigned | NO | 0 | ||
seller_guid |
int(11) unsigned | NO | 0 | ||
buyout_price |
int(11) | NO | 0 | ||
expire_time |
bigint(40) | NO | 0 | ||
buyer_guid |
int(11) unsigned | NO | 0 | ||
last_bid |
int(11) | NO | 0 | ||
start_bid |
int(11) | NO | 0 | ||
deposit |
int(11) | NO | 0 |
Field Breakdown¶
id- Primary Key. Auction identifier.house_id- Auction house (faction/neutrality) the auction runs on.item_guid- The physical item (fromitem_instance.guid).item_id- Template entry of the auctioned item.seller_guid- Seller character guid (fromcharacters.guid).buyout_price- Instant-buy price (copper).expire_time- Unix timestamp when the auction ends.buyer_guid- Buyer character guid (fromcharacters.guid); empty until the first bid.last_bid- Current highest bid (copper).start_bid- Original listing bid (copper).deposit- Deposit charged at listing; lost if the sale fails.