Schema reference / Tables / view MDX source
exam_blastocyst
Morphological findings obtained by microscopy of a human blastocyst.
Morphological findings obtained by microscopy of a human blastocyst.
Purpose. To record structured observations about a human blastocyst.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-CLUSTER.exam_blastocyst.v1 | openEHR | defines this table |
Columns
| Column | Type | Null | Description | Source |
|---|---|---|---|---|
id | uuid primary key | no | Primary key. | — |
degree_of_expansiondegree_of_expansion_codedegree_of_expansion_systemdegree_of_expansion_valueset_id | coded texttext, text, text, text | yes | Degree of expansion | /items[at0049] |
inner_cell_mass_morphologyinner_cell_mass_morphology_codeinner_cell_mass_morphology_systeminner_cell_mass_morphology_valueset_id | coded texttext, text, text, text | yes | Inner cell mass morphology | /items[at0056] |
trophectoderm_morphologytrophectoderm_morphology_codetrophectoderm_morphology_systemtrophectoderm_morphology_valueset_id | coded texttext, text, text, text | yes | Trophectoderm morphology | /items[at0060] |
other_morphological_features | text | yes | Other morphological features | /items[at0064] |
morphology_grademorphology_grade_codemorphology_grade_systemmorphology_grade_valueset_id | coded texttext, text, text, text | yes | Morphology grade | /items[at0068] |
Constraints
check ((degree_of_expansion_code is null and degree_of_expansion_system is null and degree_of_expansion_valueset_id is null) or (degree_of_expansion is not null and degree_of_expansion_code is not null and degree_of_expansion_system is not null and degree_of_expansion_valueset_id is not null))
check ((inner_cell_mass_morphology_code is null and inner_cell_mass_morphology_system is null and inner_cell_mass_morphology_valueset_id is null) or (inner_cell_mass_morphology is not null and inner_cell_mass_morphology_code is not null and inner_cell_mass_morphology_system is not null and inner_cell_mass_morphology_valueset_id is not null))
check ((trophectoderm_morphology_code is null and trophectoderm_morphology_system is null and trophectoderm_morphology_valueset_id is null) or (trophectoderm_morphology is not null and trophectoderm_morphology_code is not null and trophectoderm_morphology_system is not null and trophectoderm_morphology_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 |
|---|---|---|
degree_of_expansion_valueset_id, degree_of_expansion_code, degree_of_expansion_system, degree_of_expansion | valueset_code | restrict |
inner_cell_mass_morphology_valueset_id, inner_cell_mass_morphology_code, inner_cell_mass_morphology_system, inner_cell_mass_morphology | valueset_code | restrict |
trophectoderm_morphology_valueset_id, trophectoderm_morphology_code, trophectoderm_morphology_system, trophectoderm_morphology | valueset_code | restrict |
morphology_grade_valueset_id, morphology_grade_code, morphology_grade_system, morphology_grade | valueset_code | restrict |
Referenced by
embryo_assessment_morphological_findingsviaexam_blastocyst_id
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-CLUSTER.exam_blastocyst.v1/degree_of_expansion | 6 |
org.openehr::openEHR-EHR-CLUSTER.exam_blastocyst.v1/inner_cell_mass_morphology | 4 |
org.openehr::openEHR-EHR-CLUSTER.exam_blastocyst.v1/trophectoderm_morphology | 3 |