Thanks RyOnLife !! Finding a tag details from the suggested design by you, need to find from all tables so extra 4 SQL Join query will be perform
1. tags_users (tag_id, user_id) (SQL Join) 2. brands_tags (brand_id, tag_id) 3 products_tags (product_id, tag_id) 4 posts_tags (post_id, tag_id) Should I go ahead without worry abt SQL performance? Thanks On Oct 26, 4:14 am, RyOnLife <[EMAIL PROTECTED]> wrote: > I'm having some trouble with save/delete HABTM myself, but I can at least > help you on your table design. Following Cake conventions (plural, > lowercase, abc order) and assuming you want everything taggable, your join > tables would be: > > tags_users (tag_id, user_id) > brands_tags (brand_id, tag_id) > products_tags (product_id, tag_id) > posts_tags (post_id, tag_id) > -- > View this message in > context:http://n2.nabble.com/Tags-implementation-tp1376700p1377213.html > Sent from the CakePHP mailing list archive at Nabble.com. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
