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:237806 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
