These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Podcast Management
- Data model and import order
The tables behind Podcast Management
Podcast Management ships with 10 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 10
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Projects and schedules:
Projects, People, production tasks and project costs tie ownership, work and spending to a production cycle.
Content and revisions:
Content items and content files keep the editorial lifecycle and current attachment together.
Episodes:
Episodes connect series, audio and publish timing to content items.
Rights agreements:
Rights agreements attach permitted uses and contract dates to content items.
Distribution receipts:
Distribution receipts carry platform evidence for Episodes.
Every table, by feature
- Projects and schedules5
- Content and revisions4
- Episodes3
- Rights agreements3
- Production work and costs4
- Distribution receipts3
- Shared and settings1
- Projects
Podcast production projects with owner, schedule, budget and lifecycle status.
Linked to People - People
Staff and contributors involved in podcast production and distribution. The User link resolves to the authenticated platform user.
Linked to Users - Production tasks
Assigned production work items belonging to a project.
Linked to Projects, People - Project costs
Cost entries captured against a production project.
Linked to Projects - Content items
Individual pieces of content produced within a project, from draft through publication.
Linked to Projects, People
- Content items
Individual pieces of content produced within a project, from draft through publication.
Linked to Projects, People - Content files
Versioned files attached to a content item, each requiring its own review and approval.
Linked to Content items, People - People
Staff and contributors involved in podcast production and distribution. The User link resolves to the authenticated platform user.
Linked to Users - Rights agreements
Rights and permitted uses agreed with a party for a specific content item.
Linked to Content items
- Episodes
Podcast episodes linked to their operational content record, with series, episode number, audio and publish schedule.
Linked to Content items - Content items
Individual pieces of content produced within a project, from draft through publication.
Linked to Projects, People - Distribution receipts
Per-platform distribution evidence captured for a published episode.
Linked to Episodes
- Rights agreements
Rights and permitted uses agreed with a party for a specific content item.
Linked to Content items - Content items
Individual pieces of content produced within a project, from draft through publication.
Linked to Projects, People - Content files
Versioned files attached to a content item, each requiring its own review and approval.
Linked to Content items, People
- Production tasks
Assigned production work items belonging to a project.
Linked to Projects, People - Project costs
Cost entries captured against a production project.
Linked to Projects - Projects
Podcast production projects with owner, schedule, budget and lifecycle status.
Linked to People - People
Staff and contributors involved in podcast production and distribution. The User link resolves to the authenticated platform user.
Linked to Users
- Distribution receipts
Per-platform distribution evidence captured for a published episode.
Linked to Episodes - Episodes
Podcast episodes linked to their operational content record, with series, episode number, audio and publish schedule.
Linked to Content items - Content items
Individual pieces of content produced within a project, from draft through publication.
Linked to Projects, People
Keys and references
Keep stable identifiers for projects, content items, episodes and platform receipts. Import each child after its parent so references resolve. People link to authenticated Users. Match platform receipts by platform and external identifier, then check the linked episode. Do not collapse a content approval, episode schedule and receipt confirmation into one status.
Migration order
- Load Users and People, then Projects with owners, schedules and budgets.
- Load content items, production tasks and project costs against their projects.
- Load rights agreements and content files against the intended content items.
- Load Episodes with their linked operational content record and audio.
- Load distribution receipts against Episodes; reconcile external identifiers and confirmation dates before publication review.
Set up Podcast Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.