association-in-sequelize-test1.user.js

const { DataTypes, Model } = require("sequelize");

const Role = require("./role");
const sequelize = require("../sequelize");

class User extends Model {
  static col = {
    id: "id",
    name: "name",
    roleId: "roleId",
  };
  static alias = {
    role: "UserRole",
  };
}
User.init(
  {
    [User.col.id]: {
      type: DataTypes.UUID,
      primaryKey: true,
      defaultValue: DataTypes.UUIDV4,
    },
    [User.col.name]: DataTypes.STRING,
    [User.col.roleId]: {
      type: DataTypes.UUID,
      references: { model: Role, key: Role.col.id },
    },
  },
  {
    sequelize: sequelize.getSeq(),
  }
);
User.belongsTo(Role, {
  as: User.alias.role,
  foreignKey: User.col.roleId,
});
Role.hasMany(User, {
  as: Role.alias.user,
  foreignKey: User.col.roleId,
});

module.exports = User;