It’s an English literacy thing - we have several non-native English speakers and using only singular avoids making those folks’ lives harder. Besides it’s really nice to autopilot that categoryid is a foreign key to the category table. It also simplifies always plural words… I haven’t yet written CREATETABLE pants but if I ever do there’s zero chance of me creating a pantid.
It’s an English literacy thing - we have several non-native English speakers and using only singular avoids making those folks’ lives harder. Besides it’s really nice to autopilot that
categoryidis a foreign key to thecategorytable. It also simplifies always plural words… I haven’t yet writtenCREATE TABLE pantsbut if I ever do there’s zero chance of me creating apantid.no underscores either? What are we, apes?