Pixmos
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
- created_at — datetime — 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
- created_at — datetime — NOT NULL
- row — int — NOT NULL
- col — 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
- created_at — datetime — NOT NULL
- name — varchar(20)
- n_slot — int