Database Design - Multiple locations
Database Design - Multiple locations
- Subject: Database Design - Multiple locations
- From: "Mr. Frank Cobia" <email@hidden>
- Date: Sun, 20 Apr 2008 21:15:17 -0400
I have a database design question. I am posting it to the WebObjects
list because I am building a WebObjects app and want a solution that
works well for EOF.
I have a table of data that has to have a location associated with it.
Unfortunately the level of the location is not constant. The data can
be associated with a Country, Region, State, Metro Area, County or
City. Each of those levels is its own table with relationships
pointing to the related locations. i.e. a State knows which Region it
belongs to and which Metro Areas belong to it.
I have been unable to come up with a design that seems elegant. I have
thought of having 6 separate relationships to each of the location
levels, but it seems to duplicate data and the data could get out of
sync if a state is moved to a different region or a City is moved to a
different county.
Has anyone had a situation like this and come up with a good solution?
Thanks,
Frank Cobia
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden