'I tried to add self reference relationship using Sequelize

There is a table called employees and the employee id wants to self reference to the employee table when the employee has a team lead.

Team lead is also an employee. So how to self reference using Sequelize?

const Employee = sequelize.define("employee", {
id: {
  type: DataTypes.INTEGER,
  autoIncrement: true,
  primaryKey: true,
  allowNull: false,
},
first_name: {
  type: DataTypes.STRING(45),
  allowNull: false,
},
lead_role: {
  type: DataTypes.BOOLEAN,
  allowNull: false,
  defaultValue: false,
},
designation: {
  type: DataTypes.STRING(100),
  allowNull: true,
},
resignation_date: {
  type: DataTypes.DATE,
  allowNull: true,
},
lead_id: {
  type: DataTypes.INTEGER,
  allowNull: true,
},
});

this is my employee model associations

 Employee.associate = function (models) {
   Employee.hasOne(models.user, { foreignKey: "employee_id" });
   Employee.hasMany(models.leave_request, {
    foreignKey: "employee_id",
   });
   Employee.belongsTo(models.team, {
    foreignKey: "team_id",
   });
   Employee.belongsTo(models.team_manager, {
    foreignKey: "manager_id",
   });
   Employee.hasMany(models.attendance, {
    foreignKey: "employee_id",
   });
   Employee.belongsTo(models.employee, {
     foreignKey: "lead_id",
   });
   Employee.hasMany(models.employee, {
     foreignKey: "lead_id",
   });
 };



 


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source