과제2

테이블 (25)

CHATROOM

  • chatroom_id — int — 기본 키 — NOT NULL
  • room_name — varchar(100)

CHATROOM (Untitled5)

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

CHATROOM_MEMBER

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

CHATROOM_MEMBER' (Untitled11)

  • Key — 기본 키 — NOT NULL
  • Field

FRIENDSHIP

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

FRIENDSHIP (Untitled13)

  • Key — 기본 키 — NOT NULL
  • Field

GAME (Untitled3)

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

GAME

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

GAME_GENRE (Untitled9)

  • Key — 기본 키 — NOT NULL
  • Field

GAME_GENRE

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

GENRE (Untitled4)

  • genre_id (Key) — VARCHAR(100) — 기본 키 — NOT NULL
  • genre_name (Field) — VARCHAR(100)

GENRE

  • genre_id — int — 기본 키 — NOT NULL
  • genre_name — varchar(100)

MESSAGE (Untitled7)

  • Key — 기본 키 — NOT NULL
  • Field

MESSAGE

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

PLAY_HISTORY (Untitled10)

  • Key — 기본 키 — NOT NULL
  • Field

PLAY_HISTORY

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

PURCHASE (Untitled8)

  • Key — 기본 키 — NOT NULL
  • Field

PURCHASE

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

REVIEW

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

STREAM (Untitled2)

  • stream_id (Key) — varchar(100) — 기본 키 — NOT NULL
  • user_id (Key2) — VARCHAR(100) — 외래 키 → USER.user_id — NOT NULL
  • game_id (Key3) — VARCHAR(100) — 외래 키 → GAME.game_id — NOT NULL
  • review_id (Key22) — VARCHAR(100) — 외래 키 — NOT NULL
  • user_id (Key222) — VARCHAR(100) — 외래 키 — NOT NULL
  • chatroom_id (Key32) — VARCHAR(100) — 외래 키 — NOT NULL
  • user_id (Field) — VARCHAR(100)
  • channel_name (Field2) — VARCHAR(100)
  • category (Field3) — VARCHAR(100)

STREAM

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

STREAM_FOLLOW (Untitled12)

  • Key — 기본 키 — NOT NULL
  • Field

STREAM_FOLLOW

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

USER

  • user_id — int — 기본 키 — NOT NULL
  • username — varchar(100)
  • email — varchar(100)
  • nickname — varchar(100)
  • created_at — date

USER (Untitled)

  • user_id (Key) — VARCHAR(100) — 기본 키 — NOT NULL
  • username (Field2) — VARCHAR(100)
  • email (Field3) — VARCHAR(100)
  • nickname (Field4) — VARCHAR(100)
  • created_at (Field5) — INT