And our standard is to use singular table names. The rational is that
it's a single table and each record in it is a singular record:

So, person and personid.

But, I've heard the argument both ways, and I'm not going to smack
anyone about it.

On Wed, 21 Jul 2004 12:06:57 -0400, C. Hatton Humphrey
>
> The standard that I use is to have table names pluralized except in
> the case of join tables (users, locations, userslocations) and then
> will generate the ID based on the table name (users_id, locations_id,
> userslocations_id).
>
> Yes it can lead to long field names, however it makes for easier to
> follow standards.
>
> Hatton
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to