dearElla

Tables (12)

C2X_Account

  • uid — bigint
  • owner — nvarchar(20)
  • address — nvarchar(50)
  • upper_limit — bigint
  • lower_limit — bigint

C2X_Metadata

  • uid — bigint
  • transaction_id — nvarchar(50)
  • DID — nvarchar(20)
  • owner — nvarchar — Foreign key → C2X_Account.owner — owner 고유값
  • serial — bigint

C2X_Transaction

  • uid — bigint
  • DID — tinyint
  • owner — nvarchar(20) — Foreign key → Tbl_Account.owner
  • transaction_id — nvarchar(50) — Foreign key → C2X_Metadata.transaction_id
  • type — tinyint
  • serial — bigint
  • value — bigint
  • status_code — smallint
  • id_serial — bigint — Foreign key → Tbl_Account.id_serial
  • game_status — tinyint
  • token_id — nvarchar(50)

GAME_CharUpgradePartData

  • idx — int — Foreign key → Unit.upgrade
  • code — nvarchar(16)
  • mat_code_0 — nvarchar(16)
  • mat_cnt_0 — int
  • mat_code_1 — nvarchar(16)
  • mat_cnt_1 — int
  • mat_code_2 — nvarchar(16)
  • mat_cnt_2 — int
  • cost — int
  • cont_eff — int
  • add_value — float
  • multi_value — float
  • limit_unit_level — int

Game_CharData

  • idx — int — Foreign key → Unit.idx
  • code — nvarchar(16) — Foreign key → Game_CharRankUpData.code
  • name — nvarchar(64)
  • name_eng — nvarchar(50)
  • type — int
  • class_type — int
  • gender — int
  • base_code — nvarchar(16)
  • party_base_code — nvarchar(16)
  • chain_code_0 — nvarchar(16)
  • chain_code_1 — nvarchar(16)
  • chain_code_2 — nvarchar(16)
  • grade — int
  • attack_type — int
  • attribute — int
  • rare — float
  • book — int
  • panel — tinyint
  • str — float
  • str_inc — float
  • dex — float
  • dex_inc — float
  • int — float
  • int_inc — float
  • ad — float
  • ad_inc — float
  • ap — float
  • ap_inc — float
  • addef — float
  • addef_inc — float
  • apreg — float
  • apreg_inc — float
  • hp — float
  • hp_inc — float
  • atkdist — float
  • atkdist_inc — float
  • attack_speed — float
  • attack_speed_inc — float
  • strong — float
  • strong_inc — float
  • hit_rate — int
  • dodge_rate — int
  • critical_rate — int
  • upgrade_cost — int
  • upgrade_exp — int
  • hero_buy — int
  • skill_1 — nvarchar(16)
  • cooltime_1 — float
  • skill_2 — nvarchar(16)
  • cooltime_2 — float
  • skill_3 — nvarchar(16)
  • cooltime_3 — float
  • skill_4 — nvarchar(16)
  • cooltime_4 — float
  • skill_5 — nvarchar(16)
  • cooltime_5 — float
  • skill_6 — nvarchar(16)
  • cooltime_6 — float
  • skill_special — nvarchar(16)
  • cooltime_special — float
  • … +29

Game_CharRankUpData

  • idx — int — Foreign key → Unit.idx
  • code — nvarchar(16)
  • rank — int
  • stat_type_00 — int
  • stat_value_00 — int
  • stat_type_01 — int
  • stat_value_01 — int
  • stat_type_02 — int
  • stat_value_02 — int
  • stat_type_03 — int
  • stat_value_03 — int
  • limit_marking_level — tinyint
  • EnchantLevelCondition — int
  • MainMoneyType — tinyint
  • MainNeedValue — int
  • SubMoneyType — tinyint
  • SubNeedValue — int
  • UseUnitRankOver — tinyint
  • UseEnchantLevelCondition — tinyint
  • strSupportItemCode — nvarchar(16)
  • SupportItemCnt — int
  • UseSameUnit — tinyint

Game_CharUpgradeData

  • idx — int — Foreign key → Unit.upgrade
  • code — nvarchar(16)
  • cost — int
  • slot_code_0 — nvarchar(16)
  • slot_code_1 — nvarchar(16)
  • slot_code_2 — nvarchar(16)
  • slot_code_3 — nvarchar(16)
  • slot_code_4 — nvarchar(16)
  • cont_eff_0 — int
  • add_value_0 — float
  • multi_value_0 — float
  • cont_eff_1 — int
  • add_value_1 — float
  • multi_value_1 — float
  • cont_eff_2 — int
  • add_value_2 — float
  • multi_value_2 — float
  • cont_eff_3 — int
  • add_value_3 — float
  • multi_value_3 — float
  • cont_eff_4 — int
  • add_value_4 — float
  • multi_value_4 — float
  • cont_eff_5 — int
  • add_value_5 — float
  • multi_value_5 — float
  • marking_up_item_code_0 — nvarchar(16)
  • marking_up_item_value_0 — int
  • marking_up_item_code_1 — nvarchar(16)
  • marking_up_item_value_1 — int
  • marking_up_item_code_2 — nvarchar(16)
  • marking_up_item_value_2 — int

Tbl_Account ([DB: FC_AccountDB])

  • id_serial — bigint
  • DID — tinyint
  • owner — nvarchar(20) — user의 UUID
  • account_id — nvarchar(128)
  • account_pwd — nvarchar(32)
  • grade — tinyint
  • platform_type — tinyint
  • country_code — nvarchar(3)
  • last_world — int
  • regist_time — datetime
  • last_login — datetime
  • is_delete — tinyint
  • delete_time — datetime
  • AuthKey — bigint
  • hivedid — nvarchar(128)

Tbl_Currency

  • uid — bigint
  • did — tinyint
  • owner — nvarchar(20) — Foreign key → Tbl_Account.owner
  • type — tinyint
  • value — bigint
  • update_time — datetime

Tbl_UnitAddStat

  • uid — bigint
  • DID — tinyint
  • owner — nvarchar(20) — Foreign key → Tbl_Account.owner
  • Serial — bigint
  • EnchantLevel — int
  • AddAttackStat — int
  • AddADDefStat — int
  • AddAPDefStat — int
  • AddHPStat — int
  • update_time — datetime

Tbl_UnitTalent

  • uid — bigint
  • did — tinyint
  • owner — nvarchar(20) — Foreign key → Tbl_Account.owner
  • unit_serial — bigint
  • talent_group_idx — int
  • talent_effect_0 — int
  • talent_value_0 — float
  • talent_multi_0 — float
  • talent_effect_1 — float
  • talent_value_1 — float
  • talent_multi_1 — int
  • talent_effect_2 — float
  • talent_value_2 — float
  • talent_multi_2 — int
  • talent_effect_3 — float
  • talent_value_3 — float
  • talent_multi_3 — int
  • update_time — datetime

Unit

  • uid — bigint
  • DID — tinyint
  • owner — nvarchar(20) — Foreign key → Tbl_Account.owner
  • idx — int
  • serial — bigint — Foreign key → Tbl_UnitAddStat.Serial
  • level — tinyint
  • exp — bigint
  • enchant — tinyint
  • upgrade — tinyint
  • special — int
  • b_death — bit
  • rebirth_time — int
  • b_choice — bit
  • equip_0 — bigint
  • equip_1 — bigint
  • equip_2 — bigint
  • equip_3 — bigint
  • equip_4 — bigint
  • equip_5 — bigint
  • equip_6 — bigint
  • skill_level_0 — tinyint
  • skill_level_1 — tinyint
  • skill_level_2 — tinyint
  • skill_level_3 — tinyint
  • skill_level_4 — tinyint
  • skill_level_5 — tinyint
  • skill_level_6 — tinyint
  • date — bigint
  • exskill — int
  • exskill_level — tinyint
  • medal_level — smallint
  • medal_exp — int
  • skill_cooltime_0 — int
  • skill_cooltime_1 — int
  • skill_cooltime_2 — int
  • skill_cooltime_3 — int
  • skill_cooltime_4 — int
  • skill_cooltime_5 — int
  • skill_cooltime_6 — int
  • upgrade_status — smallint
  • rank — tinyint
  • is_delete — tinyint
  • update_time — datetime
  • awaken — tinyint
  • training_break_end_time — bigint
  • costume_idx — int
  • nft_lock — tinyint
  • befor_nft_lock — tinyint
  • can_minting_state — tinyint