The structure of the base of settlements?

Question

MySQL

Good afternoon, I am creating a bulletin board on Laravel, working on a database of settlements, I want my service to be able to search by settlements (for example, by region, district or by a specific city), at the moment my database looks like this : id--name--parent_id--slug. Is there anything else that needs to be added to the database to organize a search for specific settlements in the future site?

Answer 1

Add for future uses such as coordinates, population, and area code.
But didn’t you think to use the Google or Yandex service?

Answer 2

What is it for you? There is FIAS .

Answer 3

u92.yellow.elastictech.org here is the laravel board. Of course, it is not finished, but I took populated points from VK when I did it. But then I also made a control option through the admin panel.