|
|
Hi,
I am working on rental project and wanted to ask you about the following. Hotels, rooms in our model are facilities and fixed assets. This is also valid for some other stuff like mini-bars. FixedAsset entity has two fields "locatedAtFacilityId" and "locatedAtLocationSeqId" which yeld the following relations to Facility and FacilityLocation:
Entity : Facility Relation: one Fields: locatedAtFacilityId -> facilityId
Entity : FacilityLocation Relation: one-nofk Fields: locatedAtFacilityId -> facilityId, locatedAtLocationSeqId -> locationSeqId
We would like to be able for example, to present mini-bar as facility and fixedAsset which can be locatedAt some hotelFacility. FixedAsset supports relations to one of the entities FacilityLocation or Facility, but in our case we need to have these relations to the two of them, because our mini-bar facility could move from one hotel facility to another.
What do you think would be the best approach to handle this? I was thinking of extending the FixedAsset but please tell me if I am wrong and I am missing something...
Also why is the relation to FacilityLocation one-nofk?
Thanks:Valentina
|
Locked
