Schema reference / Tables / view MDX source

obstetric_summary

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

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`	cascade
`form_id, form_block_id`	`form_block`	cascade

Indexes

obstetric_summary_form_id_idx on form_id