실습2

테이블 (13)

CHATROOM

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

CHATROOM_MEMBER

  • member_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → USER.user_id
  • chatroom_id — int — 외래 키 → CHATROOM.chatroom_id
  • last_read_at — datetime
  • Field

FRIENDSHIP

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

GAME

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

GAME_GENRE

  • game_id — int — 외래 키 → GAME.game_id — NOT NULL
  • genre_id — int — 외래 키 → GENRE.genre_id — NOT NULL
  • Field

GENRE

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

MESSAGE

  • message_id — int — 기본 키 — NOT NULL
  • chatroom_id — int — 외래 키 → CHATROOM.chatroom_id
  • user_id — int — 외래 키 → USER.user_id
  • content — varchar
  • sent_at — datetime

PLAY_HISTORY

  • history_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → USER.user_id
  • game_id — int — 외래 키 → GAME.game_id
  • start_time — datetime
  • end_time — datetime
  • play_time — int
  • Field

PURCHASE

  • purchase_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → USER.user_id
  • game_id — int — 외래 키 → GAME.game_id
  • purchase_date — datetime
  • purchase_price — int
  • Field

REVIEW

  • review_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → USER.user_id
  • game_id — int — 외래 키 → GAME.game_id
  • content — varchar
  • rating — int
  • Field

STREAM

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

STREAM_FOLLOW

  • follow_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → USER.user_id
  • stream_id — int — 외래 키 → STREAM.stream_id
  • followed_at — datetime
  • Field

USER

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