1. Wedding Planning Platform
  2. Data model and import order
Reference

The tables behind Wedding Planning Platform

Wedding Planning 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

Events and Venues:

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

Vendor Commitments:

Vendor commitments link a vendor booking to an event and organization with deadline, agreed fee and client approval.

Guest RSV ps:

Admissions hold reservation lines for an event with guest reference, party size, reserved and admitted times.

Payment Evidence:

Payment evidence keeps provider authorizations, captures, refunds and voids against an event.

Review Queue:

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

Activity and Evidence:

Record attachments hold documents for an event; operation receipts record each guarded action and its outcome.

Access:

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

Every table, by feature

Events and Venues

4 tablesAbout this feature
  • Events

    Wedding events with capacity, lifecycle and venue

    Linked to Organizations, Team members, Venues
  • Venues

    Wedding venues available to an organization

    Linked to Organizations
  • Organizations

    Wedding planning organizations operating the platform

  • Team members

    Staff members belonging to an organization

    Linked to Organizations, Users

Vendor Commitments

4 tablesAbout this feature
  • Vendor commitments

    Vendor commitment requests and approvals for an event

    Linked to Events, Organizations
  • Events

    Wedding events with capacity, lifecycle and venue

    Linked to Organizations, Team members, Venues
  • Review decisions

    Independent review decisions recorded against event revisions

    Linked to Events, Team members
  • Record attachments

    Supporting documents and evidence attached to events

    Linked to Events, Team members

Guest RSVPs

4 tablesAbout this feature
  • Admissions

    Guest admissions and RSVP reservations for an event

    Linked to Events
  • Events

    Wedding events with capacity, lifecycle and venue

    Linked to Organizations, Team members, Venues
  • Payment evidence

    Provider payment authorizations, captures, refunds and voids

    Linked to Events
  • Operation receipts

    Durable receipts for guarded operations executed on events

    Linked to Events

Payment Evidence

3 tablesAbout this feature
  • Payment evidence

    Provider payment authorizations, captures, refunds and voids

    Linked to Events
  • Events

    Wedding events with capacity, lifecycle and venue

    Linked to Organizations, Team members, Venues
  • Admissions

    Guest admissions and RSVP reservations for an event

    Linked to Events

Review Queue

4 tablesAbout this feature
  • Review decisions

    Independent review decisions recorded against event revisions

    Linked to Events, Team members
  • Events

    Wedding events with capacity, lifecycle and venue

    Linked to Organizations, Team members, Venues
  • Vendor commitments

    Vendor commitment requests and approvals for an event

    Linked to Events, Organizations
  • Team members

    Staff members belonging to an organization

    Linked to Organizations, Users

Activity and Evidence

4 tablesAbout this feature
  • Record attachments

    Supporting documents and evidence attached to events

    Linked to Events, Team members
  • Operation receipts

    Durable receipts for guarded operations executed on events

    Linked to Events
  • Events

    Wedding events with capacity, lifecycle and venue

    Linked to Organizations, Team members, Venues
  • Team members

    Staff members belonging to an organization

    Linked to Organizations, Users

Shared and settings

1 table
  • Users

    Users

    Linked to Users

Keys and references

Every event keeps a stable record number, and every venue a code. Import reservations by event record number and guest reference, never by name. Keep the provider event identifier and reference on payment evidence so a repeated notification is recognized. Keep amounts in US dollars as recorded. 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.
  4. Load vendor commitments, then record attachments for each event.
  5. Load Admissions and verified payment evidence for paid events.
  6. Reconcile event counts, reservations against capacity and verified payments with the source before opening new reservations.

Set up Wedding Planning Platform your way.

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

How to get started