Fixed, I ran the following against the DB to replace the missing constraints.
ALTER TABLE ir_module_module
ADD CONSTRAINT ir_module_module_category_id_fkey FOREIGN KEY (category_id)
REFERENCES ir_module_category (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE SET NULL;
ALTER TABLE ir_module_module
ADD CONSTRAINT ir_module_module_create_uid_fkey FOREIGN KEY (create_uid)
REFERENCES res_users (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE SET NULL;
ALTER TABLE ir_module_module
ADD CONSTRAINT ir_module_module_write_uid_fkey FOREIGN KEY (write_uid)
REFERENCES res_users (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE SET NULL;
Fixed, I ran the following against the DB to replace the missing constraints.
ALTER TABLE ir_module_module module_ category_ id_fkey FOREIGN KEY (category_id)
ADD CONSTRAINT ir_module_
REFERENCES ir_module_category (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE SET NULL;
ALTER TABLE ir_module_module module_ create_ uid_fkey FOREIGN KEY (create_uid)
ADD CONSTRAINT ir_module_
REFERENCES res_users (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE SET NULL;
ALTER TABLE ir_module_module module_ write_uid_ fkey FOREIGN KEY (write_uid)
ADD CONSTRAINT ir_module_
REFERENCES res_users (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE SET NULL;