embryo_assessment
Assessment of morphological features and development of a single oocyte or embryo.
Assessment of morphological features and development of a single oocyte or embryo.
Purpose. To record details about the assessment of morphology and development of a single oocyte or embryo.
Source
| Model | Leg | Role |
|---|
openEHR-EHR-OBSERVATION.embryo_assessment.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. | — |
event_type | text | yes | null represents any_event | — |
label | text | yes | Label | /data[at0001]/events[at0002]/data[at0003]/items[at0010] |
id_value
id_system | text, text
text, text | yes | ID | /data[at0001]/events[at0002]/data[at0003]/items[at0011] |
description | text | yes | Description | /data[at0001]/events[at0002]/data[at0003]/items[at0034] |
developmental_stage
developmental_stage_code
developmental_stage_system
developmental_stage_valueset_id | coded text
text, text, text, text | yes | Developmental stage | /data[at0001]/events[at0002]/data[at0003]/items[at0036] |
developmental_event
developmental_event_code
developmental_event_system
developmental_event_valueset_id | coded text
text, text, text, text | yes | Developmental event | /data[at0001]/events[at0002]/data[at0003]/items[at0044] |
time_post_insemination | interval | yes | Time post-insemination | /data[at0001]/events[at0002]/data[at0003]/items[at0023] |
interpretation | text | yes | Interpretation | /data[at0001]/events[at0002]/data[at0003]/items[at0024] |
comment | text | yes | Comment | /data[at0001]/events[at0002]/data[at0003]/items[at0035] |
culture_dish_id_value
culture_dish_id_system | text, text
text, text | yes | Culture dish ID | /protocol[at0004]/items[at0006] |
method
method_code
method_system
method_valueset_id | coded text
text, text, text, text | yes | Method | /protocol[at0004]/items[at0007] |
Constraints
check (id_system is null or id_value is not null)
check ((developmental_stage_code is null and developmental_stage_system is null and developmental_stage_valueset_id is null) or (developmental_stage is not null and developmental_stage_code is not null and developmental_stage_system is not null and developmental_stage_valueset_id is not null))
check ((developmental_event_code is null and developmental_event_system is null and developmental_event_valueset_id is null) or (developmental_event is not null and developmental_event_code is not null and developmental_event_system is not null and developmental_event_valueset_id is not null))
check (culture_dish_id_system is null or culture_dish_id_value is not null)
check ((method_code is null and method_system is null and method_valueset_id is null) or (method is not null and method_code is not null and method_system is not null and method_valueset_id is not null))
Unique
References
| Columns | Target | On delete |
|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
developmental_stage_valueset_id, developmental_stage_code, developmental_stage_system, developmental_stage | valueset_code | restrict |
developmental_event_valueset_id, developmental_event_code, developmental_event_system, developmental_event | valueset_code | restrict |
method_valueset_id, method_code, method_system, method | valueset_code | restrict |
Referenced by
Indexes
embryo_assessment_form_id_idx on form_id
Child tables
3 tables hang off embryo_assessment, one row per repetition.
embryo_assessment_morphological_findings
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Primary key. | — |
embryo_assessment_id | uuid → embryo_assessment | no | — | — |
position | integer | no | Order of this row within its parent, from zero. | — |
exam_blastocyst_id | uuid | yes | — | — |
exam_embryo_id | uuid | yes | — | — |
exam_oocyte_id | uuid | yes | — | — |
exam_zygote_id | uuid | yes | — | — |
Constraints
check (num_nonnulls(exam_blastocyst_id, exam_embryo_id, exam_oocyte_id, exam_zygote_id) = 1)
Unique
embryo_assessment_id, position
References
Indexes
embryo_assessment_morphological_findings_exam_blastocyst_id_idx on exam_blastocyst_idembryo_assessment_morphological_findings_exam_embryo_id_idx on exam_embryo_idembryo_assessment_morphological_findings_exam_oocyte_id_idx on exam_oocyte_idembryo_assessment_morphological_findings_exam_zygote_id_idx on exam_zygote_id
embryo_assessment_image_representation
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Primary key. | — |
embryo_assessment_id | uuid → embryo_assessment | no | — | — |
position | integer | no | Order of this row within its parent, from zero. | — |
attachment_id | uuid | no | Image representation | /data[at0001]/events[at0002]/data[at0003]/items[at0022] |
Unique
embryo_assessment_id, positionembryo_assessment_id, attachment_id
References
Indexes
embryo_assessment_image_representation_attachment_id_idx on attachment_id
embryo_assessment_device
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|
id | uuid primary key | no | Primary key. | — |
embryo_assessment_id | uuid → embryo_assessment | no | — | — |
position | integer | no | Order of this row within its parent, from zero. | — |
device_id | uuid | no | Device | /protocol[at0004]/items[at0005] |
Unique
embryo_assessment_id, positionembryo_assessment_id, device_id
References
Indexes
embryo_assessment_device_device_id_idx on device_id
Value sets
| Value set | Codes |
|---|
org.openehr::openEHR-EHR-OBSERVATION.embryo_assessment.v1/developmental_event | 17 |
org.openehr::openEHR-EHR-OBSERVATION.embryo_assessment.v1/developmental_stage | 7 |
org.openehr::openEHR-EHR-OBSERVATION.embryo_assessment.v1/method | 2 |