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)