1. Photo Studio Management
  2. Data model
Reference

The tables behind Photo Studio Management

Photo Studio 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

Client work

Projects carry ownership, dates, budget and lifecycle; production tasks and project costs link to each project.

Shoots and choices

Photo sessions link a photographer from People; proof selections link back to the session.

Deliverables

Content items link to a project and owner; content files and rights agreements link to each content item.

Access

People link to Users; exchange rates are read-only effective rates for this app.

Every table, by feature

Projects and production

4 tablesAbout this feature
  • Projects

    Client photography projects with owner, schedule, budget and lifecycle status.

    Linked to People
  • Production tasks

    Assigned production work items for a project.

    Linked to Projects, People
  • Project costs

    Cost lines booked against a project with approval status.

    Linked to Projects
  • People

    Studio staff and contractors who own projects, content, tasks and sessions.

    Linked to Users

Photo sessions

4 tablesAbout this feature
  • Photo sessions

    Booked studio or location photo sessions with photographer and timing.

    Linked to People
  • People

    Studio staff and contractors who own projects, content, tasks and sessions.

    Linked to Users
  • Users

    Users

    Linked to Users
  • Proof selections

    Client proof image selections and print orders for a session.

    Linked to Photo sessions

Proof selections

4 tablesAbout this feature
  • Proof selections

    Client proof image selections and print orders for a session.

    Linked to Photo sessions
  • Photo sessions

    Booked studio or location photo sessions with photographer and timing.

    Linked to People
  • People

    Studio staff and contractors who own projects, content, tasks and sessions.

    Linked to Users
  • Users

    Users

    Linked to Users

Content production

5 tablesAbout this feature
  • Content items

    Individual content deliverables produced under a project.

    Linked to Projects, People
  • Content files

    Versioned file uploads attached to a content item, with approver.

    Linked to Content items, People
  • Production tasks

    Assigned production work items for a project.

    Linked to Projects, People
  • Projects

    Client photography projects with owner, schedule, budget and lifecycle status.

    Linked to People
  • People

    Studio staff and contractors who own projects, content, tasks and sessions.

    Linked to Users

Rights and review

4 tablesAbout this feature
  • Rights agreements

    Usage rights and contract coverage for a content item.

    Linked to Content items
  • Content items

    Individual content deliverables produced under a project.

    Linked to Projects, People
  • Content files

    Versioned file uploads attached to a content item, with approver.

    Linked to Content items, People
  • People

    Studio staff and contractors who own projects, content, tasks and sessions.

    Linked to Users

Publishing and delivery

5 tablesAbout this feature
  • Content items

    Individual content deliverables produced under a project.

    Linked to Projects, People
  • Content files

    Versioned file uploads attached to a content item, with approver.

    Linked to Content items, People
  • Rights agreements

    Usage rights and contract coverage for a content item.

    Linked to Content items
  • Production tasks

    Assigned production work items for a project.

    Linked to Projects, People
  • Projects

    Client photography projects with owner, schedule, budget and lifecycle status.

    Linked to People

Shared and settings

1 table
  • Exchange rates

    Read-only effective exchange rates for this app.

Keys and references

The reference fields keep each selection with its session and each content file or rights agreement with its content item. Keep the person and user link current for authorized session and proof capture. Preserve source identifiers during import so files, tasks and costs attach to the intended parent.

Migration order

  1. Users and People. Establish users, active people and their links first.
  2. Projects. Import project owners and working dates.
  3. photo sessions and proof selections. Import shoots before client choices.
  4. content items and production tasks. Attach deliverables and work to the right project.
  5. content files, rights agreements and project costs. Attach version files, rights and cost lines after their parents exist.
  6. exchange rates. Review the read-only rates used in this app.

Set up Photo Studio Management your way.

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

How to get started