Hi All, Sorry to bump this aold question up. But I wonder if, for specific extra collumns like Doctrine1.x added by behaviours, (e.g. createdAt, createdBy) there is any way to add them by annotated configs in the ManyToMany..
Thanks! El martes, 1 de noviembre de 2011 19:25:10 UTC-3, FMaz escribió: > > Hi everyone, > > We're having a lot of tables with Many to Many relation, and extra > columns. An quick easy example could be: > > table person: > - id > - name > > table email: > - id > - email > > table contact: > - person_id > - email_id > - type > > =========== > - "move 'type' in the email table": > I've used an easy to understand example. > type is not in the email table because other table link to email, but > without type, or with different type, or with differents columns, > anyway, the example is a simple one ;) ) > =========== > > So basically, we're scrambling 2 things into one: > - the relation. > - a specification of the relation. > > From a relational perspective, it's a great solution as it avoid us to > create a contact table, and 2 extra relations tables ( person to > contact, contact to email, and possibly person to email ). Not to > mention that this kind of solution would increase the number of JOIN > required in the application, and could/would have a negative impact on > performances. > > So have you encoutered similar problems; if so what were the good > solutions that worked for you ? > Thanks for sharing your experience. > > Ps.: We're using Doctrine 2. > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
