sequelize.js - Sequelize - 引用相同表主键的外键

Question

是否可以在Sequelize模型语法中构建以下内容？您想要嵌套数据的用途。

CREATE TABLE Data
(
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    ...
    `parentId` INT,
    FOREIGN KEY(parentId) REFERENCES Data(id)
);

编辑:是的

const Data = sequelize.define('Data', {
    id: {
        type: Sequelize.INTEGER,
        primaryKey: true,
        autoIncrement: true,
    },
})

Data.belongsTo(Data, { foreignKey: 'id' });

Answer 1

看来你可以!

const Data = sequelize.define('Data', {
    id: {
        type: Sequelize.INTEGER,
        primaryKey: true,
        autoIncrement: true,
    },
})

Data.belongsTo(Data, { foreignKey: 'id' });