form_vitals_calculation_form_vitals


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of form_vitals_calculation_form_vitals.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Join table between form_vitals_calculation and form_vitals table representing the derivative observation relationship between the calculation and the source records

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fvc_uuid BINARY 16 null
form_vitals_calculation.uuid Defined in XML R

fk to form_vitals_calculation.uuid
vitals_id BIGINT 19 null
form_vitals.id Defined in XML R

fk to form_vitals.id

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc fvc_uuid + vitals_id

Relationships

Close relationships within degrees of separation