我在做三张table;书籍表、作家表、书籍类型表。
我试图约束books表中的3个外键作者ID、作者姓名和流派名称。
一旦我为它编写了代码，它在我的数据库中看起来很好，但laravel给了我一个错误，我感到困惑：

SQLSTATE[HY000]：一般错误：1005无法创建表test.books（错误号：150“Foreign key constraint is incorrectly formed”）（SQL：alter table books add constraint books_writer_name_foreign外键（writer_name）references writers（name）on delete cascade on update cascade）

图书桌

public function up()
    {
        Schema::create('books', function (Blueprint $table) {
            $table->id();
            $table->string('name');

            $table->unsignedBigInteger('writer_id');
            $table->foreign('writer_id')->references('id')->
            on('writers')->onUpdate('cascade')->onDelete('cascade');

            $table->string('writer_name');
            $table->foreign('writer_name')->references('name')->
            on('writers')->onUpdate('cascade')->onDelete('cascade');

            $table->string('genre_name');
            $table->foreign('genre_name')->references('name')->
            on('book_genres')->onUpdate('cascade')->onDelete('cascade');

            $table->timestamps();
        });
    }

书写者表

public function up()
    {
        Schema::create('writers', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->timestamps();
        });
    }

图书类型表

public function up()
    {
        Schema::create('book_genres', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->timestamps();
        });
    }