ewang1
Joined 14 years ago
Karma
277
Submissions
125
Member since
Mar 13
Joined 14 years ago
I would imagine the airlines have even tougher currency requirements. That said, it's probably possible to maintain currency in several aircraft types depending on the frequency and how the jobs are scheduled.
The solution the problem you described would be to use a surrogate key column (typically a UUID/auto-increment), and not natural keys.