DEV Community

Discussion on: Database naming conventions.

Collapse
 
dmerand profile image
Donald Merand

I've tried it, and usually regret it. I'm not sure what's "good practice", or who gets to define that, but I'd rather read (and type):

Ponies::CutieMark
Avengers::Snarkiness

...than

Ponies::PonyCutieMark
Avengers::AvengerSnarkiness

If you believe in normalization of your databases, you probably want your tables to more-or-less roughly map to your concepts. For me, this means that they also map to the way I speak about those concepts. I don't say "I want the Cars Carname", I say "I want the Cars Name".

There is one exception, which would be if you're forced to use a non-normalized table but include a lot of related concepts (this happens to me a lot in FileMaker). So, for example:

Cars::Model
Cars::Make
Cars::_VendorName
Cars::_VendorID

But, as you can see, the caveat only really applies to non-normalized data (for me, at least).