How to setup Class Table Inheritance to tables with different ID-columns' names in Doctrine 2?

Question

I have a table person with id as identifier column and a tables student with person_id as PRIMARY KEY. The column student.person_id references (FOREIGN KEY) the person.id.

There are accordingly three classes: An abstract class Person with a member id and its sub-classe Student without any "identifying property".

I'm trying to define the Class Table Inheritance for this structure:

Person

use Doctrine\ORM\Mapping as ORM;
/**
 * Parent
 *
 * @ORM\Table(
 *     name="person"
 * ),
 * @ORM\Entity
 * @ORM\InheritanceType("JOINED")
 * @ORM\DiscriminatorColumn(name="type", type="string")
 */
abstract class Person
{
    /**
     * @var integer
     *
     * @ORM\Column(name="id", type="integer", nullable=false)
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="IDENTITY")
     */
    private $id;
}

Student

use Doctrine\ORM\Mapping as ORM;
/**
 * Student
 *
 * @ORM\Table(name="student")
 * @ORM\Entity
 */
class Student extends Person
{
}

But when I try to retrieve the objects

$testRepo = $entityManager->getRepository(Student::class);
$entities = $testRepo->findAll();

I'm getting an exception. The Problem is, that Doctrine assumes, the identifying column for the tables students to have the name id and build a SELECT statement like this:

SELECT t1.id AS id_2,
       t1.... AS ..._3,
       ...
FROM student t0
INNER JOIN `person` t1 ON t0.id = t1.id

instead of

SELECT t1.id AS id_2,
       t1.... AS ..._3,
       ...
FROM student t0
INNER JOIN `person` t1 ON t0.person_id = t1.id

and runs into the error

Error Code: 1054
Unknown column 't0.id' in 'on clause'

For a new system the simplest and cleanest way might be to rename the student.person_id column. But I'm currently migrating an existing system to Doctrine 2 and would like to let so much as possible as it is, so long the migration is not yet completed.

How to define a Class Table Inheritance in Doctrine 2 by using different column names for the identifier of the parent and the identifier of the child table(-s)?

Answer 1

(Posted solution on behalf of the OP).

Since I urgently needed a solution for this problem, I resolved it (or better: went around) by renaming of the identifier column to id.