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