tm.contactaddress

each contact can have one or more addresses fields field type description id int id createdts timestamp created timestamp lastupdatets timestamp last update timestamp contactid int contact this address is linked to references tm contact docid\ ufix35lrtf5e4t erzomr typeid int type of address references tm contactaddresstype docid 8t0ely4yylugzr5j m4nr street1 string street street2 string number street3 string box street4 string extra address line zip string zipcode city string city state string state countrycode string country code should be an iso 3166 1 alpha 2 http //en wikipedia org/wiki/iso 3166 1 alpha 2 two letter code references tm country docid\ eqc87ripphakuhrcowdpb sortorder int sort order for the addresses the address with sort order 0 is de main address