Reservation Data Model

The Reservation Entity is the main entity in this area and it is a complex entity - it is constructed from many different tables and relations.

The main table in this data model, is the oReservation table - every physical reservation in our hotel is related to one and only one oReservation record.

A Reservation entity can have many rooms or guests ...

A general and simplified graph of the Reservation Data Model

Understanding the Reservation Data Model

Whenever a new Reservation is entered in the system, records are inserted in the oReservation and the oReserved_Room tables.

If the Reservation is for 1 room then the system inserts 1 record in the oReservation table and 1 record in the oReserved_Room. The oReserved_Room is linked to the oReservation record and to a RoomType record.

If the Reservation is for X (many) rooms then the system inserts 1 record in the oReservation table and X (many) records in the oReserved_Room. The oReserved_Rooms are linked to the oReservation record and to RoomType records.

In both cases the system calculates prices for each staying day and for each room and inserts them in the oReserved_DayPlan table.

Every oReserved_Dayplan record is linked to a specific oReserved_Room. At the same time the system creates the various Folios - one for the main Reservation and one for each reserved room.

Now when specific rooms are assigned to the reservation, entries (records) are inserted in the oAssign_Room table.