Sequelize Migration NodeJS

user_13840116 0
Viewed 56

I'm new to the sequelize and migrations. I want to take a foreign key from another table but I'm doing it wrong and I don't know why.

Any suggestions, please?

  *module.exports = {
  up: async (queryInterface, Sequelize) => {
    return queryInterface.createTable('comments',{
      topicid : {
        type:Sequelize.INTEGER,
        foreignKey : true
      },
      commentid : {
        type : Sequelize.INTEGER,
        primaryKey:true,
        autoIncrement:true,
      },
      comment : {
        type : Sequelize.STRING
      }
    })
  },

  down: async (queryInterface, Sequelize) => {
    /**
     * Add reverting commands here.
     *
     * Example:
     * await queryInterface.dropTable('users');
     */
  }
};*
sequelize.js node.js
1 Answers
'use strict';
module.exports = {
  up: (queryInterface, Sequelize) => {
    return queryInterface.createTable('comments', {
      commentid: {
        autoIncrement: true,
        primaryKey: true,
        type: Sequelize.INTEGER
      },
      topicid: {
        foreignKey: true,
        references: {
          model: '<name_of_the_model>',
          key: '<name_of_the_key>'
        },
        type: Sequelize.INTEGER
      },
      comment: {
        type: Sequelize.STRING
      }
    });
  },
  down: (queryInterface, Sequelize) => {
    return queryInterface.dropTable('Products');
  }
};
user_97335460
Related