실습2

테이블 (12)

CHATROOM

  • chatroom_id — 기본 키 — NOT NULL — PK
  • room_name

CHATROOM_MEMBER

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

FRIENDSHIP

  • friendship_id — 기본 키 — NOT NULL — PK
  • Field
  • requester_id — PK — 외래 키 → USER.user_id — NOT NULL — PK
  • receiver_id — PK — 외래 키 → USER.user_id — NOT NULL — PK

GAME

  • game_id — 기본 키 — NOT NULL — PK
  • title
  • price
  • publisher

GAME_GENRE

  • game_id — 외래 키 → GAME.game_id — NOT NULL — PK, FK
  • genre_id — 외래 키 → GENRE.genre_id — NOT NULL — PK, FK

GENRE

  • genre_id — 기본 키 — NOT NULL — PK
  • genre_name

PLAY_HISTORY

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

PURCHASE

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

REVIEW

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

STREAM

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

STREAM_FOLLOW

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

USER

  • user_id — PK — 기본 키 — NOT NULL — PK
  • username
  • email
  • nickname
  • created_at