[castlegloom]

I worked on a codebase with a similar address problem. Oh, and there were no primary keys. Instead, each row referred back to a separate table with four keyed initials.

Good database design upfront, and vigilant upkeep will keep the application layer tidier.