Alex will be back tomorrow with a new WTF. For today, here's a classic WTF from me!

I'm sure we all have our stories of nightmarish projects inherited from clients, whether the secretary's cousin programmed a critical application in JavaScript or a community outreach program let a group home design their customer relationship management application.  Imagine my surprise when we got one that had beautifully written, well-commented ASP pages.  I thought this would be easy.

My boss asked me to put together a diagram of the database so that I'd be able to refer to it for table and column names, keys, etc.  I fired up our diagramming software, and watched in horror as it processed the tables.

Cn.  CnAdr.  CnAdrPrf.  CnAdrPrfPh_1.  CnAdrSal.  CnAttr... (time passes)
CnRelEdu_1Attr.  CnRelEdu_1AttrCat_1.

"It's ok, Jake, you'll figure out what all of these are by looking at the data and key relationships," I reassured myself.

Cracking my knuckles, I leaned forward.  "You've seen worse than this.  You saw an old lady die at a restaurant once (for real).  Let's DO this!"

No foreign key relationships?  Ok, that's fine.  You should expect this by now. Keep going.  No... no primary keys?  In any of the tables?

OK, Jake.  You're a smart guy.  Look through the actual data.  The "Cn" (central nervous?) table seems pretty important.  Let's see what we've got.

There's a pattern here, bend your brain and see if you can find it! 
CHALLENGE POINT:  Can you guess what values are in record 494?

[Advertisement] BuildMaster allows you to create a self-service release management platform that allows different teams to manage their applications. Explore how!