Doctrine：不生成外键

Question

The problem I have with doctrine is that after the

php bin/console doctrine:schema:update --force

it creates the DB but not the foreign keys. I'm using annotations and I tried to use the @ORM\JoinColumn in the ManyToOne ... etc annotations but without success.

I hope you guys can help me.

Here is the code of one of my entities:

<?PHP

namespace AppBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 * @ORM\Table(name="member")
 */
class Member{

/**
 * @ORM\Column(type="string",length=25)
 * @ORM\Id
 */
private $code;

/**
 * @ORM\Column(type="string",length=25)
 */
private $first_name;

/**
 * @ORM\Column(type="string",length=25)
 */
private $last_name;

/**
 * @ORM\Column(type="integer")
 */
private $national_id;

/**
 * @ORM\Column(type="string",length=25)
 */
private $civil_situation;

/**
 * @ORM\Column(type="string",length=1)
 */
private $gender;

/**
 * @ORM\Column(type="date")
 */
private $dob;

/**
 * @ORM\Column(type="integer")
 */
private $tel_mobile;

/**
 * @ORM\Column(type="integer")
 */
private $tel_home;

/**
 * @ORM\Column(type="integer")
 */
private $tel_ref;

/**
 * @ORM\Column(type="string",length=25)
 */
private $email;

/**
 * @ORM\Column(type="date")
 */
private $entry_date;

/**
 * @ORM\Column(type="string",length=64)
 */
private $password;

/**
 * @ORM\Column(type="integer",nullable=true)
 * @ORM\OneToOne(targetEntity="Staff")
 */
private $staff;

/**
 * @ORM\Column(type="integer",nullable=true)
 * @ORM\OneToOne(targetEntity="Student")
 */
private $student;

/**
 * @ORM\Column(type="integer")
 * @ORM\ManyToOne(targetEntity="Address")
 */
private $address;

/**
 * @ORM\Column(type="integer")
 * @ORM\ManyToOne(targetEntity="Faculty")
 */
private $faculty;

/**
 * @ORM\Column(type="integer")
 */
private $disable;

/**
 * @ORM\Column(type="string",length=25,nullable=true)
 */
private $disable_reason;

/**
 * @ORM\Column(type="integer",nullable=true)
 */
private $disable_year;

public function __construct()
{
    //nothing
}

// getters and setters

?>

Answer 1

When @ORM\Column is specified along with @ORM\JoinColumn on same column, then JoinColumn's association gets ignored and Foreign Key isn't created on table. so dont use both @ORM\Column and @ORM\JoinColumn in same column.

Do like below:

/**
*  @var Address
*
* @ORM\ManyToOne(targetEntity="Address")
* @ORM\JoinColumn(name="address_id", referencedColumnName="id", onDelete="CASCADE")
*/
private $address;

It makes column named address_id on database table, with foreign key index and on deletion of Address record, associated record in dependent table is also deleted(cascade operation). You may user other operation on onDelete, see doctrine's documentation.