Sequelize关联报错：mst_rack与mst_part未关联问题排查

问题背景 #

运行代码时触发错误提示：mst_rack is not associated to mst_part!，需求是查询关联特定Rack的Part数据，以下是相关代码及报错堆栈：

RacksModel #

import { Sequelize } from "sequelize";
import db from "../config/Database.js";
import Parts from "./PartModel.js";

const {DataTypes} = Sequelize;
const Racks = db.define('mst_rack',{
    id: {
        type: DataTypes.INTEGER(11),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true,
        field: 'ID'
    },
    rack_no:{
        type: DataTypes.STRING(10)
    }, 
},{
  freezeTableName:true 
});

Racks.associate = function(models) {
    Parts.belongsTo(models.mst_rack, {foreignKey: 'id'});
}

export default Racks;

PartModel #

import { Sequelize } from "sequelize";
import db from "../config/Database.js";
import Racks from "./RackModel.js";

const {DataTypes} = Sequelize;

const Parts = db.define('mst_part',{
    part_no:{
        allowNull: false,
        type: DataTypes.STRING(10)
    },
    part_name:{
        allowNull: false,
        type: DataTypes.STRING(100)
    },
    part_uniq:{
        allowNull: false,
        type: DataTypes.STRING(100)
    },
    mst_rackId: {
        type: DataTypes.INTEGER(11),
        allowNull: false,
        references: {
        model: 'mst_rack',
        key: 'ID'
    },
        field: 'id_rack'
    }
},{
      freezeTableName:true
});

Parts.associate = function(models) {
    Racks.hasOne(models.mst_rack, {foreignKey: 'id',sourceKey: 'mst_rackId'});

}

export default Parts;

Part Controller #

import Parts from "../models/PartModel.js";
import Racks from "../models/RackModel.js"

export const getParts = async(req, res) => {
    try {
        const parts = await Parts.findAll({
            attributes:['id','part_no', 'part_name', 'part_uniq', 'id_rack'],
            include: [
                {model: Racks},
                {model: Racks, as: 'PartRack'},
            ]
    })
        res.json(parts);
    } catch (error) {
        console.log(error);
    }
 }

报错堆栈 #

at mst_part._getIncludedAssociation (D:!Develop\be-stock-opname\node_modules\sequelize\lib\model.js:565:13)
at mst_part._validateIncludedElement (D:!Develop\be-stock-opname\node_modules\sequelize\lib\model.js:502:53)
at D:!Develop\be-stock-opname\node_modules\sequelize\lib\model.js:421:37
at Array.map ()
at mst_part._validateIncludedElements (D:!Develop\be-stock-opname\node_modules\sequelize\lib\model.js:417:39)
at mst_part.findAll (D:!Develop\be-stock-opname\node_modules\sequelize\lib\model.js:1124:12)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async getParts (file:///D:/!Develop/be-stock-opname/controllers/Part.js:6:23)

错误分析 #

1. 关联关系颠倒：RacksModel中错误地让Parts.belongsTo(models.mst_rack)，belongsTo的主体应为Part（Part属于Rack），此写法导致关联注册逻辑混乱。
2. 关联配置错误：PartModel的associate中，Racks.hasOne(models.mst_rack)完全逻辑错误，应为Rack关联Part而非自身；同时外键、sourceKey映射混乱，未匹配数据库实际字段。
3. Controller关联不匹配：include中使用的PartRack别名未在模型关联中定义，且重复include Racks实例，Sequelize无法识别对应关联关系。

修复方案 #

1. 修正RacksModel的关联逻辑 #

正确定义Rack与Part的一对多关系：

Racks.associate = function(models) {
    // 一个Rack对应多个Part，若为一对一则替换为hasOne
    Racks.hasMany(models.mst_part, { foreignKey: 'mst_rackId', as: 'Parts' });
}

2. 修正PartModel的关联逻辑 #

定义Part属于Rack的关系，并配置正确的外键与别名：

// 先修正导入路径，确保与RacksModel文件名匹配（若文件名为RacksModel.js）
import Racks from "./RacksModel.js";

// ... 其余代码保持不变 ...

Parts.associate = function(models) {
    // Part属于Rack，外键为mst_rackId，对应Rack的id字段
    Parts.belongsTo(models.mst_rack, { foreignKey: 'mst_rackId', as: 'PartRack' });
}

同时确认mst_rackId字段的数据库映射准确性：

mst_rackId: {
    type: DataTypes.INTEGER(11),
    allowNull: false,
    references: {
        model: 'mst_rack',
        key: 'ID' // 对应Racks表的ID字段
    },
    field: 'id_rack' // 对应数据库中Part表的id_rack字段
}

3. 修正Controller的查询逻辑 #

只include已定义的关联，并使用正确别名：

export const getParts = async(req, res) => {
    try {
        const parts = await Parts.findAll({
            attributes: ['id','part_no', 'part_name', 'part_uniq', 'id_rack'],
            include: [
                { 
                    model: Racks, 
                    as: 'PartRack',
                    attributes: ['id', 'rack_no'] // 按需返回Rack字段，可选
                }
            ]
        });
        res.json(parts);
    } catch (error) {
        console.log(error);
        res.status(500).json({ message: error.message });
    }
 }

验证 #

启动服务后调用接口，即可正常返回关联对应Rack信息的Part数据，报错消失。

内容的提问来源于stack exchange，提问作者Firdan Mahendra Wardana