I am always patient when I am not doing it. :)
let me know if I can help.
Adrian Crum sent the following on 7/25/2008 12:55 PM:
> I was planning on doing that. Be patient. ;-)
>
> -Adrian
>
> BJ Freeman wrote:
>> just wishful thinking but would like to see trees implemenent on the
>> side to you can display the one to many (parent to child)
>>
>> David E Jones sent the following on 7/25/2008 12:28 PM:
>>> You're correct Adrian. One small piece of errata: this is a many-to-one
>>> relationship from child to parent (ie many children for one parent, one
>>> parent for each child).
>>>
>>> On a side note, this is an incredibly common relational modeling
>>> pattern... nothing special about it, and a tool along with the
>>> join/assoc entities (for many-to-many relationships) that everyone
>>> should become familiar with.
>>>
>>> -David
>>>
>>>
>>> On Jul 25, 2008, at 1:22 PM, Adrian Crum wrote:
>>>
>>>> Building is a parent of floor, floor is a parent of room. It's
>>>> one-to-one from child to parent.
>>>>
>>>> -Adrian
>>>>
>>>> BJ Freeman wrote:
>>>>> how would you implement a building with multiple floors and a floor
>>>>> with
>>>>> multiple rooms
>>>>> seems a way to have one to many would be necessary.
>>>>> David E Jones sent the following on 7/25/2008 12:05 PM:
>>>>>> This is a good question, and I'm surprised as I look at the data
>>>>>> model
>>>>>> to see no Facility to Facility relationship. It was probably years
>>>>>> ago,
>>>>>> but I thought there was a simple parentFacilityId or something on the
>>>>>> Facility entity that would implement a simple hierarchy for
>>>>>> Facilities.
>>>>>>
>>>>>> It would be interesting to go way back and see if this was ever there
>>>>>> and what ultimately happened to it if it was, but for right now I'm
>>>>>> okay
>>>>>> with adding this.
>>>>>>
>>>>>> For Facility hierarchies I don't think we need a separate association
>>>>>> entity, to implement a graph, or a non-strict hierarchy where a node
>>>>>> can
>>>>>> have multiple parents. A strict hierarchy should be fine for this,
>>>>>> where
>>>>>> each Facility has only one parent Facility because this is a
>>>>>> constraint
>>>>>> of their physical reality anyway.
>>>>>>
>>>>>> -David
>>>>>>
>>>>>>
>>>>>> On Jul 25, 2008, at 11:06 AM, Adrian Crum wrote:
>>>>>>
>>>>>>> But that's not how it is structured in the book. Figure 2.11 shows a
>>>>>>> facility being related to itself. It appears to me there needs to
>>>>>>> be a
>>>>>>> parentFacilityId field.
>>>>>>>
>>>>>>> -Adrian
>>>>>>>
>>>>>>> BJ Freeman wrote:
>>>>>>>> make a facilities
>>>>>>>> like
>>>>>>>> building
>>>>>>>> floor
>>>>>>>> room
>>>>>>>> then make facilities group
>>>>>>>> then add the facilities to the group
>>>>>>>> Adrian Crum sent the following on 7/25/2008 9:05 AM:
>>>>>>>>> In the Data Model Resource Book, chapter 2, it shows that
>>>>>>>>> facilities
>>>>>>>>> can
>>>>>>>>> be made up of other facilities. For example, a building facility
>>>>>>>>> can be
>>>>>>>>> made up of floor facilities, and the floor facilities can be made
>>>>>>>>> up of
>>>>>>>>> room facilities.
>>>>>>>>>
>>>>>>>>> I don't see how this is done in OFBiz. Where do I make the
>>>>>>>>> connection?
>>>>>>>>>
>>>>>>>>> -Adrian
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>
>>>>>>
>>>
>>>
>>>
>>
>>
>
>
>
