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