That's right, Nested Set is the way to go. Both Propel and Doctrine support them.
Regards, Christopher. Von: symfony-users@googlegroups.com [mailto:symfony-us...@googlegroups.com] Im Auftrag von Arnold Ispan Gesendet: Sonntag, 5. September 2010 21:31 An: symfony-users@googlegroups.com Betreff: Re: [symfony-users] [symfony1.4] not sure how to make parent-child category structure in doctrine schema Hello, Why don't use nested sets to represent this structure? On Sun, Sep 5, 2010 at 9:39 PM, ryr <ryr1...@gmail.com<mailto:ryr1...@gmail.com>> wrote: Hello, I want to make a two-tier structure of the categories in which each item is either a parent of, or relate to one of the parents. Example structure: Category 1 - Subcategory 1 - Subcategory 2 - Subcategory 3 Category 2 Category 3 - Subcategory 4 - Subcategory 5 Category 4 How to implement this in config/doctrine/schema.yml? -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com<http://symfony-project.com> You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com<mailto:symfony-users@googlegroups.com> To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com<mailto:symfony-users%2bunsubscr...@googlegroups.com> For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en