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 cake-php@googlegroups.com
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
-~--~~~~--~~--~--~---