postal address is one of those cases where you probably do just want to shove it all in a string as most structural constraints eventually backfire - especially

postal address is one of those cases where you probably do just want to shove it all in a string as most structural constraints eventually backfire - especially if you support international: http://www.columbia.edu/~fdc/postal/ http://www.columbia.edu/~fdc/postal/ the most common schema I've seen is usually something like line1, line2, line3, city, state, country, zip, etc. if it's a reporting database then city/state/country/zip is often mashed into some sort of location id.