CODEWITHSUNDEEP
phpcakephpdata-modeling
user350269
user350269

Reputation: 105

cakePHP data model with multiple foreign keys to same table

Based on cakePHP's data model conventions, to setup a foreign key I would specify a column with the source_table followed by an _id.

I have an accounts and an account_messages table. Now the complication arises when I need 2 foreign key references to the same accounts table. Specifically I need to keep track of the account_id in the TO field and the account_id in the FROM field on a message.

From the docs/bakery, I would specify account_id.. however what would I specify for the second reference?!?

Is this possible and still benefit from cakePHP's magic code?

Any insight would be appreciated.

Ry

Upvotes: 8

Views: 6514

Answers (1)

Sam D
Sam D

Reputation: 470

I usually will do something like having a to_id and a from_id and then use something like this

I think all that you need is in that link

HTH Sam

Upvotes: 11

Related Questions