Custom fields for Laravel models. How to design a database?

Question

Database design

Let's say we have some models in our project: Article, news, comment, user. So, it became necessary to add custom fields to these entities (analogue of Custom fields in Bitrix). Each entity can have many and different types of fields (string, number, list, file, boolean).
What is the best way to design a database for such a case in order to make the most of Eloquent "relationships" and avoid "manual" queries?

Answer 1

I don’t know how Bitrix implemented this, but I think Entity–attribute–value model (EAV) will suit you .

Answer 2

Maybe NoSQL is better suited for such tasks? For example, try with Mongo, will it not hurt so much?
In general, such an architecture is very weak and poorly scalable.

Answer 3

if you have postgress - jsonb
If muscle - it seems there is something too, but I don't know.
jsonb in postgress works just as fast as nosql databases