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