August 29, 2006 at 1:34 pm
I've hit a snag on a project I'm working with here's the scenario.
I have a list of health facilities. These health facilities exist in a physical location. The facilities can be grouped by counties, parishes, districts,or anything. The counties/group can be grouped into a higher grouping level e.g. Trauma Regions, Emergency medical Service regions or anything. Facilities can exist in more than one grouping. A Group can also be grouped by an infinite number of higher level groups e.g. State, Country, Province etc.
Basically i want to be able to dynamically create an infinite number of groups for my facilities(note groups can be grouped).
Does anyone know how to model this correctly and effeciently?Thanks in advance.
August 29, 2006 at 1:49 pm
Here is the first stab.
1.FacilityMaster Object
FacilityID,Name,Address,City,State,County,District...
2.GroupMaster Object
GroupMasterID,GroupName,State,County,District...
3.Facility_X_Group
FacilityID,GroupMasterID,...
Hope this helps.
Thanks
Sreejith
August 29, 2006 at 1:55 pm
Thanks. That solves the facility part
What about groups in groups?
August 30, 2006 at 9:08 am
I haven't examined the query writing end of this but you can:
Group_X_Group (ChildGroupMasterID, ParentGroupMasterID)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply