Sonic Baker wrote: > I was in the process of replying again to this last week but couldn't find a > suitable link to point you to, sorry. > I was going to suggest searching for the subtype/supertype database design > pattern. > Basically you have a supertype table which contains all attributes common to > all subtypes and only put the different unique fields of the other types in > the subtype tables (much like Scott has suggested above).
Thanks, for that idea too. FYI, I just now stumbled across the Propel project and found this in the documentation (main index is http://propel.phpdb.org/docs/user_guide/index.html) http://propel.phpdb.org/docs/user_guide/chapters/AdvancedObjectModel.html which seems to do OO over an RDBMS. Thanks to all who have replied, I need to do some thinking now! Allan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
