I am not sure how to proceed for my database schema and for my model associations, any help will be appreciated!!!
Okei, here it goes;
Model 1 : Post (id, title, category_id, tag_id, body, created, modified) Model 2 : Category (id, title, description, created, modified) Model 3 : Tag (id, title, description, created, modified)
Mu problem is how to "build" the database table to allow for multiple tags and categories, with associations.
Example: If Post 1 belongsTo category_id = 1, and hasMany Tag, tag_id: 1, 3, 8, 99 Example2: If Post 2 belongTo category_id = 1,5 and hasMany Tag, tag_id: 1, 8, 43
So basicly, I am not sure what schema to go with and the best practice to allow for multiple associations.
Any suggestions??
Thanks! -Tom