실습2

테이블 (13)

CHATROOM (Untitled5)

  • chatroom_id (PK) — 기본 키 — NOT NULL
  • room_name (Field)

CHATROOM_MEMBER (Untitled11)

  • member_id (PK) — 기본 키 — NOT NULL
  • user_id (PK2) — 외래 키 → USER.user_id — NOT NULL
  • chatroom_id (PK3) — 외래 키 → CHATROOM.chatroom_id — NOT NULL

FRIENDSHIP (Untitled13)

  • friendship_id (PK) — 기본 키 — NOT NULL
  • requester_id (PK2) — 외래 키 → USER.user_id — NOT NULL
  • receiver_id (PK3) — 외래 키 → USER.user_id — NOT NULL
  • status (Field)
  • requested_at (Field2)

GAME (Untitled3)

  • game_id (PK) — 기본 키 — NOT NULL
  • title (Field)
  • price (Field2)
  • game_id (Field3)

GAME_GENRE (Untitled10)

  • game_id (PK) — 외래 키 → GAME.game_id — NOT NULL
  • genre_id (PK2) — 외래 키 → GENRE.genre_id — NOT NULL

GENRE (Untitled4)

  • genre_id (PK) — 기본 키 — NOT NULL
  • genre_name (Field) — NOT NULL

MESSAGE (Untitled7)

  • message_id (PK) — 기본 키 — NOT NULL
  • chatroom_id (PK2) — 외래 키 → CHATROOM.chatroom_id — NOT NULL
  • user_id (PK3) — 외래 키 → USER.user_id — NOT NULL
  • content (Field)
  • sent_at (Field2)

PLAY_HISTORY (Untitled9)

  • history_id (PK) — 기본 키 — NOT NULL
  • user_id (PK2) — 외래 키 → USER.user_id — NOT NULL
  • game_id (PK3) — 외래 키 → GAME.game_id — NOT NULL
  • start_time (Field)
  • end_time (Field2)
  • play_time (Field3)

PURCHASE (Untitled8)

  • purchase (PK) — 기본 키 — NOT NULL
  • user_id (PK2) — 외래 키 → USER.user_id — NOT NULL
  • game_id (PK3) — 외래 키 → GAME.game_id — NOT NULL
  • purchase_date (Field)
  • purchase_price (Field2)

REVIEW (Untitled6)

  • review_id (PK) — 기본 키 — NOT NULL
  • user_id (FK) — 외래 키 → USER.user_id — NOT NULL
  • game_id (PK2) — 외래 키 → GAME.game_id — NOT NULL
  • content (Field)
  • rating (Field2)

STREAM (Untitled2)

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

STREAM_FOLLOW (Untitled12)

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

USER (Untitled)

  • user_id (PK) — 기본 키 — NOT NULL
  • username (Field)
  • email (Field2)
  • nickname (Field3)
  • created_at (Field4)