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