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 |