genre_id | name |
---|---|
1 | Jazz |
2 | Rock |
id | title | release_date | artist_id |
---|---|---|---|
(→ Artists.id) | |||
1 | Jazz Collection | 2022-01-01 | 1 |
2 | Classical Jazz | 2022-07-01 | 2 |
3 | Guitar Masterpieces | 2022-06-01 | 3 |
4 | Acoustic Rock | 2022-08-01 | 4 |
id | title | length | album_id |
---|---|---|---|
(→ Albums.id) | |||
1 | Cool Blues | 3.5 | 1 |
2 | Elegant Waltz | 4.2 | 2 |
3 | Fast Riff | 3.0 | 3 |
4 | Slow Ballad | 4.7 | 4 |
artist_id | genre_id | years_in_industry |
---|---|---|
(→ Artists.id) | (→ Genres.genre_id) | |
1 | 1 | 10 |
2 | 1 | 20 |
3 | 2 | 10 |
4 | 2 | 30 |
id | name |
---|---|
1 | John Doe |
2 | Jane Smith |
3 | Tom Brown |
4 | Emily Davis |