SteamInventory - Laravel Schema Designer

steam_games

id increments
app_id smallInteger
realname string (175)
name string (100)
headerimg string (200)
capsule string (200)
banner string (250)
timestamps timestamps

game_items

id increments
market_hash_name string (200)
app_id smallInteger
classid bigInteger
fixedprice float (8,2)
timestamps timestamps
steam_game_id ^FK integer

item_price_apis

id increments
name string (200)
url string (200)
command string (200)
steam_game_id ^FK integer
abiliity_add_items tinyInteger
disable tinyInteger
timestamps timestamps

game_item_prices

id increments
game_item_id ^FK integer
price float (8,2)
timestamps timestamps
item_price_api_id ^FK integer

api_txns

id increments
item_price_api_id ^FK integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01