ok some more progress in getting this right, i uploaded my current db
table design at www.jpgalea.com/design.jpg and also my erm diagram at
www.jpgalea.com/erm.jpg
here are my model associations at the moment:
Listing
var $belongsTo = array('Module','Task');
Membership
var $belongsTo = array('Module','Role','User');
Module
var $hasOne = array('Review' )
var $hasMany = array('Membership','Listing');
Review
var $belongsTo = array('Module');
Role
var $hasMany = array('Task','Membership');
Task
var $hasMany = array('Listing');
var $belongsTo = array('Role');
User
var $hasMany = array('Membership','Listing');
im not sure if this is the correct way to do things however and given
that this is the first time i am using cake i would like to make sure
that everything is set up well
before i bake and continue modifying the system.
a description of what i am trying to achieve can be found at
www.jpgalea.com/system.doc
Basically apart from being unsure if this is a correct way to
associate models (which however seems to work pretty well) the only
problem i have is that I would like the task listing to be displayed
when a user is viewed, because every user has a number of tasks in one
or more module to perform, so the idea is to have a task list.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
