Use singular nouns for database table names
5 days ago
- #database
- #relational-databases
- #naming-conventions
- Debate over whether table names in relational databases should be singular or plural.
- Arguments for plural names: tables store multiple records and read well in FROM clauses.
- Arguments for singular names: tables represent a single relation, match ORM class names, and avoid inconsistency with already plural relations.
- Singular names prevent future inconsistencies, especially with relations that are inherently plural.