Doctrine 2: How to handle join tables with extra columns

properties doctrine-orm many-to-many jointable
Jasper N. Brouwer picture Jasper N. Brouwer · Sep 6, 2013 · Viewed 22.7k times · Source

How do I setup a join table with extra columns, or a many-to-many association with additional properties, in Doctrine 2?

Answer

Jasper N. Brouwer picture Jasper N. Brouwer · Sep 6, 2013

First off, let me explain that this does not exist:

A join table (also known as a junction table or cross-reference table) is a table that links 2 (or more) other tables together within the same database by primary key. This means that a join table will only contain foreign keys, there is no place for these extra columns.

So when you need extra columns in such a table, it is no longer just a "link" between other tables, but becomes a real table on its own!

In terms of Doctrine 2, you no longer have a many-to-many association between 2 entities, but get a one-to-many/many-to-one association between 3 entities.

Continue reading here for more details explanations:

Related questions

What is the { get; set; } syntax in C#?

I am learning ASP.NET MVC and I can read English documents, but I don't really understand what is happening in this code: public class Genre { public string Name { get; set; } } What does this mean: { get; set; }?

Read More
Sorting object property by values

If I have a JavaScript object such as: var list = { "you": 100, "me": 75, "foo": 116, "bar": 15 }; Is there a way to sort the properties based on value? So that I end up with list = { "bar": 15, "me": 75, "you": 100, "foo": 116 };

Read More
Get property value from string using reflection

I am trying implement the Data transformation using Reflection1 example in my code. The GetSourceValue function has a switch comparing various types, but I want to remove these types and properties and have GetSourceValue get the value of the property …

Read More