ZIP codes are not numeric data -- it doesn't make sense to add or subtract a ZIP code, for example, and leading zeros must be preserved. This database structure would cause my ZIP code "02116" to become `2116`. A string datatype such as `TEXT` would be a better choice.