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