Functionally, it's no big deal. A little bit of a pain having to maintain two unique indexes, one for the PK and one for AK, but I've worked with such systems in the past. They function fine. The naming standard of just an ID column is also not the end of the world, but it removes clarity and that's something you must strive for when writing code. It's just going to make things difficult down the line, but it won't be a showstopper.