I put a screenshot of my database organization online
at http://www.geoworld.org/database.gif It features four
tables, focusing on Continents, Nations, States and
Counties. Notice that Continents and Nations share a
"CCode" (continent codes) column
So how are you going to put Russia in both Asia and Europe? How are you going to put Turkey in both Asia and Europe? Egypt in Africa and Asia?
Nations and States share a NCode (nation codes) field, and States and Counties share a SCode (state codes) field.
My country does not have counties, and instead of states it has provinces. How are you going to deal with that?
Answering my questions is answering your own question :-)
Jochem
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
