I am trying to create a multi-criteria rating system in CakePHP that is dynamic in the sense that I can go back and add new criteria to rate on later on without a bunch of code changing and altering of tables, etc. Here's what I've come up with on my own, but if someone has a better solution to tackling this, please, by all means, let me know :)
=ratings= id rating_types_id rating =rating_types= id name published created updated =service_types= id name published created updated (JOINING TABLE) =rating_service_types= (habtm) ratings_id service_types_id ================================= Essentially, each service type needs the same rating criterias. What I am trying to figure out is how to get everything connected properly or if I am just going abou this wrong? Also a bit off-topic, but could someone send me in the direction of some complex db design delimas and how they were solved in CakePHP for future reference? I just want to rip into SQL and handle this, but I'd rather try this thru the magic of Cake and I want to make sure I'm following the conventions. Oh and btw, the rating is going to just store a value from 1-5, it's not going to be a full on rating system for users to use. Thanks guys, Jake Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
