'id' is the convention, so if you can stick to it you will make your life easier. If you really want to change the name of the primary key field you can set a model attribute: see http://book.cakephp.org/2.0/en/models/model-attributes.html#primarykey
You can easily create relations to multiple tables: see http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html. If a single model is associated with the same foreign table twice, you simple give the association a different name, for example User and Owner might both link to the users table and the User model. See http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#multiple-relations-to-the-same-model Jeremy Burns Class Outfit http://www.classoutfit.com On 18 Feb 2013, at 03:22:30, Anchita Dubey <[email protected]> wrote: > Hi, I am a beginner in cakePHP. I was in a situation where I had named my > tables in my database as 'tablename_id' and later I was advised to change all > the primary keys to just 'id'. Is it easier to have the primary key in > cakePHP named as simply id? Do I always need to go back and make changes at > database level to make it work in cakePHP? Also if there are associative > tables having foreign keys of two different tables then what could be done if > keys are named 'id'(with no prefix of tablename). Please advice. Thanks. > > > -- > Like Us on FaceBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/cake-php?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
