artists
id | name | genre |
1 | The Beatles | Rock |
2 | Michael Jackson | Pop |
3 | Lady Gaga | Pop |
4 | Elton John | Classic Rock |
5 | Adele | Pop |
concerts
id | artistId | date | city | concertHall |
| (→ artists.id) | | | |
1 | 1 | 2023-06-01 | New York | Madison Square Garden |
2 | 2 | 2023-07-15 | Los Angeles | Staples Center |
3 | 3 | 2023-08-30 | Chicago | United Center |
4 | 4 | 2023-09-10 | Dallas | American Airlines Center |
5 | 5 | 2023-10-01 | Boston | TD Garden |
venues
id | venueName | location | capacity |
1 | Madison Square Garden | New York | 20000 |
2 | Staples Center | Los Angeles | 19000 |
3 | United Center | Chicago | 23000 |
4 | American Airlines Center | Dallas | 19000 |
5 | TD Garden | Boston | 19000 |
tickets
id | concertId | price | quantity | type |
| (→ concerts.id) | | | |
1 | 1 | 100 | 1000 | General Admission |
2 | 1 | 200 | 500 | VIP |
3 | 2 | 120 | 1000 | General Admission |
4 | 2 | 220 | 500 | VIP |
5 | 3 | 150 | 1000 | General Admission |
users
id | username | email | passwordHash |
1 | user1 | user1@example.com | passwordhash1 |
2 | user2 | user2@example.com | passwordhash2 |
3 | user3 | user3@example.com | passwordhash3 |
4 | user4 | user4@example.com | passwordhash4 |
5 | user5 | user5@example.com | passwordhash5 |
bookings
id | userId | ticketId | bookingDate | status |
| (→ users.id) | (→ tickets.id) | | |
1 | 1 | 1 | 2024-02-19 13:13:50 | Confirmed |
2 | 2 | 2 | 2024-02-19 13:13:50 | Confirmed |
3 | 3 | 3 | 2024-02-19 13:13:50 | Confirmed |
4 | 4 | 4 | 2024-02-19 13:13:50 | Confirmed |
5 | 5 | 5 | 2024-02-19 13:13:50 | Confirmed |