Use singular nouns for database table names
Use singular nouns for database table names A common debate in relational database circles is whether the names of tables should be singular or plural. If you have a table that stores users, should the table be called user or users ? The arguments for plural are straightforward: The table is storing more than one user. It reads well in the FROM clause: SELECT id , name FROM users ; The arguments for singular are more subtle: Strictly speaking, we’re not naming a table, we’re naming a relati