How to create a many to many relationship with extra columns in jhipster?

Question

The jhipster doesn't support create many to many relationships with extra fields.

What is the best way to create many to many association with extra columns in jhispter? Should i create a two one-to-many relationship with extra fields?

Answer 1

Using JHipster Domain Language (JDL), a @ManytoMany holding extra properties (columns) can be easily achieved using an association entity and two ManyToOne relationships. See below:

entity Foo{
    ...
}

entity Bar{
    ...
}

entity FooBarAssociation{
    extraProperty1 String
    extraProperty2 String
    ...
}

relationship ManyToOne {
  FooBarAssociation{foo} to Foo{bars}
  FooBarAssociation{bar} to Bar{foos}
}