is-there-common-street-addresses-database-design-for-all-addresses-of-the-world

http://stackoverflow.com/questions/929684/is-there-common-street-addresses-database-design-for-all-addresses-of-the-world

 

Depending on your actual need, you will determine either a) it doesn't really matter, and you can go for a free-text approach, or b) structured/specific fields for all countries, or c) country specific architecture.

 

Have a look at Database Answers. Specifically, this covers many cases:

AddressId
Line1
Line2
Line3
Line4
Suburb
 CityTown
ZipOrPostcode
StateProvinceCounty
CountryId
OtherAddressDetails