@kdfrawg I can almost tell this project's entire history by the things they have tacked onto the schema over time to paper over the core flaws.
I fully understand why people trying to get off that software tell me, "I don't care. Name your price. Get us off this!".
If the program that operates on this mess is even remotely similar…