projectM.V3

Tables (10)

user_action_summary (Untitled7)

  • usid (Key2) — int — Primary key — NOT NULL
  • action_type (Field) — int — NOT NULL
  • key_1 (Field2) — int — NOT NULL
  • key_2 (Field3) — int — NOT NULL
  • key_3 (Field4) — int — NOT NULL
  • action_value (Field5) — bigint — NOT NULL

user_content_info (Untitled8)

  • usid (Key2) — int — Primary key — NOT NULL
  • mst_content_id (Field) — int — NOT NULL
  • content_key (Field2) — int — NOT NULL
  • r_time (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 (Field4) — int — NOT NULL
  • mst_item_id (Field) — int — NOT NULL
  • item_category (Field2) — int — NOT NULL
  • item_amount (Field3) — int — NOT NULL

user_mission_info (Untitled6)

  • usid (Key2) — int — Primary key — NOT NULL
  • mission_type (Field) — int — NOT NULL
  • key_1 (Field2) — int — NOT NULL
  • key_2 (Field3) — int — NOT NULL
  • key_3 (Field4) — int — NOT NULL
  • action_id (Field6) — int — NOT NULL
  • mst_mission_id (Field5) — nt
  • mission_value (Field7) — int
  • mission_status (Field8) — int — NOT NULL

user_recharge (Untitled4)

  • usid (key) — int — Primary key — NOT NULL
  • mst_recharge_id (Field) — int — NOT NULL
  • last_recharge_time (Field2) — int — NOT NULL
  • stadard_day (Field3) — int — NOT NULL
  • remain_recharge_time (Field4) — int

user_setting (Untitled12)

  • usid (Key2) — int — Primary key — NOT NULL
  • setting_type (Key3) — int — Primary key — NOT NULL — 1-타일맵배율
  • setting_value (Field2) — int — NOT NULL

user_stage_explore_info_detail (Untitled2)

  • usid (Key) — int — Primary key — NOT NULL
  • explore_preview_id (Key2) — int — Primary key — NOT NULL
  • mst_explore_id (Field) — int — NOT NULL — 1-s_reward, 2-l_reward, 3-training, 5-monster
  • value_01 (Field2) — int — training_id or enemy_group_id
  • value_02 (Field3) — int — training_id
  • value_03 (Field4) — int — training_id

user_stage_info (Untitled)

  • usid (Key) — int — Primary key — NOT NULL
  • mst_map_seq (Field) — int — NOT NULL
  • stage_boss_summon_gauge (Field2) — int — NOT NULL
  • explore_state (Field3) — int — NOT NULL — 1-normal, 2-training, 3-monster
  • value_01 (Field4) — int — training_id_1 or mst_enemy_group_id
  • value_02 (Field5) — int — training_id_2
  • value_03 (Field6) — int — training_id_3
  • stand_by_open_next_seq (Field7) — int — 1-not, 2-standby

user_training_info (Untitled9)

  • usid (Key) — int — Primary key — NOT NULL
  • mst_training_id (Key2) — int — Primary key — NOT NULL
  • training_level (Field) — int — NOT NULL
  • training_exp (Field2) — int — NOT NULL