What are the best practices for organizing delivery addresses in the database (partitioning into directories, etc.)?

Question

Database design

There are addresses to which the order is delivered (one-to-many orders).

I want to make an addresses table with foreign keys to reference tables (cities, streets, etc.).

1. Is it generally normal if the table has only auto-increment and foreign keys? Or is it done in some other way?

2. The task, as I understand it, is typical. Are there any ready made solutions? Maybe services? Give me some pointers at least :)

Thank you.

Answer 1

So far I have found this service: https://dadata.ru/ - most likely this is part of the solution