prote

Tables (6)

Untitled (songs)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (title) — NOT NULL
  • Field (artist) — NOT NULL
  • Field (album_image) — NOT NULL
  • Field (category) — NOT NULL
  • Field (like_count) — NOT NULL

Untitled (play_histories)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (user_id) — NOT NULL — Foreign key → users.Key — NOT NULL
  • Key (song_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Field (played_at) — NOT NULL

Untitled (likes)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (user_id) — NOT NULL — Foreign key → users.Key — NOT NULL
  • Key (song_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL

Untitled (user_emotions)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (user_id) — NOT NULL — Foreign key → users.Key — NOT NULL
  • Field (emotion) — NOT NULL
  • Field (search_count) — NOT NULL

Untitled (prefer_songs)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (user_id) — NOT NULL — Foreign key → users.Key — NOT NULL
  • Key (song_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL

users

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (username) — NOT NULL
  • Field (password) — NOT NULL
  • Field (nickname) — NOT NULL
  • Field (profile_image) — NOT NULL
  • Field (email) — NOT NULL
  • Field (role) — NOT NULL