1. Venue Booking System
  2. Data model and import order
Reference

The tables behind Venue Booking System

Venue Booking System 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

Bookings and holds:

Bookings, booking resources. Bookings with their reserved resource lines.

Resources and capacity:

Resources, Organizations. Bookable spaces and services.

Venue packages:

Venue packages. Hall, times and guest count per booking revision.

Payments and deposits:

Payment evidence. Provider payment events per booking.

Review and evidence:

Review decisions, record attachments. Decisions and supporting files.

Operations control and people:

Operation receipts, team members, Users.

Every table, by feature

Bookings and holds

3 tablesAbout this feature
  • Bookings

    Venue booking records with lifecycle, quoted amount and interval.

    Linked to Organizations, Team members, Resources
  • Booking resources

    Reserved resource lines belonging to a booking.

    Linked to Bookings, Resources
  • Resources

    Bookable halls, rooms and service resources with eligibility notes.

    Linked to Organizations

Resources and capacity

3 tablesAbout this feature
  • Resources

    Bookable halls, rooms and service resources with eligibility notes.

    Linked to Organizations
  • Booking resources

    Reserved resource lines belonging to a booking.

    Linked to Bookings, Resources
  • Organizations

    Venue operating organizations that own resources, bookings and evidence.

Venue packages

3 tablesAbout this feature
  • Venue packages

    Reviewed venue package revisions for a booking.

    Linked to Bookings, Organizations
  • Bookings

    Venue booking records with lifecycle, quoted amount and interval.

    Linked to Organizations, Team members, Resources
  • Review decisions

    Independent review decisions recorded against a booking revision.

    Linked to Bookings, Team members

Payments and deposits

2 tablesAbout this feature
  • Payment evidence

    Provider payment events reconciled against a booking.

    Linked to Bookings
  • Bookings

    Venue booking records with lifecycle, quoted amount and interval.

    Linked to Organizations, Team members, Resources

Review and evidence

4 tablesAbout this feature
  • Review decisions

    Independent review decisions recorded against a booking revision.

    Linked to Bookings, Team members
  • Record attachments

    Uploaded evidence files attached to a booking.

    Linked to Bookings, Team members
  • Bookings

    Venue booking records with lifecycle, quoted amount and interval.

    Linked to Organizations, Team members, Resources
  • Team members

    Staff members with an authenticated platform identity and role scope.

    Linked to Organizations, Users

Operations control

3 tablesAbout this feature
  • Operation receipts

    Durable receipts for guarded operations with stable operation keys.

    Linked to Bookings
  • Bookings

    Venue booking records with lifecycle, quoted amount and interval.

    Linked to Organizations, Team members, Resources
  • Booking resources

    Reserved resource lines belonging to a booking.

    Linked to Bookings, Resources

Shared and settings

1 table
  • Users

    Users

    Linked to Users

Keys and references

Reservation lines, packages, payment events, decisions, attachments and operation receipts reference their booking. Reservation lines reference a resource. Bookings, resources and packages belong to an organization. Team members link to their user account. Keep booking record numbers, resource codes and provider event identifiers stable and import by them.

Migration order

  1. Load Organizations, Users and team members.
  2. Load Resources with codes, contacts and eligibility notes.
  3. Load upcoming Bookings with their booking resources.
  4. Load venue packages for those bookings, and verified payment evidence.
  5. Reconcile the calendar with your current system and test permissions before go-live.

Set up Venue Booking System your way.

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

How to get started