1. Virtual Event Platform
  2. Data model and import order
Reference

The tables behind Virtual Event Platform

Virtual Event Platform 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

Event Schedule:

Events, Venues, Organizations, team members. Each event belongs to an organization, names a venue and an owning team member, and carries a version number.

Breakout Sessions:

Breakout sessions belong to an event and organization with track, start time, participant capacity and host.

Admission Workspace:

Admissions hold registration lines for an event with name, attendee reference, quantity, price, reserved and admitted times.

Review Queue:

Review decisions record the decision, reason and reviewer against an event version.

Evidence Center:

Payment evidence keeps provider authorizations, captures, refunds and voids; record attachments hold files with visibility.

Event Command:

Operation receipts record each guarded action on an event and its outcome.

Access:

Users hold platform accounts; team members link each staff member to a user and organization.

Every table, by feature

Event Schedule

4 tablesAbout this feature
  • Events

    Virtual events moving through draft, review, approval, open and completion.

    Linked to Organizations, Team members, Venues
  • Venues

    Eligible physical or virtual venues used as the counterparty for events.

    Linked to Organizations
  • Organizations

    Tenant organizations that own events, venues and team membership.

  • Team members

    Authenticated platform identities with an operational role inside an organization.

    Linked to Organizations, Users

Breakout Sessions

4 tablesAbout this feature
  • Breakout sessions

    Breakout session extensions submitted for independent review before opening.

    Linked to Events, Organizations
  • Events

    Virtual events moving through draft, review, approval, open and completion.

    Linked to Organizations, Team members, Venues
  • Record attachments

    Uploaded evidence files attached to an event with a visibility scope.

    Linked to Events, Team members
  • Review decisions

    Independent reviewer decisions recorded against a frozen event revision.

    Linked to Events, Team members

Admission Workspace

4 tablesAbout this feature
  • Admissions

    Reserved and admitted attendee lines belonging to an event.

    Linked to Events
  • Events

    Virtual events moving through draft, review, approval, open and completion.

    Linked to Organizations, Team members, Venues
  • Payment evidence

    Provider authorization, capture, refund and void evidence for event payments.

    Linked to Events
  • Operation receipts

    Idempotent receipts for every guarded operation executed against an event.

    Linked to Events

Review Queue

4 tablesAbout this feature
  • Review decisions

    Independent reviewer decisions recorded against a frozen event revision.

    Linked to Events, Team members
  • Events

    Virtual events moving through draft, review, approval, open and completion.

    Linked to Organizations, Team members, Venues
  • Breakout sessions

    Breakout session extensions submitted for independent review before opening.

    Linked to Events, Organizations
  • Team members

    Authenticated platform identities with an operational role inside an organization.

    Linked to Organizations, Users

Evidence Center

4 tablesAbout this feature
  • Payment evidence

    Provider authorization, capture, refund and void evidence for event payments.

    Linked to Events
  • Record attachments

    Uploaded evidence files attached to an event with a visibility scope.

    Linked to Events, Team members
  • Events

    Virtual events moving through draft, review, approval, open and completion.

    Linked to Organizations, Team members, Venues
  • Team members

    Authenticated platform identities with an operational role inside an organization.

    Linked to Organizations, Users

Event Command

5 tablesAbout this feature
  • Operation receipts

    Idempotent receipts for every guarded operation executed against an event.

    Linked to Events
  • Events

    Virtual events moving through draft, review, approval, open and completion.

    Linked to Organizations, Team members, Venues
  • Admissions

    Reserved and admitted attendee lines belonging to an event.

    Linked to Events
  • Payment evidence

    Provider authorization, capture, refund and void evidence for event payments.

    Linked to Events
  • Organizations

    Tenant organizations that own events, venues and team membership.

Shared and settings

1 table
  • Users

    Users

    Linked to Users

Keys and references

Every event keeps a stable record number, and every venue and organization a code. Import registrations by event record number and attendee reference, never by name. Keep the provider event ID and reference on payment evidence so a repeated notification is recognized. Amounts are recorded in US dollars. Each operation receipt keeps a unique operation key.

The platform holds 11 tables and 16 relationships.

Migration order

  1. Load Organizations, Users and team members.
  2. Load Venues with codes, contacts and eligibility notes.
  3. Load open Events with record numbers, owners, venues and capacity, then breakout sessions.
  4. Load record attachments for each event.
  5. Load Admissions and verified payment evidence for paid events.
  6. Reconcile event counts, registrations against capacity and verified payments with the source before opening new registrations.

Set up Virtual Event Platform your way.

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

How to get started