I have a database table named order. It contains eCommerce orders. Problem is, that's a reserved word in MySQL, and while I can use back-ticks to prevent issues, it's probably a good idea not to use a reserved word.I could name it orders. Problem is, that's a plural. The rest of my tables using the singular naming scheme. Also, there's some debate on using plurals for database table names, and most people seem to prefer using singular.I could name it order_details, which is technically correct because each row contains details, as opposed to order_items where each row contains an item, but it's rather confusing.I think naming things is hard, but also important. Order tables are very common and I hope this question, while specific, will be useful to future users.What should I rename my order table?
What to rename my order table?
language agnostic;naming
Totally opinion based, but I'll throw in a couple of ideas.I like order_header plus order_details which makes it clear how they fit together.You could call it sales_order to distinguish between, say, a purchase_order, which is entirely different.  Or customer_order which makes it clear where the order came from.Or you could keep the name order but use the database's syntax to distinguish it from a keyword. In SQL Server you'd use [order] and in MySQL you'd use backticks, like this:SELECT * FROM `order`