The itype and itemtype fields in many tables refer to the itemtypes table but are not defined as foreign keys.. they should be to prevent data corruption.