1. Hostel Management
  2. Data model
Reference

The tables behind Hostel Management

Hostel 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

Booking and rooms

Parties identify the booking contact; Leases connect the party to Units and the stay dates. Rate plans carry dated unit-type pricing rules.

Guest service

Service requests connect a stay and unit to an assigned People record. People connect to Users.

Guest account

Charges, outlet charges and Receipts each reference Leases while retaining their own amount and status.

Outlets

Outlet bookings connect restaurant or spa plans to Leases. Exchange rates retain effective currency rates.

Every table, by feature

Stays and check-in

6 tablesAbout this feature
  • Leases

    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.

  • Charges

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

    Linked to Leases
  • Receipts

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

    Linked to Leases
  • Service requests

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

    Linked to Units, People, Leases

Rooms and capacity

4 tablesAbout this feature
  • Units

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

  • Leases

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

    Linked to Parties, Units
  • Service requests

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

    Linked to Units, People, Leases
  • Rate plans

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

Guest parties

5 tablesAbout this feature
  • Parties

    Guests, groups, companies and other booking parties.

  • Leases

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

    Linked to Parties, Units
  • Units

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

  • Receipts

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

    Linked to Leases
  • Charges

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

    Linked to Leases

Service work

5 tablesAbout this feature
  • Service requests

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

    Linked to Units, People, Leases
  • Units

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

  • Leases

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

    Linked to Parties, Units
  • People

    Staff members who own and are assigned hospitality service work.

    Linked to Users
  • Users

    Users

    Linked to Users

Charges and receipts

5 tablesAbout this feature
  • Charges

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

    Linked to Leases
  • Receipts

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

    Linked to Leases
  • Leases

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

    Linked to Parties, Units
  • Parties

    Guests, groups, companies and other booking parties.

  • Outlet charges

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

    Linked to Leases

Outlets and rates

5 tablesAbout this feature
  • Rate plans

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

  • Outlet bookings

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

    Linked to Leases
  • Outlet charges

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

    Linked to Leases
  • Leases

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

    Linked to Parties, Units
  • Units

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

Shared and settings

1 table
  • Exchange rates

    Read-only effective exchange rates for this app.

Keys and references

Reservation number identifies a stay in daily work. The required Tenant and Unit references connect Leases to Parties and Units. Required Lease references connect charges, receipts, outlet bookings and outlet charges to the same stay. A service request also requires Unit and assigned to. Person code identifies a staff record, and People.User links it to Users.

Dates serve different purposes. Starts at and ends at define a stay or rate plan interval. Service date, charged at and received at date financial activity. Due at and completed at date operational work. Status belongs to each record’s own lifecycle; a room marked Available says something different from a stay marked Confirmed.

Migration order

  1. Load Users and People, then verify staff assignments and access.
  2. Load Parties, Units and rate plans with their current identifiers and dates.
  3. Load Leases with their party and unit references.
  4. Load service requests and outlet bookings against their stays.
  5. Load Charges, outlet charges and Receipts, retaining their statuses and references.
  6. Review exchange rates where effective currency rates are used.

Set up Hostel Management your way.

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

How to get started