sonus

Tables (6)

Comment (comment)

  • comment_id — Primary key — NOT NULL

Like (like)

  • like_id — Primary key — NOT NULL
  • user_id — Foreign key → User.user_id — NOT NULL
  • music_id — Foreign key → Music.music_id — NOT NULL

Music (music)

  • music_id — Primary key — NOT NULL
  • user_id — Foreign key → User.user_id — NOT NULL
  • music_title (title)
  • music_content (content)
  • albumImgUrl
  • music_plays (plays)

Music_plalist_relation (music_playlist_relation)

  • music_id — Foreign key → Music.music_id — NOT NULL
  • playlist_id (Key) — Foreign key → Playlist.playlist_id — NOT NULL

Playlist (playlist)

  • playlist_id (Key) — Primary key — NOT NULL
  • user_id — Foreign key → User.user_id — NOT NULL

User (user)

  • user_id — Primary key — NOT NULL
  • user_email (email)
  • refresh_token (hashedRefreshToken)