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.
- Heritage / Museum Management
- Data model
The tables behind Heritage / Museum Management
Heritage / Museum 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
- Change it
- Add fields and tables in Proto
How the model is organised
Collection and organizations:
Organizations, collection items, team members and Users establish operating context and item ownership.
Loan planning:
Loans ties the owner and counterparty to a due date, copy count, status and revision.
Exhibition scope:
Exhibition loans records the event request under the parent loan.
Custody activity:
Loan events keeps reservation quantity and admission evidence under that parent.
Review and evidence:
Review decisions and record attachments preserve decisions and supporting files.
Operational effects:
Operation receipts and payment evidence track guarded actions and provider events.
Every table, by feature
- Collection and organizations5
- Loan planning5
- Exhibition loans6
- Reservation and admission5
- Review and evidence6
- Operations and payment5
- Organizations
Operating organizations that own loans, collection items and team members.
- Collection items
Physical or virtual collection items and resource providers used by loans.
Linked to Organizations - Team members
Staff membership linking a platform user to an organization and role.
Linked to Organizations, Users - Users
Users
Linked to Users - Loans
Loans with copy count, lifecycle and revision.
Linked to Organizations, Team members, Collection items
- Loans
Loans with copy count, lifecycle and revision.
Linked to Organizations, Team members, Collection items - Collection items
Physical or virtual collection items and resource providers used by loans.
Linked to Organizations - Loan events
Reserved and issued loan-event lines for a loan.
Linked to Loans - Review decisions
Independent reviewer decisions recorded against a source revision.
Linked to Loans, Team members - Operation receipts
Idempotent receipts for guarded operations with expected revision and result state.
Linked to Loans
- Exhibition loans
Exhibition loan records submitted for review and completion.
Linked to Loans, Organizations - Loans
Loans with copy count, lifecycle and revision.
Linked to Organizations, Team members, Collection items - Loan events
Reserved and issued loan-event lines for a loan.
Linked to Loans - Review decisions
Independent reviewer decisions recorded against a source revision.
Linked to Loans, Team members - Record attachments
Uploaded evidence files linked to a loan with visibility scope.
Linked to Loans, Team members - Payment evidence
Provider payment authorizations, captures, refunds and voids.
Linked to Loans
- Loans
Loans with copy count, lifecycle and revision.
Linked to Organizations, Team members, Collection items - Loan events
Reserved and issued loan-event lines for a loan.
Linked to Loans - Payment evidence
Provider payment authorizations, captures, refunds and voids.
Linked to Loans - Operation receipts
Idempotent receipts for guarded operations with expected revision and result state.
Linked to Loans - Collection items
Physical or virtual collection items and resource providers used by loans.
Linked to Organizations
- Review decisions
Independent reviewer decisions recorded against a source revision.
Linked to Loans, Team members - Record attachments
Uploaded evidence files linked to a loan with visibility scope.
Linked to Loans, Team members - Loans
Loans with copy count, lifecycle and revision.
Linked to Organizations, Team members, Collection items - Exhibition loans
Exhibition loan records submitted for review and completion.
Linked to Loans, Organizations - Team members
Staff membership linking a platform user to an organization and role.
Linked to Organizations, Users - Operation receipts
Idempotent receipts for guarded operations with expected revision and result state.
Linked to Loans
- Operation receipts
Idempotent receipts for guarded operations with expected revision and result state.
Linked to Loans - Payment evidence
Provider payment authorizations, captures, refunds and voids.
Linked to Loans - Loans
Loans with copy count, lifecycle and revision.
Linked to Organizations, Team members, Collection items - Loan events
Reserved and issued loan-event lines for a loan.
Linked to Loans - Review decisions
Independent reviewer decisions recorded against a source revision.
Linked to Loans, Team members
Keys and references
The parent loan is the shared reference for exhibition requests, event lines, decisions, attachments, operation receipts and payment evidence. Organization references partition the operating context. Staff references identify the loan owner, reviewer and uploader. Operation key and provider event ID identify repeat-sensitive action and provider events; Revision and source revision connect decisions to the version actually reviewed.
Migration order
- Load Organizations and Users, then connect team members to both.
- Load collection items with the correct organization and provider details.
- Create Loans with owner, counterparty, due date and copy count.
- Add exhibition loans and loan events beneath their parent loans.
- Add record attachments and review decisions with their parent and staff references.
- Add payment evidence and operation receipts only with their authoritative event and action identities.
Set up Heritage / Museum Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.