Database and Model Design for HABTM

Hi,

I am still a Cake newbie, but maybe someone give me a hint on my
issue. I am trying to learn cake by developing a recipe site.

There are Maincategories and Subcategories.
F.e.

BBQ -> (Pork, Beef, Vegetarian)
Main Dish -> (Vegetarian....)

A recipe can belong to different Categories, so a "Steak" could show
up under "BBQ" and "Main Dish" and there under Beef.

I'm planing to have a Form which reads out the Maincategories from the
DB and when you click on a checkbox, the subcategories should show up
(AJAX Request?)

I have been thinking about the DB Design now for a while and thought I
first had a solution. Than I got doubts and re-designed the tables and
the models. I am now rather confused if this design is correct and
would hope that someone could give some feedback. Okay, here the
tables:
===================
maincategories *** this table is filled manually
- id
- maincategory
===================
subcategories *** this table is filled manually
- id
- subcategory
- maincategory_id
===================
recipes_subcategories ** this will be filled in when Add Recipe Form
was send off
- id
- subcategory_id
- recipe_id
===================
recipes ** this will be filled in when Add Recipe Form was send off
- id
- recipename
===================

My Models:

====== Recipe Model
=======================================================
class Recipe extends AppModel {
var $name = 'Recipe';
var $belongsTo = array(
'User' => array(
'className'
=> 'User'
)
);

var $hasAndBelongsToMany = array(
'Subcategory'
=>

array(

'className' => 'Subcategory',

'joinTable' => 'recipes_subcategories',

'foreignKey' => 'recipe_id',

'associationForeignKey' => 'subcategory_id'
)
);

============================================================================

====== Subcategory Model
=======================================================
class Subcategory extends AppModel {
var $name = 'Subcategory';
var $belongsTo = array('Maincategory');
var $hasAndBelongsToMany = array(

'Recipe' =>

array(

'className' => 'Recipe',

'joinTable' => 'recipes_subcategories',

'foreignKey' => 'subcategory_id',

'associationForeignKey' => 'recipe_id'
)
);
}

Is this setup correct or any advice how it should look instead? Thanks
a lot in advance.

--~--~---------~--~----~------------~-------~--~----~
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 cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---