Search code examples
databasedatabase-design

Table Naming: Underscore vs Camelcase? namespaces? Singular vs Plural?

How do I name tables in a database?

Most developers tend to name the tables depending on the language that requires the database (JAVA, .NET, PHP, etc.). This isn't right.

I've been naming like:

doctorsMain
doctorsProfiles
doctorsPatients
patientsMain
patientsProfiles
patientsAntecedents

I'm concerned with:

  • legibility
  • speed of identification of the module the table is from (doctors||patients)
  • ease of understanding, to prevent confusions
Solution

  • Being consistent is far more important than what particular scheme you use.