All applications611

Find your application

611 applications

Open full catalog

Browse applications by category or open the full catalog.

  1. Cruise Line Management
  2. Data model
Reference

The tables behind Cruise Line Management

Cruise Line 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

Guest and stay

Parties identifies the booking party; Reservations connects that party to a Unit and stay dates.

Capacity and price

Units holds the current resource state; rate plans holds dated nightly prices by unit type.

Service

Excursion bookings and service tasks point back to Reservations; People links task owners to Users.

Finance

Folio charges, outlet charges and Payments attach to the stay. Exchange rates holds dated read-only rates.

Every table, by feature

Reservations and guests

3 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
  • Units

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

Units and rates

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

Check-in and service

4 tablesAbout this feature
  • Reservations

    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.

  • 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

Restaurant and spa bookings

3 tablesAbout this feature
  • Excursion bookings

    Excursion and onboard venue bookings attached to 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.

Folio and outlet charges

4 tablesAbout this feature
  • Folio charges

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

    Linked to Reservations
  • Outlet 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
  • Excursion bookings

    Excursion and onboard venue bookings attached to a reservation.

    Linked to Reservations

Payments and departure

6 tablesAbout this feature
  • Payments

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

    Linked to Reservations
  • Folio charges

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

    Linked to Reservations
  • Outlet 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
  • Units

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

  • Service tasks

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

    Linked to Units, People, Reservations

Shared and settings

2 tables
  • Exchange rates

    Read-only effective exchange rates for this app.

  • Users

    Users

    Linked to Users

Keys and references

Reservation number identifies a stay for the team. The reference from Reservations to Parties is Guest, while the reference to Units is Unit. Service tasks carries both Unit and Reservation and uses assigned to for its People owner. Charges, payments and venue bookings each use Reservation. Preserve these links when importing data so the service and financial history remains attached to the correct stay.

Migration order

  1. Set people and parties. Bring in Users, People and Parties with stable identities.
  2. Set available resources. Import Units and dated rate plans.
  3. Bring in stays. Load Reservations with valid Guest and Unit references.
  4. Attach operational work. Load excursion bookings and service tasks against their reservations.
  5. Attach finance. Load folio charges, outlet charges and Payments after the stay references are checked.
  6. Check rates. Review exchange rates separately as read-only effective rates.

Set up Cruise Line Management your way.

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

How to get started