Rank-Track

Tables (3)

member

  • member_id — BIGINT — Primary key — NOT NULL
  • rating — BIGINT
  • solved_count — BIGINT
  • handle — VARCHAR(255)
  • name — VARCHAR(255)
  • profile_image_url — VARCHAR(255)
  • tier — ENUM('BRONZE_1','BRONZE_2','BRONZE_3','BRONZE_4','BRONZE_5','DIAMOND_1','DIAMOND_2','DIAMOND_3','DIAMOND_4','DIAMOND_5','GOLD_1','GOLD_2','GOLD_3','GOLD_4','GOLD_5','MASTER','PLATINUM_1','PLATINUM_2','PLATINUM_3','PLATINUM_4','PLATINUM_5','RUBY_1','RUBY_2','RUBY_3','RUBY_4','RUBY_5','SILVER_1','SILVER_2','SILVER_3','SILVER_4','SILVER_5','UNRATED')

member_history

  • member_history_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id
  • rating — BIGINT
  • solved_count — BIGINT
  • timestamp — DATETIME(6)
  • tier — ENUM('BRONZE_1','BRONZE_2','BRONZE_3','BRONZE_4','BRONZE_5','DIAMOND_1','DIAMOND_2','DIAMOND_3','DIAMOND_4','DIAMOND_5','GOLD_1','GOLD_2','GOLD_3','GOLD_4','GOLD_5','MASTER','PLATINUM_1','PLATINUM_2','PLATINUM_3','PLATINUM_4','PLATINUM_5','RUBY_1','RUBY_2','RUBY_3','RUBY_4','RUBY_5','SILVER_1','SILVER_2','SILVER_3','SILVER_4','SILVER_5','UNRATED')

stage_solved_count

  • stage_solved_count_id — BIGINT — Primary key — NOT NULL
  • level — INT — NOT NULL
  • solved — INT — NOT NULL
  • member_history_id — BIGINT — Foreign key → member_history.member_history_id