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.
- Event + Ticketing + CRM + Analytics
- Data model
The tables behind Event + Ticketing + CRM + Analytics
Event + Ticketing + CRM + Analytics 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
Organization
Organizations, team members, Users and Venues define operating scope and the people and places available to events.
Event operations
Events anchor schedules and capacity; Admissions and ticket scans record claims and check-ins.
Review and evidence
Review decisions, record attachments, payment evidence and operation receipts keep decisions, files, provider events and guarded-action results with the parent event.
Every table, by feature
- Event Planning7
- Venue Setup4
- Admissions4
- Ticket Scans6
- Review and Evidence6
- Operation Reconciliation6
- Shared and settings1
- Events
Programs, events and sessions with capacity, lifecycle and revision.
Linked to Organizations, Team members, Venues - Organizations
Operating organizations that own events, venues and team members.
- Team members
Staff membership linking a platform user to an organization and role.
Linked to Organizations, Users - Venues
Physical or virtual venues and resource providers used by events.
Linked to Organizations - Review decisions
Independent reviewer decisions recorded against a source revision.
Linked to Events, Team members - Admissions
Reserved and admitted admission lines for an event.
Linked to Events - Ticket scans
Ticket scan records submitted for review and completion.
Linked to Events, Organizations
- Venues
Physical or virtual venues and resource providers used by events.
Linked to Organizations - Organizations
Operating organizations that own events, venues and team members.
- Events
Programs, events and sessions with capacity, lifecycle and revision.
Linked to Organizations, Team members, Venues - Team members
Staff membership linking a platform user to an organization and role.
Linked to Organizations, Users
- Admissions
Reserved and admitted admission lines for an event.
Linked to Events - Events
Programs, events and sessions with capacity, lifecycle and revision.
Linked to Organizations, Team members, Venues - Payment evidence
Provider payment authorizations, captures, refunds and voids.
Linked to Events - Operation receipts
Idempotent receipts for guarded operations with expected revision and result state.
Linked to Events
- Ticket scans
Ticket scan records submitted for review and completion.
Linked to Events, Organizations - Events
Programs, events and sessions with capacity, lifecycle and revision.
Linked to Organizations, Team members, Venues - Admissions
Reserved and admitted admission lines for an event.
Linked to Events - Review decisions
Independent reviewer decisions recorded against a source revision.
Linked to Events, Team members - Payment evidence
Provider payment authorizations, captures, refunds and voids.
Linked to Events - Operation receipts
Idempotent receipts for guarded operations with expected revision and result state.
Linked to Events
- Review decisions
Independent reviewer decisions recorded against a source revision.
Linked to Events, Team members - Record attachments
Uploaded evidence files linked to an event with visibility scope.
Linked to Events, Team members - Payment evidence
Provider payment authorizations, captures, refunds and voids.
Linked to Events - Events
Programs, events and sessions with capacity, lifecycle and revision.
Linked to Organizations, Team members, Venues - Ticket scans
Ticket scan records submitted for review and completion.
Linked to Events, 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 Events - Events
Programs, events and sessions with capacity, lifecycle and revision.
Linked to Organizations, Team members, Venues - Admissions
Reserved and admitted admission lines for an event.
Linked to Events - Ticket scans
Ticket scan records submitted for review and completion.
Linked to Events, Organizations - Review decisions
Independent reviewer decisions recorded against a source revision.
Linked to Events, Team members - Payment evidence
Provider payment authorizations, captures, refunds and voids.
Linked to Events
Keys and references
Events.Organization points to Organizations, Events.Owner to team members and Events.Counterparty to Venues. Admissions.Parent and ticket scans.Parent point to Events. Review decisions.Parent, payment evidence.Parent, record attachments.Parent and operation receipts.Parent also point to Events. Team members.User links staff membership to Users. Review decisions.Reviewer identifies the deciding team member. Source revision and expected revision serve different checks: a decision refers to the reviewed source, while a receipt records the revision an operation expected.
Migration order
- Import Organizations and Users, then team members and Venues.
- Import Events with their organization, owner and venue references.
- Import Admissions and ticket scans under the correct parent events.
- Bring over review decisions, record attachments, payment evidence and operation receipts with their original references and times.
- Reconcile status values, revisions, provider references and admitted times before opening the next operating cycle.
Set up Event + Ticketing + CRM + Analytics your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.