On Thu, Aug 5, 2010 at 6:19 AM, keymaster <[email protected]> wrote:
> The context is a standard ecommerce platform.
>
> A Country hasMany States.
> Some Countries have no States.
> A Region can be made up of either:
> 1. entire Countries, or
> 2. States within a Country.

I suggest you use only the 2nd definition. If you use the 1st then you
might as well also say that several countries together can make up a
region. And then, some countries may be part of two regions (Turkey?)
which, obviously, is getting far too strange.

I recently worked on an app where new members can only reside in
either the US or Canada, and I needed to know state/province. I chose
to say that the latter was the Region within the Country. So, Member
belongsTo Country and Region.

Of course, this was further complicated by the fact that some existing
members live in Germany, Korea, and Japan, but that's a whole other
story. Gotta love edge cases!

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en

Reply via email to