Introduction of new reservation entities
----------------------------------------
Key: OFBIZ-1590
URL: https://issues.apache.org/jira/browse/OFBIZ-1590
Project: OFBiz
Issue Type: Improvement
Affects Versions: SVN trunk
Reporter: Valentina Sirkova
I propose the introduction of the following entities: AccommodationClass,
AccommodationSpot,AccommodationMap. Their design is based on the book "The data
model resource book".
- AccommodationClass could define classes for hotels, cars, planes etc. I
have added one more field here parentAccClass, as I thought it could be
valuable for building more complicated hierarchies.
- AccommodationMap is used to say how many spaces a class has. I have
extended it further with a field overbooked, which could store the overbooking
data for each class. E.g if we have that field we might know how many rooms of
class "deluxe" could be overbooked. The primary key of AccommodationMap in the
book includes the "NrOfSpaces" field but I did not add it in the patch as I am
not sure of its exact purpose.
- AccommodationSpot defines the specific seat,room etc of a given class. It is
very powerful entity as it let us define the seat as a spot simply. This is
very useful for planes and buses for example as we have the chance to define
all the seats as spots and are not required to make them fas. I have modified
the type of the field "accomNumber" to be of type short-varchar as plane seats
for example are mixture of letters and numbers(The book models it of type
numeric). The fk fields include the "nrOfSpaces" field in the book which I have
not included in my patch.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
