There appears to be a couple of foreign key constraints missing, we need to fix this. A DB schema diagram, showing the tables, fields and relationships also needs to be created.