Laravel - how to use foreign primary key that's not an integer?

Question

I'm trying to set a string column as a primary key of a table, then reference that from another table as a foreign key. Is this possible? Per the documentation:

Laravel assumes every table has a numeric primary key (usually named “id”) and ensures the value of this column is unique for each new row added to the table. Laravel doesn’t really work well unless each table has a numeric primary key. So, for your average Laravel application, please ensure that you define a primary key using the increments() method.

In my case, I don't want to define an id column as it would be useless. The string column I want to define will act as a primary key. If this is possible, can I get an example migration snippet?

Answer 1

This is an old question, but for the sake of correctness I'd like to point out that in the current versions of Eloquent you can indeed use non numeric primary/foreign keys.

One thing you need to do is to set the property $incrementing to false on the models that use non autoincrementing ids.

class Employee extends Model
{
    public $incrementing = false;

    // ...
}

also, the migration can be something like this:

Schema::create('employees', function (Blueprint $table) {
    $table->string('id')->primary();
    // ...
});