Database

The schema creates these tables:

• marketplace_users: shop profiles.
• marketplace_listings: active and historical listings.
• marketplace_bids: classic bids.
• marketplace_mailbox: items and money waiting to be collected.
• marketplace_history: event history.
• marketplace_ratings: ratings.
• marketplace_favorites: favourites.
• marketplace_deliveries: NPC or logistics deliveries.
• marketplace_trades: in-person trades.
• marketplace_proxy_bids: maximum automatic bids.
• marketplace_follows: seller follows.
• marketplace_wishlist: wanted-item alerts.
• marketplace_reports: moderation reports.
• marketplace_refunds: refund requests.
• marketplace_messages: messages and conversations.

marketplace_users

Stores the seller’s public profile and status.

marketplace_listings

Stores the listing, its type, price, status, images, delivery mode, rarity and other metadata.

marketplace_bids

Stores traditional bids.

marketplace_mailbox

Stores items and money delivered to the mailbox.

marketplace_history

Stores the history of transactions and events.

marketplace_ratings

Stores ratings from buyers to sellers.

marketplace_favorites

Links users with favourite listings.

marketplace_deliveries

Records deliveries in transit, delivered, robbed or failed.

marketplace_trades

Records in-person trades and their status.

marketplace_proxy_bids

Stores the maximum automatic bid limit per player and listing.

marketplace_follows

Follow relationships between player and seller.

marketplace_wishlist

Active alerts by item and maximum price.

marketplace_reports

Reports submitted by players.

marketplace_refunds

Refund requests and resolutions.

marketplace_messages

Chat messages and proposals linked to listings.