Crazy. You should suggest that you append
Crazy to the end of everything.
[tt]
OccupancyCrazy
-----------------------------
OccupancyCrazyId int
OccupancyCrazyCd char(8)
OccupancyCrazyNm varchar(32)
OccupancyCrazyDescr varchar(256)
[/tt]
Seriously!
I am NOT a fan of abbreviations. Not even a little. In fact, the only abbreviations you will find in my database is
ID (short for identification). Furthermore, I think it is completely ludicrous that "abbreviation" is such a long word. Who's bright idea was that!
Personally, I would prefer things to be spelled out (not to use abbreviations). Also.... why bother adding extra words if they don't add to the clarity.
Think about it this way....
Will a user EVER see a table name or column name? Probably not. So, who benefits from the name change? developers. Does adding CD to end end of certain columns and table names improve the clarity of the code? I don't think so.
In my opinion, you shouldn't do this.
-
George
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom