Table Naming: Underscore vs Camelcase? namespaces? Singular vs Plural?
I've been reading a couple of questions/answers on StackOverflow trying to find the 'best', or should I say must accepted way, to name tables on a Database.

Most of the developers tend to name the tables depending on the language that requires the database (JAVA, .NET, PHP, etc). However I just feel this isn't right.

 The way I've been naming tables till now is doing something like:

    doctorsMain
    doctorsProfiles
    doctorsPatients
    patientsMain
    patientsProfiles
    patientsAntecedents 

The things I'm concerned are:

 - Legibility
 - Quick identifying of the module the table is from (doctors||patients)
 - Easy to understand, to prevent confusions.

I would like to read any opinions regarding naming conventions.
Thank you.
Table Naming: Underscore vs Camelcase? namespaces? Singular vs Plural?
===

I've been reading a couple of questions/answers on StackOverflow trying to find the 'best', or should I say must accepted way, to name tables on a Database.

Most of the developers tend to name the tables depending on the language that requires the database (JAVA, .NET, PHP, etc). However I just feel this isn't right.

 The way I've been naming tables till now is doing something like:

    doctorsMain
    doctorsProfiles
    doctorsPatients
    patientsMain
    patientsProfiles
    patientsAntecedents 

The things I'm concerned are:

 - Legibility
 - Quick identifying of the module the table is from (doctors||patients)
 - Easy to understand, to prevent confusions.

I would like to read any opinions regarding naming conventions.
Thank you.