Setting custom column names for foreign Keys in Sequelize Node.js

Question

sequelize noobie here so sorry in advance. I am making some Table associations in my app between users posts and comments

Comments Model

import { DataTypes } from 'sequelize';


export const comment = (db) => {
  db.define('comment', {
    commentContent: {
      type: DataTypes.TEXT,
      allowNull: false
    }
  });
}

export const setModelRelationships = (db) => {
    const { user, post, comment } = db.models

    user.hasMany(post);
    user.hasMany(comment);

    post.belongsTo(user);
    post.hasMany(comment);

    comment.belongsTo(post);
    comment.belongsTo(user);
}

Checking my db comments has 6 columns:

if I want to give the postId a custom name such as: commentedOnPostId how can I do this with Sequelize?

Anatoly · Accepted Answer · 2022-04-23 14:44:07Z

1

You can use foreignKey option in associations like this:

post.hasMany(comment, { foreignKey: 'commentedOnPostId' });
comment.belongsTo(post, { foreignKey: 'commentedOnPostId' });

It's important to indicate the same foreignKey option value in both associations.

answered Apr 23, 2022 at 14:44

Anatoly

23.2k3 gold badges33 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Setting custom column names for foreign Keys in Sequelize Node.js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related