douyong1885 2018-09-01 23:37
浏览 55
已采纳

Laravel - 它可能在表上添加外键,数据类型字符串是否未签名?

i have two table, table universitas and table fakultas

on schema table universitas like below

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

and table fakultas like below

public function up()
    {
        Schema::create('fakultas', function (Blueprint $table) {
            $table->increments('id');
            $table->string('nama_fakultas');
            $table->string('nama_universitas')->unsigned();
            $table->foreign('nama_universitas')->references('id')->on('universitas');
            $table->string('keterangan');
            $table->timestamps();
        });
    }

its possible if i use data type string and use unsigned?

when i executed with php artisan migrate, i get an Error

  • 写回答

1条回答 默认 最新

  • dongwei6457 2018-09-01 23:49
    关注

    The use of unsigned on a string makes no sense from a database perspective. The purpose of unsigned is to determine whether a numeric field can take negative values. For instance, a:

    $table->tinyInteger('foo');
    

    will create a database field that will take values between -128 and +128, whereas

    $table->tinyInteger('foo')->unsigned();
    

    will create a database field with the range 0 - 255

    The important thing with your foreign keys is that the datatype of the foreign key must match the datatype of the primary key of the other table, whether it is a number or a string.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 python提取.csv文件中的链接会经常出现爬取失败
  • ¥15 数据结构中的数组地址问题
  • ¥15 maya的mel里,怎样先选择模型A,然后利用mel脚本自动选择有相同名字的模型B呢。
  • ¥15 Python题,根本不会啊
  • ¥15 会会信号与系统和python的来
  • ¥15 关于#python#的问题
  • ¥20 oracle RAC 怎么配置啊,配置
  • ¥15 excel 日常使用中出现问题
  • ¥20 pdusession建立失败
  • ¥15 为什么mqtt接收不到数据?