gw2-schema.md

Game items

Data comes from here. Definitely possible to get more but I haven't had a reason to yet.

• id : Game ID from ANet. Same value that shows up in the URL on the trading post website we use (example; this item's ID is 24349). Note that some items have the same name but are actually > 1 item in the database. This is how ANet does it so I didn't mess with it.
• name : Name that shows up in the game
• icon : Yup
• is_market_transaction : Ignore for now; I added this and will prob remove it. Not currently meaningful whatsoever.

Market listing records

Data comes from here. I'm deleting records that are more than 30 days old to keep the database size down.

• item_id : Foreign key to the game_items table.
• recorded : When the API request occurred
• type : 0 means these are 'buy' postings, 1 means these are 'sell' postings
• step_id : all records that share the same step_id were recorded very close to each other. A new 'step' starts every 15 minutes.
• listings : The number of listings @ this price, comes directly from ANet.
• price : The price in copper.
• quantity : Total number of items at the price across listings.

Player transactions

Data comes from here. Cancelled transactions are automatically removed every 15 minutes.

• id : Generated by ANet.
• item_id : The item being bought or sold.
• price : Yup
• quantity : Double yup
• created_str : Timestamp for when the transaction was created.
• purchased_str : Timestamp for when the transaction was completed (blank if its still active).
• who_id : Foreign key to user table describing whose transaction this is.
• type : 0 means buy, 1 means sell

Users

Useful for joining with other tables if you want to put our names beside results to make it more readable.

• name : Descriptive string for each user.
• api_key : Used for making user-specific requests to ANet API.