Laravel relationship with single column - development

Laravel relationship with single column

I have a table called “fields”:

Schema::create('fields', function (Blueprint $table) {
    $table->increments('id');
    $table->string("label");
    $table->string("name")->unique();
    $table->text("options")->nullable();
    $table->timestamps();
});

I want to have another table which simply stores the ids of some of the fields. I will call this default_fields.

I basically want a relationship or logic that allows me to grab these default_fields like I would with any other relation:

Schema::create('default_fields', function (Blueprint $table) {
    $table->increments('id');
    $table->integer("field_id");
});

How can I create a relationship that grabs all the fields whose id’s are present in this table? I also want to be able to sync().

Would I just make a model for DefaultField and then do something like Field::whereIn('id', DefaultField::get()->pluck('id'))?

And then code my own sync() logic? Is there a super easy way to do this that I’m missing? I’d also like to be able to sort this like I would any other relation.

from Laravel Questions and Answers https://laravelquestions.com/php/laravel-relationship-with-single-column/
via Lzo Media