MySQL Forums
Forum List  »  MySQL Workbench

Re: need help with tables/fields structure.
Posted by: Michael Reed
Date: April 23, 2009 04:05AM

Stay away from multiple tables. You would probably have a base table that includes information common to each container/table, and a column for the parent. Maybe also something to indicate whether it is a container or table? User defined fields can be added with a many-to-many join. Do it with mysql and properly defined indexes instead of php, and it will probably be fast enough. Good luck

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: need help with tables/fields structure.
2047
April 23, 2009 04:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.