Maintenance address in the database



  • There's a database with addresses. I'm thinking about the structure. To date, there are tables: Like streets, streets, human settlements, human settlements. That's the question. Lenin's Prospect in Krasnoyarsk and Lenin's Prospect in Tomska are different things, so the Streets have to have these lines in the table?

    ID/Police/Typ Street/Imya

    1/1/1/Lenin

    2/2/1/Lenin

    Or do the street table not need a column for the Human Settlements, but instead make a separate communication table for the [Police Point] and Prospect Lenin will not be duplicated for each town?



  • It's completely different, and that's why they're gonna want to change the name of Lenin's Street to the Gun Dump, and you're going to get a lot of fun problems the street out of all the other cities.

    Well, you're gonna have to take good account of the "story" because some of the data will relate to the old name and part to the new one.

    Copy that to the CLDR or FAIS structure, you'll be easier.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2