Foreign Key Between Not Primary Key.

[layn (Foros)]

Hello,

I have 2 tables: assistant and activity.

There is a realtion between both.

In table activity, there is a colum name “organizator_id” and a foreign key to “les_number” (in assistant table). But “les_number” isn’t the primary key of assistant table (I tell this because I don’t know if this could be the problem).

In assistant and activity model exist the relations:

Assistant:

'activities' => array(self::HAS_MANY, 'Activity', 'organizer_id'),

Activity:

'organizer' => array(self::BELONGS_TO, 'Assistant', 'fk_activity_organizer'),

My problem is in the activity view, in CDetailView array I try to show the organizator name instead of id:

'attributes'=>array(

  ...

  asistant.name,

  ...

But in the view I see "Not Set".

I check the foreign key in the db with this query:

mysql> select * from les01_activity join les01_assistant on les01_assistant.les_number=les01_activity.organizer_id where les01_assistant.id=1 \G;

*************************** 1. row ***************************

       id: 2

activity_type: 1

tournament: 1

activity_name: Soccer

description: Soccer game.

max_players: 4

     turn: 1

start_time: 2013-09-22 17:40:00

 end_time: 2013-09-21 20:00:00

organizer_id: 1

game_table: M23

    rules: 3 teams, 10min matchs.


       id: 1

les_number: 1

     name: Layn


 surnames: 


      dni: 


      age: NULL


   gender: 1


     mail: 

population:

     role: 9


    phone: NULL

insert_time: 2013-08-27 18:09:54

   status: 1

1 row in set (0.00 sec)

ERROR:

No query specified

Could be because I’m not using primary key in the foreign key ? Do you know how could I fix this ?

Thanks.

[nineinchnick (Janek Jan)]

Read the docs how to define relations():

In case you need to specify custom PK->FK association you can define it as array(‘fk’=>‘pk’).