...

• 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:

1. accomodationMap (of a fixed asset)
   This is a floorplan of a fixedasset which can be a vehicle,plane or restaurant-area of a facility.
2. accomodationSpot (of a accomodationmap)
   This is a seat, table, chair of the accomodation map for a certain accomodation class
3. accomodationClass (type of accomodationSpot)
   this is the type of class, like firstClass,businessClass but also standard or luxuryroom.
4. 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.
• 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.