Schema reference / Tables / view MDX source
exam_oocyte
Morphological findings obtained by microscopy of a human oocyte.
Morphological findings obtained by microscopy of a human oocyte.
Purpose. To record structured observations of a human oocyte.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-CLUSTER.exam_oocyte.v1 | openEHR | defines this table |
Columns
| Column | Type | Null | Description | Source |
|---|---|---|---|---|
id | uuid primary key | no | Primary key. | — |
maturity_of_cumulus_oocyte_complexmaturity_of_cumulus_oocyte_complex_codematurity_of_cumulus_oocyte_complex_systemmaturity_of_cumulus_oocyte_complex_valueset_id | coded texttext, text, text, text | yes | Maturity of cumulus-oocyte complex | /items[at0028] |
oocyte_maturation_stageoocyte_maturation_stage_codeoocyte_maturation_stage_systemoocyte_maturation_stage_valueset_id | coded texttext, text, text, text | yes | Oocyte maturation stage | /items[at0035] |
oocyte_size_coded_textoocyte_size_coded_text_codeoocyte_size_coded_text_systemoocyte_size_coded_text_valueset_idoocyte_size_quantity_magnitudeoocyte_size_quantity_units | coded texttext, text, text, text, numeric, text | yes | Oocyte size | /items[at0039] |
oocyte_shapeoocyte_shape_codeoocyte_shape_systemoocyte_shape_valueset_id | coded texttext, text, text, text | yes | Oocyte shape | /items[at0040] |
cytoplasmic_morphologycytoplasmic_morphology_codecytoplasmic_morphology_systemcytoplasmic_morphology_valueset_id | coded texttext, text, text, text | yes | Cytoplasmic morphology | /items[at0041] |
zona_pellucida_thicknesszona_pellucida_thickness_codezona_pellucida_thickness_systemzona_pellucida_thickness_valueset_id | coded texttext, text, text, text | yes | Zona pellucida thickness | /items[at0042] |
perivitelline_space_size_coded_textperivitelline_space_size_coded_text_codeperivitelline_space_size_coded_text_systemperivitelline_space_size_coded_text_valueset_idperivitelline_space_size_quantity_magnitudeperivitelline_space_size_quantity_units | coded texttext, text, text, text, numeric, text | yes | Perivitelline space size | /items[at0043] |
perivitelline_space_morphologyperivitelline_space_morphology_codeperivitelline_space_morphology_systemperivitelline_space_morphology_valueset_id | coded texttext, text, text, text | yes | Perivitelline space morphology | /items[at0078] |
first_polar_body_morphologyfirst_polar_body_morphology_codefirst_polar_body_morphology_systemfirst_polar_body_morphology_valueset_id | coded texttext, text, text, text | yes | First polar body morphology | /items[at0044] |
metaphase_spindle_sizemetaphase_spindle_size_codemetaphase_spindle_size_systemmetaphase_spindle_size_valueset_id | coded texttext, text, text, text | yes | Metaphase spindle size | /items[at0045] |
metaphase_spindle_locationmetaphase_spindle_location_codemetaphase_spindle_location_systemmetaphase_spindle_location_valueset_id | coded texttext, text, text, text | yes | Metaphase spindle location | /items[at0083] |
other_morphological_features | text | yes | Other morphological features | /items[at0046] |
morphology_grademorphology_grade_codemorphology_grade_systemmorphology_grade_valueset_id | coded texttext, text, text, text | yes | Morphology grade | /items[at0077] |
Constraints
check ((maturity_of_cumulus_oocyte_complex_code is null and maturity_of_cumulus_oocyte_complex_system is null and maturity_of_cumulus_oocyte_complex_valueset_id is null) or (maturity_of_cumulus_oocyte_complex is not null and maturity_of_cumulus_oocyte_complex_code is not null and maturity_of_cumulus_oocyte_complex_system is not null and maturity_of_cumulus_oocyte_complex_valueset_id is not null))
check ((oocyte_maturation_stage_code is null and oocyte_maturation_stage_system is null and oocyte_maturation_stage_valueset_id is null) or (oocyte_maturation_stage is not null and oocyte_maturation_stage_code is not null and oocyte_maturation_stage_system is not null and oocyte_maturation_stage_valueset_id is not null))
check ((oocyte_size_coded_text_code is null and oocyte_size_coded_text_system is null and oocyte_size_coded_text_valueset_id is null) or (oocyte_size_coded_text is not null and oocyte_size_coded_text_code is not null and oocyte_size_coded_text_system is not null and oocyte_size_coded_text_valueset_id is not null))
check ((oocyte_size_quantity_magnitude is null and oocyte_size_quantity_units is null) or (oocyte_size_quantity_magnitude is not null and oocyte_size_quantity_units is not null))
check (oocyte_size_quantity_magnitude is null or (oocyte_size_quantity_units = 'um' and oocyte_size_quantity_magnitude >= 0))
check (num_nonnulls(oocyte_size_coded_text, oocyte_size_quantity_magnitude) <= 1)
check ((oocyte_shape_code is null and oocyte_shape_system is null and oocyte_shape_valueset_id is null) or (oocyte_shape is not null and oocyte_shape_code is not null and oocyte_shape_system is not null and oocyte_shape_valueset_id is not null))
check ((cytoplasmic_morphology_code is null and cytoplasmic_morphology_system is null and cytoplasmic_morphology_valueset_id is null) or (cytoplasmic_morphology is not null and cytoplasmic_morphology_code is not null and cytoplasmic_morphology_system is not null and cytoplasmic_morphology_valueset_id is not null))
check ((zona_pellucida_thickness_code is null and zona_pellucida_thickness_system is null and zona_pellucida_thickness_valueset_id is null) or (zona_pellucida_thickness is not null and zona_pellucida_thickness_code is not null and zona_pellucida_thickness_system is not null and zona_pellucida_thickness_valueset_id is not null))
check ((perivitelline_space_size_coded_text_code is null and perivitelline_space_size_coded_text_system is null and perivitelline_space_size_coded_text_valueset_id is null) or (perivitelline_space_size_coded_text is not null and perivitelline_space_size_coded_text_code is not null and perivitelline_space_size_coded_text_system is not null and perivitelline_space_size_coded_text_valueset_id is not null))
check ((perivitelline_space_size_quantity_magnitude is null and perivitelline_space_size_quantity_units is null) or (perivitelline_space_size_quantity_magnitude is not null and perivitelline_space_size_quantity_units is not null))
check (num_nonnulls(perivitelline_space_size_coded_text, perivitelline_space_size_quantity_magnitude) <= 1)
check ((perivitelline_space_morphology_code is null and perivitelline_space_morphology_system is null and perivitelline_space_morphology_valueset_id is null) or (perivitelline_space_morphology is not null and perivitelline_space_morphology_code is not null and perivitelline_space_morphology_system is not null and perivitelline_space_morphology_valueset_id is not null))
check ((first_polar_body_morphology_code is null and first_polar_body_morphology_system is null and first_polar_body_morphology_valueset_id is null) or (first_polar_body_morphology is not null and first_polar_body_morphology_code is not null and first_polar_body_morphology_system is not null and first_polar_body_morphology_valueset_id is not null))
check ((metaphase_spindle_size_code is null and metaphase_spindle_size_system is null and metaphase_spindle_size_valueset_id is null) or (metaphase_spindle_size is not null and metaphase_spindle_size_code is not null and metaphase_spindle_size_system is not null and metaphase_spindle_size_valueset_id is not null))
check ((metaphase_spindle_location_code is null and metaphase_spindle_location_system is null and metaphase_spindle_location_valueset_id is null) or (metaphase_spindle_location is not null and metaphase_spindle_location_code is not null and metaphase_spindle_location_system is not null and metaphase_spindle_location_valueset_id is not null))
check ((morphology_grade_code is null and morphology_grade_system is null and morphology_grade_valueset_id is null) or (morphology_grade is not null and morphology_grade_code is not null and morphology_grade_system is not null and morphology_grade_valueset_id is not null))References
| Columns | Target | On delete |
|---|---|---|
maturity_of_cumulus_oocyte_complex_valueset_id, maturity_of_cumulus_oocyte_complex_code, maturity_of_cumulus_oocyte_complex_system, maturity_of_cumulus_oocyte_complex | valueset_code | restrict |
oocyte_maturation_stage_valueset_id, oocyte_maturation_stage_code, oocyte_maturation_stage_system, oocyte_maturation_stage | valueset_code | restrict |
oocyte_size_coded_text_valueset_id, oocyte_size_coded_text_code, oocyte_size_coded_text_system, oocyte_size_coded_text | valueset_code | restrict |
oocyte_shape_valueset_id, oocyte_shape_code, oocyte_shape_system, oocyte_shape | valueset_code | restrict |
cytoplasmic_morphology_valueset_id, cytoplasmic_morphology_code, cytoplasmic_morphology_system, cytoplasmic_morphology | valueset_code | restrict |
zona_pellucida_thickness_valueset_id, zona_pellucida_thickness_code, zona_pellucida_thickness_system, zona_pellucida_thickness | valueset_code | restrict |
perivitelline_space_size_coded_text_valueset_id, perivitelline_space_size_coded_text_code, perivitelline_space_size_coded_text_system, perivitelline_space_size_coded_text | valueset_code | restrict |
perivitelline_space_morphology_valueset_id, perivitelline_space_morphology_code, perivitelline_space_morphology_system, perivitelline_space_morphology | valueset_code | restrict |
first_polar_body_morphology_valueset_id, first_polar_body_morphology_code, first_polar_body_morphology_system, first_polar_body_morphology | valueset_code | restrict |
metaphase_spindle_size_valueset_id, metaphase_spindle_size_code, metaphase_spindle_size_system, metaphase_spindle_size | valueset_code | restrict |
metaphase_spindle_location_valueset_id, metaphase_spindle_location_code, metaphase_spindle_location_system, metaphase_spindle_location | valueset_code | restrict |
morphology_grade_valueset_id, morphology_grade_code, morphology_grade_system, morphology_grade | valueset_code | restrict |
Referenced by
embryo_assessment_morphological_findingsviaexam_oocyte_id
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/cytoplasmic_morphology | 7 |
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/first_polar_body_morphology | 5 |
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/maturity_of_cumulus_oocyte_complex | 4 |
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/metaphase_spindle_location | 2 |
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/metaphase_spindle_size | 3 |
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/oocyte_maturation_stage | 3 |
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/oocyte_shape | 2 |
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/oocyte_size | 3 |
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/perivitelline_space_morphology | 2 |
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/perivitelline_space_size | 3 |
org.openehr::openEHR-EHR-CLUSTER.exam_oocyte.v1/zona_pellucida_thickness | 3 |