How to link jsonb field to other tables?

Question

Laravel

The site has the ability to save the search,
when saving, the user id and json query string are written to the table, for example

{  
   "advert_status":1,
   "filter_models":{  
      "type_id":1,
      "adventure_state":1
   },
   "additionally_filter":{  
      "currency_id":1
   }
}

The task is to link, for example, filter_models->type_id by id with the types table through a one-to-one relationship

Answer 1

Look towards https://github.com/staudenmeir/eloquent-json-relations . In one of the projects, we set up connections like this.