id | show_title | show_type | performer_id |
---|---|---|---|
(→ genres.genre_name) | (→ performers.id) | ||
1 | Stand-Up Comedy Show | Comedy | 1 |
2 | Stand-Up Comedy Show | Comedy | 2 |
3 | Sketch Comedy Show | Comedy | 1 |
4 | Sketch Comedy Show | Comedy | 2 |
id | episode_number | release_date | show_id |
---|---|---|---|
(→ shows.id) | |||
1 | 1 | 2022-01-01 | 1 |
2 | 2 | 2022-01-08 | 1 |
3 | 1 | 2022-01-15 | 2 |
4 | 2 | 2022-01-22 | 2 |
id | season_number | start_date | end_date | show_id |
---|---|---|---|---|
(→ shows.id) | ||||
1 | 1 | 2021-12-01 | 2022-03-31 | 1 |
2 | 1 | 2021-12-01 | 2022-03-31 | 2 |
3 | 1 | 2022-04-01 | 2023-06-30 | 3 |
4 | 1 | 2022-04-01 | 2023-06-30 | 4 |
id | rating_value | review_text | user_id | show_id |
---|---|---|---|---|
(→ users.id) | (→ shows.id) | |||
1 | 5 | Great comedy! | 1 | 1 |
2 | 4 | Funny but could have been better. | 2 | 1 |
3 | 3 | Not my favorite type of humor. | 1 | 3 |
4 | 4 | Really enjoyed this sketch! | 2 | 4 |
5 | 5 | Laughed so much! Highly recommend. | 1 | 2 |
id | name | birth_date |
---|---|---|
1 | Chris Lee | 2003-06-15 |
2 | Jane Doe | 1987-10-02 |
id | username | password | |
---|---|---|---|
1 | UserOne | userone@example.com | password1 |
2 | UserTwo | usertwo@example.com | password2 |