Last post Oct 09, 2015 08:34 AM by Mikesdotnetting
Oct 09, 2015 08:25 AM|anandh_aspdotnet|LINK
I want to design geo hierarchy table structures in loosely coupled..
Country -> States -> Cities -> Streets.
In future if I want to include Areas in between States and Cities, it should be effortless. How we can design? Kindly suggest me.
Oct 09, 2015 08:34 AM|Mikesdotnetting|LINK
You need a table for each entity: Country, State, City, Street. When you add an Area or Region table, you will add a foreign key column to your City table to cater for the AreaID.