September 10th, 2013
In my previous blog I explained how to handle the mythical "join tables with extra columns" in Doctrine 2. It comes down to _not_ creating a many-to-many association, but a one-to-many/many-to-one. But in the real world we usually treat this process a bit differently: We draw up a contract in which we specify the information that's needed, including the person and company it relates to.
September 6th, 2013
A _join table_ table (also know 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.