DB Design for Storing International Addresses

github logo ・1 min read

Every country has a different address hierarchy with different fields. Some has prefectures, others have counties. USA addresses have a necessary ZIP Code field, etc.

This design has the country agnostic aspect I am looking for but it is absolutely not scalable at all.

  1. On a RDBMS system, how would you go about your scheme design?
  2. On the corresponding user interface, how would you design form fields?

What are your design choices on these problems?

twitter logo DISCUSS
Classic DEV Post from Apr 1

Tell me about a time you messed up

So I brought down the site for a little while this morning. Now I'm interested ...

Sıddık AÇIL profile image