Since we reference airports quite a lot in many tables, it would be a good idea to store airports in a table. We can store other data about airpots as well, for example the airport name and location using coordinates. This might be important for drawing of maps in the future, too.
Since we reference airports quite a lot in many tables, it would be a good idea to store airports in a table. We can store other data about airpots as well, for example the airport name and location using coordinates. This might be important for drawing of maps in the future, too.
We need a source of data, of all ICAO airports worldwide. An option seems to be: https://ourairports.com/data/