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