0

The table was created by Sequelize. Then I imported data into that table from an .sql file with Workbench.

Now Sequelize throws "Unknown column 'id' in 'field list'" when I try to create an entry.

'id' is defined in the table as the primary key:

MySQL workbench screenshot

Can I alter the table to get it to work with Sequelize?

Example of model:

var Record = sequelize.define("Record", {
        secondaryID: {
            type: DataTypes.UUID,
            allowNull: false,
            unique: true,
            autoIncrement: false
        },
        description: DataTypes.STRING(1024),
        title: DataTypes.STRING,
        documentType: DataTypes.STRING,
        /*About 80 variables of the STRING type*/
        });
Roy G
  • 901
  • 10
  • 25
markkazanski
  • 439
  • 7
  • 20

0 Answers0