vb

Tables (13)

battle_pass (Untitled11)

  • battle_pass_id (Key) — int — Primary key — NOT NULL
  • battle_pass_type (Field2) — varchar(1)
  • battle_pass_step (Field3) — int
  • reward_type (Field4) — varchar(1)
  • reward_info (Field5) — int
  • bonus_reward_id (Field6) — int

buster (Untitled3)

  • buster_id (Key2) — int — Primary key — NOT NULL
  • buster_name (Field2) — varchar(30)
  • buster_attack (Field3) — int
  • buster_hp (Field4) — int
  • buster_skill (Field5) — int
  • buster_attribute (Field6) — int

buster_level (Untitled4)

  • buster_id (Key) — int — Primary key — NOT NULL
  • buster_level (Field2) — int
  • buster_exp (Field3) — int

buster_upgrade_level (Untitled5)

  • buster_id (Key) — int — Primary key — NOT NULL
  • buster_level (Field2) — int
  • ability_type (Field3) — int
  • ability_value (Field4) — int

product (Untitled9)

  • id (Key) — int — Primary key — NOT NULL
  • product_type (Field) — varchar(1)
  • qty (Field2) — int
  • item_id (Field3) — int
  • google_product_id (Key2) — int — Foreign key → product_map.google_product_id — NOT NULL

product_map (Untitled10)

  • google_product_id (Key) — int — Primary key — NOT NULL
  • iap_product_id (Field) — int
  • value (Field3) — int
  • iap_product_name (Field4) — int

user (Untitled)

  • user_id (Key) — int — Primary key — NOT NULL
  • nickname (Field) — varchar(30)
  • device_id (Field2) — varchar(50)
  • pgs_id (Field3) — varchar(30)
  • user_status (Field4) — varchar(1)
  • join_time (Field5) — datetime
  • login_time (Field6) — datetime
  • logout_time (Field7) — datetime
  • exp (Field8) — int
  • user_level (Field9) — int
  • stage_level (Field10) — int
  • coin (Field11) — int
  • gem_f (Field12) — int
  • gem_c (Field13) — int
  • stamina (Field14) — int
  • battle_pass_point (Field15) — int
  • tutorial_yn (Field16) — varchar(1)
  • inviter (Field17) — int
  • Field18 — date_time

user_battle_pass (Untitled12)

  • id (Key) — bigint — Primary key — NOT NULL
  • battle_pass_type_open_yn (Field3) — varchar(1)
  • battle_pass_step (Field4) — int
  • battle_pass_id (Key2) — int — Foreign key → battle_pass.battle_pass_id — NOT NULL
  • user_id (Key3) — int — Foreign key → user.user_id — NOT NULL

user_buster (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • buster_id (Field2) — int
  • buster_level (Field3) — int
  • buster_attack (Field4) — int
  • buster_hp (Field5) — int
  • buster_attribute_qty (Field6) — int
  • update_time (Field7) — date_time
  • buster_id (Key3) — int — Foreign key → buster_level.buster_id — NOT NULL
  • buster_id (Key2) — int — Foreign key → buster.buster_id — NOT NULL
  • buster_id (Key4) — int — Foreign key → buster_upgrade_level.buster_id — NOT NULL
  • user_id (Key5) — int — Foreign key → user.user_id — NOT NULL

user_buster_equip (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • equip1 (Field2) — int
  • equip2 (Field3) — int
  • equip3 (Field4) — int
  • equip4 (Field5) — int
  • update_time (Field6) — date_time
  • user_id (Key2) — int — Foreign key → user.user_id — NOT NULL

user_inventory (Untitled8)

  • id (Key) — bigint — Primary key — NOT NULL
  • item_id (Field2) — int
  • qty (Field3) — int
  • update_time (Field4) — date_time
  • user_id (Key2) — int — Foreign key → user.user_id — NOT NULL

user_mail (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • deadline (Field2) — datetime
  • coin (Field3) — int
  • gem_f (Field4) — int
  • gem_c (Field5) — int
  • stamina (Field6) — int
  • update_time (Field7) — datetime
  • user_id (Key2) — int — Foreign key → user.user_id — NOT NULL

vb_log (Untitled13)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → user.user_id — NOT NULL
  • nickname (Field4) — varchar(30)
  • type (Field2) — int
  • n1 (Field5) — vahrchar(128)
  • n2 (Field6) — vahrchar(128)
  • n3 (Field7) — vahrchar(128)
  • n4 (Field8) — vahrchar(128)
  • n5 (Field9) — vahrchar(128)
  • n6 (Field10) — vahrchar(128)
  • n7 (Field11) — vahrchar(128)
  • n8 (Field12) — vahrchar(128)
  • n9 (Field13) — vahrchar(128)
  • n10 (Field14) — vahrchar(128)
  • n11 (Field15) — vahrchar(128)
  • n12 (Field16) — vahrchar(128)
  • n13 (Field17) — vahrchar(128)
  • n14 (Field18) — vahrchar(128)
  • n15 (Field19) — vahrchar(128)
  • log_time (Field3) — datetime