Introduction
This page is a discussion for the implementation on how we register the reservation of seats in a location for a certain date and time. Please add comments and/or amend the text.
Current system
Currently there is a reservation possibility for rooms in a Hotel. It makes usage of the product --> fixedasset --> techdatacalendar entities for registration of location and availability. Reservations are stored in the order --> orderitem --> workEffort entities.
This is fine for rooms in a Hotel but this organization has the following problems:
- There is a duplication of data for the reservation date in workeffort and the availability date in the techData calendar.
- It does not cater for floorplans as is used in planes, cinemas and busses and in most restaurants.
Proposed Changes
As suggested in the mailinglist, it is proposed to add 3 more entities:
- accomodationMap (of a fixed asset)
This is a floorplan of a fixedasset which can be a vehicle,plane or restaurant-area of a facility. - accomodationSpot (of a accomodationmap)
This is a seat, table, chair of the accomodation map for a certain accomodation class - accomodationClass (type of accomodationSpot)
this is the type of class, like firstClass,businessClass but also standard or luxuryroom. - Reservations are still done using the current implementation however we need to add accomodationMapId and accomodationSpotId to the workeffort.
Definitions
- A restaurant is a facility with a dining area which is a fixed asset having a accomodation map with spots which are tables and/or seats. A table can be reserved selecting the product (table reservation for fixedasset 'dining area' in a facility) and selecting the accomodation spot from the related map.
- An Aeroplane, Bus or Train is a fixed asset having a accomodation map with spots in several classes flying from airport A which is a facility to airport B which is another facility
- A hotel is a facility with a restaurant (fixedasset) and rooms (single fixed asset) having a accomodation map with spots which are rooms.