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.
- On a RDBMS system, how would you go about your scheme design?
- On the corresponding user interface, how would you design form fields?
What are your design choices on these problems?