space talk

Tables (6)

Celestial Body (천체(채팅 방))

  • id — int — Primary key — NOT NULL — Unique
  • 항성계 ID (stellarSystemId) — int — Foreign key → Stellar Sytem.id — NOT NULL
  • 이름 (name) — varchar(30) — NOT NULL
  • 타입 (type) — varchar(30) — NOT NULL — 행성, 항성
  • 항성 타입 (starType) — varchar(30) — 적색 거성, 초신성 ...
  • 질량 (mass) — int — NOT NULL
  • 광도 (luminosity) — int — NOT NULL
  • 크기 (size) — int — NOT NULL
  • 자전 주기 (rotationPeriod) — int — NOT NULL
  • 공전 주기 (orbitalPeriod)

ChatMember (채팅방 멤버)

  • 유저 ID (userId) — int — Foreign key → User.id — NOT NULL
  • 천체 ID (CelestialBodyId) — int — Foreign key → Celestial Body.id — NOT NULL — Unique
  • 항성계 ID (stellarSystemId) — int — Foreign key → Celestial Body.항성계 ID — NOT NULL

ChatMessage (메시지)

  • id — int — Primary key — NOT NULL
  • 유저 ID (userId) — int — Foreign key → ChatMember.유저 ID — NOT NULL
  • 천체 ID (CelestialBodyId) — int — Foreign key → ChatMember.천체 ID — NOT NULL — Unique
  • 항성계 ID (stellarSystemId) — int — Foreign key → ChatMember.항성계 ID — NOT NULL
  • content — char(256) — NOT NULL
  • sendAt — timestamp — NOT NULL

Stellar Sytem (항성계)

  • id — int — Primary key — NOT NULL
  • x — float — NOT NULL
  • y — float — NOT NULL
  • z — float — NOT NULL

User

  • id — int — Primary key — NOT NULL
  • pw — varchar(30) — NOT NULL
  • email — varchar(30) — NOT NULL

User Profile

  • id — int — Foreign key → User.id — NOT NULL
  • 이름 (name) — varchar(30) — NOT NULL
  • 소개글 (introduction) — varchar(200)
  • 레벨 (level) — int — NOT NULL