07-20-2023, 05:23 AM
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.
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.