1. Exhibition / Trade Show
  2. Data model and migration order
Reference

The tables behind Exhibition / Trade Show

Exhibition / Trade Show 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

Events and capacity:

Events records hold the window, venue, operator, owner, status and admission limit.

Booths and exhibitors:

Booth assignments link the exhibitor Organization and booth to the parent Events record.

Admissions:

Admissions lines sit under Events with reservation and admitted times.

Organizations and venues:

Organizations, Venues, team members and Users identify the operator, location and people.

Review and evidence:

Review decisions and record attachments hold source-revision decisions and supporting material.

Payments and reconciliation:

Payment evidence and operation receipts preserve provider facts and guarded-action outcomes.

Every table, by feature

Events and capacity

5 tablesAbout this feature
  • 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.

  • Venues

    Physical or virtual venues and resource providers used by events.

    Linked to Organizations
  • 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

Booths and exhibitors

5 tablesAbout this feature
  • Booth assignments

    Exhibitor booth assignment 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
  • Organizations

    Operating organizations that own events, venues and team members.

  • 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

Admissions

4 tablesAbout this feature
  • 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

Venues and organizations

6 tablesAbout this feature
  • Organizations

    Operating organizations that own events, venues and team members.

  • Venues

    Physical or virtual venues and resource providers used by events.

    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
  • Events

    Programs, events and sessions with capacity, lifecycle and revision.

    Linked to Organizations, Team members, Venues
  • Booth assignments

    Exhibitor booth assignment records submitted for review and completion.

    Linked to Events, Organizations

Review and evidence

5 tablesAbout this feature
  • 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
  • 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
  • Operation receipts

    Idempotent receipts for guarded operations with expected revision and result state.

    Linked to Events

Payments and reconciliation

5 tablesAbout this feature
  • 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
  • Admissions

    Reserved and admitted admission lines for an event.

    Linked to Events
  • Booth assignments

    Exhibitor booth assignment 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

Keys and references

Use stable organization and venue codes, then event record numbers and revision values. Parent is the reference from Admissions, booth assignments, review decisions, payment evidence, operation receipts and record attachments to Events. The booth assignment also references the exhibitor Organization. The event references its operating Organization, Owner in team members and venue in Counterparty. Keep provider event identifiers and operation keys stable when importing repeated external events.

Keep the current revision with each guarded action. A reviewer decision carries its source revision and operation key; an operation receipt carries its expected revision and linked effects. These values let the team distinguish a repeated request from a changed one.

Migration order

  1. Load Organizations, Users, team members and Venues with stable codes and active states.
  2. Load Events with their operating organization, owner, venue, start and capacity.
  3. Load booth assignments and Admissions under the correct parent event.
  4. Load record attachments, review decisions, payment evidence and operation receipts with source identifiers intact.
  5. Compare per-event booth, admission and verified payment results before opening the next operating cycle.

Set up Exhibition / Trade Show your way.

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

How to get started