Hi there, I have really a great problem designing one part of my mysql db.
I need a join table in my db with three foreign keys, or three habtm relations. I already have three tables for three entities, each with primary key. And it is definetly necessary for me to have a join table with all three primary keys as foreign keys. Let me show you: Entity1 ---------- PK1 , Entry Entity2 ---------- PK2, Entry Entity3 --------- PK3 Entry Join Table ---------- PK, FK1, FK2, FK3 How can I bake such a table? I found nothing about naming conventions about this issue. Should I call the table "entities1_entities2_entities3" ??? I really found no hint in all the documentation, bakery, etc... I would appreciate every help. Regards, Robert --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
