Cannot override `foreignKey` for hasMany using `through` setting

[sourcec0de]

As the title suggests

var Tag = schema.define('Tag', {
    name: String,
    parent_id: Number
}, {
    table: 'tags'
});

var Category = schema.define('Category', {
    name: String
}, {
    table: 'categories'
});

// Intersection Tables
var TagCategory = schema.define('TagCategory', {
    tag_id: Number,
    category_id: Number
}, {
    table: 'tag_categories'
});

// Relations
TagCategory.belongsTo(Tag);
TagCategory.belongsTo(Category);

Tag.belongsTo(Tag, {
    as: 'parent',
    foreignKey: 'parent_id'
});

Tag.hasMany(Category, {
    as: 'categories',
    through: TagCategory,
    foreignKey: 'tag_id'
})

Category.hasMany(Tag, {
    as: 'tags',
    through: TagCategory,
    foreignKey: 'category_id'
})

This results in table schema like this

• tags
  • name
  • parent_id
• categories
  • name
• tag_categories
  • tag_id
  • category_id
  • tagId
  • categoryId

[sourcec0de]

It automatically creates tagId and categoryId by default

[shaunc]

This is even worse if you want to have a many-to-many relationship between a table and itself: not only can't you control the names, but they are the same. :(

[taoyuan]

Any progress on this?