How to organize and store custom fields?

Question

MySQL

There is an entity, it can have N number of fields of different types and selects and text, etc.

Answer 1

Create a second table where you will store the ID of the parent entity, and the table entries themselves will be fields