Address Table

Proposed schema for US, belongsTo(various) addresses table

CREATE TABLE `addresses` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `name1` varchar(100) NOT NULL,
  `name2` varchar(100) NOT NULL,
  `address1` varchar(100) NOT NULL,
  `address2` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL DEFAULT '',
  `state` varchar(2) NOT NULL,
  `postal_code` varchar(20) NOT NULL,
  `country` varchar(10) NOT NULL DEFAULT '',
  `foreign_key` int(11) DEFAULT NULL,
  `foreign_table` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Postal recommendations

Use the following guidelines:

• All capital letters.
• No punctuation.
• At least 10-point type.
• One space between city and state.
• Two spaces between state and ZIP Code.
• Left justified.

TIPS

• Always put the attention line on top * never below the city and state or in the bottom corner of your mailpiece.
• If you can’t fit the suite or apartment number on the same line as the delivery address, put it on the line ABOVE the delivery address, NOT on the line below.
• Words like “east” and “west” are called directionals and they are VERY important. A missing or a bad directional can prevent your mail from being delivered correctly.
• Use the free ZIP Code Lookup and the ZIP+4 code lookup on the Postal Explorer website (left frame) to find the correct ZIP Codes and ZIP+4 codes for your addresses.