MP | 재구성 ERD

테이블 (48)

achievement_tb

  • achievement_code — TINYINT — 기본 키 — NOT NULL
  • log_code — TINYINT — 외래 키 → game_log_type_tb.log_code — NOT NULL
  • reward_code — TINYINT
  • reward_type — ENUM( 'item', 'part', 'unit' )
  • reward_amount — INT
  • required_value — INT

character_tb

  • character_code — TINYINT — 기본 키 — NOT NULL
  • price — INT
  • payment_item_code — TINYINT

container_category_probability_tb

  • category_type — ENUM( 'item', 'part', 'unit' ) — 기본 키 — NOT NULL
  • item_code — TINYINT — 외래 키 → game_item_tb.item_code — NOT NULL
  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' ) — 외래 키 → entity_grade_tb.grade_code — NOT NULL
  • probability — FLOAT

container_grade_data_tb

  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' ) — 외래 키 → entity_grade_tb.grade_code — NOT NULL
  • required_cache — INT
  • required_time — INT

container_probability_tb

  • code_type — ENUM( 'item', 'part', 'unit' ) — 기본 키 — NOT NULL
  • amount — INT — 기본 키 — NOT NULL
  • code — TINYINT — 기본 키 — NOT NULL
  • item_code — TINYINT — 외래 키 → game_item_tb.item_code — NOT NULL
  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' ) — 외래 키 → entity_grade_tb.grade_code — NOT NULL
  • score — FLOAT

craft_product_tb

  • craft_code — TINYINT — 기본 키 — NOT NULL
  • product_code — TINYINT
  • product_type — ENUM( 'item', 'part', 'unit' )
  • product_amount — INT
  • material1_code — TINYINT
  • material1_count — INT
  • material2_code — TINYINT
  • material2_count — INT
  • shop_line_code — TINYINT

entity_grade_tb

  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' ) — 기본 키 — NOT NULL

game_config_tb

  • game_version — VARCHAR(20) — 기본 키 — NOT NULL
  • max_user_level — INT
  • max_unit_level — INT
  • max_part_level — INT
  • part_slot_unlock_level — INT
  • turn_time — INT
  • damage_energy_ratio — FLOAT
  • damage_taken_energy_ratio — FLOAT
  • power_ratio — FLOAT
  • buff_count — INT
  • initial_line_damage — INT
  • line_damage_turn_interval — INT
  • line_damage_ratio — FLOAT
  • buff_ratio — FLOAT
  • damage_reinforce_ratio — FLOAT
  • reinforce_max_count — INT
  • level_up_reward_amount — INT

game_item_tb

  • item_code — TINYINT — 기본 키 — NOT NULL
  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' ) — 외래 키 → entity_grade_tb.grade_code
  • item_type — ENUM( 'material', 'container', 'special', 'currency' )

game_log_type_tb

  • log_code — TINYINT — 기본 키 — NOT NULL

game_part_tb

  • part_code — TINYINT — 기본 키 — NOT NULL
  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' ) — 외래 키 → entity_grade_tb.grade_code
  • ability_type — ENUM( 'damage', 'health', 'speed', 'weight', 'critical_rate', 'critical_damage' )

game_unit_tb

  • unit_code — TINYINT — 기본 키 — NOT NULL
  • base_hp — INT
  • base_damage — INT
  • base_speed — INT
  • base_weight — INT
  • base_critical_rate — INT
  • base_critical_damage — INT
  • damage_growth — FLOAT
  • hp_growth — FLOAT
  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' ) — 외래 키 → entity_grade_tb.grade_code
  • skill_cost — INT

map_tb

  • map_code — VARCHAR(100) — 기본 키 — NOT NULL
  • map_version — TIMESTAMP — 기본 키 — NOT NULL
  • map_data — TEXT

match_default_reward_tb

  • result_type — ENUM( 'win', 'lose' ) — 기본 키 — NOT NULL
  • experience — INT
  • currency — INT

match_result_reward_tb

  • reward_code — TINYINT — 기본 키 — NOT NULL
  • reward_type — ENUM( 'item', 'part', 'unit' )
  • amount — INT
  • required_score — INT

npc_tb

  • npc_code — TINYINT — 기본 키 — NOT NULL
  • npc_name — VARCHAR(20)
  • country_code — VARCHAR(2)
  • score — INT
  • level — INT

npc_unit_tb

  • unit_order — TINYINT — 기본 키 — NOT NULL
  • npc_code — TINYINT — 외래 키 → npc_tb.npc_code — NOT NULL
  • unit_code — TINYINT — 외래 키 → game_unit_tb.unit_code
  • unit_level — INT
  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' )
  • accuracy — INT
  • level_value — INT
  • behavior_code — TINYINT
  • part_uuid_1 — VARCHAR(50)
  • part_uuid_2 — VARCHAR(50)
  • part_uuid_3 — VARCHAR(50)
  • part_uuid_4 — VARCHAR(50)

part_ability_value_tb

  • level — INT — 기본 키 — NOT NULL
  • part_code — TINYINT — 외래 키 → game_part_tb.part_code — NOT NULL
  • ability_value — INT

part_decompose_tb

  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' ) — 외래 키 → entity_grade_tb.grade_code — NOT NULL
  • min_amount — INT
  • max_amount — INT

part_upgrade_cost_tb

  • level — INT — 기본 키 — NOT NULL
  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' ) — 외래 키 → entity_grade_tb.grade_code — NOT NULL
  • required_score — INT

part_upgrade_value_tb

  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' ) — 외래 키 → entity_grade_tb.grade_code — NOT NULL
  • upgrade_value — INT

rank_reward_tb

  • reward_code — TINYINT — 기본 키 — NOT NULL
  • tier_code — TINYINT — 외래 키 → tier_tb.tier_code — NOT NULL
  • reward_type — ENUM( 'item', 'part', 'unit' )
  • amount — INT

roulette_entry_tb

  • entry_code — TINYINT — 기본 키 — NOT NULL
  • item_code — TINYINT — 외래 키 → game_item_tb.item_code — NOT NULL
  • amount — INT
  • probability — FLOAT

server_ip_ban_tb

  • ip_address — VARCHAR(50) — 기본 키 — NOT NULL
  • reason — VARCHAR(100)
  • start_time — BIGINT

shop_product_tb

  • shop_product_code — TINYINT — 기본 키 — NOT NULL
  • product_code — TINYINT
  • product_type — ENUM( 'item', 'part', 'unit' )
  • product_amount — INT
  • price — INT
  • payment_item_code — TINYINT
  • shop_line_code — TINYINT
  • purchase_limit — INT

stage_tb

  • stage_code — TINYINT — 기본 키 — NOT NULL
  • sub_stage_code — TINYINT — 기본 키 — NOT NULL
  • reward_code — TINYINT
  • reward_type — ENUM( 'item', 'part', 'unit' )
  • reward_amount — INT
  • reward_experience — INT
  • npc_code — TINYINT
  • map_code — VARCHAR(100) — NOT NULL

tier_tb

  • tier_code — TINYINT — 기본 키 — NOT NULL
  • required_score — INT
  • win_score — INT
  • lose_score — INT
  • matching_min_range — INT
  • matching_max_range — INT

unit_upgrade_cost_tb

  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' ) — 외래 키 → entity_grade_tb.grade_code — NOT NULL
  • required_piece — INT

user_achievement_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • achievement_code — TINYINT — 외래 키 → achievement_tb.achievement_code — NOT NULL
  • log_code — TINYINT — 외래 키 → achievement_tb.log_code — NOT NULL
  • achieved — BOOLEAN

user_ban_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • reason — VARCHAR(100)
  • start_time — BIGINT

user_character_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • character_code — TINYINT — 외래 키 → character_tb.character_code — NOT NULL

user_consent_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • terms_agreed — BOOLEAN — NOT NULL
  • privacy_agreed — BOOLEAN — NOT NULL

user_container_tb

  • container_uuid — VARCHAR(50) — 기본 키 — NOT NULL
  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • item_code — TINYINT — 외래 키 → game_item_tb.item_code
  • open_time — BIGINT

user_game_data_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • character_code — TINYINT — 외래 키 → character_tb.character_code — NOT NULL
  • experience — INT
  • level — INT

user_game_setting_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • max_part_count — INT
  • tutorial_step — INT

user_gift_tb

  • gift_uuid — VARCHAR(50) — 기본 키 — NOT NULL
  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • gift_code — TINYINT
  • gift_type — ENUM( 'item', 'part', 'unit' )
  • amount — INT
  • title — VARCHAR(50)
  • content — VARCHAR(100)
  • expired_time — BIGINT

user_item_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • item_code — TINYINT — 외래 키 → game_item_tb.item_code — NOT NULL
  • amount — INT

user_log_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • log_code — TINYINT — 외래 키 → game_log_type_tb.log_code — NOT NULL
  • log_value — INT

user_part_tb

  • part_uuid — VARCHAR(50) — 기본 키 — NOT NULL
  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • part_code — TINYINT — 외래 키 → game_part_tb.part_code
  • level — INT

user_profile_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • country_code — VARCHAR(2) — NOT NULL
  • profile_name — VARCHAR(20)

user_purchase_log_tb

  • purchase_uuid — VARCHAR(50) — 기본 키 — NOT NULL
  • product_id — VARCHAR(50)
  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • purchase_type — VARCHAR(50)
  • purchase_time — BIGINT

user_rank_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • tier_code — TINYINT — 외래 키 → tier_tb.tier_code — NOT NULL
  • winning_streak — INT
  • score — INT

user_runtime_data_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • unit_part_data — VARCHAR(1000)
  • unit_order_data — VARCHAR(1000)
  • notification_data — VARCHAR(1000)
  • lobby_data — VARCHAR(1000)

user_session_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • device_uuid — VARCHAR(50)
  • access_expiry_time — BIGINT
  • refresh_expiry_time — BIGINT

user_shop_purchase_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • shop_product_code — TINYINT — 외래 키 → shop_product_tb.shop_product_code — NOT NULL
  • purchase_count — INT

user_stage_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • stage_code — TINYINT
  • stage_level — INT

user_tb

  • user_uuid — VARCHAR(50) — 기본 키 — NOT NULL
  • external_user_id — VARCHAR(50) — NOT NULL
  • signup_time — BIGINT
  • login_type — VARCHAR(20)
  • redirect_id — VARCHAR(50)

user_unit_tb

  • user_uuid — VARCHAR(50) — 외래 키 → user_tb.user_uuid — NOT NULL
  • unit_code — TINYINT — 외래 키 → game_unit_tb.unit_code — NOT NULL
  • level — INT
  • grade_code — ENUM( 'grade_1', 'grade_2', 'grade_3', 'grade_4', 'grade_5', 'grade_6', 'tutorial' ) — 외래 키 → entity_grade_tb.grade_code