Re: Primary key in cakePHP

'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 <sohamasmi@gmail.com> 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 cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.