Doctine, Custom Join Table

Hi,

I’m currently studying Doctrine 2, but i’m a bit stuck at the moment, every method I’ve tried for the follow has resulted in a fail.

I have the following tables;

  • Models - Database table containing basic information such as manufacturer, etc.
  • Features - Database table containing generic vehicle features such as air con, abs, etc.

What I’m trying to do is to create a table where the models and features are associated with custom values like this;

+-------------+------------+---------+
| model_id    | feature_id | value   |
+-------------+------------+---------+
| 1           | 20         | 9       |
| 1           | 2          | Leather |
+-------------+------------+---------+

Every time I’ve tried, either the relationships have not worked, or I’ve ended up with a standard many:many table containing just model_id and feature_id.

Cheers

Michael

I’ve done it.
Every thing appears to work…

Cheers

I moved a post to a new topic: Doctrine, Issue with Custom Join Table