开发者

Doctrine 2 join table + extra fields

开发者 https://www.devze.com 2023-01-30 05:14 出处:网络
I\'ve got two tables and a join table: \'staff\', \'classification\' and \'staff_classification\'. In the join table I\'ve got an extra boole开发者_StackOverflow中文版an field: \'showclassification\'.

I've got two tables and a join table: 'staff', 'classification' and 'staff_classification'. In the join table I've got an extra boole开发者_StackOverflow中文版an field: 'showclassification'. My annotation is as follows:

 /**
 * @ManyToMany(targetEntity="Staff", inversedBy="classifications")
 * @JoinTable(name="staff_classifications",
 *  joinColumns={@JoinColumn(name="staffid", referencedColumnName="id")},
 *  inverseJoinColumns={@JoinColumn(name="classificationid", referencedColumnName="id", unique=true)});
 */
  1. How do I add the extra field 'showclassifications' to the join table?
  2. How do I reference the field via DQL? E.g. What query would get all of a staff's classifications that are allowed to be shown?
  3. Do I place the above annotation in one class and a @ManyToMany annotation with no @joinTable in the other? E.g. @ManyToMany (targetEntity="Classification")?


You want an entity that describes the relationship (StaffClassifications), which has OneToMany relationships with both staff and classifications.

ManyToMany doesn't allow you have any "extra" properties, because the join table is not an entity, and thus can't have any properties.

0

精彩评论

暂无评论...
验证码 换一张
取 消