[EMAIL PROTECTED] wrote: > I guess my next question would be: can you somehow consolidate all of > the various jobs into a single 'Job' model? In otherwords, is there > anything so unique about each job that you couldn't represent each job > with the same model? If this is the case, you could simply give Person > a job_id, and things would work out nicely.
As it happens, this application is for managing the scheduling and logging of court interpreter activities, and there are 'people' involved with what I call 'events' in various ways. There are different subclasses of people: judges, prosecutors, courtroom support personnel, probation officers, interpreters. I've started calling these 'roles' (though not necessarily for ACL purposes) and each person record has a role_id, which I think is akin to the job_id you're suggesting. But the data fields that need to persist for a judge are different from those of an interpreter. E.g., for interpreters we actually need to store dates of birth and social security numbers for security clearances. So I want interpreters to have their own table, with each interpreter record having a parent in 'people' that stores the generic stuff like firstname, lastname. I thought this inheritance model was more elegant, more Object Oriented, than having several different tables that all have firstname, lastname etc columns in them. Now I am seeing the downside. > > Looking at the 'Judge' model you posted, it seems simple enough that it > could be represented by a single Job model -- I don't know if this is > totally accurate though, since you have no doubt omited code to save > space. Um, I didn't really omit much at all because I am still just playing and learning cake, so all these app files are very very short right now. > > Google ate my original response :( Sorry about that. I thought Google was infallible (-: Thanks again. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
