如何在自引用关联中强制执行外键约束？

假设最简单的例子：

var Person = sequelize.define('Person', {
  name: Sequelize.STRING,
});

Person.hasMany(Person, { as: 'Children', foreignKeyConstraint: true });

If we sequelize.sync这样，我们得到一个ChildrenPersons具有两列主键的连接表，由以下形式组成PersonId and ChildrenId，但没有外键：

CREATE TABLE `ChildrenPersons` (
  `PersonId` int(11) NOT NULL DEFAULT '0',
  `ChildrenId` int(11) NOT NULL DEFAULT '0',
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`PersonId`,`ChildrenId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

我怎样才能使PersonId and ChildrenId CONSTRAIN编辑外键，引用Persons.id ?

I tried 手动创建连接表 https://gist.github.com/mihai-rotaru/7233452#file-sequelize-self-referencing-js，但没有成功。

我不太熟悉sequelize，但我知道你可以使用它直接发出SQL查询和命令sequelize.query

因此，如果您只想创建具有外键约束的两个表，这里是适当的 SQL（请注意，这是 SQLite 方言 - 请注意缺少日期时间）

CREATE TABLE Persons(
    id integer primary key, 
    name text);
CREATE TABLE ChildrenPersons(
    personId integer not null, 
    childrenId integer not null, 
    createdAt integer not null,  
    updatedAt integer not null, 
    primary key(personId,childrenId), 
    foreign key(personId) references Persons(id), 
    foreign key(childrenId) references Persons(id));

我希望这有帮助

EDIT

以下代码将使用sequelize 行话创建表（已确认与sequ​​elize 1.7.9 一起使用）：

var Sequelize = require('sequelize'),
sequelize = new Sequelize('test','','',
            {
            dialect: 'sqlite',
                storage: 'test.db'
            })
var Person = sequelize.define('Person', {name: Sequelize.STRING})
var PersonChildren = sequelize.define('PersonChildren',
        {
            PersonId: {
                type: Sequelize.INTEGER,
                references: Person,
                referencesKey: 'id',
                primaryKey: true
            },
            ChildrenId: {
                type: Sequelize.INTEGER,
                references: Person,             
                referencesKey: 'id',
                primaryKey: true
            }
        })
sequelize.sync({force: true}).complete(function(err){
    if(!!err){
        console.log('Error: ',err)
    }else
    {
        console.log('All OK')
    }   
})

请参阅以下 Sequelize 文档文章来强制执行外键约束：http://sequelizejs.com/docs/latest/associations http://sequelizejs.com/docs/latest/associations