디비과제2

테이블 (13)

CHATROOM

  • chatroom_id — INT — 기본 키 — NOT NULL
  • room_name — VARCHAR(100)

CHATROOM_MEMBER

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

FRIENDSHIP

  • friendship_id — INT — 기본 키 — NOT NULL
  • requester_id — INT — 외래 키 → USER.user_id
  • receiver_id — INT — 외래 키 → USER.user_id
  • status — VARCHAR(100)
  • requested_at — TIMESTAMP

GAME

  • game_id — INT — 기본 키 — NOT NULL
  • title — VARCHAR(100)
  • price — INT
  • publisher — VARCHAR(100)

GAME_GENRE

  • 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(100)

MESSAGE

  • message_id — INT — 기본 키 — NOT NULL
  • chatroom_id — INT — 외래 키 → CHATROOM.chatroom_id
  • user_id — INT — 외래 키 → USER.user_id
  • content — CHAR
  • sent_at — TIMESTAMP

PLAY_HISTORY

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

PURCHASE

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

REVIEW

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

STREAM

  • stream_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → USER.user_id
  • channel_name — VARCHAR(100)
  • category — VARCHAR(100)

STREAM_FOLLOW

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

USER

  • user_id — INT — 기본 키 — NOT NULL
  • username — VARCHAR(100)
  • email — VARCHAR(100)
  • nickname — VARCHAR(100)
  • created_at — TIMESTAMP