Creating a new record on an associated table needs first letter to be upper case (UserId)

[omarpr]

Hello everyone:

I'm working on a project using NodeJS 18, Sequelize (6.35.2) and Postgres (8.11.3) and I'm getting this weird behavior. But first, here are the models...

user.js

const { Model, DataTypes } = require('sequelize')
const { sequelize } = require('../db')

class User extends Model {
  toJSON() {
    return { ...super.toJSON(), password: null, confirmationCode: null } 
  }
}

User.init({
  firstName: {
    type: DataTypes.STRING,
    allowNull: false
  },
  lastName: {
    type: DataTypes.STRING,
    allowNull: false
  },
  email: {
    type: DataTypes.STRING,
    allowNull: false
  },
  password: {
    type: DataTypes.STRING,
    allowNull: false
  },
  confirmationCode: {
    type: DataTypes.STRING,
    allowNull: false
  },
  state: {
    type: DataTypes.STRING,
    defaultValue: 'pending',
    allowNull: false
  }
}, {
  sequelize,
  underscored: false
})

module.exports = {
  User
}

user_reset_token.js

const { Model, DataTypes } = require('sequelize')
const { sequelize } = require('../db')
const { User } = require('./user')

class UserResetToken extends Model {

}

UserResetToken.init({
  token: {
    type: DataTypes.TEXT,
    allowNull: false
  },
  expiresIn: {
    type: DataTypes.DATE,
    allowNull: false
  },
  state: {
    type: DataTypes.STRING,
    defaultValue: 'active',
    allowNull: false
  }
}, {
  sequelize,
  underscored: false
})

UserResetToken.belongsTo(User)

module.exports = {
  UserResetToken
}

And then, I create the UserResetToken record like this:

const createUserResetToken = async userId => {
  // I'm sure there are better ways of generating this token but, let's start with this for now.
  const token = uuidv4()
  const expiresIn = new Date()

  expiresIn.setMinutes(expiresIn.getMinutes() + 30)

  const userResetToken = await UserResetToken.create({
    UserId: userId,
    token,
    expiresIn,
    state: ACTIVE
  })

  return userResetToken.id ? token : false
}

Notice the UserId with the capital U. If I try doing userId, I get the record with a null value in the column.

I would love to do all of this just using camelCase, I also tried using underscored: true but the problem persists.

Any ideas?

[ephys]

In Sequelize 6, foreign key attributes are prefixed by the target model name, so usually is capitalized. You can use a custom name like this: https://sequelize.org/docs/v7/associations/belongs-to-many/#foreign-keys-names

In Sequelize 7, we make the generated foreign key camelCase instead of PascalCase

[omarpr]

I tried before using foreignKey with no success. I'm going to take a peak on v7 :)

Thanks!