>>Publicly visible keys are OK in many cases - you got barcodes and various abbreviations on at least half the items within a meter from yourself - but making them primary and/or editable is a recipe for trouble.
>
>Yup, he needs to retire if not willing to update his ideas. In addition he has shortened all the table and column names to remove most but not all vowels. I struggle to know what some of these mean and certainly cannot craft a query without looking directly at a table/ column definition. I am pretty sure the days of 10.3 limitations ended a few years back. Plus they are all in CAPS. Argh!

Look at the bright side: at least that means no underscores.