如何在sequelize中设置外键

const { Sequelize, DataTypes } = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql'
});

const User = sequelize.define('User', {
  // 定义User模型的属性
  name: {
    type: DataTypes.STRING,
    allowNull: false
  }
});

const Post = sequelize.define('Post', {
  // 定义Post模型的属性
  title: {
    type: DataTypes.STRING,
    allowNull: false
  },
  content: {
    type: DataTypes.TEXT,
    allowNull: false
  }
});

// 定义User和Post之间的关联关系
User.hasMany(Post, { foreignKey: 'userId' });
Post.belongsTo(User, { foreignKey: 'userId' });

sequelize.sync()
  .then(() => {
    console.log('Models synced to database');
  })
  .catch((error) => {
    console.error('Error syncing models to database:', error);
  });

// 创建一个用户
User.create({ name: 'John' })
  .then((user) => {
    // 创建一个帖子，并关联到该用户
    return Post.create({ title: 'Hello', content: 'World', userId: user.id });
  })
  .then((post) => {
    console.log('Post created:', post);
  })
  .catch((error) => {
    console.error('Error creating post:', error);
  });