Circles

idname
1The Red Nose Circus
2The Magic Show
3Acrobatics Extravaganza

Performers

idtype
1Clown
2Magician
3Juggler
4Singer
5Dancer

Shows

idtitlestart_dateend_date
1Opening Night2023-01-012023-01-31
2Midweek Matinee2023-02-152023-02-19
3End Of Season Party2023-03-302023-03-31

Venues

idname
1City Hall Auditorium
2Big Top Tent
3Riverfront Amphitheater

ShowVenues

show_idvenue_iddate
(→ Shows.id)(→ Venues.id)
112023-01-01
222023-02-16
332023-03-30

CircleShows

circle_idshow_id
(→ Circles.id)(→ Shows.id)
11
12
21
22
33

CirclePerformers

circle_idperformer_id
(→ Circles.id)(→ Performers.id)
11
12
21
23
None5
31