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 -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Anyone have any ideas? Thanks! matt jacobs wrote:> 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-- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
store them as strings and enjoy all the headaches you won''t be having. :) On 6/5/07, matt jacobs <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > > Anyone have any ideas? > > > Thanks! > > > matt jacobs wrote: > > 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 > > > -- > Posted via http://www.ruby-forum.com/. > > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---