Sequelize -属于使用targetKey

const { Sequelize, DataTypes, Model } = require('sequelize');
const sequelize = new Sequelize('sqlite::memory:'); // 示例使用 SQLite 内存数据库

class User extends Model {}
User.init({
  username: DataTypes.STRING,
  email: DataTypes.STRING
}, { sequelize, modelName: 'user' });

class Profile extends Model {}
Profile.init({
  bio: DataTypes.TEXT,
  website: DataTypes.STRING
}, { sequelize, modelName: 'profile' });

// 定义一对一关联，使用 targetKey 指定 Profile 的主键
User.hasOne(Profile, { foreignKey: 'userId', targetKey: 'id' });
Profile.belongsTo(User, { foreignKey: 'userId', targetKey: 'id' });

(async () => {
  await sequelize.sync({ force: true });
  // 创建用户和个人资料
  const user = await User.create({ username: 'john_doe', email: 'john@example.com' });
  const profile = await Profile.create({ bio: 'Hello, I am John Doe.', website: 'john-doe.com', userId: user.id });

  // 查询用户及其个人资料
  const foundUser = await User.findOne({
    where: { id: user.id },
    include: [Profile]
  });
  console.log(foundUser.toJSON());
})();