laravel unique foreign key combination code example
Example 1: laravel unique multiple columns
$table->unique(['mytext', 'user_id']);
Example 2: composite unique between two columns laravel migration
public function up()
{
Schema::table('user_projects', function (Blueprint $table) {
$table->unique(["user_id", "project_id"], 'user_project_unique');
});
}
public function down()
{
Schema::table('user_projects', function (Blueprint $table) {
$table->dropUnique('user_project_unique');
});
}
Example 3: laravel set field unique
Schema::table('manufacturers', function($table)
{
$table->string('name')->unique();
});
Example 4: laravel rule unique where
'required|email|unique:company_users,email_address,NULL,id,company_id,' . $request->company_id