Hey Guys, I am creating a php app using the cakephp framework. I am a newbie with cakephp and understand the importance of having the correct model associations. I have done some searching on model association but am confused on how to apply the correct model relationships. Here is a brief summary on what my app will do: I have types of users: 1. Users and 2. Assessors.
1. Users login to the system and can search for Assessors. Users can select an Assessor and can only select one Assessor. If they want to select another Assessor then they need to first remove their current Assessor. Once the user selects an Assessor, their selected Assessor can create an Invoice that can be view my Users. Users can have multiple Invoices from their selected Assessor. 2. Assessor’s can login to the system and view list of users that have selected them. They can create Invoices for their users. So Assessor can create zero or many invoices for their users. 3. Invoice has two status: 1. Open and 2. Close, so when the Assessor creates an invoice for a particular user, the invoice has a status “Open” and when the user has paid, the invoice status changes to “Close” By applying normalization, I get four tables 1. Users 2. Assessors 3. Invoices and 4. Statuses. Could someone plz guide me on what would be the correct relationships between these tables. Thanks, Ket Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" 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 To unsubscribe, reply using "remove me" as the subject.
