## PERFORMERS

ID | NAME | AGE | GENRE | STREET_PERFORMER | STREET_LOCATION
--- | --- | --- | --- | --- | ---
1 | David Blaine | 49 | Magic | 1 | Times Square, New York
2 | Dynamo | 38 | Magic | 0 | Piccadilly Circus, London
3 | Marco Tempest | 52 | Magic | 1 | Las Vegas Strip, Las Vegas
4 | Julius Dein | 27 | Magic | 1 | Leicester Square, London
5 | Antonin Decouflé | 60 | Mime | 1 | Times Square, New York
6 | Jean-Baptiste Thoret | 35 | Mime | 0 | La Defense, Paris

## SHOWS

ID | TITLE | DURATION
--- | --- | ---
1 | The Magic Show | 90.0
2 | Mystery Spectacular | 120.0
3 | Dynamo Live | 105.0
4 | Illusionists | 110.0
5 | Deception | 95.0

## VENUES

ID | NAME | LOCATION
--- | --- | ---
1 | Broadway Theatre | New York City
2 | Royal Variety Performance | London
3 | Palazzo del Cinema | Venice
4 | Madison Square Garden | New York City
5 | Wynn Las Vegas | Las Vegas

## SHOW_VENUE_MAPPINGS

SHOW_ID | VENUE_ID
--- | ---
(→ SHOWS.ID) | (→ VENUES.ID)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## PERFORMER_SHOW

PERFORMER_ID | SHOW_ID
--- | ---
(→ PERFORMERS.ID) | (→ SHOWS.ID)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5