title: Unhandled rejection SequelizeForeignKeyConstraintError: insert or update on table
body: <p>I use sequelize-cli for migrations:</p>
  
  <p>My migration code:</p>
  
  <pre><code>module.exports = {
   up(queryInterface, Sequelize) {
     queryInterface.showAllSchemas({
       options: {},
     }).then((data) =&gt; {
       data.forEach(schema =&gt; queryInterface.addColumn({
         tableName: 'visitors',
         schema, // dynamic schemas coming from loop
       }, 'purposeId', {
         type: Sequelize.INTEGER,
         references: {
           model: 'purposes', // name of Target model
           key: 'id', // key in Target model that we're referencing
         },
       }));
     });
   },
  };
  </code></pre>
  
  <p>I have multiple schemas, inside that i have table called 'visitors', in that table i want to add column called 'purposeId' references from 'purposes' table.</p>
  
  <p>Migrations successfully done, also i got a purposeId column inside my 'visitors' table.</p>
  
  <p>But if i do crud operations inside 'visitors' table i am getting this error:</p>
  
  <p>Unhandled rejection SequelizeForeignKeyConstraintError: insert or update on table "visitors" violates foreign key constraint "visitors_purposeId_fkey"</p>
  
  <p>NOTE: I am using postgres.</p>