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.
- Fundraising Gala Management
- Data model
The tables behind Fundraising Gala Management
Fundraising Gala Management ships with 12 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
- 12
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Event planning:
Events ties Organizations, team members and Venues to the gala schedule and capacity.
Operating records:
Admissions and gala pledges belong to Events; pledges also reference Organizations.
Evidence:
Payment evidence, record attachments, review decisions and operation receipts belong to Events.
Identity and rates:
Users relates to team members; exchange rates holds effective rates for the operating context.
Every table, by feature
- Event planning6
- Venue and organization setup5
- Admissions and capacity4
- Pledges and decisions4
- Event review7
- Evidence and closeout7
- Shared and settings1
- Events
Gala events with capacity, lifecycle, owner, and venue context.
Linked to Organizations, Team members, Venues - Organizations
Organizations that own and scope gala operations.
- Team members
Active organization members who prepare and review gala records.
Linked to Organizations, Users - Venues
Eligible venues used as event counterparties.
Linked to Organizations - Review decisions
Independent review decisions for exact source revisions.
Linked to Events, Team members - Operation receipts
Idempotent receipts for guarded operational actions.
Linked to Events
- Organizations
Organizations that own and scope gala operations.
- Team members
Active organization members who prepare and review gala records.
Linked to Organizations, Users - Users
Users
Linked to Users - Venues
Eligible venues used as event counterparties.
Linked to Organizations - Events
Gala events with capacity, lifecycle, owner, and venue context.
Linked to Organizations, Team members, Venues
- Events
Gala events with capacity, lifecycle, owner, and venue context.
Linked to Organizations, Team members, Venues - Admissions
Admission reservations and admitted attendance linked to events.
Linked to Events - Payment evidence
Provider evidence for authorization, capture, refund, and void events.
Linked to Events - Operation receipts
Idempotent receipts for guarded operational actions.
Linked to Events
- Gala pledges
Documented gala pledges linked to events and review evidence.
Linked to Events, Organizations - Events
Gala events with capacity, lifecycle, owner, and venue context.
Linked to Organizations, Team members, Venues - Organizations
Organizations that own and scope gala operations.
- Payment evidence
Provider evidence for authorization, capture, refund, and void events.
Linked to Events
- Events
Gala events with capacity, lifecycle, owner, and venue context.
Linked to Organizations, Team members, Venues - Venues
Eligible venues used as event counterparties.
Linked to Organizations - Organizations
Organizations that own and scope gala operations.
- Team members
Active organization members who prepare and review gala records.
Linked to Organizations, Users - Review decisions
Independent review decisions for exact source revisions.
Linked to Events, Team members - Record attachments
Evidence files attached to event-scoped records.
Linked to Events, Team members - Operation receipts
Idempotent receipts for guarded operational actions.
Linked to Events
- Events
Gala events with capacity, lifecycle, owner, and venue context.
Linked to Organizations, Team members, Venues - Admissions
Admission reservations and admitted attendance linked to events.
Linked to Events - Gala pledges
Documented gala pledges linked to events and review evidence.
Linked to Events, Organizations - Payment evidence
Provider evidence for authorization, capture, refund, and void events.
Linked to Events - Review decisions
Independent review decisions for exact source revisions.
Linked to Events, Team members - Operation receipts
Idempotent receipts for guarded operational actions.
Linked to Events - Record attachments
Evidence files attached to event-scoped records.
Linked to Events, Team members
Keys and references
The event is the parent for admissions, pledges and review evidence. Its owner references a team member, while its counterparty references a venue. Each review decision records a source revision and reviewer. Operation receipts carry an operation key and expected revision, which help trace guarded actions across retries. Payment evidence carries a provider event identifier and reference for reconciliation.
Migration order
- Load Organizations, Users and team members so ownership and scope are available.
- Load Venues and exchange rates before preparing current events.
- Load Events with valid organization, owner and venue references.
- Load Admissions and gala pledges against their parent event.
- Bring in payment evidence, record attachments, review decisions and operation receipts with their event links and source identities.
Set up Fundraising Gala Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.