I have always had the
pk of the table as this pattern: lowercase tablename + Id.
That was what I was taught in college and didn't think about it. When I was challenged on it from someone using
mongo db (a non-relational db) I couldn't figure out why I have ever done it this way?
The only thing I can think about is that some ORMs have it so that the auto build
pk columns that normally match this pattern.
Any insight would be greatly appreciated.