Review

You should index all your foreign keys