Re: help in relating tables and normailsation
Posted by: Rick James
Date: May 28, 2010 10:19AM

The values of ID, Parent, Child into Categories don't make sense.
Also, you don't need both Parent and Child; only Parent. That is, each row has (ID and Parent). To find all the children, do
WHERE Parent = ?
This also implies an index on Parent.

Note: INT(20) is not BIGINT. INT(20) is still INT, which is limited to +/- 2 billion. Ditto for int(4). I'm surprised to see these, since you obviously know about TINYINT.

You have a languages table, yet the charset is latin1 -- which does not handle Asian languages well. Recommend switching to utf8.

dqg_module_settings smells like an arbitrary key-value table. I hope you don't plan on finding things via that table.

Options: ReplyQuote

Written By
Re: help in relating tables and normailsation
May 28, 2010 10:19AM

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.