Database comment table anti-pattern design – adjacency list, path enumeration, nested set, closure table, no best only best fit

type is the class of the region: 1: country, 2: province, 3: city, 4: district

When the level is relatively certain, there is no problem in designing the table in this way, and it is also very convenient to call.

This article is reprinted from: https://ldqk.xyz/2167
This site is for inclusion only, and the copyright belongs to the original author.