user_db
Tables (3)
user (계정)
- playerId (Key) — INT — Primary key — NOT NULL
- nickname (Field) — VARCHAR(36)
- password (Field2) — VARCHAR(255)
- coin (Field3) — INT
- finalCheck (Field4) — BOOL
- last_login (Field5) — TIMESTAMP
- created_at (Field6) — TIMESTAMP
user_character (사용자 캐릭터 데이터)
- uuid (Key) — VARCHAR(36) — Primary key — NOT NULL
- playerId (Key2) — INT — Foreign key → user.playerId — NOT NULL
- character_class (Field) — INT
- level (Field2) — INT
- soul (Field3) — INT
user_unlock_characters (해금 캐릭터 목록)
- id (Key) — INT — Primary key — NOT NULL
- playerId (Key2) — INT — Foreign key → user.playerId — NOT NULL
- cerbe (Field) — BOOL
- uni (Field2) — BOOL
- nix (Field3) — BOOL
- chad (Field4) — BOOL
- miho (Field5) — BOOL
- levi (Field6) — BOOL
- wyv (Field7) — BOOL
- drago (Field8) — BOOL
- kiri (Field9) — BOOL