legendino

Tables (96)

achievement

  • id — int(11) — Primary key — NOT NULL
  • reward_item_type — varchar(1) — NOT NULL
  • reward_item_id — int(11) — Foreign key → item.id — NOT NULL
  • reward_item_quantity — int(11) — NOT NULL
  • achievement_category_id — int(11) — NOT NULL
  • achievement_id — int(11) — NOT NULL

alembic_version

  • version_num — varchar(32) — Primary key — NOT NULL

arena_rank_grade_reward

  • id — int(11) — Primary key — NOT NULL
  • rank — tinyint(4) — NOT NULL
  • reward_item_id — int(11) — Foreign key → item.id — NOT NULL
  • reward_item_type — varchar(1) — NOT NULL
  • reward_qty — int(11) — NOT NULL

arena_rank_table

  • id — int(11) — Primary key — NOT NULL
  • min_point — int(11) — NOT NULL
  • max_point — int(11) — NOT NULL

arena_reward

  • id — int(11) — Primary key — NOT NULL
  • rank — int(11) — NOT NULL
  • reward_coin — int(11) — NOT NULL

arena_season

  • id — int(11) — Primary key — NOT NULL
  • season — int(11) — NOT NULL
  • end_date — datetime — NOT NULL
  • start_date — datetime — NOT NULL

arena_season_rank_init_table

  • id — int(11) — Primary key — NOT NULL
  • range_start — int(11) — NOT NULL
  • range_end — int(11) — NOT NULL
  • init_point — int(11) — NOT NULL

arena_season_rank_point_reward

  • id — int(11) — Primary key — NOT NULL
  • range_start — int(11) — NOT NULL
  • range_end — int(11) — NOT NULL
  • reward_item_id — int(11) — Foreign key → item.id — NOT NULL
  • reward_item_type — varchar(1) — NOT NULL
  • reward_qty — int(11) — NOT NULL

arena_season_ranking_reward

  • id — int(11) — Primary key — NOT NULL
  • range_start — int(11) — NOT NULL
  • range_end — int(11) — NOT NULL
  • reward_item_id — int(11) — Foreign key → item.id — NOT NULL
  • reward_item_type — varchar(1) — NOT NULL
  • reward_qty — int(11) — NOT NULL

arena_shop

  • id — int(11) — Primary key — NOT NULL
  • item_id — int(11) — Foreign key → item.id — NOT NULL — item 테이블 id
  • appear_rank — tinyint(4) — NOT NULL
  • appearance_rate — double — NOT NULL
  • item_type — varchar(1) — NOT NULL
  • quantity — int(11) — NOT NULL
  • buy_price — int(11) — NOT NULL

attendance_reward

  • id — int(11) — Primary key — NOT NULL
  • reward_item_type — varchar(1) — NOT NULL
  • reward_item_id — int(11) — Foreign key → item.id — NOT NULL
  • reward_item_qty — int(11) — NOT NULL

boss_reward

  • id — int(11) — Primary key — NOT NULL
  • stage_level — int(11)
  • reward_type — varchar(1)
  • reward_item_id — int(11)
  • reward_qty — int(11)

client_version

  • id — int(11) — Primary key — NOT NULL
  • asset_version — tinyint(4) — NOT NULL
  • effect_version — tinyint(4) — NOT NULL
  • sound_version — tinyint(4) — NOT NULL
  • spine_version — tinyint(4) — NOT NULL
  • major_version — int(11) — NOT NULL
  • minor_version — int(11) — NOT NULL
  • update_date — datetime — NOT NULL

coupon

  • id — int(11) — Primary key — NOT NULL
  • code — varchar(20) — NOT NULL
  • type — varchar(1) — NOT NULL
  • reward_item_type — varchar(1) — NOT NULL
  • reward_item_id — int(11) — Foreign key → item.id — NOT NULL
  • reward_item_quantity — int(11) — NOT NULL
  • coupon_group — tinyint(4) — NOT NULL
  • created_date — datetime — NOT NULL
  • expire_date — datetime — NOT NULL

coupon_consume_history

  • id — int(11) — Primary key — NOT NULL
  • user_id — varchar(12) — Foreign key → user.user_id — NOT NULL
  • code — varchar(20) — NOT NULL
  • coupon_group — tinyint(4) — NOT NULL
  • used_date — datetime — NOT NULL

dictionary_reward

  • id — int(11) — Primary key — NOT NULL
  • whole_collection_number — int(11) — NOT NULL
  • reward_type — varchar(1) — NOT NULL
  • reward_id — int(11) — Foreign key → item.id — NOT NULL
  • reward_qty — tinyint(4) — NOT NULL

dino

  • id — int(11) — Primary key — NOT NULL
  • base_power — int(11) — NOT NULL
  • base_teeth — int(11) — NOT NULL
  • base_tail — int(11) — NOT NULL
  • base_defense — int(11) — NOT NULL
  • base_hp — int(11) — NOT NULL
  • attribute — tinyint(4) — NOT NULL
  • dino_type — tinyint(4) — NOT NULL
  • generation — tinyint(4) — NOT NULL
  • rank — tinyint(4) — NOT NULL
  • appearance_rate — double — NOT NULL
  • exchange_point — int(11) — NOT NULL

dino_exchange

  • id — int(11) — Primary key — NOT NULL
  • point — int(11) — NOT NULL
  • reward_item_id — int(11) — Foreign key → item.id — NOT NULL
  • reward_item_type — varchar(1) — NOT NULL
  • base_quantity — int(11) — NOT NULL
  • additional_quantity — int(11) — NOT NULL
  • appearance_rate — double — NOT NULL

dino_growth_rate

  • id — int(11) — Primary key — NOT NULL
  • rank — tinyint(4) — NOT NULL
  • generation — tinyint(4) — NOT NULL
  • growth_power — double — NOT NULL
  • growth_teeth — double — NOT NULL
  • growth_tail — double — NOT NULL
  • growth_defense — double — NOT NULL
  • growth_hp — double — NOT NULL

dino_level

  • id — int(11) — Primary key — NOT NULL
  • level — int(11) — NOT NULL
  • require_exp — int(11)
  • selling_price — int(11)
  • total_exp — int(11)
  • rank — tinyint(4)
  • generation — tinyint(4)

dino_log

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(20) — Foreign key → user.user_id — NOT NULL
  • dino_id — int(11) — NOT NULL
  • udid — int(11) — NOT NULL
  • issue_type — varchar(1) — NOT NULL
  • issue_date — datetime — NOT NULL

dino_skill

  • id — int(11) — Primary key — NOT NULL
  • skill_id — int(11) — NOT NULL
  • dino_id — int(11) — Foreign key → dino.id — NOT NULL
  • skill_type — varchar(1) — NOT NULL

dp_issue_table

  • id — bigint(20) — Primary key — NOT NULL
  • id (id2) — bigint(20) — Foreign key → user.id — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • developer_payload — varchar(128) — NOT NULL
  • issue_time — datetime — NOT NULL
  • verification_level — varchar(1) — NOT NULL
  • inapp_product_id — varchar(50) — NOT NULL

egg

  • id — int(11) — Primary key — NOT NULL
  • buy_price — int(11) — NOT NULL
  • selling_price — int(11) — NOT NULL
  • appearance_rate — double — NOT NULL
  • appear_level — int(11) — NOT NULL
  • born_rank_1_rate — double — NOT NULL
  • born_rank_2_rate — double — NOT NULL
  • born_rank_3_rate — double — NOT NULL
  • born_rank_4_rate — double — NOT NULL
  • born_rank_5_rate — double — NOT NULL
  • breed_time — int(11) — NOT NULL

endpoint_list

  • id — bigint(20) — Primary key — NOT NULL
  • device_id — varchar(100) — NOT NULL
  • end_point — varchar(255) — NOT NULL

equipment

  • id — int(11) — Primary key — NOT NULL
  • category_id — int(11) — NOT NULL
  • power — int(11) — NOT NULL
  • teeth — int(11) — NOT NULL
  • tail — int(11) — NOT NULL
  • defense — int(11) — NOT NULL
  • hp — int(11) — NOT NULL
  • search_time_dec_rate — double — NOT NULL
  • search_item_inc_rate — double — NOT NULL
  • get_gold_inc_rate — double — NOT NULL
  • search_treasure_inc_rate — double — NOT NULL
  • combine_rank — tinyint(4) — NOT NULL
  • set_id — int(11) — NOT NULL
  • rank — tinyint(4) — NOT NULL
  • selling_price — int(11) — NOT NULL
  • appear_level — tinyint(4) — NOT NULL
  • appearance_rate — double — NOT NULL
  • buy_price — int(11) — NOT NULL
  • part_id — tinyint(4) — NOT NULL

event_attendance_reward

  • id — int(11) — Primary key — NOT NULL
  • attendance_cnt — int(11) — NOT NULL
  • attendance_type — varchar(1) — NOT NULL
  • reward_item_type — varchar(1) — NOT NULL
  • reward_item_id — int(11) — Foreign key → item.id — NOT NULL
  • reward_item_qty — int(11) — NOT NULL

event_involver_list

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • event_id — tinyint(4) — NOT NULL
  • event_type — varchar(1) — NOT NULL
  • complete_date — datetime — NOT NULL
  • reward_collect_yn — varchar(1) — NOT NULL

event_shop

  • id — int(11) — Primary key — NOT NULL
  • item_id — int(11) — Foreign key → item.id — NOT NULL
  • item_type — varchar(1) — NOT NULL
  • item_qty — int(11) — NOT NULL
  • exchange_material_id — int(11) — NOT NULL
  • exchange_quantity — int(11) — NOT NULL
  • product_reset_type — varchar(1)

evolution

  • id — int(11) — Primary key — NOT NULL
  • dino_id — int(11)
  • next_gen_id — int(11)
  • stone_cost — tinyint(4)
  • gold_cost — int(11)
  • sub_material_id — int(11)
  • sub_material_cost — int(11)
  • id (id2) — int(11) — Foreign key → dino.id — NOT NULL

explore

  • id — int(11) — Primary key — NOT NULL
  • duration — int(11) — NOT NULL
  • base_damage — int(11) — NOT NULL

explore_reward

  • id — int(11) — Primary key — NOT NULL
  • area_type — tinyint(4) — NOT NULL
  • item_id — int(11) — Foreign key → item.id — NOT NULL
  • hidden_type — varchar(1) — NOT NULL
  • reward_type — varchar(1) — NOT NULL
  • reward_qty — tinyint(4) — NOT NULL
  • reward_gold — int(11) — NOT NULL
  • explore_round — tinyint(4) — NOT NULL

formula

  • id — int(11) — Primary key — NOT NULL
  • consume_1_id — int(11) — NOT NULL
  • consume_2_id — int(11) — NOT NULL
  • consume_3_id — int(11) — NOT NULL
  • consume_4_id — int(11) — NOT NULL
  • consume_1_qty — int(11) — NOT NULL
  • consume_2_qty — int(11) — NOT NULL
  • consume_3_qty — int(11) — NOT NULL
  • consume_4_qty — int(11) — NOT NULL
  • result_item_id — int(11) — NOT NULL
  • result_item_type — varchar(1) — NOT NULL
  • gold_cost — int(11) — NOT NULL

formula_equipment_rate

  • id — int(11) — Primary key — NOT NULL
  • rank — tinyint(4) — NOT NULL
  • appearance_rate — double — NOT NULL

friend_match_point

  • id — bigint(20) — Primary key — NOT NULL
  • win_reward_point — int(11)
  • lose_reward_point — int(11)
  • draw_reward_point — int(11)
  • daily_maximum — int(11)

friend_match_point_reward

  • id — bigint(20) — Primary key — NOT NULL
  • reward_step — int(11)
  • item_id — int(11) — Foreign key → item.id — NOT NULL
  • item_type — varchar(1) — NOT NULL
  • item_qty — int(11) — NOT NULL
  • required_point — int(11)

incubator

  • id — int(11) — Primary key — NOT NULL
  • open_price — int(11)
  • price_type — varchar(1)

intro_dino_case

  • id — int(11) — Primary key — NOT NULL
  • dino_id — int(11) — Foreign key → dino.id — NOT NULL
  • skill_id — int(11) — Foreign key → dino_skill.id — NOT NULL

item

  • id — int(11) — Primary key — NOT NULL
  • selling_price — int(11)
  • name — varchar(15) — NOT NULL
  • appear_level — tinyint(4) — NOT NULL
  • buy_price — int(11) — NOT NULL
  • appearance_rate — double — NOT NULL
  • appear_qty — tinyint(4) — NOT NULL

level_reward

  • id — int(11) — Primary key — NOT NULL
  • level — int(11) — Foreign key → level_up.level — NOT NULL
  • reward_type — varchar(1) — NOT NULL
  • reward_id — int(11) — NOT NULL
  • reward_cnt — int(11) — NOT NULL

level_up

  • level — int(11) — Primary key — NOT NULL
  • required_exp — int(11) — NOT NULL
  • total_exp — int(11) — NOT NULL

lv_up_event_reward

  • id — bigint(20) — Primary key — NOT NULL
  • event_id — tinyint(4) — NOT NULL
  • dino_rank — tinyint(4) — NOT NULL
  • dino_attribute — tinyint(4) — NOT NULL
  • event_reward_item_id_1 — int(11) — Foreign key → item.id — NOT NULL
  • event_reward_item_type_1 — varchar(1) — NOT NULL
  • event_reward_item_qty_1 — varchar(1) — NOT NULL
  • event_reward_item_id_2 — int(11) — Foreign key → item.id — NOT NULL
  • event_reward_item_type_2 — varchar(1) — NOT NULL
  • event_reward_item_qty_2 — varchar(1) — NOT NULL

play_cnt_reward

  • id — int(11) — Primary key — NOT NULL
  • play_cnt — tinyint(4)
  • reward_item_type — varchar(1)
  • reward_quantity — int(11)
  • reward_item_id — int(11) — Foreign key → item.id — NOT NULL

product

  • id — int(11) — Primary key — NOT NULL
  • product_type — varchar(1)
  • value — int(11)
  • quantity — int(11)
  • cash_product_id — int(11)
  • product_id — int(11)

product_map

  • id — tinyint(4) — Primary key — NOT NULL
  • iap_product_id — varchar(128) — NOT NULL
  • product_id — varchar(128) — NOT NULL

qr_consume_history

  • id — bigint(20) — Primary key — NOT NULL
  • qr_code — varchar(20) — NOT NULL
  • code_type — varchar(1) — NOT NULL
  • user_id — varchar(10) — NOT NULL
  • edition — varchar(10) — NOT NULL
  • used_date — datetime — NOT NULL

qrcode

  • id — int(11) — Primary key — NOT NULL
  • code — varchar(12) — NOT NULL
  • dino_id — int(11) — Foreign key → dino.id — NOT NULL
  • used_yn — varchar(1) — NOT NULL
  • qr_type — varchar(1) — NOT NULL
  • edition — varchar(10) — NOT NULL
  • created_date — datetime — NOT NULL
  • promotion_gen — int(11) — NOT NULL

quest

  • id — int(11) — Primary key — NOT NULL
  • quest_type — varchar(1) — NOT NULL
  • rank — tinyint(4) — NOT NULL
  • quest_reward_id — int(11) — NOT NULL
  • quest_reward_type — varchar(1) — NOT NULL
  • quest_reward_qty — int(11) — NOT NULL
  • clear_type — varchar(1) — NOT NULL
  • clear_cnt — int(11) — NOT NULL
  • appearance_rate — double — NOT NULL

random_pick

  • id — int(11) — Primary key — NOT NULL
  • category_id — int(11) — Foreign key → item.id — NOT NULL
  • dino_id — int(11)
  • appearance_rate — double

random_pick_extra

  • id — int(11) — Primary key — NOT NULL
  • ticket_id — int(11)
  • item_id — int(11) — Foreign key → item.id — NOT NULL
  • item_type — varchar(1)
  • quantity — int(11)
  • appearance_rate — double

reskill

  • id — int(11) — Primary key — NOT NULL
  • rank — tinyint(4)
  • reset_item_qty — tinyint(4)
  • consume_dino_cost — tinyint(4)

scenario

  • id — int(11) — Primary key — NOT NULL
  • condition_stage_level — tinyint(4) — NOT NULL
  • condition_sub_stage_level — tinyint(4) — NOT NULL

server_status

  • id — int(11) — Primary key — NOT NULL
  • server_status — varchar(1) — NOT NULL
  • arena_status — varchar(1) — NOT NULL
  • msg — varchar(256) — NOT NULL
  • start_date — datetime — NOT NULL

shop

  • id — int(11) — Primary key — NOT NULL
  • product_id — int(11)
  • product_type — varchar(1)
  • value — int(11)
  • type — varchar(1)
  • quantity — int(11)
  • open_stage_level — tinyint(4)

shop_purchase_limit

  • id — int(11) — Primary key — NOT NULL
  • product_id — int(11) — Foreign key → shop.id — NOT NULL
  • limit — int(11) — NOT NULL

skin

  • id — int(11) — Primary key — NOT NULL
  • collect_type — varchar(1) — NOT NULL
  • condition — tinyint(4) — NOT NULL

stage_buff

  • id — int(11) — Primary key — NOT NULL
  • cost — int(11)
  • cost_type — varchar(1)

stage_reward

  • id — int(11) — Primary key — NOT NULL
  • stage_level — tinyint(4)
  • stage_area_level — tinyint(4)
  • reward_item_id — int(11)
  • reward_type — varchar(1)
  • reward_qty — tinyint(4)
  • reward_gold — int(11)
  • reward_egg_id — int(11)
  • reward_egg_qty — tinyint(4)
  • appearance_rate — double
  • reward_giving_type — varchar(1)

static_version

  • id — int(11) — Primary key — NOT NULL
  • major_version — tinyint(4) — NOT NULL
  • minor_version — tinyint(4) — NOT NULL
  • update_date — datetime — NOT NULL

treasure_box_reward

  • id — int(11) — Primary key — NOT NULL
  • stage_level — tinyint(4) — Foreign key → stage_reward.id — NOT NULL
  • treasure_reward_type — varchar(1) — NOT NULL
  • treasure_item_id — int(11) — NOT NULL
  • treasure_reward_qty — int(11) — NOT NULL
  • treasure_reward_appear_rate — double — NOT NULL

user

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(10) — Primary key — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • device_id — varchar(50) — NOT NULL
  • os_type — varchar(1) — NOT NULL
  • pgs_id — varchar(30) — NOT NULL
  • agc_id — varchar(30) — NOT NULL
  • pgs_sync_yn — varchar(1) — NOT NULL
  • agc_sync_yn — varchar(1) — NOT NULL
  • gold — int(11) — NOT NULL
  • crystal — int(11) — NOT NULL
  • arena_coin — int(11) — NOT NULL
  • dino_watch_edition — tinyint(4) — NOT NULL
  • current_equip_deck_id — tinyint(4) — NOT NULL
  • quest_drop_cnt — tinyint(4) — NOT NULL
  • current_tutorial_id — tinyint(4) — NOT NULL
  • tutorial_finished_yn — varchar(1) — NOT NULL
  • intro_dino_id — int(11) — NOT NULL
  • current_dictionary_reward_id — tinyint(4) — NOT NULL
  • initial_dino_collect_yn — varchar(1) — NOT NULL
  • user_status — varchar(1) — NOT NULL
  • current_stage_level — tinyint(4) — NOT NULL
  • age — tinyint(4) — NOT NULL
  • sex — varchar(1) — NOT NULL
  • skin_id — tinyint(4) — NOT NULL
  • dictionary_complete — double — NOT NULL
  • attendance_cnt — tinyint(4) — NOT NULL
  • attendance_check — varchar(1) — NOT NULL
  • quest_reset_yn — varchar(1) — NOT NULL
  • item_shop_reset_yn — varchar(1) — NOT NULL
  • join_time — datetime — NOT NULL
  • login_time — datetime — NOT NULL
  • logout_time — datetime — NOT NULL
  • leave_req_time — datetime — NOT NULL
  • arena_item_shop_reset_yn — varchar(1) — NOT NULL
  • pvp_quest_drop_cnt — tinyint(4) — NOT NULL
  • pvp_quest_complete_yn — varchar(1) — NOT NULL
  • all_arena_reward_collected — varchar(1) — NOT NULL
  • push_allowed_yn — varchar(1) — NOT NULL
  • reg_id — varchar(200) — NOT NULL
  • daily_summon_valid_time — datetime — NOT NULL
  • arena_play_reward_exp_time — datetime — NOT NULL
  • accum_friend_match_point — int(11) — NOT NULL
  • daily_gather_point — int(11) — NOT NULL
  • friend_match_point — int(11) — NOT NULL
  • current_exp — int(11) — NOT NULL
  • current_user_level — int(11) — NOT NULL
  • current_level_reward_collected — varchar(1) — NOT NULL
  • current_level_reward_step — tinyint(4) — NOT NULL

user_achievement

  • id — int(11) — Primary key — NOT NULL
  • user_id (user_id2) — varchar(10) — Foreign key → user.user_id — NOT NULL
  • user_id — varchar(20) — NOT NULL
  • achievement_id — int(11) — NOT NULL
  • take_yn — varchar(1) — NOT NULL

user_arena

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • win_cnt — int(11) — NOT NULL
  • lose_cnt — int(11) — NOT NULL
  • current_arena_rank — tinyint(4) — NOT NULL
  • season_max_rank — tinyint(4) — NOT NULL
  • season_win_cnt — int(11) — NOT NULL
  • season_lose_cnt — int(11) — NOT NULL
  • mmr — double — NOT NULL
  • ranking — int(11) — NOT NULL
  • daily_win_cnt — tinyint(4) — NOT NULL
  • draw_cnt — int(11) — NOT NULL
  • season_draw_cnt — int(11) — NOT NULL
  • daily_play_cnt — tinyint(4) — NOT NULL
  • reward_1_collected_yn — varchar(1) — NOT NULL
  • reward_2_collected_yn — varchar(1) — NOT NULL
  • reward_3_collected_yn — varchar(1) — NOT NULL
  • bot_draw_cnt — int(11) — NOT NULL
  • bot_lose_cnt — int(11) — NOT NULL
  • bot_win_cnt — int(11) — NOT NULL

user_arena_log_key

  • id — int(11) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • room_key — varchar(200) — NOT NULL
  • played_date — datetime — NOT NULL

user_arena_play_reward

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • arena_reward_id — tinyint(4) — NOT NULL

user_arena_rank_grade_reward

  • id — int(11) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • reward_rank_grade — tinyint(4) — NOT NULL
  • rewarded_yn — varchar(1) — NOT NULL

user_arena_season_history

  • id — int(11) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • season — int(11) — NOT NULL
  • ranking — int(11) — NOT NULL
  • win_cnt — int(11) — NOT NULL
  • mmr — double — NOT NULL
  • confirmed_yn — varchar(1) — NOT NULL

user_arena_season_reward

  • id — int(11) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • season — int(11) — NOT NULL
  • reward_type — varchar(1) — NOT NULL
  • item_id — int(11) — NOT NULL
  • item_type — varchar(1) — NOT NULL
  • item_qty — int(11) — NOT NULL

user_arena_shop

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • slot_id — tinyint(4) — NOT NULL
  • shop_product_id — tinyint(4) — NOT NULL
  • slot_opened_yn — varchar(1) — NOT NULL
  • soldout_yn — varchar(1) — NOT NULL

user_dino

  • id — int(11) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • dino_id — int(11) — Foreign key → dino.id — NOT NULL
  • dino_rank — tinyint(4) — NOT NULL
  • level — int(11) — NOT NULL
  • current_exp — int(11) — NOT NULL
  • next_exp — int(11) — NOT NULL
  • total_exp — int(11) — NOT NULL
  • power — int(11) — NOT NULL
  • teeth — int(11) — NOT NULL
  • tail — int(11) — NOT NULL
  • hp — int(11) — NOT NULL
  • defense — int(11) — NOT NULL
  • attribute — tinyint(4) — NOT NULL
  • evolve_count — tinyint(4) — NOT NULL
  • special_skill_1 — int(11) — NOT NULL
  • special_skill_2 — int(11) — NOT NULL
  • special_skill_3 — int(11) — NOT NULL
  • deck_deployed_yn — varchar(1) — NOT NULL
  • deployed_deck_id — tinyint(4) — NOT NULL

user_dino_deck

  • id — int(11) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • deck_no — tinyint(4) — NOT NULL
  • pos_1_dino_id — int(11) — NOT NULL
  • pos_2_dino_id — int(11) — NOT NULL
  • pos_3_dino_id — int(11) — NOT NULL
  • pos_4_dino_id — int(11) — NOT NULL
  • arena_deployed — varchar(1) — NOT NULL

user_dino_dictionary

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • dino_id — int(11) — NOT NULL
  • capture_yn — varchar(1) — NOT NULL

user_dino_dictionary_reward

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • reward_id — varchar(20) — NOT NULL
  • collected_yn — varchar(1) — NOT NULL

user_egg_inventory

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • egg_id — int(11) — NOT NULL
  • quantity — int(11) — NOT NULL

user_equipment

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • deck — tinyint(4) — NOT NULL
  • equipment_1 — int(11) — NOT NULL
  • equipment_2 — int(11) — NOT NULL
  • equipment_3 — int(11) — NOT NULL
  • equipment_4 — int(11) — NOT NULL
  • equipment_5 — int(11) — NOT NULL
  • equip_1_set_id — int(11) — NOT NULL
  • equip_2_set_id — int(11) — NOT NULL
  • equip_3_set_id — int(11) — NOT NULL
  • equip_4_set_id — int(11) — NOT NULL
  • equip_5_set_id — int(11) — NOT NULL
  • equip_1_combine_rank — tinyint(4) — NOT NULL
  • equip_2_combine_rank — tinyint(4) — NOT NULL
  • equip_3_combine_rank — tinyint(4) — NOT NULL
  • equip_4_combine_rank — tinyint(4) — NOT NULL
  • equip_5_combine_rank — tinyint(4) — NOT NULL
  • arena_deployed — varchar(1) — NOT NULL

user_equipment_inventory

  • id — bigint(20) — Primary key — NOT NULL
  • user_id (user_id2) — varchar(10) — Foreign key → user.user_id — NOT NULL
  • itemid (Field) — int(11) — NOT NULL

user_event_attendance

  • id — int(11) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • attendance_type — varchar(1) — NOT NULL
  • attendance_cnt — tinyint(4) — NOT NULL

user_event_shop

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • product_id — int(11) — NOT NULL
  • reset_type — varchar(1) — NOT NULL
  • bought_yn — varchar(1) — NOT NULL

user_explore

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • dino_id — int(11) — NOT NULL
  • base_level — tinyint(4) — NOT NULL
  • base_max_health — int(11) — NOT NULL
  • current_health — int(11) — NOT NULL
  • current_defense — int(11) — NOT NULL
  • area_type — tinyint(4) — NOT NULL
  • explore_complete_yn — varchar(1)
  • explore_cnt — tinyint(4)
  • end_time — datetime — NOT NULL
  • area_open_yn — varchar(1) — NOT NULL
  • area_vacancy_yn — varchar(1) — NOT NULL
  • item_appear_up_rate — double — NOT NULL
  • gold_inc_rate — double — NOT NULL
  • resend_available — varchar(1) — NOT NULL

user_explore_reward

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — varchar(10) — Foreign key → user.user_id — NOT NULL
  • collected_reward_id — int(11) — NOT NULL
  • collected_area — int(11) — NOT NULL

and 16 more tables