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