I wanted to be sure about the convention of wat serves as primary key in the Measurement table. I am going to implement the CDM for databases in which many measurements are executed repititively.
pO2 is measured for patient x on jan 13
pO2 is measured for patient x on feb 15
In OHDSI's description about the measurement table is stated that the measurement_id is a unique identifier but this will be undone when a measurement is executed twice. If measurement_date is part of the primary key (together with - at least - measurement_id and person_id) there is no problem. If I cannot store multiple measurements of the same measurement_id on the same patient in this way, please elaborate on a solution.
Thank you in advance!