test3

Tables (13)

STREAM

  • Key (stream_id) — int — Primary key — NOT NULL
  • Field (channel_name) — varchar
  • Field (category) — varchar
  • user_id — int — Foreign key → USER.user_id — NOT NULL

USER

  • user_id — int — Primary key — NOT NULL
  • user_name — varchar
  • email — varchar
  • nickname — varchar
  • created_at

Untitled (GAME)

  • Key (game_id) — int — Primary key — NOT NULL
  • Field (title) — varchar
  • Field (price) — int
  • Field (publisher) — varchar

Untitled (GENRE)

  • Key (genre_id) — int — Primary key — NOT NULL
  • Field (genre_name) — varchar

Untitled (CHATROOM)

  • Key (chatroom_id) — int — Primary key — NOT NULL
  • Field (room_name) — varchar

Untitled (REVIEW)

  • Key (review_id) — int — Primary key — NOT NULL
  • Field (content) — varchar
  • Field (rating) — varchar
  • user_id — int — Foreign key → USER.user_id — NOT NULL
  • Key (game_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (MESSAGE)

  • Key (message_id) — int — Primary key — NOT NULL
  • Key (chatroom_id) — int — Foreign key → Untitled.Key — NOT NULL
  • user_id — int — Foreign key → USER.user_id — NOT NULL
  • Field (content) — varchar
  • Field (sent_at) — varchar

Untitled (PURCHASE)

  • Key (purchase_id) — int — Primary key — NOT NULL
  • Field (purchase_date) — varchar
  • Field (purchase_price) — int
  • user_id — int — Foreign key → USER.user_id — NOT NULL
  • Key (game_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (PLAY_HISTORY)

  • Key (history_id) — int — Primary key — NOT NULL
  • Field (start_time) — char
  • Field (end_time) — char
  • Field (play_time) — int
  • user_id — int — Foreign key → USER.user_id — NOT NULL
  • Key (game_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (GAME_GENRE)

  • Key (game_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (genre_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (CHATROOM_MEMBER)

  • Key (member_id) — int — Primary key — NOT NULL
  • Field (last_read_at) — char
  • user_id — int — Foreign key → USER.user_id — NOT NULL
  • Key (chatroom_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (STREAM_FOLLOW)

  • Key (follow_id) — int — Primary key — NOT NULL
  • Field (followed_at) — char
  • user_id — int — Foreign key → USER.user_id — NOT NULL
  • Key (stream_id) — int — Foreign key → STREAM.Key — NOT NULL

Untitled (FRIENDSHIP)

  • Key (friendship_id) — int — Primary key — NOT NULL
  • Field (status) — char
  • Field (requested_at) — char