id | studio_name | address | podcast | genre | rating |
---|---|---|---|---|---|
1 | Studio A | 123 Main St. | Podcast XYZ | Comedy | 4.8 |
2 | Studio B | 456 Elm Rd. | Podcast ABC | Drama | 4.7 |
plan_id | plan_name | monthly_price | annual_price | features |
---|---|---|---|---|
1 | Basic Plan | 9.99 | 99.0 | Access to all shows |
2 | Premium Plan | 14.99 | 149.0 | Ad-free experience |
content_id | title | description | duration | release_date | category |
---|---|---|---|---|---|
1 | Movie A | A thrilling action movie | 120 | 2022-01-01 | Action |
2 | TV Show B | An exciting crime drama series | 480 | 2021-10-01 | Crime Drama |
customer_id | first_name | last_name | password | subscription_plan_id | |
---|---|---|---|---|---|
(→ SubscriptionPlan.plan_id) | |||||
1 | John | Doe | john@example.com | password123 | 1 |
2 | Jane | Smith | jane@example.com | passwordabc | 2 |
history_id | customer_id | content_id | play_date |
---|---|---|---|
(→ Customer.customer_id) | (→ ContentLibrary.content_id) | ||
1 | 1 | 1 | 2022-01-02 12:00:00 |
2 | 2 | 2 | 2022-01-03 15:30:00 |