1. Campground / RV Park Mgmt
  2. Data model
Reference

The tables behind Campground / RV Park Mgmt

Campground / RV Park Mgmt 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

Booking core

Parties and Units anchor Reservations, while rate plans hold dated prices by unit type.

Stay operations

Amenity bookings and service tasks refer to the reservation; tasks also point to the unit and assigned People.

Guest account

Folio charges, utility charges and Payments each link to Reservations, preserving their own dates, amounts and statuses.

Access and reference

People connects staff to Users; exchange rates holds effective reference rates.

Every table, by feature

Reservations

9 tablesAbout this feature
  • Reservations

    Stay and resource bookings with arrival, departure, party size and nightly rate.

    Linked to Parties, Units
  • Parties

    Guests, groups, companies and other booking parties.

  • Units

    Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.

  • Rate plans

    Dated nightly rate plans by unit type with minimum stay rules.

  • Amenity bookings

    Restaurant, spa and other outlet bookings attached to a reservation.

    Linked to Reservations
  • Service tasks

    Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.

    Linked to Units, People, Reservations
  • Folio charges

    Guest folio charges for a reservation, draft through posted or voided.

    Linked to Reservations
  • Payments

    Guest payments received against a reservation, pending through confirmed or refunded.

    Linked to Reservations
  • Utility charges

    Restaurant, spa and other outlet charges posted against a reservation.

    Linked to Reservations

Units and rate plans

4 tablesAbout this feature
  • Units

    Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.

  • Rate plans

    Dated nightly rate plans by unit type with minimum stay rules.

  • Reservations

    Stay and resource bookings with arrival, departure, party size and nightly rate.

    Linked to Parties, Units
  • Service tasks

    Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.

    Linked to Units, People, Reservations

Guest parties

6 tablesAbout this feature
  • Parties

    Guests, groups, companies and other booking parties.

  • Reservations

    Stay and resource bookings with arrival, departure, party size and nightly rate.

    Linked to Parties, Units
  • Amenity bookings

    Restaurant, spa and other outlet bookings attached to a reservation.

    Linked to Reservations
  • Service tasks

    Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.

    Linked to Units, People, Reservations
  • Folio charges

    Guest folio charges for a reservation, draft through posted or voided.

    Linked to Reservations
  • Payments

    Guest payments received against a reservation, pending through confirmed or refunded.

    Linked to Reservations

Service tasks

5 tablesAbout this feature
  • Service tasks

    Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.

    Linked to Units, People, Reservations
  • People

    Staff members who own and are assigned hospitality service work.

    Linked to Users
  • Users

    Users

    Linked to Users
  • Units

    Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.

  • Reservations

    Stay and resource bookings with arrival, departure, party size and nightly rate.

    Linked to Parties, Units

Amenities and utility charges

5 tablesAbout this feature
  • Amenity bookings

    Restaurant, spa and other outlet bookings attached to a reservation.

    Linked to Reservations
  • Utility charges

    Restaurant, spa and other outlet charges posted against a reservation.

    Linked to Reservations
  • Reservations

    Stay and resource bookings with arrival, departure, party size and nightly rate.

    Linked to Parties, Units
  • Parties

    Guests, groups, companies and other booking parties.

  • Payments

    Guest payments received against a reservation, pending through confirmed or refunded.

    Linked to Reservations

Folio and payments

5 tablesAbout this feature
  • Folio charges

    Guest folio charges for a reservation, draft through posted or voided.

    Linked to Reservations
  • Utility charges

    Restaurant, spa and other outlet charges posted against a reservation.

    Linked to Reservations
  • Payments

    Guest payments received against a reservation, pending through confirmed or refunded.

    Linked to Reservations
  • Reservations

    Stay and resource bookings with arrival, departure, party size and nightly rate.

    Linked to Parties, Units
  • Parties

    Guests, groups, companies and other booking parties.

Shared and settings

1 table
  • Exchange rates

    Read-only effective exchange rates for this app.

Keys and references

A reservation connects one guest party to one unit for an arrival and departure period. The linked reservation is the common key for extra bookings, tasks, charges and payments. Service tasks also reference a unit and an assigned staff member. People links to Users for the staff identity. Keep those references intact when moving historical bookings or charges into the app.

Migration order

  1. Load Users and People, then the unit inventory and guest Parties.
  2. Load rate plans with their effective date ranges and unit types.
  3. Load Reservations with their guest and unit references, dates and statuses.
  4. Add linked amenity bookings and service tasks with their reservations and assignees.
  5. Add folio charges, utility charges and Payments against the correct reservations.
  6. Check exchange rates and reconcile source identities before staff work from the imported records.

Set up Campground / RV Park Mgmt your way.

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

How to get started