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