DEV Community

Sıddık AÇIL
Sıddık AÇIL

Posted on

DB Design for Storing International Addresses

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?

Top comments (0)