I tried naming tables in the singular form once. I hated it. For some reason it bothered me to write sql that read "select top 50 * from book"
On 4/14/06, Barney Boisvert <[EMAIL PROTECTED]> wrote: > > link_user_group. Name your tables in all lower case (or all upper > case - never mixed case), and use singular nouns, rather than plurals. > > I typically order the tables in a link table's name with the same > order as the direction of common usage. So you mostly want to get the > groups of a user, not the users in a group, so it's named > link_user_group. But that's all personal preference, and has almost > no meaning on anything, as long as you're consistent. > > Note also that this only applies to two-column tables, where each is a > foreign key, and they're combined to form the primary key. If that > definition doesn't work, then you're not talking about a link table, > you're talking about an association entity (where the association is > an entity in it's own right), and should be named as such. > > cheers, > barneyb > > On 4/14/06, John McKown <[EMAIL PROTECTED]> wrote: > > Imagine these two database tables: "Users" and "Groups" > > > > You want a Foreign Key table to link them together (or what I call a > linking > > table) that might be named "UserGroups". > > > > But "UserGroups" as a table name itself does not stand out in the table > list > > because it does not use a prefixed naming convention (something I like > about > > Fusebox on the web side). > > > > Examples table names might be: "LT_Users_Groups" or.... > "FK_Users_Groups". > > > > Is there an understood standard there? Also, the order of the table > names > > might need to be taken into account based on where the foreign keys are. > > > > Thoughts? > > > > > > John McKown > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 100 invites. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238015 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
