>>>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.

Oh no, those exist in his model also. lol