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

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