---
title: "embryo_assessment"
description: "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`](/docs/tables/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`<br />`id_system` | text, text<br />`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`<br />`developmental_stage_code`<br />`developmental_stage_system`<br />`developmental_stage_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Developmental stage | `/data[at0001]/events[at0002]/data[at0003]/items[at0036]` |
| `developmental_event`<br />`developmental_event_code`<br />`developmental_event_system`<br />`developmental_event_valueset_id` | coded text<br />`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`<br />`culture_dish_id_system` | text, text<br />`text`, `text` | yes | Culture dish ID | `/protocol[at0004]/items[at0006]` |
| `method`<br />`method_code`<br />`method_system`<br />`method_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Method | `/protocol[at0004]/items[at0007]` |

## Constraints

```sql
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

- `form_block_id`

## References

| Columns | Target | On delete |
|---|---|---|
| `form_id` | [`form`](/docs/tables/form) | cascade |
| `form_id, form_block_id` | [`form_block`](/docs/tables/form_block) | cascade |
| `developmental_stage_valueset_id, developmental_stage_code, developmental_stage_system, developmental_stage` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `developmental_event_valueset_id, developmental_event_code, developmental_event_system, developmental_event` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `method_valueset_id, method_code, method_system, method` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

- [`embryo_assessment_morphological_findings`](/docs/tables/embryo_assessment_morphological_findings) via `embryo_assessment_id`
- [`embryo_assessment_image_representation`](/docs/tables/embryo_assessment_image_representation) via `embryo_assessment_id`
- [`embryo_assessment_device`](/docs/tables/embryo_assessment_device) via `embryo_assessment_id`

## 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`](/docs/tables/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

```sql
check (num_nonnulls(exam_blastocyst_id, exam_embryo_id, exam_oocyte_id, exam_zygote_id) = 1)
```

#### Unique

- `embryo_assessment_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `embryo_assessment_id` | [`embryo_assessment`](/docs/tables/embryo_assessment) | cascade |
| `exam_blastocyst_id` | [`exam_blastocyst`](/docs/tables/exam_blastocyst) | no action |
| `exam_embryo_id` | [`exam_embryo`](/docs/tables/exam_embryo) | no action |
| `exam_oocyte_id` | [`exam_oocyte`](/docs/tables/exam_oocyte) | no action |
| `exam_zygote_id` | [`exam_zygote`](/docs/tables/exam_zygote) | no action |

#### Indexes

- `embryo_assessment_morphological_findings_exam_blastocyst_id_idx` on `exam_blastocyst_id`
- `embryo_assessment_morphological_findings_exam_embryo_id_idx` on `exam_embryo_id`
- `embryo_assessment_morphological_findings_exam_oocyte_id_idx` on `exam_oocyte_id`
- `embryo_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`](/docs/tables/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, position`
- `embryo_assessment_id, attachment_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `embryo_assessment_id` | [`embryo_assessment`](/docs/tables/embryo_assessment) | cascade |
| `attachment_id` | [`attachment`](/docs/tables/attachment) | restrict |

#### 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`](/docs/tables/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, position`
- `embryo_assessment_id, device_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `embryo_assessment_id` | [`embryo_assessment`](/docs/tables/embryo_assessment) | cascade |
| `device_id` | [`device`](/docs/tables/device) | no action |

#### 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 |

