Levels of insanity · 2007-10-12 12:43
This is how they figure out how to store customer addresses in the database where I work:
| Table Fields | Street Address | Shop Address | Lot | Road Mail Box | PO Box | GPO Box | Locked Bag | Private Bag | Private Box | DX Box | Overseas |
| ADDR_TYPE | P | P | P | P | P | P | P | P | P | P | P |
| ADDR_FORMAT_TYPE | H | S | L | R | P | G | B | U | V | X | O |
| ADDR_CARE_OF | y | y | y | y | y | y | y | y | y | y | y |
| ADDR_FLOOR | y | y | n | n | n | n | n | n | n | n | n |
| ADDR_BUILDING | y | y | y | y | n | n | n | n | n | n | n |
| ADDR_UNIT_NUM | y | Shop No. | n | n | n | n | n | n | n | n | n |
| ADDR_BOX_NUM | n | n | n | n | y | y | y | y | y | y | n |
| ADDR_STREET_NUM | y | y | Lot No. | Box No. | n | n | n | n | n | n | n |
| ADDR_STREET_NAME | y | y | y | y | n | n | n | n | n | n | n |
| ST_STREET_TYPE | y | y | y | y | n | n | n | n | n | n | n |
| ADDR_STREET_TYPE_DESC | y | y | y | y | n | n | n | n | n | n | n |
| ADDR_DIRN | y | y | y | y | n | n | n | n | n | n | n |
| ADDR_TOWN_NAME | y | y | y | y | y | y | y | y | y | y | n |
| ADDR_POSTCODE | y | y | y | y | y | y | y | y | y | n | n |
| ADDR_STATE | y | y | y | y | y | y | y | y | y | n | n |
| ADDR_COUNTRY | n | n | n | n | n | n | n | n | n | n | y |
| ADDR_OVERSEAS | n | n | n | n | n | n | n | n | n | n | y |
| ADDR_SUITE | y | y | y | y | n | n | n | n | n | n | n |
I just wanted you to know this so the next time you see me drinking heavily, you might be more inclined to buy me a beer.
Commenting is closed for this article.