Hi everyone,
I’m planning an application that I’m going to be working on where I’ll
have a number of Users and I’ll need to store the user’s current
position on a governing board (if he/she has a position) and also all
past positions that the user has held. There are only a handful of
positions so I was thinking of making the positions symbols and storing
the current position as either a nil value or the symbol if the user
holds the position (and there is only one person per position at a time)
and a serialized list of the positions that each user has held in the
past. Does this make sense or is there a better way to do this? Also,
would I make my column types as binary types or INTS? I’m not sure what
a symbol should be represented by.
Also, on a related note, each user might/might not want all of his/her
information public, is it a good idea to have a seperate column for
every possible hidden value which represents a boolean indicating if
that value should be shown? (E.g. for columns email_address, phone, etc
there would be email_address_public phone_public, etc.)
Thanks everyone!
Matt