# Manage of dynamic tables.

**URL:** <https://discuss.rubyonrails.org/t/manage-of-dynamic-tables/13172>\
**Category:** rubyonrails-talk\
**Created:** [May 19, 2007, 10:51pm UTC](https://discuss.rubyonrails.org/t/manage-of-dynamic-tables/13172 "2007-05-19T22:51:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Neshumah](https://avatars.discourse-cdn.com/v4/letter/n/5f9b8f/32.png) [@Neshumah](https://discuss.rubyonrails.org/u/Neshumah)\
**Post date:** [May 19, 2007, 10:51pm UTC](https://discuss.rubyonrails.org/t/manage-of-dynamic-tables/13172/1 "2007-05-19T22:51:53Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Neshumah](https://avatars.discourse-cdn.com/v4/letter/n/5f9b8f/32.png) [@Neshumah](https://discuss.rubyonrails.org/u/Neshumah)\
**Post date:** [May 19, 2007, 11:53pm UTC](https://discuss.rubyonrails.org/t/manage-of-dynamic-tables/13172/2 "2007-05-19T23:53:50Z")

</div>

Or maybe some other way to get this done ? Thanks very much