Using Laravel schema builder and migrations

Question

I am new to Laravel PHP framework. I am confused with how Laravel schema builder and migrations work. I created two tables using Laravel migrations. Below are my two tables:

public function up()
    {
        Schema::create('hotels', function(Blueprint $table)
        {
            $table->increments('id');
            $table->integer('hotel_id');
            $table->string('name');
            $table->string('address')->nullable();
            $table->string('city')->nullable();
            $table->string('province')->nullable();
            $table->string('country')->nullable();
            $table->timestamps();
        });
    }

This is my other table:

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

My question is how can can I make relations with two tables using Foreign keys? If I have to use Schema Builder where do I have to put the schema file?

Antonio Carlos Ribeiro · Accepted Answer · 2013-12-04 18:53:31Z

1

You can do it in the very same migrations, using Schema Builder. This is how you create a foreign key using migrations:

public function up()
{
    Schema::create('rooms', function(Blueprint $table)
    {
        $table->increments('id');

        $table->integer('hotel_id');

        $table->string('name');

        $table->foreign('hotel_id')
              ->references('id')
              ->on('hotels')
              ->onDelete('cascade');

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

edited Dec 4, 2013 at 18:53

answered Dec 4, 2013 at 18:10

Antonio Carlos Ribeiro

87.9k22 gold badges220 silver badges205 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

hasib32 Over a year ago

I am tried use your way. I am getting this errors: [Exception] SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'hotel_id' doesn't exist in table (SQL: alter table rooms add constraint rooms_hotel_id_foreign foreign key (hotel_id) references hotels (id) on delete cascade) (Bindings: array ( ))

hasib32 Over a year ago

so I have to create the column first then add the foreign key ?

Antonio Carlos Ribeiro Over a year ago

Yes, but you can make it in the same migration. The foreign key is just a constraint + index.

Collectives™ on Stack Overflow

Using Laravel schema builder and migrations

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related