mobvsjient_Eng

Tables (8)

Character Basic Data (charactertable)

  • Primary Key (seq) — INT — Primary key — NOT NULL
  • User ID (Owner) — INT — Foreign key → Character Table.User Id — NOT NULL — Auto Incremental
  • Character ID (id) — INT — Foreign key → Character Table.Primary Key — NOT NULL
  • Character Type (type) — INT
  • Character Rank (parent) — INT
  • Cost (cost) — INT

Character Table (characterdata)

  • Primary Key (id) — INT — Primary key — NOT NULL
  • User Id (Owner) — INT — Foreign key → User Table.Primary Key — NOT NULL — Auto Incremental
  • Character ID (CharacterId) — INT
  • Character Experience (Exp) — INT
  • Character Creation Time (CreateTime) — DATETIME
  • Character Skin (Skin) — INT

Purchase Log (purchaserequestlog)

  • Primary Key (seq) — INT — Primary key — NOT NULL
  • User ID (Owner) — INT — Foreign key → User Purchase Data.User ID — NOT NULL — Auto Incremental
  • Purchase Receipt Number (Receipt) — INT
  • Purchase Attempt Count (Tryout) — INT
  • CreateTime — DATETIME

User Flags Data (flagsdata)

  • Primary Key (seq) — INT — Primary key — NOT NULL
  • User ID (Owner) — INT — Foreign key → User Table.Primary Key — NOT NULL — Auto Incremental
  • Flag ID (Id) — INT
  • Acquired At (CreateTime) — DATETIME

User Item Purchase Data (shopdata)

  • Primary Key (seq) — INT — Primary key — NOT NULL
  • User ID (Owner) — INT — Foreign key → User Table.Primary Key — NOT NULL — Auto Incremental
  • Item 1 (shopitem1) — INT
  • Item 2 (shopitem2) — INT
  • Item 3 (shopitem3) — INT
  • Item Update Time (NextUpdateTime) — DATETIME

User Purchase Data (PurchaseToken)

  • Primary Key (id) — INT — Primary key — NOT NULL
  • User ID (Owner) — INT — Foreign key → User Table.Primary Key — NOT NULL — Auto Incremental
  • Product ID (ProductId) — VARCHAR(24)
  • Purchase Token (PurchaseToken) — VARCHAR(200)
  • Purchase Time (PurchaseDate) — DATETIME

User Skin Data (skindata)

  • Primary (id) — INT — Primary key — NOT NULL
  • User ID (Owner) — INT — Foreign key → User Table.Primary Key — NOT NULL — Auto Incremental
  • Skin ID (SkinId) — INT
  • Skin Acquisition Time (CreateTime) — DATETIME

User Table (accountdata)

  • Primary Key (id) — INT — Primary key — NOT NULL — Auto Incremental
  • Account — VARCHAR(90) — NOT NULL
  • Nickname — VARCHAR(64)
  • Region (Country) — VARCHAR(4)
  • SocialId — VARCHAR(64)
  • NoAds — INT
  • Address — VARCHAR(20)
  • Created At (CreateTime) — DATETIME
  • Execution Count (PlayCount) — INT
  • Coin Count (Coin) — INT
  • Gem Count (Gem) — INT
  • Ticket — INT
  • Tocket Usage Time (TicketUpdateTime) — DATETIME
  • Flags — INT
  • Login Authentication Key (SessionKey) — INT
  • Last Session Update Time (SessionUpdateTime) — DATETIME