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.
- Radio Station Management
- Data model
The tables behind Radio Station Management
Radio Station 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
Programming
Broadcast slots stores presenter-led air windows and their lifecycle; People stores the referenced presenter.
Production
Projects owns content items, production tasks and project costs.
Content review
Content files and rights agreements link to the content item under review.
Spot evidence
Ad play logs links a scheduled and played spot to content items.
Access
People connects staff and contributors to Users.
Every table, by feature
- Programming Schedule2
- Content Projects5
- Production Work5
- Content and Versions6
- Rights Clearance5
- Ad Play Evidence4
- Shared and settings1
- Broadcast slots
Scheduled programming slots with presenter, air window and broadcast status.
Linked to People - People
Station staff and contributors referenced by content, production and broadcast work.
Linked to Users
- Projects
Content and programming projects with owner, schedule, budget and lifecycle status.
Linked to People - Content items
Individual pieces of content produced under a project, from draft through publication.
Linked to Projects, People - Production tasks
Assigned production work items belonging to a project.
Linked to Projects, People - Project costs
Cost entries recorded against projects for budget tracking and reconciliation.
Linked to Projects - People
Station staff and contributors referenced by content, production and broadcast work.
Linked to Users
- Production tasks
Assigned production work items belonging to a project.
Linked to Projects, People - Projects
Content and programming projects with owner, schedule, budget and lifecycle status.
Linked to People - People
Station staff and contributors referenced by content, production and broadcast work.
Linked to Users - Content items
Individual pieces of content produced under a project, from draft through publication.
Linked to Projects, People - Content files
Versioned file assets attached to a content item, with approval attribution.
Linked to Content items, People
- Content items
Individual pieces of content produced under a project, from draft through publication.
Linked to Projects, People - Content files
Versioned file assets attached to a content item, with approval attribution.
Linked to Content items, People - Projects
Content and programming projects with owner, schedule, budget and lifecycle status.
Linked to People - People
Station staff and contributors referenced by content, production and broadcast work.
Linked to Users - Rights agreements
Rights clearance agreements covering content items, uses and validity windows.
Linked to Content items - Production tasks
Assigned production work items belonging to a project.
Linked to Projects, People
- Rights agreements
Rights clearance agreements covering content items, uses and validity windows.
Linked to Content items - Content items
Individual pieces of content produced under a project, from draft through publication.
Linked to Projects, People - Content files
Versioned file assets attached to a content item, with approval attribution.
Linked to Content items, People - Projects
Content and programming projects with owner, schedule, budget and lifecycle status.
Linked to People - People
Station staff and contributors referenced by content, production and broadcast work.
Linked to Users
- Ad play logs
Logged ad spot plays against content records with scheduled and actual timestamps.
Linked to Content items - Content items
Individual pieces of content produced under a project, from draft through publication.
Linked to Projects, People - Content files
Versioned file assets attached to a content item, with approval attribution.
Linked to Content items, People - Broadcast slots
Scheduled programming slots with presenter, air window and broadcast status.
Linked to People
Keys and references
The reference on each child record is the important join. A content files row points to its content items parent; a rights agreements row points to the same kind of parent. Ad play logs uses operational record for its content link. Broadcast slots uses Presenter for the People reference. Projects is the parent for content, tasks and costs. Preserve these references during migration, and check date values and select values before the team uses the schedule or review lists.
Migration order
- Import Users and People, then confirm the People.User links.
- Import Projects with their People owners.
- Add content items, production tasks and project costs under the right projects.
- Add content files and rights agreements under their content items.
- Add broadcast slots with presenters and air windows.
- Add ad play logs with valid content references and timestamps.
Set up Radio Station Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.