projectM.V2

Tables (12)

user_action_summary (Untitled7)

  • usid (Key2) — int — Primary key — NOT NULL
  • usid (Key) — int — Foreign key → user_info.usid — 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_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_content_info (Untitled8)

  • usid (Key2) — int — Primary key — NOT NULL
  • usid (Key) — int — Foreign key → user_info.usid — 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 (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_mission_info (Untitled6)

  • usid (Key2) — int — Primary key — NOT NULL
  • usid (Key) — int — Foreign key → user_info.usid — 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
  • usid (Key) — int — Foreign key → user_info.usid — 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-타일맵배율
  • usid (Key) — int — Foreign key → user_info.usid — NOT NULL
  • setting_value (Field2) — int — NOT NULL

user_special_tile_info (Untitled11)

  • special_tile_info_id (Key2) — int — Primary key — NOT NULL — A.I
  • usid (Key) — int — Foreign key → user_tile_map_info.usid — NOT NULL
  • usid (Field) — int — NOT NULL
  • target_user_type (Field2) — int — 1-실제유저, 2-npc
  • target_user_id (Field3) — int

user_special_tile_info_detail (Untitled10)

  • special_tile_info_id (Key2) — int — Primary key — NOT NULL — A.I
  • special_tile_info_idx (Key3) — int — Primary key — NOT NULL
  • usid (Key) — int — Foreign key → user_special_tile_info.usid — NOT NULL
  • tile_type (Field) — int — NOT NULL — 6:PVP, 7:steal, 8:carrot_field, 9:wanted
  • value_01 (Field2) — int
  • value_02 (Field3) — int
  • value_03 (Field4) — int

user_tile_map_dice_preview (Untitled9)

  • usid (Key2) — int — Primary key — NOT NULL
  • preview_id (Key3) — int — Primary key — NOT NULL
  • usid (Key) — 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

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:PVP, 3:강탈, 4:당근밭, 5:현상수배
  • special_tile_info_id (Field) — int