Hello all.I am learning and doing projects on PHP.While designing database i often come into situation where i need to join more than two tables.for example i have tables 1.users 2.works 3.certificates 3.exams
users HBTM works and works HBTM users.so i created users_works table.but the problem is that users_works can have many certificates and exams.so i created table user_works like 1.id 2.user_id 3.work_id 4.certificate_id 5.exam_id Is this right table for users_works table?or do i have to create another table for certificates and exams like users_work_certificates with 1.id 2.users_work_id 3.certificate_id I really don't know what will be database structure for this relationship.I have this kind of situation in many project.Please guide me to create right tables and relationship between these tables and relationship. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
