Re: help in relating tables and normailsation

[Rick James]

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.