artists

idnamegenre
1The BeatlesRock
2Michael JacksonPop
3Lady GagaPop
4Elton JohnClassic Rock
5AdelePop

concerts

idartistIddatecityconcertHall
(→ artists.id)
112023-06-01New YorkMadison Square Garden
222023-07-15Los AngelesStaples Center
332023-08-30ChicagoUnited Center
442023-09-10DallasAmerican Airlines Center
552023-10-01BostonTD Garden

venues

idvenueNamelocationcapacity
1Madison Square GardenNew York20000
2Staples CenterLos Angeles19000
3United CenterChicago23000
4American Airlines CenterDallas19000
5TD GardenBoston19000

tickets

idconcertIdpricequantitytype
(→ concerts.id)
111001000General Admission
21200500VIP
321201000General Admission
42220500VIP
531501000General Admission

users

idusernameemailpasswordHash
1user1user1@example.compasswordhash1
2user2user2@example.compasswordhash2
3user3user3@example.compasswordhash3
4user4user4@example.compasswordhash4
5user5user5@example.compasswordhash5

bookings

iduserIdticketIdbookingDatestatus
(→ users.id)(→ tickets.id)
1112024-02-19 13:13:50Confirmed
2222024-02-19 13:13:50Confirmed
3332024-02-19 13:13:50Confirmed
4442024-02-19 13:13:50Confirmed
5552024-02-19 13:13:50Confirmed