> Well, the supervisor has different behavior (Employee.is_supervisor =
> true), so, I'd see it as another entity and model.
> But, you can put this condition in the relationship declaration and
> use the same model.
>
True but if I have employee Bob who is a supervisor. Bob supervises
Tina, and Pete but Bob also has a supervisor, Sam.
In this scenario wouldn't Bob have to exist in both the Employee and
Supervisor tables? That would be duplicate data which is bad.
Sam (The boss)
|
Bob (middle manager)
/ \
Tina Pete (employees)
The following link describes a similar scenario, so this what I'm
trying to model:
http://groups.google.com/group/cake-php/browse_thread/thread/6fea193fdd352916/5997925ec651fe1a?lnk=gst&q=join+to+itself+join+table#5997925ec651fe1a
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
