problem solution unify foreign key type. table.bigInteger('userid'); -> table.bigInteger('userid').unsigned(); // users migration file // roles mig