| user_id | username | password | city | country | created_at | |
|---|---|---|---|---|---|---|
| 1 | User1 | email@example.com | password123 | New York | USA | 2024-02-19 15:04:39 |
| 2 | User2 | email2@example.com | password321 | Los Angeles | USA | 2024-02-19 15:04:39 |
| subscription_id | user_id | plan | start_date | end_date |
|---|---|---|---|---|
| (→ Users.user_id) | ||||
| 1 | 1 | Basic | 2022-01-01 | 2022-12-31 |
| 2 | 2 | Premium | 2022-01-02 | 2022-12-31 |
| show_id | title | genre | description | release_year | language |
|---|---|---|---|---|---|
| 1 | Show1 | Drama | A drama series about a detective | 2020 | English |
| 2 | Show2 | Comedy | A comedy series about friends | 2019 | English |
| episode_id | show_id | season | episode_number | title | duration | release_date |
|---|---|---|---|---|---|---|
| (→ Shows.show_id) | ||||||
| 1 | 1 | 1 | 1 | Episode 1 | 60 | 2022-01-01 |
| 2 | 2 | 1 | 1 | Episode 1 | 60 | 2022-01-02 |
| rating_id | user_id | show_id | episode_id | stars | comment |
|---|---|---|---|---|---|
| (→ Users.user_id) | (→ Shows.show_id) | (→ Episodes.episode_id) | |||
| 1 | 1 | 1 | 1 | 5 | Great Show! |
| 2 | 2 | 2 | 1 | 4 | Funny but could be better. |
| reality_show_id | name | network | host | premiere_date | winner | city | country |
|---|---|---|---|---|---|---|---|
| 1 | RealityShow1 | Network A | Host1 | 2022-01-01 | Winner1 | City1 | Country1 |
| 2 | RealityShow2 | Network B | Host2 | 2022-01-02 | Winner2 | City2 | Country2 |