Users

user_idusernameemailpasswordcitycountrycreated_at
1User1email@example.compassword123New YorkUSA2024-02-19 15:04:39
2User2email2@example.compassword321Los AngelesUSA2024-02-19 15:04:39

Subscriptions

subscription_iduser_idplanstart_dateend_date
(→ Users.user_id)
11Basic2022-01-012022-12-31
22Premium2022-01-022022-12-31

Shows

show_idtitlegenredescriptionrelease_yearlanguage
1Show1DramaA drama series about a detective2020English
2Show2ComedyA comedy series about friends2019English

Episodes

episode_idshow_idseasonepisode_numbertitledurationrelease_date
(→ Shows.show_id)
1111Episode 1602022-01-01
2211Episode 1602022-01-02

Ratings

rating_iduser_idshow_idepisode_idstarscomment
(→ Users.user_id)(→ Shows.show_id)(→ Episodes.episode_id)
11115Great Show!
22214Funny but could be better.

RealityShows

reality_show_idnamenetworkhostpremiere_datewinnercitycountry
1RealityShow1Network AHost12022-01-01Winner1City1Country1
2RealityShow2Network BHost22022-01-02Winner2City2Country2