Schema reference / Tables / view MDX source

apgar

A tool to assess the clinical status of the newborn infant immediately after birth and their response to resuscitation.

Purpose. To record the results for each component parameter and their total sum for the Apgar score.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.apgar.v2`	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.	—
`event_type`	`text`	yes	null represents any_event	—
`respiratory_effort` `respiratory_effort_code` `respiratory_effort_system` `respiratory_effort_numeric` `respiratory_effort_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Respiratory effort	`/data[at0002]/events[at0003]/data[at0001]/items[at0009]`
`heart_rate` `heart_rate_code` `heart_rate_system` `heart_rate_numeric` `heart_rate_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Heart rate	`/data[at0002]/events[at0003]/data[at0001]/items[at0005]`
`muscle_tone` `muscle_tone_code` `muscle_tone_system` `muscle_tone_numeric` `muscle_tone_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Muscle tone	`/data[at0002]/events[at0003]/data[at0001]/items[at0013]`
`reflex_irritability` `reflex_irritability_code` `reflex_irritability_system` `reflex_irritability_numeric` `reflex_irritability_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Reflex irritability	`/data[at0002]/events[at0003]/data[at0001]/items[at0017]`
`skin_colour` `skin_colour_code` `skin_colour_system` `skin_colour_numeric` `skin_colour_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Skin colour	`/data[at0002]/events[at0003]/data[at0001]/items[at0021]`
`total`	`integer`	yes	Total	`/data[at0002]/events[at0003]/data[at0001]/items[at0025]`

Constraints

check ((respiratory_effort_code is null and respiratory_effort_system is null and respiratory_effort_numeric is null and respiratory_effort is null) or (respiratory_effort_valueset_id is not null and respiratory_effort_code is not null and respiratory_effort_system is not null and respiratory_effort_numeric is not null and respiratory_effort is not null))
check ((heart_rate_code is null and heart_rate_system is null and heart_rate_numeric is null and heart_rate is null) or (heart_rate_valueset_id is not null and heart_rate_code is not null and heart_rate_system is not null and heart_rate_numeric is not null and heart_rate is not null))
check ((muscle_tone_code is null and muscle_tone_system is null and muscle_tone_numeric is null and muscle_tone is null) or (muscle_tone_valueset_id is not null and muscle_tone_code is not null and muscle_tone_system is not null and muscle_tone_numeric is not null and muscle_tone is not null))
check ((reflex_irritability_code is null and reflex_irritability_system is null and reflex_irritability_numeric is null and reflex_irritability is null) or (reflex_irritability_valueset_id is not null and reflex_irritability_code is not null and reflex_irritability_system is not null and reflex_irritability_numeric is not null and reflex_irritability is not null))
check ((skin_colour_code is null and skin_colour_system is null and skin_colour_numeric is null and skin_colour is null) or (skin_colour_valueset_id is not null and skin_colour_code is not null and skin_colour_system is not null and skin_colour_numeric is not null and skin_colour is not null))
check (total is null or total between 0 and 10)

Unique

form_block_id

References

Columns	Target	On delete
`form_id`	`form`	cascade
`form_id, form_block_id`	`form_block`	cascade
`respiratory_effort_valueset_id, respiratory_effort_code, respiratory_effort_system, respiratory_effort, respiratory_effort_numeric`	`valueset_code`	restrict
`heart_rate_valueset_id, heart_rate_code, heart_rate_system, heart_rate, heart_rate_numeric`	`valueset_code`	restrict
`muscle_tone_valueset_id, muscle_tone_code, muscle_tone_system, muscle_tone, muscle_tone_numeric`	`valueset_code`	restrict
`reflex_irritability_valueset_id, reflex_irritability_code, reflex_irritability_system, reflex_irritability, reflex_irritability_numeric`	`valueset_code`	restrict
`skin_colour_valueset_id, skin_colour_code, skin_colour_system, skin_colour, skin_colour_numeric`	`valueset_code`	restrict

Indexes

apgar_form_id_idx on form_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.apgar.v2/heart_rate`	3
`org.openehr::openEHR-EHR-OBSERVATION.apgar.v2/muscle_tone`	3
`org.openehr::openEHR-EHR-OBSERVATION.apgar.v2/reflex_irritability`	3
`org.openehr::openEHR-EHR-OBSERVATION.apgar.v2/respiratory_effort`	3
`org.openehr::openEHR-EHR-OBSERVATION.apgar.v2/skin_colour`	3