I've been working with databases for a long time and there are no shortage of things I've seen other people do that I don't like. Sometimes I shake my head a little. Sometimes I might groan inwardly (hopefully not aloud), and sometimes I might make an effort to convince someone else to do something differently.
Sometimes I'm really annoyed (or angry) and don't even know what to do.
I know that most people are trying to just get work done. They might rush through something and not do a good job, perhaps because of oversight, or perhaps they are naïve about the effects of their work. Maybe they have ingrained habits and are unwilling to change. Maybe there's another reason (let me know if there is one).
However, no matter the reason, it can be very frustrating to work on poor database designs. There might be other things that bother you, but today I'm focused on the data model. Do you see poor naming of objects? Are there problems with the way they structure their entities? A lack of indexes?
What are your biggest complaints about the structures in your databases?
While I am looking forward to your stories, I want you to be professional. We've all made mistakes, and there is likely some (most?) code we've written that we wish we could redo. Don't embarrass anyone or any organization, but let us know which types of problems or anti-patterns are your biggest complaints. Bonus points if you can do it in a humorous story.