How to store registration settings?

Question

Software design

I know that the question is already “hackneyed”, but I can’t decide for myself how to store the registration settings for events. Help!
There are activities. These events have different types of registrations: competition, battles, master class, and so on. Each of these registrations has configurable settings and default values:

• Registration start date
  
• Registration end date
  
• Cost calculator type
  
• Currency
  
• Maximum number of registrations
  
• Show registration list widget
  
• Show number of participants
  
• etc.
  

Registration settings are selected by the user or are used by default.
1. Where to store such data in MySQL or in noSQL?
2. How should such data be stored?
3. What should be the architecture if MySQL storage is used?
Perhaps somewhere there is a good article where the issue is analyzed based on various tasks. I would be very grateful for the links!

Answer 1

One table is the event itself with the date / currency and other garbage that is identical for everyone. Other table field id, title, type. The third with event id, settings field id, field value. https://designpatternsphp.readthedocs.io/en/latest...

Answer 2

in the database