Tim Holloway wrote:Only thing that really catches my attention is that you're using 45-character VARCHAR fields for your keys (IDs).
Usually you'll get better database performance using numeric keys. Plus it's less trouble if you're generating keys automatically with no inherent meaning (that is, simply to point to stuff).
If those 45 character fields are essential text, you could always define them as secondary keys and flag them as UNIQUE.
Thank you very much for your reply. I'll make those improvements.
What do you think about the foreign keys between user and request is there any better way to do that.
And do you think that there is a circular reference between Comment, Request and User