projectM
Tables (13)
user_battle_map_info (Untitled)
- usid (Key) — int — Primary key — NOT NULL
- usid (Key2) — int — Foreign key → user_info.usid — NOT NULL
- mst_map_seq (Field) — int — NOT NULL
user_equip_part_info (Untitled7)
- usid (Key2) — int — Primary key — NOT NULL
- equip_part (Key3) — int — Primary key — NOT NULL — 1~6
- usid (Key) — int — Foreign key → user_info.usid — NOT NULL
- user_equipment_id (Key22) — bigint — Foreign key → user_equipment.user_equipment_id — NOT NULL
- user_equipment_id (Field) — int
user_equipment (Untitled8)
- user_equipment_id (Key2) — bigint — Primary key — NOT NULL — A.I
- usid (Key) — int — Foreign key → user_info.usid — NOT NULL
- mst_equipment_id (Field) — int — NOT NULL
- equipment_level (Field2) — int — NOT NULL
- equipment_grade (Field3) — int — NOT NULL
- option_id_01 (Field10) — int
- option_value_01 (Field11) — int
- option_id_02 (Field12) — int
- option_value_02 (Field13) — int
- option_id_03 (Field14) — int
- option_value_03 (Field15) — int
user_equipment_preview (Untitled11)
- user_equipment_id (Key2) — bigint — Foreign key → user_equipment.user_equipment_id — NOT NULL — A.I
- reward_preview_id (Key) — int — Foreign key → user_reward_preview_detail.reward_preview_id — NOT NULL
- reward_preview_idx (Key3) — int — Foreign key → user_reward_preview_detail.reward_preview_idx — NOT NULL
user_equipment_tmp_record (Untitled13)
- user_equiment_id (Key) — bigint — Primary key — NOT NULL
- user_equipment_id (Key2) — bigint — Foreign key → user_equipment.user_equipment_id — NOT NULL — A.I
- obtain_route (Field) — int — NOT NULL
- equipment_state (Field2) — int — NOT NULL — 1-none, 2-eqiup, 3-delete
- usid (Field3) — int — NOT NULL
user_info (Untitled3)
- usid (Key) — int — Primary key — NOT NULL
- server_no (Field) — int — NOT NULL
- account_name (Field2) — varchar — NOT NULL
- account_level (Field3) — int — NOT NULL
- account_exp (Field4) — int — NOT NULL
- create_time (Field5) — int — NOT NULL
- last_login_time (Field6) — int — NOT NULL
- total_login_day (Field7) — int — NOT NULL
user_item (Untitled5)
- user_item_id (Key2) — bigint — Primary key — NOT NULL — A.I
- usid (Key) — int — Foreign key → user_info.usid — NOT NULL
- mst_item_id (Field) — int — NOT NULL
- item_category (Field2) — int — NOT NULL
- item_amount (Field3) — int — NOT NULL
user_reward_preview (Untitled6)
- reward_preview_id (Key2) — AI — Primary key — NOT NULL
- usid (Key) — int — Foreign key → user_tile_map_dice_preview.usid — NOT NULL
- usid (Field) — int — NOT NULL
user_reward_preview_detail (Untitled9)
- reward_preview_id (Key) — int — Primary key — NOT NULL
- reward_preview_idx (Key3) — int — Primary key — NOT NULL
- reward_preview_id (Key2) — Foreign key → user_reward_preview.reward_preview_id — NOT NULL
- usid (Key4) — int — Foreign key → user_reward_preview.usid — NOT NULL
- content_id (Field) — int — NOT NULL
- content_value (Field2) — int
- item_type (Field3) — int — NOT NULL
- mst_item_id (Field4) — int — NOT NULL
- item_amount (Field5) — int — NOT NULL
- item_overlap_type (Field6) — int — NOT NULL
- value_01 (Field7) — int
- value_02 (Field8) — int
- value_03 (Field9) — int
- value_04 (Field10) — int
- value_05 (Field11) — int
- value_06 (Field12) — int
- value_07 (Field13) — int
- value_08 (Field14) — int
- value_09 (Field15) — int
- value_10 (Field16) — int
user_setting (Untitled12)
- usid (Key2) — int — Primary key — NOT NULL
- setting_type (Key3) — int — Primary key — NOT NULL — 1-타일맵배율
- usid (Key) — int — Foreign key → user_info.usid — NOT NULL
- setting_value (Field2) — int — NOT NULL
user_stat (Untitled4)
- usid (Key2) — int — Primary key — NOT NULL
- usid (Key) — int — Foreign key → user_info.usid — NOT NULL
- stat_type (Field) — int — NOT NULL — 1:atk, 2:hp, 3:rec
- stat_level (Field2) — int — NOT NULL
user_tile_map_dice_preview (Untitled10)
- usid (Key) — int — Primary key — NOT NULL
- preview_id (Key2) — int — Primary key — NOT NULL
- usid (Key3) — int — Foreign key → user_tile_map_info.usid — NOT NULL
- dice_value_01 (Field) — int — NOT NULL
- dice_value_02 (Field2) — int — NOT NULL
- after_roll_tile_map_seq (Field3) — int — NOT NULL
- reward_preview_id (Field4) — int
user_tile_map_info (Untitled2)
- usid (Key) — int — Primary key — NOT NULL
- usid (Key2) — int — Foreign key → user_battle_map_info.usid — NOT NULL
- usid (Key3) — int — Foreign key → user_info.usid — NOT NULL
- tile_map_seq (Field2) — int — NOT NULL
- tile_state (Field4) — int — NOT NULL — 1-일반, 2-장비대기, 3-소셜대기