1. Pilgrimage / Religious Tourism
  2. Data model
Reference

The tables behind Pilgrimage / Religious Tourism

Pilgrimage / Religious Tourism 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

People and parties

Users links to People; Parties holds customer, carrier and provider names for transport operations.

Group planning

Pilgrimage groups selects a leader from People. Pilgrim services belongs to a group.

Transport

Trips selects a customer, vehicle and driver. Trip stops, transport documents, delivery evidence and trip charges point to the trip.

Reference records

Vehicles keeps fleet capacity and status; exchange rates keeps effective currency rates.

Every table, by feature

Group Planning

3 tablesAbout this feature
  • Pilgrimage groups

    Pilgrim groups travelling together with departure, return, leader and participant count.

    Linked to People
  • People

    Staff and volunteer people records for pilgrimage operations, each linked to a platform user.

    Linked to Users
  • Pilgrim services

    Accommodation, meal, transport and visit services arranged for a pilgrimage group.

    Linked to Pilgrimage groups

Pilgrim Services

3 tablesAbout this feature
  • Pilgrim services

    Accommodation, meal, transport and visit services arranged for a pilgrimage group.

    Linked to Pilgrimage groups
  • Pilgrimage groups

    Pilgrim groups travelling together with departure, return, leader and participant count.

    Linked to People
  • Trips

    Planned and dispatched journeys carrying pilgrim groups between origin and destination.

    Linked to Parties, Vehicles, People

Trip Dispatch

5 tablesAbout this feature
  • Trips

    Planned and dispatched journeys carrying pilgrim groups between origin and destination.

    Linked to Parties, Vehicles, People
  • Parties

    Customers, carriers and providers engaged for pilgrimage transport operations.

  • Vehicles

    The motorcoach and shuttle fleet used for pilgrim group movements.

  • People

    Staff and volunteer people records for pilgrimage operations, each linked to a platform user.

    Linked to Users
  • Trip stops

    Ordered itinerary stops for a trip with planned and actual arrival and departure times.

    Linked to Trips

Fleet and People

5 tablesAbout this feature
  • Vehicles

    The motorcoach and shuttle fleet used for pilgrim group movements.

  • People

    Staff and volunteer people records for pilgrimage operations, each linked to a platform user.

    Linked to Users
  • Users

    Users

    Linked to Users
  • Transport documents

    Permits, insurance certificates and route authorities attached to a trip and verified by a named person.

    Linked to People, Trips
  • Trips

    Planned and dispatched journeys carrying pilgrim groups between origin and destination.

    Linked to Parties, Vehicles, People

Trip Execution

3 tablesAbout this feature
  • Trips

    Planned and dispatched journeys carrying pilgrim groups between origin and destination.

    Linked to Parties, Vehicles, People
  • Trip stops

    Ordered itinerary stops for a trip with planned and actual arrival and departure times.

    Linked to Trips
  • Delivery evidence

    Proof of delivery recorded at the end of a trip with recipient and confirmation status.

    Linked to Trips

Delivery and Charges

4 tablesAbout this feature
  • Delivery evidence

    Proof of delivery recorded at the end of a trip with recipient and confirmation status.

    Linked to Trips
  • Trip charges

    Charge lines raised against a trip with draft, approved and invoiced lifecycle.

    Linked to Trips
  • Trips

    Planned and dispatched journeys carrying pilgrim groups between origin and destination.

    Linked to Parties, Vehicles, People
  • Trip stops

    Ordered itinerary stops for a trip with planned and actual arrival and departure times.

    Linked to Trips

Shared and settings

1 table
  • Exchange rates

    Read-only effective exchange rates for this app.

Keys and references

The human trip reference is trip reference. Each trip’s Customer points to Parties, Vehicle to Vehicles and Driver to People. Pilgrimage groups.Leader also points to People. Pilgrim services.Group points to pilgrimage groups. Transport documents.verified by points to People. The trip-linked detail tables use their Trip reference to keep route, files, delivery and charges together.

Migration order

  1. Load Users and People, then check each person-user link.
  2. Load Parties and Vehicles and confirm vehicle capacities and units.
  3. Load pilgrimage groups and pilgrim services, checking leader and group references.
  4. Load Trips, then ordered trip stops and transport documents.
  5. Load delivery evidence and trip charges against the correct journey.
  6. Load exchange rates if currency reference data is needed for the operating scope.

Set up Pilgrimage / Religious Tourism your way.

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

How to get started