Page 1 of 1
Table Name Conventions/Standards
Posted: Fri Oct 24, 2003 6:57 am
by zenabi
This isn't overly important, but is it recommended to have tables named in a singular or plural manner?
Eg.
or
Posted: Fri Oct 24, 2003 8:04 am
by twigletmac
It's totally up to you, I tend to use plurals for the table name and then singulars for fields but that's just because I like it that way.
Mac
Posted: Fri Oct 24, 2003 8:06 am
by evilMind
It makes more sense to have a table called "users" which will store multiple users (instead of user which makes it seem like there is only one 'user'). Just as it would make more sense to have a table named 'cars' which would hold information about many 'cars' not just one. As mentioned earlier, it's really up to you; however, it makes more sense to stick with what twigletmac posted.