Inplayer2
테이블 (5)
chatroom
- message_id — BIGINT — 기본 키 — NOT NULL
- stream_id — BIGINT — 외래 키 → stream.stream_id — NOT NULL
- user_id — BIGINT — 외래 키 → 회원정보.user_id — NOT NULL
- sent_at — TIMESTAMP
- INDEX — idx_stream_chat
notification
- notification_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → 회원정보.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- type — VARCHAR(20) — NOT NULL — SYSTEM/STREAM/CHAT
- is_read — BOOLEAN
- created_at — TIMESTAMP
- INDEX — idx_user_notification
stream
- stream_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → 회원정보.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL — READY/LIVE/ENDED
- started_at — TIMESTAMP
- ended_at — TIMESTAMP
- viewer_count — INT
- thumbnail_url — VARCHAR(255)
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_stream
stream_statistics
- stat_id — BIGINT — 기본 키 — NOT NULL
- stream_id — BIGINT — 외래 키 → stream.stream_id — NOT NULL
- peak_viewers — INT
- total_viewers — INT
- chat_count — INT
- recorded_at — TIMESTAMP
- INDEX — idx_stream_stats
회원정보 (member)
- user_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- profile_image — VARCHAR(255)
- social_provider — VARCHAR(20) — NOT NULL — google/kakao/naver
- social_id — VARCHAR(255) — NOT NULL
- refresh_token — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_active — BOOLEAN