YII2. How to make settings for multiple cities?

Hello! You need to make the opportunity to make settings on site: change the site name, phone, Email, and so on. The site has several cities and clubs. Every city and club settings. I have two solutions to this:

1. Option. Instead of "value" to add the name of the city
5a3111353ef15893791461.png5a3111c7dc2bb047525830.png2. Make a settings table with a field city_id
To make a table config, where specify the city_id and club_id.

How can I improve? Or tell me your decision.
June 10th 19 at 15:29
1 answer
June 10th 19 at 15:31
Solution
id | city_name
id | club_name
id | setting_name | setting_type
id | setting_id | city_id | club_id | setting_value
Thank you! - jacquelyn_Nikolaus84 commented on June 10th 19 at 15:34

Find more questions by tags Yii