Re: [SQLDownUnder] [SQLStyle] #1: Singular vs Plural Table Naming

[Michael Silk]

thoughts on that would be that your "key" requirement would be missing
in most of my bridging tables. they typically only have a pk, fk and
fk. (or maybe, if i'm feeling lucky, a fk fk as a dual pk).

but i would still go for the renaming option, as you advise.


On 7/9/07, Greg Low <greg.low@xxxxxxxxxxx> wrote:
> Hi David,
>
> That's an interesting one. My personal preference is to give the linking table a separate name if I think of it as a separate entity. The acid test for me (no database pun intended) is as soon as I want to add additional columns to it, rather than it just providing the relationship between other tables. As an example, if we had:
>
> Husbands
> Wives
>
> (I know it's contrived :-)
>
> We might have:
>
> Marriages
>
> Rather than HusbandWives :-)
>
> For me, the key thing here (damn another database pun), would be that a "Marriage" would have other attributes like a date and a celebrant, etc.
>
> Thoughts?
>
> Regards,
> Greg
>
> Dr Greg Low
> Readify | Senior Consultant
> Suite 206 Nolan Tower | 29 Rakaia Way | Docklands | VIC 3008 | Australia
> M: +61 419 201 410 | E: mailto:greg.low@xxxxxxxxxxx | W: www.readify.net
>
> -----Original Message-----
> From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx [mailto:SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of David Spearritt
> Sent: Monday, 9 July 2007 4:04 PM
> To: SQLDownUnder@xxxxxxxxxxxxxxxxxxxxxx
> Subject: Re: [SQLDownUnder] [SQLStyle] #1: Singular vs Plural Table Naming
>
> > [CONS] Plurals for table names are generally inconsistent. Some end in "s"
> > others "ies", others "es" or "ys" etc. So there is a higher likelihood of
> > developers misspelling the names.
> >
> > [CONS] When you have a link table, you don't put the plural in each half of
> > the name. CustomerAddresses, not CustomersAddresses, or do you?
>
> I'm with Celko on this. The best name is a singular name that refers
> to the set or collection like CustomerAddressBook.
>
> David Spearritt
> http://www.orlitech.com.au
>
>
> to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net
>
>
>
>
> to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net
--
mike
http://lets.coozi.com.au/


to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net