My request SQL fail when I try to insert data in my table PostVotes I use sequelize migration to migrate my database and I have the same probleme when I make my sql request in my console.

sequelize db:migrate

When I use sequelize.sync() i don't have this problem

My table:

/* TABLE Users */
  queryInterface.createTable('Users', {
    id: {
      allowNull: false,
      primaryKey: true,
      type: Sequelize.UUID,
      defaultValue: Sequelize.UUIDV4,
    },
    password: {
      type: Sequelize.STRING,
      allowNull: false,
    },
    email: {
      type: Sequelize.STRING,
      allowNull: false,
      unique: true,
    },
  }),
  queryInterface.createTable('Posts', {
    id: {
      allowNull: false,
      primaryKey: true,
      type: Sequelize.UUID,
      defaultValue: Sequelize.UUIDV4,
    },
    title: {
      type: Sequelize.STRING,
      allowNull: false,
    },
    userId: {
      type: Sequelize.UUID,
      primaryKey: true,
      onDelete: 'CASCADE',
      references: {
        model: 'Users',
        key: 'id',
      },
    },
  }),

  /* Table posts votes*/
  queryInterface.createTable('PostVotes', {
    id: {
      allowNull: false,
      primaryKey: true,
      type: Sequelize.UUID,
      defaultValue: Sequelize.UUIDV4,
    },
    vote: {
      // eslint-disable-next-line new-cap
      type: Sequelize.ENUM('up', 'down'),
      validate: {
        isIn: [['up', 'down']],
      },
      allowNull: false,
    },
    userId: {
      type: Sequelize.UUID,
      primaryKey: true,
      onDelete: 'CASCADE',
      references: {
        model: 'Users',
        key: 'id',
      },
    },
    postId: {
      type: Sequelize.UUID,
      primaryKey: true,
      onDelete: 'CASCADE',
      references: {
        model: 'Posts',
        key: 'id',
      },
    },
  }),

[Error: SQLITE_ERROR: foreign key mismatch - "PostVotes" referencing "Posts"]

I already find answer but nothing is working. I think my mistake is in the table PostVotes but I don't understand what.

Thanks !