Storing addresses in a database?

Question

SQL

A similar question was previously asked here , but didn't get much publicity.
The question is in the design of the table, how correctly to create the fields:
ID(pk) | street | house | apartment?

Answer 1

Download KLADR from the tax office and see its structure. They also distribute the description of the format.
You can use it in your application - convert it to a format convenient for you and use it.