ArtistID | Name | Genre |
---|---|---|
1 | The Beatles | Rock |
2 | Michael Jackson | Pop |
3 | Adele | Pop |
AlbumID | Title | ReleaseYear | ArtistID |
---|---|---|---|
(→ Artists.ArtistID) | |||
1 | Abbey Road | 1969 | 1 |
2 | Thriller | 1982 | 2 |
3 | 21 | 2011 | 3 |
ConcertID | Date | City | Country | VenueName | HeadlineArtistID |
---|---|---|---|---|---|
(→ Artists.ArtistID) | |||||
1 | 2021-07-15 20:00:00 | London | UK | Wembley Stadium | 2 |
2 | 2021-08-01 20:00:00 | New York | USA | MetLife Stadium | 1 |
3 | 2021-09-10 20:00:00 | Paris | France | Stade de France | 3 |
TicketID | PurchaseDate | SeatNumber | CustomerID | ConcertID | Price |
---|---|---|---|---|---|
(→ Customers.CustomerID) | (→ Concerts.ConcertID) | ||||
1 | 2021-07-15 12:00:00 | Section A, Row 1, Seat 10 | 1 | 1 | 100 |
2 | 2021-07-15 12:00:00 | Section B, Row 1, Seat 10 | 2 | 1 | 75 |
3 | 2021-08-01 12:00:00 | Section C, Row 1, Seat 10 | 3 | 2 | 150 |
4 | 2021-08-01 12:00:00 | Section D, Row 1, Seat 10 | 4 | 2 | 100 |
CustomerID | FirstName | LastName | PhoneNumber | AddressLine | PostalCode | |
---|---|---|---|---|---|---|
1 | John | Doe | johndoe@example.com | +1234567890 | 123 Main St | 60601 |
2 | Jane | Smith | janesmith@example.com | +9876543210 | 456 Elm St | 90001 |
3 | Emily | Williams | emilywilliams@example.com | +1357924680 | 789 Oak St | 02110 |
4 | Peter | Jackson | pjackson@example.com | +19876543210 | 123 Maple Ave | 19101 |