On Wed, 21 May 2008 11:44:05 -0700, Chris Travers wrote: > One thing that is remarkably hard to model relationally is address data. > In particular different places have different semantics. Some countries > have mail codes while some do not. Some places it makes sense to track > states and provinces while in some countries this doesn't make sense. And > this is not even trying to track things like street addresses in cities > like Managua.... > > So, I am wondering if we should track some additional data in the > application. For example, we could track which countries should require > states data, or we could simply keep with a minimal of not-null > constraints. > > What do people think?
What are the fields used by international express shipment companies? I would guess that set required for delivery has been standardized by these and EDI specs, etc. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
