Logic of region value change in website data

I don't know what kind of opinion you have on the change logic of region values in website data. Let's talk about my logic first: 1. Our website has the following Region value & nbsp;. for the indexing speed, all region values have their own values. & Nbsp; 1-China & nbsp; 1-logic of region value change in website data
I don't know what kind of good opinions you have on this.

Let's talk about my logic first:
1. Our website has the following Region values. for indexing speed, all region values have their own values.
1-China
1-Beijing
1-Chaoyang District
2-Haidian District
3 -...
2-Shanghai
3 -...
5-Guangdong
1-Guangzhou
2 -...
2-South Korea
3-Japan
4 -...

When editing information, the user selects three levels of region values from the country, province, and city.

Problem: The region information in China will change. This time Some data is difficult to update.
For example, a province merges three cities into a new city. Or delete a city. (Easy to add)

Is there a mature region value management method? Share:
------ Solution --------------------
The data in your example is of a finite classification.
Based on these characteristics, you can organize data in this way.
01 China
0101 Beijing
010101 Chaoyang District
010102 Haidian District
010103...
Shanghai 0102
0103...
0105 Guangdong
Guangzhou 010501
010502...
02 South Korea
03 Japan
The country code + zoning code (these all have the national standards of the corresponding country)