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