1. Re: [OT]Where's everyone from? Contest
Lewis Townsend wrote:
>
> I like this idea.
>
> The database should include: "*" indicates index key fields
>
> [city table]
> *Name
This will not be sufficient because it is possible to have two or more
cities with the same name. I live in Melbourne, Victoria, Australia, not
Melbourne, Florida, USA.
Instead, just give each city a unique id value just like you'd give people.
Maybe the Location value could be used, so long as it wouldn't be possible
to move a city to a new location.
> Country
> State/Province
> Location(lat,long)
>
> [Person table]
> *ID number
> Last Name
> First Name
Instead of Last/First name, use Family/Given name as these cross cultures
a bit better. Not all cultures place the Family name last.
> City
> State/Province
> Country
> Notes(euphoria relevant info)
>
> This way only the city records would contain coordinants.
> and the people records would contain city, state, and country.
> This seems like a good way to simplify the globe so there won't
> be multiple dots in one spot.
>
> Below lies the signature of Lewis Townsend
> Lewy T
>
--
Derek Parnell
Melbourne, Australia
