--- title: "obstetric_summary" description: "Summary or persistent information about the numbers of key obstetric events." --- Summary or persistent information about the numbers of key obstetric events. **Purpose.** To record summary or persistent information about the numbers of key obstetric events that may impact risk assessment or decision support. ## Source | Model | Leg | Role | |---|---|---| | `openEHR-EHR-EVALUATION.obstetric_summary.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. | — | | `description` | `text` | yes | Description | `/data[at0001]/items[at0025]` | | `gravidity` | `integer` | yes | Gravidity | `/data[at0001]/items[at0002]` | | `parity` | `integer` | yes | Parity | `/data[at0001]/items[at0003]` | | `term_births` | `integer` | yes | Term births | `/data[at0001]/items[at0015]` | | `preterm_births` | `integer` | yes | Preterm births | `/data[at0001]/items[at0016]` | | `abortions` | `integer` | yes | Abortions | `/data[at0001]/items[at0017]` | | `miscarriages` | `integer` | yes | Miscarriages | `/data[at0001]/items[at0004]` | | `terminations` | `integer` | yes | Terminations | `/data[at0001]/items[at0005]` | | `ectopic_pregnancies` | `integer` | yes | Ectopic pregnancies | `/data[at0001]/items[at0011]` | | `live_births` | `integer` | yes | Live births | `/data[at0001]/items[at0006]` | | `multiple_births` | `integer` | yes | Multiple births | `/data[at0001]/items[at0018]` | | `stillbirths` | `integer` | yes | Stillbirths | `/data[at0001]/items[at0012]` | | `neonatal_deaths` | `integer` | yes | Neonatal deaths | `/data[at0001]/items[at0028]` | | `caesarean_sections` | `integer` | yes | Caesarean sections | `/data[at0001]/items[at0027]` | | `comment` | `text` | yes | Comment | `/data[at0001]/items[at0026]` | | `last_updated` | `timestamptz` | yes | Last updated | `/protocol[at0008]/items[at0009]` | | `definition_of_viability_duration`
`definition_of_viability_quantity_magnitude`
`definition_of_viability_quantity_units` | quantity
`interval`, `numeric`, `text` | yes | Definition of viability | `/protocol[at0008]/items[at0021]` | ## Constraints ```sql check (gravidity is null or gravidity between 0 and 100) check (parity is null or parity between 0 and 100) check (term_births is null or term_births between 0 and 100) check (preterm_births is null or preterm_births between 0 and 100) check (abortions is null or abortions between 0 and 100) check (miscarriages is null or miscarriages between 0 and 100) check (terminations is null or terminations between 0 and 100) check (ectopic_pregnancies is null or ectopic_pregnancies between 0 and 100) check (live_births is null or live_births between 0 and 100) check (multiple_births is null or multiple_births between 0 and 100) check (stillbirths is null or stillbirths between 0 and 100) check ((definition_of_viability_quantity_magnitude is null and definition_of_viability_quantity_units is null) or (definition_of_viability_quantity_magnitude is not null and definition_of_viability_quantity_units is not null)) check (num_nonnulls(definition_of_viability_duration, definition_of_viability_quantity_magnitude) <= 1) ``` ## 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 | ## Indexes - `obstetric_summary_form_id_idx` on `form_id`