Hi group, Im new at here and I hope someone could give me a hand, im building an app witch is going to manage big amount of contacts, but my problem is that I need to accept a variety of columns from my customers, so i was planning to do this: Have a table named Lists on witch I would manage some other tables that I would built dynamically respecting the user data, so if an user want to upload a csv with 6 columns, I create a table with arbitrary random name with 6 columns plus my control columns. So schema looks like: Lists > id, company_id, name, table_name (this would be my dynamically created table name) My dynamic tables would have, I already have a datatype parser for colums data type definition. Table# > id, email, creation_date, column1, column2, column3..... columnN My problem with this schema is that I don''t know how to manage dynamically created tables. If you could give me a hand or some ideas, I appreciate it. Thanks very much --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Or maybe some other way to get this done ? Thanks very much --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Neshumah wrote:> Or maybe some other way to get this done ? > Thanks very muchTo be honest I do not see the value of this is the way you explain, why not create a table for all contacts, where you have a lot of different fields, for all the contacts, so that you will have several values in your table which are not filled out. If you want to have a variable number of phonenumbers, emails or webpages, then you could consider setting up another table with a 1 to n relationship... Hope this helps, Branko -- 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 -~----------~----~----~----~------~----~------~--~---