No puedo ejecutar mi comando de migración debido a este error:

SQLSTATE[HY000]: Error general: 1215 No se puede agregar la restricción de clave externa (SQL: alterar la tabla user_schools agregar restricción user_schools_school_id_foreign clave externa ( school_id ) hace referencia a schools ( id ) en la cascada de eliminación)

Código

users

 Schema::create('users', function (Blueprint $table) { $table->uuid('id')->primary(); $table->string('name'); $table->string('email')->unique(); $table->timestamp('email_verified_at')->nullable(); $table->string('password'); $table->rememberToken(); $table->softDeletes('deleted_at', 0); $table->timestamps(); });

schools

 Schema::create('schools', function (Blueprint $table) { $table->uuid('id')->primary(); $table->string('code')->unique(); $table->string('name'); $table->set('type', ['TK', 'SD', 'SMP', 'SMA', 'SMK']); $table->softDeletes('deleted_at', 0); $table->timestamps(); });

user_schools

 Schema::create('user_schools', function (Blueprint $table) { $table->uuid('id')->primary(); $table->foreignId('school_id')->constrained('schools')->onDelete('cascade'); $table->foreignId('user_id')->constrained('users')->onDelete('cascade'); $table->set('type', ['Manager', 'Staff', 'Teacher', 'Student']); $table->softDeletes('deleted_at', 0); $table->timestamps(); });

NOTA: Mis archivos de migración se basan enla documentación de laravel, pero recibo este error.

¿Alguna idea?