Webapp
Tables (5)
COMMENT
- comment_id — INT
- playlist_id — INT — Foreign key → PLAYLIST.playlist_id — NOT NULL
- user_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
LIKE_LIST
- like_id — INT
- playlist_id — INT — Foreign key → PLAYLIST.playlist_id — NOT NULL
- user_id — INT — NOT NULL
- created_at — DATETIME
PLAYLIST
- playlist_id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- genre — VARCHAR(50)
- created_at — DATETIME
PLAYLIST_SONG
- playlist_song_id — INT
- playlist_id — INT — Foreign key → PLAYLIST.playlist_id — NOT NULL
- song_id — INT — Foreign key → SONG.song_id — NOT NULL
SONG
- song_id — INT
- title — VARCHAR(100) — NOT NULL
- artist — VARCHAR(100) — NOT NULL
- album — VARCHAR(100)
- genre — VARCHAR(50)