Missing constraint in OpenMRS data model

OpenMRS: 1.9.2

Hi Everyone,

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).

This has been checked on OpenMRS 1.11.0 as well. patient_identifier has a same missing constraint (from patient_identifier to person table).

Do you mean this?

1 Like

I didn’t check this ticket. Sorry and, thanks @dkayiwa