Pixmos_jh

Tables (11)

adjacent_pixel

  • pixel_id — int — Foreign key → pixel.id — NOT NULL
  • adj_pixel_id — int — Foreign key → pixel.id — NOT NULL

commander_immutable

  • id — int — Primary key — NOT NULL
  • rarity — enum("normal","rare","epic","lengendary") — Foreign key → rarity.rarity — NOT NULL
  • attack_buff — decimal — NOT NULL
  • defense_buff — decimal — NOT NULL
  • mining_speed_buff — decimal — NOT NULL

commander_mutable

  • id — int — Foreign key → commander_immutable.id — NOT NULL
  • hp — int — NOT NULL
  • registration_fee — int — NOT NULL

commander_owner

  • commander_id — int — Foreign key → commander_immutable.id — NOT NULL
  • wallet_address — char(42) — Foreign key → user.wallet_address — NOT NULL

commanding_pixel

  • commander_id — int — Foreign key → commander_immutable.id — NOT NULL
  • pixel_id — int — Foreign key → pixel.id — NOT NULL

pixel

  • id — int — Primary key — NOT NULL
  • grid_r — int — NOT NULL
  • grid_q — int — NOT NULL
  • pxsol — int — NOT NULL
  • xpxsol — int — NOT NULL
  • xpxsol_reserves — int — NOT NULL

pixel_owner

  • pixel_id — int — Foreign key → pixel.id — NOT NULL
  • wallet_address — char(42) — Foreign key → user.wallet_address — NOT NULL

rarity

  • rarity — enum("normal","rare","epic","lengendary") — Primary key — NOT NULL
  • radius — int — NOT NULL
  • max_union_pixels — int — NOT NULL
  • mining_speed — decimal — NOT NULL
  • charge_fee — int — NOT NULL

refinement

  • id — int — Primary key — NOT NULL
  • pixel_id — int — Foreign key → pixel.id — NOT NULL
  • amount — int — NOT NULL
  • created_at — datetime — NOT NULL
  • ended_at — datetime — NOT NULL
  • claimed_at — datetime
  • stopped_at — datetime

union

  • pixel_id — int — Foreign key → pixel.id — NOT NULL
  • commander_id — int — Foreign key → commander_immutable.id — NOT NULL

user

  • wallet_address — char(42) — Primary key — NOT NULL
  • name — varchar(20)
  • n_slot — int