php - How to design database fields in dynamic forms?

Question

I have a client who needs to do an annual review every year. The add page for the annual review is dynamic. Clicking an add button will add an annual review for one year. How do I design the fields in the database? Thanks

Answer 1

If the added attributes do not require conditional query, they can be encapsulated into JSON or other formats and saved in BLOB or TEXT.

Answer 2

You can consider making one record every year, so that the fields in the database do not need to be adjusted.