We desire to migrate the existing condition data captured via the emrapi module to the new condition table as contained in the core data model which supports Encounter Diagnoses as shown here. There are differences in the two condition tables as can be seen here. For the new condition table, verification_status and clinical_status fields are not nullable.
How do migrate the data putting into consideration that the new table has some nullable fields?
Do we make those fields nullable?
Do we assign a default value when migrating the data?
What are your suggestions please?