laravel custom primary key attributes

Question

I have made a custom primary key in Laravel. On my model

protected $primaryKey = ['profileId'];

public $incrementing = false;

Migration = $table->integer('profileId')->unsigned();

$table->primary('profileId');  

Is there use of making a custom primary key unsigned(). ?

Answer 1

you use unsigned() to have only positive values, since AUTO_INCREMENT starts at zero by default and increments in the positive direction, it's more convenient to utilize the positive values than the negative value.On your mogration file add:

$table->primary('profileId')->unsigned();

In case you want a string as primary key then;

$table->string('column', 30)->primary();   

and

public $incrementing = false;

Answer 2

In your migration when you are creating the table you can indicate the primary key with primary():

Schema::create('table', function (Blueprint $table) {
   $table->primary('profileId');  
});

If your primary key is a string you need to add to your model:

public $incrementing = false;

Answer 3

class UserVerification extends Model
{
protected $primaryKey = 'your_key_name'; // or null

public $incrementing = false;
}

Answer 4

As per the documentation, You can try below code if your primary key is a string:

$table->tinyInteger('profileId');
$table->primary('profileId');

And if you want it as auto increment you have to do something like this

$table->tinyInteger('profileId')->unsigned()->autoIncrement()‌​;