1. Community Event Platform
  2. Data model
Reference

The tables behind Community Event Platform

Community 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

Organization context

Organizations, People and Users establish ownership and staff membership; community groups describes the event setting.

Event operations

Community events is the parent for event registrations and event RSV ps.

Decisions and evidence

Review decisions, evidence documents, operation runs and payment evidence remain linked to the event.

Every table, by feature

Event planning

5 tablesAbout this feature
  • Community events

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

    Linked to Organizations, People, Community groups
  • Organizations

    Operating organizations that own events, venues and team members.

  • People

    Staff membership linking a platform user to an organization and role.

    Linked to Organizations, Users
  • Community groups

    Physical or virtual venues and resource providers used by events.

    Linked to Organizations
  • Evidence documents

    Uploaded evidence files linked to an event with visibility scope.

    Linked to Community events, People

Community groups

3 tablesAbout this feature
  • Community groups

    Physical or virtual venues and resource providers used by events.

    Linked to Organizations
  • Community events

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

    Linked to Organizations, People, Community groups
  • Organizations

    Operating organizations that own events, venues and team members.

Registrations

6 tablesAbout this feature
  • Event registrations

    Participant registration records submitted for review and completion.

    Linked to Community events, Organizations
  • Community events

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

    Linked to Organizations, People, Community groups
  • Organizations

    Operating organizations that own events, venues and team members.

  • Review decisions

    Independent reviewer decisions recorded against a source revision.

    Linked to Community events, People
  • Event RSV ps

    Reserved and admitted admission lines for an event.

    Linked to Community events
  • Payment evidence

    Provider payment authorizations, captures, refunds and voids.

    Linked to Community events

Admission

5 tablesAbout this feature
  • Event RSV ps

    Reserved and admitted admission lines for an event.

    Linked to Community events
  • Community events

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

    Linked to Organizations, People, Community groups
  • Event registrations

    Participant registration records submitted for review and completion.

    Linked to Community events, Organizations
  • Operation runs

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

    Linked to Community events
  • Payment evidence

    Provider payment authorizations, captures, refunds and voids.

    Linked to Community events

Review and evidence

6 tablesAbout this feature
  • Review decisions

    Independent reviewer decisions recorded against a source revision.

    Linked to Community events, People
  • Evidence documents

    Uploaded evidence files linked to an event with visibility scope.

    Linked to Community events, People
  • Community events

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

    Linked to Organizations, People, Community groups
  • Event registrations

    Participant registration records submitted for review and completion.

    Linked to Community events, Organizations
  • Operation runs

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

    Linked to Community events
  • People

    Staff membership linking a platform user to an organization and role.

    Linked to Organizations, Users

Payment and closeout

5 tablesAbout this feature
  • Payment evidence

    Provider payment authorizations, captures, refunds and voids.

    Linked to Community events
  • Operation runs

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

    Linked to Community events
  • Community events

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

    Linked to Organizations, People, Community groups
  • Event RSV ps

    Reserved and admitted admission lines for an event.

    Linked to Community events
  • Review decisions

    Independent reviewer decisions recorded against a source revision.

    Linked to Community events, People

Shared and settings

1 table
  • Users

    Users

    Linked to Users

Keys and references

Use the event’s identity and Revision to check an action against the current scope. Operation runs.operation key identifies a repeated guarded request. Review decisions.source revision identifies the scope a reviewer decided. Payment evidence.provider event ID and provider reference identify the reported provider effect; Verified marks whether that effect was confirmed. Keep those identifiers through import and correction.

Migration order

  1. Import Organizations and Users, then People with the right organization and user reference.
  2. Import community groups for those organizations.
  3. Import community events with owner, group, date, capacity and current lifecycle.
  4. Link event registrations and event RSV ps to their parent events.
  5. Attach evidence documents, review decisions, operation runs and payment evidence with original revisions and provider identifiers.

Set up Community Event Platform your way.

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

How to get started