Yii – Create a custom relation between two tables

To make a custom relationship between two tables in a model, it is possible to add an additional option in the relation in which one indicates which foreign key should be used with which field.

    public function relations()
    {
        return array(
            'nomRelation' => array(
                self::HAS_ONE,
                'otherTable,
                '',
                'on'=>'thisTable.fk_otherTable = otherTable.id'
            ),
        );
    }