Skip to content

database structure

ineveraskedforthis edited this page Jul 11, 2020 · 10 revisions

database tables

table columns
accounts login, password_hash, id, char_id
chars id, user_id, cell_id, name, hp, max_hp, savings, stash, equip, data
last_id id_type, last_id
battles id, ids, teams, positions
cells id, x, y, name, market_id, item_market_id int, owner_id, pop_id
markets id, data
market_orders id, typ, tag, owner_id, amount, price, market_id
agents id, cell_id, name, savings, stash
consumers id, cell_id, name, savings, stash, data
pops id, cell_id, name, savings, stash, data, race_tag, ai_tag
enterprises id, cell_id, name, savings, stash, data, ai_tag
worlds x, y
items_orders id serial primary key, item jsonb, owner_id int, buyout_price int, current_price int, latest_bidder int, end_time int, market_id int
items_markets id int serial primary key, orders int[]
тест

Home

About code

Abstract concepts

  • To be rewritten

Stories (russian)

Clone this wiki locally