Schema reference / Tables / view MDX source

exam_zygote

Morphological findings obtained by microscopy of the human zygote.

Purpose. To record structured observations of the human zygote.

Source

Model	Leg	Role
`openEHR-EHR-CLUSTER.exam_zygote.v1`	openEHR	defines this table

Columns

Column	Type	Null	Description	Source
`id`	`uuid primary key`	no	Primary key.	—
`number_of_pronuclei`	`integer`	yes	Number of pronuclei	`/items[at0005]`
`pronuclear_symmetry` `pronuclear_symmetry_code` `pronuclear_symmetry_system` `pronuclear_symmetry_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Pronuclear symmetry	`/items[at0001]`
`pronuclear_morphology` `pronuclear_morphology_code` `pronuclear_morphology_system` `pronuclear_morphology_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Pronuclear morphology	`/items[at0002]`
`number_of_polar_bodies`	`integer`	yes	Number of polar bodies	`/items[at0034]`
`polar_body_morphology` `polar_body_morphology_code` `polar_body_morphology_system` `polar_body_morphology_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Polar body morphology	`/items[at0003]`
`cytoplasmic_morphology` `cytoplasmic_morphology_code` `cytoplasmic_morphology_system` `cytoplasmic_morphology_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Cytoplasmic morphology	`/items[at0004]`
`nucleolar_precursor_bodies` `nucleolar_precursor_bodies_code` `nucleolar_precursor_bodies_system` `nucleolar_precursor_bodies_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Nucleolar precursor bodies	`/items[at0019]`
`other_morphological_features`	`text`	yes	Other morphological features	`/items[at0028]`
`morphology_grade` `morphology_grade_code` `morphology_grade_system` `morphology_grade_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Morphology grade	`/items[at0032]`

Constraints

check ((pronuclear_symmetry_code is null and pronuclear_symmetry_system is null and pronuclear_symmetry_valueset_id is null) or (pronuclear_symmetry is not null and pronuclear_symmetry_code is not null and pronuclear_symmetry_system is not null and pronuclear_symmetry_valueset_id is not null))
check ((pronuclear_morphology_code is null and pronuclear_morphology_system is null and pronuclear_morphology_valueset_id is null) or (pronuclear_morphology is not null and pronuclear_morphology_code is not null and pronuclear_morphology_system is not null and pronuclear_morphology_valueset_id is not null))
check ((polar_body_morphology_code is null and polar_body_morphology_system is null and polar_body_morphology_valueset_id is null) or (polar_body_morphology is not null and polar_body_morphology_code is not null and polar_body_morphology_system is not null and polar_body_morphology_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 ((nucleolar_precursor_bodies_code is null and nucleolar_precursor_bodies_system is null and nucleolar_precursor_bodies_valueset_id is null) or (nucleolar_precursor_bodies is not null and nucleolar_precursor_bodies_code is not null and nucleolar_precursor_bodies_system is not null and nucleolar_precursor_bodies_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
`pronuclear_symmetry_valueset_id, pronuclear_symmetry_code, pronuclear_symmetry_system, pronuclear_symmetry`	`valueset_code`	restrict
`pronuclear_morphology_valueset_id, pronuclear_morphology_code, pronuclear_morphology_system, pronuclear_morphology`	`valueset_code`	restrict
`polar_body_morphology_valueset_id, polar_body_morphology_code, polar_body_morphology_system, polar_body_morphology`	`valueset_code`	restrict
`cytoplasmic_morphology_valueset_id, cytoplasmic_morphology_code, cytoplasmic_morphology_system, cytoplasmic_morphology`	`valueset_code`	restrict
`nucleolar_precursor_bodies_valueset_id, nucleolar_precursor_bodies_code, nucleolar_precursor_bodies_system, nucleolar_precursor_bodies`	`valueset_code`	restrict
`morphology_grade_valueset_id, morphology_grade_code, morphology_grade_system, morphology_grade`	`valueset_code`	restrict

Referenced by

embryo_assessment_morphological_findings via exam_zygote_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-CLUSTER.exam_zygote.v1/cytoplasmic_morphology`	4
`org.openehr::openEHR-EHR-CLUSTER.exam_zygote.v1/nucleolar_precursor_bodies`	3
`org.openehr::openEHR-EHR-CLUSTER.exam_zygote.v1/polar_body_morphology`	4
`org.openehr::openEHR-EHR-CLUSTER.exam_zygote.v1/pronuclear_morphology`	3
`org.openehr::openEHR-EHR-CLUSTER.exam_zygote.v1/pronuclear_symmetry`	2