Did aviation software for 7 years. This is 100% the first assumption about waypoint / navaid when new devs come in.

And this is why you always use surrogate keys and not natural keys. No matter how much you convince yourself that your natural key is unique and will never change, if a human created the value then a human can change the value or create duplicates, and eventually will.

But that wouldn't help you here. The flight plan will come in with the code and you'll still have to resolve that to your keys.

Sure, but that means you are putting in the infrastructure to resolve it, instead of assuming there will never be a need to.

Or even more straightforward, just don’t believe anyone 100% knows what they are doing until they exhaustively list every assumption they are making.

Even more straightforward, just don’t believe anyone 100% knows what they are doing.

Which also means never assume the exhaustive list is 100%.

I wouldn't be able to produce such a list, even for areas where I totally do know everything that would be on the list.

Bingo, without some means of credible verification, then assume it’s incomplete.

or falsehoods programmers believe about global identifiers