duanpao4172 2017-04-24 04:03
浏览 48
已采纳

Doctrine:不生成外键

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

?>
  • 写回答

1条回答 默认 最新

  • duan1979768678 2017-04-24 06:34
    关注

    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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 滑块验证码拖动问题悬赏
  • ¥15 Wanted but not invoked:Actually, there were zero interactions with this moc
  • ¥20 怎么驱动tb6612
  • ¥15 Arcgis 3D效果点要素
  • ¥15 在执行yolo训练脚本的时候,没有报错,在扫描val这一步后就推出执行了
  • ¥15 delphi开发的WEBSERVER改用HTTPS协议
  • ¥15 pic16f877A单片机的计数器proteus仿真失效
  • ¥100 调查 Vitis AI 中验证 .xmodel 量化后的正确性
  • ¥30 codelite全屏时file、setting那一行消失了
  • ¥15 gazebo-rviz教程