What does "wind up" mean when it refers to a person?

[Cactuar is watching]

?
It's a noun. Not a verb.

I found a question that reads "Who is the biggest wind up in your family?" on Y!A.
What is the biggest wind up?