I had an error in Sequelize with a foreign key not matching a column name. Checking the DB, I saw that the column 'WokflowId' was named 'WorkflowID', so I changed the name in the Sequelize model.

It looks like this

'use strict';
const Sequelize = require('sequelize');
const sequelize = require('../util/database');

const WorkflowsAccessRights = sequelize.define('Workflows_AccessRights', {  
  id:{
    type: Sequelize.BIGINT,
    autoIncrement: true,
    allowNull: false,
    primaryKey: true
  },
  WorkflowID: Sequelize.BIGINT,
  GroupID: Sequelize.BIGINT,
  Enabled: Sequelize.INTEGER
},{
  timestamps: false,
  freezeTableName: true,
});

module.exports = WorkflowsAccessRights

But now that I changed the column name to get the right one, I get this error

Column names in each table must be unique. Column name 'WorkflowId' in table 'Workflows_AccessRights' is specified more than once.

Except that, no column has this name now... Did I miss something in the setup or is there a way to freeze the column name?