방송

테이블 (13)

chatroom

  • chatroom_id — int — 기본 키 — NOT NULL
  • room_name — varchar — NOT NULL

chatroom_member

  • member_id — int — 기본 키 — NOT NULL
  • last_read_at — datetime
  • user_id — int — 외래 키 → users.user_id — NOT NULL
  • chatroom_id — int — 외래 키 → chatroom.chatroom_id — NOT NULL

friendship

  • friendship_id — int — 기본 키 — NOT NULL
  • status — varchar — NOT NULL
  • requested_at — datetime — NOT NULL
  • requester_id — int — 외래 키 → users.user_id — NOT NULL
  • receiver_id — int — 외래 키 → users.user_id — NOT NULL

game

  • game_id — int — 기본 키 — NOT NULL
  • title — varchar — NOT NULL
  • price — int — NOT NULL
  • publisher — varchar — NOT NULL

game_genre

  • game_genre_id — int — 기본 키 — NOT NULL
  • game_id — int — 외래 키 → game.game_id — NOT NULL
  • genre_id — int — 외래 키 → genre.genre_id — NOT NULL

genre

  • genre_id — int — 기본 키 — NOT NULL
  • genre_name — varchar — NOT NULL

message

  • message_id — int — 기본 키 — NOT NULL
  • content — text — NOT NULL
  • sent_at — datetime — NOT NULL
  • chatroom_id — int — 외래 키 → chatroom.chatroom_id — NOT NULL
  • user_id — int — 외래 키 → users.user_id — NOT NULL

play_history

  • history_id — int — 기본 키 — NOT NULL
  • start_time — datetime — NOT NULL
  • end_time — datetime
  • play_time — int — NOT NULL
  • user_id — int — 외래 키 → users.user_id — NOT NULL
  • game_id — int — 외래 키 → game.game_id — NOT NULL

purchase

  • purchase_id — int — 기본 키 — NOT NULL
  • purchase_date — datetime — NOT NULL
  • purchase_price — int — NOT NULL
  • user_id — int — 외래 키 → users.user_id — NOT NULL
  • game_id — int — 외래 키 → game.game_id — NOT NULL

review

  • review_id — int — 기본 키 — NOT NULL
  • content — text
  • rating — int — NOT NULL
  • user_id — int — 외래 키 → users.user_id — NOT NULL
  • game_id — int — 외래 키 → game.game_id — NOT NULL
  • purchase_id — int — 외래 키 → purchase.purchase_id — NOT NULL

stream

  • stream_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → users.user_id — NOT NULL
  • channel_name — varchar — NOT NULL
  • category — varchar — NOT NULL

stream_follow

  • follow_id — int — 기본 키 — NOT NULL
  • followed_at — datetime — NOT NULL
  • user_id — int — 외래 키 → users.user_id — NOT NULL
  • stream_id — int — 외래 키 → stream.stream_id — NOT NULL

users

  • user_id — int — 기본 키 — NOT NULL
  • username — varchar — NOT NULL
  • email — varchar — NOT NULL
  • nickname — varchar — NOT NULL
  • created_at — datetime — NOT NULL