WTF Next?

Dev ramblings from a master of nothing.

  Home  |   Contact  |   Syndication    |   Login
  130 Posts | 0 Stories | 77 Comments | 0 Trackbacks

News

INETA Community Speakers Program
GeeksWithBlogs.net: WTFNext's hosting!

View Stacy Vicknair's profile on LinkedIn

Twitter







Tag Cloud


Archives

Post Categories

Community Links

User Groups

I’m currently working with a data table that stores member information. In the table itself, the member’s first and last names are each stored as the following respectively:

mbr_1st_nam
mbr_lst_nam

I don’t know who chose these names, but this definitely begs for reconsideration. 1 and l are too close in design in some fonts, and when playing around with large amounts of TSQL in terminal like fonts, I don’t want to have to strain or waste additional time wondering if that’s an l or 1.

So what do these names really save here? One letter each? Was the trade-off truly worth this?

I could understand that obeying the whole “make names you can pronounce when abbreviating” aspect is maintained, but this was not the way to go. For me, this definitely should have been mbr_first_nam and mbr_last_nam at the least.

</rant>

 

Technorati Tags: ,
posted on Thursday, October 30, 2008 11:25 AM

Feedback

# re: The power of a name: 1st versus lst 10/30/2008 11:57 AM Carl
I agree totally.

If these are columns in a 'member' table, and the designer really wanted to save letters, they should have done away with mbr_ on each of them IMHO.

# re: The power of a name: 1st versus lst 10/30/2008 12:04 PM Stacy Vicknair
You're right about that, and that actually makes me think a little more about the member entries.

The table is called member_acct, but it should represent a single member. However, there are sets of information in the table corresponding to joint member information as well, if there is a joint owner.

As well, the mbr_ prefix isn't kept consistently. The home phone is described as the "Member's home phone number", but the field is home_phone not mbr_home_phone.

All in all the table is not a good clean abstraction of what it wants to represent.

# re: The power of a name: 1st versus lst 10/31/2008 11:00 AM Randolpho
Abbr. is almst. alws. ovrrtd.

Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: