Jump to:

3375 Posts in 999 Topics by 712 members

Data Model Questions

SilverStripe Forums » Data Model Questions » Many_to_many, additional information in the join table

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 982 Views
  • katja
    Avatar
    Community Member
    46 Posts

    Many_to_many, additional information in the join table Link to this post

    Hi,

    I have a many to many relationship between two DataObjects. So in the database I have a table called Object1_Object2 that stores the two IDs of each of the objects. Is there a way I can store in this table a description of the relationship between the two?

    And how can this be represented in a class?

    Can anybody point me in the right direction?

    Thanks,
    Katja

  • swaiba
    Avatar
    Forum Moderator
    1769 Posts

    Re: Many_to_many, additional information in the join table Link to this post

    I haven't used it, but I believe "many_many_extraFields" on DataObject is what you are looking for.

  • katja
    Avatar
    Community Member
    46 Posts

    Re: Many_to_many, additional information in the join table Link to this post

    Thanks for the quick reply! And from Bristol ;)

    That sounds like it's the right thing, I will look into that right now.

    P.S. Do you know any other SilverStripe people in Bristol? Maybe could meet up sometime?

    Thanks again,
    Katja

  • swaiba
    Avatar
    Forum Moderator
    1769 Posts

    Re: Many_to_many, additional information in the join table Link to this post

    Yar! there are three of us in the office and I know of one other freelancer who lives here - I'll bet there are more because of the number of web agencies here. I previously suggested a meet up (as I've been to the London meetups but they are quite a trip!) - so I am very interested to meet and discuss silverstripe

    Barry

  • katja
    Avatar
    Community Member
    46 Posts

    Re: Many_to_many, additional information in the join table Link to this post

    Yes, I've been to some of those, but not at the same time. I'll email ;)

    982 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.