Sails-Many-to-Many through

_info.md

An example on how to setup Many-to-Many relationships through a junction table with it's own model definition, enabling individual attributes and filtering on the relationship.

app.js

module.exports = {

	attributes: {
  
    [ ... ]
	
		owners: {
			collection: "user",
			via: "apps",
			through: "team"
		}
		
		[ ... ]

	}
};

team.js

module.exports = {

	tableName: 'team',
	tables: [ 'user', 'app' ],
	junctionTable: true,

	attributes: {
		id: {
			primaryKey: true,
			autoIncrement: true,
			type: 'integer'
		},
		user: {
			columnName: 'user',
			type: 'integer',
			foreignKey: true,
			references: 'user',
			on: 'id',
			via: 'app',
			groupBy: 'user'
		},
		app: {
			columnName: 'app',
			type: 'integer',
			foreignKey: true,
			references: 'app',
			on: 'id',
			via: 'user',
			groupBy: 'app'
		},
		role: {
			type: "string"
		}
	}
};

user.js

module.exports = {

	attributes: {
  
    [ ... ]

		apps: {
			collection: "app",
			via: "owners",
			through: "team"
		}
		
	}
};