K-STEAM LoginServerDB

테이블 (7)

Untitled (userInfos)

  • uuid — objectId — 외래 키 → 사용자.uuid — NOT NULL
  • Field (firstname) — string — NOT NULL
  • Field (lastname) — string — NOT NULL
  • Field (nickname) — string — NOT NULL
  • Field (lastLoginDate) — datetime — NOT NULL
  • Field (profile) — string

Untitled (avatars)

  • uuid — objectId — 외래 키 → 사용자.uuid — NOT NULL
  • Field (gender) — string — NOT NULL
  • Field (skin) — int — NOT NULL
  • Field (hair) — string
  • Field (hairColor) — string — NOT NULL
  • Field (top) — string
  • Field (bottom) — string
  • Field (shoes) — string
  • Field (acc) — string
  • Field (face) — string

Untitled (friends)

  • uuid — objectId — 외래 키 → 사용자.uuid — NOT NULL
  • Field (friend) — objectId — NOT NULL
  • Field (status) — string — NOT NULL
  • Field (created) — datetime — NOT NULL
  • Key (channel) — string — 외래 키 → Untitled.Key — NOT NULL

Untitled (assetbundles)

  • Key (_id) — objectId — 기본 키 — NOT NULL
  • Field (platform) — string — NOT NULL
  • Field (name) — string — NOT NULL
  • Field (version) — int — NOT NULL
  • Field (filePath) — string — NOT NULL
  • Field (crc) — string — NOT NULL
  • Field (assetNames) — array — NOT NULL
  • Field (latest) — boolean — NOT NULL
  • Field (created) — datetime — NOT NULL
  • Field

Untitled (messages)

  • Key (channel) — string — 기본 키 — NOT NULL
  • Field (count) — int — NOT NULL
  • Field (members) — array — NOT NULL
  • Field (messages) — array
  • Field (reads) — array — NOT NULL

Untitled (versions)

  • Key (_id) — objectId — 기본 키 — NOT NULL
  • Field (platform) — string — NOT NULL
  • Field (version) — string — NOT NULL
  • Field (latest) — boolean — NOT NULL
  • Field

사용자 (users)

  • uuid — objectId — 기본 키 — NOT NULL
  • Field (email) — string — NOT NULL
  • Field2 (password) — string — NOT NULL
  • Field3 (verify) — boolean — NOT NULL
  • Field4 (verifyString) — string
  • Field5 (signupComplete) — boolean — NOT NULL
  • Field6 (created) — datetime — NOT NULL
  • Field7 (playing) — boolean — NOT NULL