In a situation where I'm defining a 'home' group for users (relationship is HMT on 'memberhsips' model) by adding a 'home' column to the memberships table, what reasons are there to use boolean vs binary?
fox_mulder_cp: thanks. Would the best way to enforce only a single 'home' be to set default to false, and add logic in the controller/model to change it to True when a home is set (and convert any standing True state to False), or is there a better way?
To go off tyul's question, I've got a similar situation in that I have users that join Clubs, which is done through a Membership model (user_clubs)... I was planning on just adding a "home_club" attribute to the Memberships model to indicate the user's main Club. Sensible?