While working on synchronization process for local instances of OpenMRS to one central OpenMRS, I have observed a missing constraint in the data model. ‘patient_identifier’ table has a column patient_id but it does not implement a foreign key constraint that refers to the person table (since patient table itself refers to the person table).