Geeks With Blogs

News INETA Community Speakers Program WTFNext's hosting!

View Stacy Vicknair's profile on LinkedIn

WTF Next? Dev ramblings from a master of nothing.

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:


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.



Technorati Tags: ,
Posted on Thursday, October 30, 2008 11:25 AM Other | Back to top

Comments on this post: The power of a name: 1st versus lst

# re: The power of a name: 1st versus lst
Requesting Gravatar...
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.
Left by Carl on Oct 30, 2008 11:57 AM

# re: The power of a name: 1st versus lst
Requesting Gravatar...
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.
Left by Stacy Vicknair on Oct 30, 2008 12:04 PM

# re: The power of a name: 1st versus lst
Requesting Gravatar...
Abbr. is almst. alws. ovrrtd.
Left by Randolpho on Oct 31, 2008 11:00 AM

Your comment:
 (will show your gravatar)

Copyright © Stacy Vicknair | Powered by: