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-소셜대기