Schema reference / Tables / view MDX source
fetal_biometry
Ultrasound and Doppler measurements of the dimensions of an embryo or fetus.
Ultrasound and Doppler measurements of the dimensions of an embryo or fetus.
Purpose. To record ultrasound and doppler measurements of an embryo or fetus in utero.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-OBSERVATION.fetal_biometry.v1 | openEHR | defines this table |
Columns
| Column | Type | Null | Description | Source |
|---|---|---|---|---|
id | uuid primary key | no | Primary key. | — |
form_id | uuid → form | no | The form this entry was recorded on. | — |
form_block_id | uuid | yes | The block within the form, when the entry is bound to one. | — |
crown_rump_length_crl_magnitudecrown_rump_length_crl_units | quantitynumeric, text | yes | Crown-rump length (CRL) | /data[at0001]/events[at0002]/data[at0003]/items[at0004] |
biparietal_diameter_bpd_magnitudebiparietal_diameter_bpd_units | quantitynumeric, text | yes | Biparietal diameter (BPD) | /data[at0001]/events[at0002]/data[at0003]/items[at0006] |
occipito_frontal_diameter_ofd_magnitudeoccipito_frontal_diameter_ofd_units | quantitynumeric, text | yes | Occipito-frontal diameter (OFD) | /data[at0001]/events[at0002]/data[at0003]/items[at0007] |
head_circumference_hc_magnitudehead_circumference_hc_units | quantitynumeric, text | yes | Head circumference (HC) | /data[at0001]/events[at0002]/data[at0003]/items[at0008] |
trans_cerebellar_diameter_tcd_magnitudetrans_cerebellar_diameter_tcd_units | quantitynumeric, text | yes | Trans-cerebellar diameter (TCD) | /data[at0001]/events[at0002]/data[at0003]/items[at0009] |
interocular_distance_iod_magnitudeinterocular_distance_iod_units | quantitynumeric, text | yes | Interocular distance (IOD) | /data[at0001]/events[at0002]/data[at0003]/items[at0010] |
binocular_distance_bod_magnitudebinocular_distance_bod_units | quantitynumeric, text | yes | Binocular distance (BOD) | /data[at0001]/events[at0002]/data[at0003]/items[at0011] |
abdominal_circumference_ac_magnitudeabdominal_circumference_ac_units | quantitynumeric, text | yes | Abdominal circumference (AC) | /data[at0001]/events[at0002]/data[at0003]/items[at0012] |
femur_length_fl_magnitudefemur_length_fl_units | quantitynumeric, text | yes | Femur length (FL) | /data[at0001]/events[at0002]/data[at0003]/items[at0013] |
humeral_length_hl_magnitudehumeral_length_hl_units | quantitynumeric, text | yes | Humeral length (HL) | /data[at0001]/events[at0002]/data[at0003]/items[at0014] |
comment | text | yes | Comment | /data[at0001]/events[at0002]/data[at0003]/items[at0015] |
bpd_methodbpd_method_codebpd_method_systembpd_method_valueset_id | coded texttext, text, text, text | yes | BPD method | /protocol[at0016]/items[at0017] |
Constraints
check ((crown_rump_length_crl_magnitude is null and crown_rump_length_crl_units is null) or (crown_rump_length_crl_magnitude is not null and crown_rump_length_crl_units is not null))
check (crown_rump_length_crl_magnitude is null or (crown_rump_length_crl_units = 'mm' and crown_rump_length_crl_magnitude >= 0) or (crown_rump_length_crl_units = 'cm' and crown_rump_length_crl_magnitude >= 0) or (crown_rump_length_crl_units = '[in_i]' and crown_rump_length_crl_magnitude >= 0))
check ((biparietal_diameter_bpd_magnitude is null and biparietal_diameter_bpd_units is null) or (biparietal_diameter_bpd_magnitude is not null and biparietal_diameter_bpd_units is not null))
check (biparietal_diameter_bpd_magnitude is null or (biparietal_diameter_bpd_units = 'mm' and biparietal_diameter_bpd_magnitude >= 0) or (biparietal_diameter_bpd_units = 'cm' and biparietal_diameter_bpd_magnitude >= 0) or (biparietal_diameter_bpd_units = '[in_i]' and biparietal_diameter_bpd_magnitude >= 0))
check ((occipito_frontal_diameter_ofd_magnitude is null and occipito_frontal_diameter_ofd_units is null) or (occipito_frontal_diameter_ofd_magnitude is not null and occipito_frontal_diameter_ofd_units is not null))
check (occipito_frontal_diameter_ofd_magnitude is null or (occipito_frontal_diameter_ofd_units = 'mm' and occipito_frontal_diameter_ofd_magnitude >= 0) or (occipito_frontal_diameter_ofd_units = 'cm' and occipito_frontal_diameter_ofd_magnitude >= 0) or (occipito_frontal_diameter_ofd_units = '[in_i]' and occipito_frontal_diameter_ofd_magnitude >= 0))
check ((head_circumference_hc_magnitude is null and head_circumference_hc_units is null) or (head_circumference_hc_magnitude is not null and head_circumference_hc_units is not null))
check (head_circumference_hc_magnitude is null or (head_circumference_hc_units = 'mm' and head_circumference_hc_magnitude >= 0) or (head_circumference_hc_units = 'cm' and head_circumference_hc_magnitude >= 0) or (head_circumference_hc_units = '[in_i]' and head_circumference_hc_magnitude >= 0))
check ((trans_cerebellar_diameter_tcd_magnitude is null and trans_cerebellar_diameter_tcd_units is null) or (trans_cerebellar_diameter_tcd_magnitude is not null and trans_cerebellar_diameter_tcd_units is not null))
check (trans_cerebellar_diameter_tcd_magnitude is null or (trans_cerebellar_diameter_tcd_units = 'mm' and trans_cerebellar_diameter_tcd_magnitude >= 0) or (trans_cerebellar_diameter_tcd_units = 'cm' and trans_cerebellar_diameter_tcd_magnitude >= 0) or (trans_cerebellar_diameter_tcd_units = '[in_i]' and trans_cerebellar_diameter_tcd_magnitude >= 0))
check ((interocular_distance_iod_magnitude is null and interocular_distance_iod_units is null) or (interocular_distance_iod_magnitude is not null and interocular_distance_iod_units is not null))
check (interocular_distance_iod_magnitude is null or (interocular_distance_iod_units = 'mm' and interocular_distance_iod_magnitude >= 0) or (interocular_distance_iod_units = 'cm' and interocular_distance_iod_magnitude >= 0) or (interocular_distance_iod_units = '[in_i]' and interocular_distance_iod_magnitude >= 0))
check ((binocular_distance_bod_magnitude is null and binocular_distance_bod_units is null) or (binocular_distance_bod_magnitude is not null and binocular_distance_bod_units is not null))
check (binocular_distance_bod_magnitude is null or (binocular_distance_bod_units = 'mm' and binocular_distance_bod_magnitude >= 0) or (binocular_distance_bod_units = 'cm' and binocular_distance_bod_magnitude >= 0) or (binocular_distance_bod_units = '[in_i]' and binocular_distance_bod_magnitude >= 0))
check ((abdominal_circumference_ac_magnitude is null and abdominal_circumference_ac_units is null) or (abdominal_circumference_ac_magnitude is not null and abdominal_circumference_ac_units is not null))
check (abdominal_circumference_ac_magnitude is null or (abdominal_circumference_ac_units = 'mm' and abdominal_circumference_ac_magnitude >= 0) or (abdominal_circumference_ac_units = 'cm' and abdominal_circumference_ac_magnitude >= 0) or (abdominal_circumference_ac_units = '[in_i]' and abdominal_circumference_ac_magnitude >= 0))
check ((femur_length_fl_magnitude is null and femur_length_fl_units is null) or (femur_length_fl_magnitude is not null and femur_length_fl_units is not null))
check (femur_length_fl_magnitude is null or (femur_length_fl_units = 'mm' and femur_length_fl_magnitude >= 0) or (femur_length_fl_units = 'cm' and femur_length_fl_magnitude >= 0) or (femur_length_fl_units = '[in_i]' and femur_length_fl_magnitude >= 0))
check ((humeral_length_hl_magnitude is null and humeral_length_hl_units is null) or (humeral_length_hl_magnitude is not null and humeral_length_hl_units is not null))
check (humeral_length_hl_magnitude is null or (humeral_length_hl_units = 'mm' and humeral_length_hl_magnitude >= 0) or (humeral_length_hl_units = 'cm' and humeral_length_hl_magnitude >= 0) or (humeral_length_hl_units = '[in_i]' and humeral_length_hl_magnitude >= 0))
check ((bpd_method_code is null and bpd_method_system is null and bpd_method_valueset_id is null and bpd_method is null) or (bpd_method is not null and bpd_method_code is not null and bpd_method_system is not null and bpd_method_valueset_id is not null))Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
bpd_method_valueset_id, bpd_method_code, bpd_method_system, bpd_method | valueset_code | restrict |
Indexes
fetal_biometry_form_id_idxonform_id
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-OBSERVATION.fetal_biometry.v1/bpd_method | 2 |