final_music_streaming
Tables (11)
ALBUM
- album_id — INT
- title — VARCHAR(100) — NOT NULL
- release_date — DATE
- artist_id — INT
- cover_url — VARCHAR(255)
ARTIST
- artist_id — INT
- name — VARCHAR(100) — NOT NULL
- bio — TEXT
- image_url — VARCHAR(255)
FOLLOW_ARTIST
- user_id — INT
- artist_id — INT
- followed_at — TIMESTAMP
LIKE_SONG
- user_id — INT
- song_id — INT
- liked_at — TIMESTAMP
LISTEN_HISTORY
- history_id — INT
- user_id — INT
- song_id — INT
- listened_at — TIMESTAMP
LYRICS
- song_id — INT
- content — TEXT
PLAYLIST
- playlist_id — INT
- title — VARCHAR(100)
- user_id — INT
- created_at — TIMESTAMP
PLAYLIST_SONG
- playlist_id — INT
- song_id — INT
- order_num — INT
SONG
- song_id — INT
- title — VARCHAR(100) — NOT NULL
- duration — INT
- genre — VARCHAR(50)
- album_id — INT
- artist_id — INT
SUBSCRIPTION
- user_id — INT
- is_active — BOOLEAN
- start_date — DATE
- end_date — DATE
- payment_method — VARCHAR(50)
USER
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- birthdate — DATE
- gender — VARCHAR(10)
- created_at — TIMESTAMP