Episode
id | Podcast_id | Episode_Number | Release_Date | Length |
| (→ Podcast.id) | | | |
1 | 1 | 1 | 2021-07-01 | 60 |
2 | 1 | 2 | 2021-07-08 | 60 |
3 | 2 | 1 | 2021-07-15 | 30 |
4 | 3 | 1 | 2021-07-01 | 45 |
5 | 4 | 1 | 2020-07-01 | 35 |
Category
id | Name |
1 | Entertainment |
2 | Technology |
3 | Food & Cooking |
4 | Health & Fitness |
5 | News |
Podcast_Category
Podcast_id | Category_id |
(→ Podcast.id) | (→ Category.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
Subscriber
id | Email | Password | Joined_Date |
1 | john@example.com | password123 | 2021-06-01 |
2 | alice@example.com | secret456 | 2021-06-15 |
3 | bob@example.com | abc789 | 2021-07-01 |
4 | charlie@example.com | xyz123 | 2021-07-15 |
5 | diana@example.com | mno456 | 2021-08-01 |
Subscription
Subscriber_id | Podcast_id | Start_Date | End_Date |
(→ Subscriber.id) | (→ Podcast.id) | | |
1 | 1 | 2021-07-01 | 2021-08-01 |
1 | 2 | 2021-07-01 | 2021-08-01 |
2 | 3 | 2021-07-15 | 2021-08-15 |
3 | 4 | 2021-07-01 | 2021-08-01 |
4 | 5 | 2021-07-15 | 2021-08-15 |
Podcast
id | Debut_Date | Title | Hosts | Duration |
1 | Monday | The Morning Show | Jane Doe and John Smith | 60 |
2 | Tuesday | Technology Today | Alice Johnson | 30 |
3 | Wednesday | Cooking with Chef Mike | Mike Brown | 45 |
4 | Thursday | Health Matters | Dr. Lisa Wilson | 35 |
5 | Friday | News Roundup | Tom Harris | 60 |