## Circles

id | name
--- | ---
1 | The Red Nose Circus
2 | The Magic Show
3 | Acrobatics Extravaganza

## Performers

id | type
--- | ---
1 | Clown
2 | Magician
3 | Juggler
4 | Singer
5 | Dancer

## Shows

id | title | start_date | end_date
--- | --- | --- | ---
1 | Opening Night | 2023-01-01 | 2023-01-31
2 | Midweek Matinee | 2023-02-15 | 2023-02-19
3 | End Of Season Party | 2023-03-30 | 2023-03-31

## Venues

id | name
--- | ---
1 | City Hall Auditorium
2 | Big Top Tent
3 | Riverfront Amphitheater

## ShowVenues

show_id | venue_id | date
--- | --- | ---
(→ Shows.id) | (→ Venues.id) |
1 | 1 | 2023-01-01
2 | 2 | 2023-02-16
3 | 3 | 2023-03-30

## CircleShows

circle_id | show_id
--- | ---
(→ Circles.id) | (→ Shows.id)
1 | 1
1 | 2
2 | 1
2 | 2
3 | 3

## CirclePerformers

circle_id | performer_id
--- | ---
(→ Circles.id) | (→ Performers.id)
1 | 1
1 | 2
2 | 1
2 | 3
None | 5
3 | 1