Re: a complex data model- a cakephp breakthrough?

2008-09-20 Thread Michael
This is an example of a classic sub-type entity. As was previously stated add all your common attributes to the parent table. Performing an inner join on your foreign key between the parent and sub-type entities will limit the result set to just the specific sub-type you are interested in (i.e.

Re: a complex data model- a cakephp breakthrough?

2008-09-19 Thread Delian
Hi, I think that can be achieved by adding this attribute to the parent model instead. Then all your models will inherit this property. 2008/9/18 Joe <[EMAIL PROTECTED]> > > Sounds like something that could be easily handled with EAV modeling. > I wrote about it awhile ago. http://blog.joebeeson

Re: a complex data model- a cakephp breakthrough?

2008-09-18 Thread Joe
Sounds like something that could be easily handled with EAV modeling. I wrote about it awhile ago. http://blog.joebeeson.com/?p=30 There are plenty of other sources of good information on the topic. With EAV you keep the number of tables small and it's still pretty fast with smart indexing while

Re: a complex data model- a cakephp breakthrough?

2008-09-18 Thread villas
Hi bMilesp, If I understood your requirement correctly, it sounds like a good starting point would be for you to search on 'polymorphic'. On Sep 18, 3:49 am, bMilesp <[EMAIL PROTECTED]> wrote: > This is an interesting problem that i believe can have a reasonable > solution using cakephp. i'm no

a complex data model- a cakephp breakthrough?

2008-09-17 Thread bMilesp
This is an interesting problem that i believe can have a reasonable solution using cakephp. i'm not going to get into the background, but it stems from this idea: http://fornicode.com/2008/03/18/cakephp-a-has-either-association/ now for the business. my current company has a custom built CMS an