Schema reference / Tables / view MDX source
respiration
The characteristics of spontaneous breathing by an individual.
The characteristics of spontaneous breathing by an individual.
Purpose. To record the characteristics of spontaneous breathing by an individual.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-OBSERVATION.respiration.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. | — |
presencepresence_codepresence_systempresence_valueset_id | coded texttext, text, text, text | yes | Presence | /data[at0001]/events[at0002]/data[at0003]/items[at0062] |
rate_magnituderate_units | quantitynumeric, text | yes | Rate | /data[at0001]/events[at0002]/data[at0003]/items[at0004] |
regularityregularity_coderegularity_systemregularity_valueset_id | coded texttext, text, text, text | yes | Regularity | /data[at0001]/events[at0002]/data[at0003]/items[at0005] |
depthdepth_codedepth_systemdepth_valueset_id | coded texttext, text, text, text | yes | Depth | /data[at0001]/events[at0002]/data[at0003]/items[at0016] |
clinical_description | text | yes | Clinical description | /data[at0001]/events[at0002]/data[at0003]/items[at0024] |
clinical_interpretationclinical_interpretation_codeclinical_interpretation_systemclinical_interpretation_valueset_id | coded texttext, text, text, text | yes | Clinical interpretation | /data[at0001]/events[at0002]/data[at0003]/items[at0009] |
comment | text | yes | Comment | /data[at0001]/events[at0002]/data[at0003]/items[at0070] |
body_positionbody_position_codebody_position_systembody_position_valueset_id | coded texttext, text, text, text | yes | Body position | /data[at0001]/events[at0002]/state[at0022]/items[at0065] |
confounding_factors | text | yes | Confounding factors | /data[at0001]/events[at0002]/state[at0022]/items[at0056] |
inspired_oxygen | uuid | yes | Inspired oxygen | /data[at0001]/events[at0002]/state[at0022]/items[at0055] |
Constraints
check ((presence_code is null and presence_system is null and presence_valueset_id is null and presence is null) or (presence is not null and presence_code is not null and presence_system is not null and presence_valueset_id is not null))
check ((rate_magnitude is null and rate_units is null) or (rate_magnitude is not null and rate_units is not null))
check (rate_magnitude is null or (rate_units = '/min' and rate_magnitude between 0 and 200))
check ((regularity_code is null and regularity_system is null and regularity_valueset_id is null and regularity is null) or (regularity is not null and regularity_code is not null and regularity_system is not null and regularity_valueset_id is not null))
check ((depth_code is null and depth_system is null and depth_valueset_id is null and depth is null) or (depth is not null and depth_code is not null and depth_system is not null and depth_valueset_id is not null))
check ((clinical_interpretation_code is null and clinical_interpretation_system is null and clinical_interpretation_valueset_id is null) or (clinical_interpretation is not null and clinical_interpretation_code is not null and clinical_interpretation_system is not null and clinical_interpretation_valueset_id is not null))
check ((body_position_code is null and body_position_system is null and body_position_valueset_id is null and body_position is null) or (body_position is not null and body_position_code is not null and body_position_system is not null and body_position_valueset_id is not null))Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
presence_valueset_id, presence_code, presence_system, presence | valueset_code | restrict |
regularity_valueset_id, regularity_code, regularity_system, regularity | valueset_code | restrict |
depth_valueset_id, depth_code, depth_system, depth | valueset_code | restrict |
clinical_interpretation_valueset_id, clinical_interpretation_code, clinical_interpretation_system, clinical_interpretation | valueset_code | restrict |
body_position_valueset_id, body_position_code, body_position_system, body_position | valueset_code | restrict |
inspired_oxygen | inspired_oxygen | no action |
Indexes
respiration_form_id_idxonform_idrespiration_inspired_oxygen_idxoninspired_oxygen
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-OBSERVATION.respiration.v2/body_position | 5 |
org.openehr::openEHR-EHR-OBSERVATION.respiration.v2/depth | 4 |
org.openehr::openEHR-EHR-OBSERVATION.respiration.v2/presence | 2 |
org.openehr::openEHR-EHR-OBSERVATION.respiration.v2/regularity | 2 |