I'm working on designing the database schema and model for an application that involves Administrators, SalesPeople, Designers, Customers, etc. They all share common attributes such as firstname, lastname, email, phone, password, etc.
Traditionally, I've had a People table with the shared attributes, and other tables with the extended fields required for each of the Administrators, SalesPeople, Designers, Customers, etc. They have shared the same primary key as the table that they inherit from. I'm reading "Agile Web Development with Rails" to help me learn the MVC concepts better, and it suggests doing inheritance with a single table with a 'type' column and the extended fields for each of the specializations all in the People table. What is the best way to do this in the cake framework? I'm completely open for suggestions. If you have any good articles that you can point me to, that would be great. (I'll need some guidance on implementation either of these strategies, or a different stategy if needed.) Thanks, you all are great! Jimmy --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
