Studio

idstudio_nameaddresspodcastgenrerating
1Studio A123 Main St.Podcast XYZComedy4.8
2Studio B456 Elm Rd.Podcast ABCDrama4.7

SubscriptionPlan

plan_idplan_namemonthly_priceannual_pricefeatures
1Basic Plan9.9999.0Access to all shows
2Premium Plan14.99149.0Ad-free experience

ContentLibrary

content_idtitledescriptiondurationrelease_datecategory
1Movie AA thrilling action movie1202022-01-01Action
2TV Show BAn exciting crime drama series4802021-10-01Crime Drama

Customer

customer_idfirst_namelast_nameemailpasswordsubscription_plan_id
(→ SubscriptionPlan.plan_id)
1JohnDoejohn@example.compassword1231
2JaneSmithjane@example.compasswordabc2

PlayHistory

history_idcustomer_idcontent_idplay_date
(→ Customer.customer_id)(→ ContentLibrary.content_id)
1112022-01-02 12:00:00
2222022-01-03 15:30:00