How to define three way many to many relations using belongsToMany?

[Bruce Chou]

Hi all,

  I'm trying to create a database which contains a three way many to many to many relation. For example: A teacher gave a talk for a specific field at a meeting room. 

(Teacher, field and room are 3 standalone tables with primary key.)

I tried to create this relation by the following snippets:

1) Field.belongsToMany(models.Teacher , {through: 'TeachersGiveTalksAtRooms'});

    Field.belongsToMany(models.Room, {through: 'TeachersGiveTalksAtRooms'});

2) Room.belongsToMany(models.Field, {through: 'TeachersGiveTalksAtRooms'});

    Room.belongsToMany(models.Teacher, {through: 'TeachersGiveTalksAtRooms'});

3) Teacher.belongsToMany(models.Room, {through: 'TeachersGiveTalksAtRooms'});

    Teacher.belongsToMany(models.Field, {through: 'TeachersGiveTalksAtRooms'});

However, only two of the relations (Teacher & Field ) show up in the result table. Could anyone help? Thanks.

[Mick Hansen]

We don't currently support >= 3 N:M relations.
You'll have to manually maintain and include the join table.

--

Mick Hansen

@mhansendev
mhansen.io

[Bruce C. Chou (周敬程)]

ok I will do it manually. Thank you~