1. Digital Asset Management
  2. Data model
Reference

The tables behind Digital Asset Management

Digital Asset Management ships with 11 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
11
Features
6, plus shared settings
Change it
Add fields and tables in Proto

How the model is organised

Production

Projects contain content items, production tasks and project costs. People own projects and items and receive tasks.

Files and media

Content files attach revisions to content items; media versions attach renditions to content items.

Rights

Rights agreements attach to content items and usage rights attach to media versions.

Access and reference

People link to Users; exchange rates stores effective currency rates.

Every table, by feature

Content library

7 tablesAbout this feature
  • Content items

    Individual content items produced within a project.

    Linked to Projects, People
  • Projects

    Content production projects with budget, schedule and lifecycle status.

    Linked to People
  • Content files

    File revisions attached to a content item, with approving reviewer.

    Linked to Content items, People
  • Media versions

    Versioned media renditions captured for a content item.

    Linked to Content items
  • Rights agreements

    Rights and licensing agreements covering content items.

    Linked to Content items
  • Usage rights

    License and usage rights granted for a media version.

    Linked to Media versions
  • Production tasks

    Assigned production work for a project.

    Linked to Projects, People

File revisions

4 tablesAbout this feature
  • Content files

    File revisions attached to a content item, with approving reviewer.

    Linked to Content items, People
  • Content items

    Individual content items produced within a project.

    Linked to Projects, People
  • Rights agreements

    Rights and licensing agreements covering content items.

    Linked to Content items
  • People

    People involved in digital asset management work: owners, producers, reviewers and finance staff.

    Linked to Users

Media versions

3 tablesAbout this feature
  • Media versions

    Versioned media renditions captured for a content item.

    Linked to Content items
  • Content items

    Individual content items produced within a project.

    Linked to Projects, People
  • Usage rights

    License and usage rights granted for a media version.

    Linked to Media versions

Rights coverage

5 tablesAbout this feature
  • Rights agreements

    Rights and licensing agreements covering content items.

    Linked to Content items
  • Usage rights

    License and usage rights granted for a media version.

    Linked to Media versions
  • Content items

    Individual content items produced within a project.

    Linked to Projects, People
  • Media versions

    Versioned media renditions captured for a content item.

    Linked to Content items
  • Content files

    File revisions attached to a content item, with approving reviewer.

    Linked to Content items, People

Production projects

5 tablesAbout this feature
  • Projects

    Content production projects with budget, schedule and lifecycle status.

    Linked to People
  • Production tasks

    Assigned production work for a project.

    Linked to Projects, People
  • Content items

    Individual content items produced within a project.

    Linked to Projects, People
  • People

    People involved in digital asset management work: owners, producers, reviewers and finance staff.

    Linked to Users
  • Project costs

    Costs incurred against a content project.

    Linked to Projects

Project costs

2 tablesAbout this feature
  • Project costs

    Costs incurred against a content project.

    Linked to Projects
  • Projects

    Content production projects with budget, schedule and lifecycle status.

    Linked to People

Shared and settings

2 tables
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Users

    Users

    Linked to Users

Keys and references

The parent references are the route through the model. Content files.Content and rights agreements.Content lead to content items. Media versions.operational record also leads to content items, and usage rights.Media leads to media versions. Content items.Project, production tasks.Project and project costs.Project lead to Projects. Owner and assignee references lead to People, which in turn links to Users.

Migration order

  1. People and access. Set up Users and People so records can have accountable owners and assignees.
  2. Projects. Bring in project names, owners, schedules and budgets.
  3. Content and tasks. Add content items and production tasks with their project links.
  4. Files and rights. Add content files, media versions and rights agreements against the correct items.
  5. Version use and costs. Add usage rights to the correct versions and project costs to their projects. Bring in exchange rates when effective currency reference is needed.

Set up Digital Asset Management your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

How to get started