| 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 |