I am using Symfony2 for my application and using Doctrine .orm.yml files for relation mapping.
I have three entities as follows:
user entity which contains id(integer primary key), user_name(varchar)
portfolio entity which contains id(integer primary key), name(varchar), user_id (FK from user to identify who created the portfolio)
progress entity which contains id(integer primary key), progress_text(varchar)
My problem is that I am not aware how to set the many to many relationship among three entities i.e. Portfolio, User and Progress.
I want to set a relationship in a way such that the new table that gets created as a result of this relationship contains the below fields:
In the above list created_at, updated_at and type are the fields that I am using for some business rules purpose.
Please some body help me in writing their .orm.yml files. I understand that there are inbuilt commands in Symfony2 that generates entity and their corresponding .orm.yml files. But I am not aware how to write the above required relation in their corresponding file.