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