Table Descriptions


TABLES:

game_logins

  • time - timestamp
  • game_id - int
  • user_id - int
  • acct_id - int

char_logins

  • time
  • user_id
  • acct_id
  • char_id

auction_house_posts

  • list_id
  • seller_char_id
  • time
  • item
  • quantity
  • min_bid
  • min_buyout
  • duration

auction_house_sells

  • list_id
  • buyer_char_id
  • time
  • was_buyout
  • paid

char_info - contains information regarding WoW characters

  • user_id - the id for the user this char belongs to
  • acct_id - the account this character is on
  • char_id - a unique id for the character
  • creation_date - when the character was created
  • faction
  • race
  • class
  • level
  • last_played - the date the character was last logged in to
  • quests_completed - the number of quests the character has completed

acct_info

  • user_id
  • acct_id
  • activation_date
  • characters
  • status
  • status_date

acct_actions



char_actions

  • user_id,
  • acct_id
  • action_ts
  • character_id,
  • action
  • object
  • location

attacks

  • user_id
  • acct_id
  • character_id
  • action_ts
  • action
  • object
  • location