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.
- Print Media / Newspaper
- Data Model
The tables behind Print Media / Newspaper
Print Media / Newspaper 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
- Change it
- Add fields and tables in Proto
Every table, by feature
- Edition Planning5
- Editorial Desk5
- Content Pipeline6
- Version and Rights Review6
- Production and Costs5
- Circulation Routes4
- Projects
Editorial and commercial projects such as editions, supplements and special sections.
Linked to People - Content items
Individual stories, features, columns and advertising content produced for a project.
Linked to Projects, People - Production tasks
Production and layout work required to deliver a project.
Linked to Projects, People - Project costs
Costs incurred against a project, from draft through approval and payment.
Linked to Projects - People
Staff and contributors who own, produce, review and deliver print media work.
Linked to Users
- Editorial assignments
Desk assignments linking reporters to stories for a specific edition.
Linked to People - People
Staff and contributors who own, produce, review and deliver print media work.
Linked to Users - Users
Users
Linked to Users - Content items
Individual stories, features, columns and advertising content produced for a project.
Linked to Projects, People - Projects
Editorial and commercial projects such as editions, supplements and special sections.
Linked to People
- Content items
Individual stories, features, columns and advertising content produced for a project.
Linked to Projects, People - Content files
Versioned files attached to a content item, each with its own approval.
Linked to Content items, People - Rights agreements
Rights and usage agreements covering content items.
Linked to Content items - Projects
Editorial and commercial projects such as editions, supplements and special sections.
Linked to People - People
Staff and contributors who own, produce, review and deliver print media work.
Linked to Users - Production tasks
Production and layout work required to deliver a project.
Linked to Projects, People
- Content files
Versioned files attached to a content item, each with its own approval.
Linked to Content items, People - Rights agreements
Rights and usage agreements covering content items.
Linked to Content items - Content items
Individual stories, features, columns and advertising content produced for a project.
Linked to Projects, People - Projects
Editorial and commercial projects such as editions, supplements and special sections.
Linked to People - People
Staff and contributors who own, produce, review and deliver print media work.
Linked to Users - Users
Users
Linked to Users
- Production tasks
Production and layout work required to deliver a project.
Linked to Projects, People - Project costs
Costs incurred against a project, from draft through approval and payment.
Linked to Projects - Projects
Editorial and commercial projects such as editions, supplements and special sections.
Linked to People - People
Staff and contributors who own, produce, review and deliver print media work.
Linked to Users - Content items
Individual stories, features, columns and advertising content produced for a project.
Linked to Projects, People
- Circulation routes
Dispatch and return evidence for each circulation route and edition.
Linked to Content items - Content items
Individual stories, features, columns and advertising content produced for a project.
Linked to Projects, People - Projects
Editorial and commercial projects such as editions, supplements and special sections.
Linked to People - People
Staff and contributors who own, produce, review and deliver print media work.
Linked to Users
Keys and references
A content items record references one Projects record and one People owner. Content files and rights agreements each reference content items. Content files also references the approving People record. Editorial assignments references a reporter in People. Production tasks and project costs reference Projects; production tasks also references an assigned People record. Circulation routes references content items through operational record. People references Users through User.
Keep saved list screens as views of these source tables. They provide a way to inspect and filter records; they do not add another business record to import.
Migration order
- Load Users and People so owners, reporters, assignees and reviewers resolve.
- Load Projects with owners, dates, statuses and budgets.
- Load editorial assignments and content items with the right people and project references.
- Load content files and rights agreements for the current content items.
- Load production tasks and project costs against the intended projects.
- Load circulation routes after their operational content records exist.
Set up Print Media / Newspaper your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.