Most of it comes down to personal / team preference - you should be trying to make life easier for yourself by knowing what something will be called rather than trying to thinking of a name.
However, you may not be there for the whole life of the database so you need to be clear in your naming - document it!
Don't be too verbose or over abbreviate as per Grant's comments
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx