Music

idtitleartistreleaseDateMusic_GenreVenue
1Some Pop SongSome Artist2021-08-30Pop SongMadison Square Garden
2Another Pop SongAnother Artist2021-09-01Pop SongDifferent Venue
3Some Hip Hop SongSome Rapper2021-07-26Hip Hop SongMadison Square Garden
4Yet Another Hip Hop SongAnother Rapper2021-07-28Hip Hop SongDifferent Venue

Artists

idnamegenrecountry
1First ArtistRockUSA
2Second ArtistElectronicUK

Concerts

iddatevenueNamelocationticketPrice
12021-08-30 20:00:00MSGNew York City100.0
22021-09-01 20:00:00Different VenueLos Angeles80.0

Tickets

idconcertIdseatNumberprice
(→ Concerts.id)
11A1100.0
22B180.0

Reviews

idconcertIdreviewerNameratingcomments
(→ Concerts.id)
11John Doe5Great show!
22Jane Smith4Good performance.

Fans

idfanNamefavoriteArtistIdfavoriteConcertId
(→ Artists.id)(→ Concerts.id)
1Mike Johnson11
2Emily Davis22