[ 
https://issues.apache.org/jira/browse/OFBIZ-1590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12562548#action_12562548
 ] 

Valentina Sirkova commented on OFBIZ-1590:
------------------------------------------

Hi Karnchana, 

Let`s move this discussion to the user list(subscribe if you have not). I 
created a thread with your comments. Here is the link:
http://www.nabble.com/Question-on-spot-class-map-entities%28copied-from-jira-1590%29-to15089930.html

Regards: Valentina

> Introduction of new reservation entities
> ----------------------------------------
>
>                 Key: OFBIZ-1590
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1590
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: order
>    Affects Versions: SVN trunk
>            Reporter: Valentina Sirkova
>         Attachments: spot_class_map_entities.patch
>
>
> 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.

Reply via email to