--- title: "respiration" description: "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`](/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. | — | | `presence`
`presence_code`
`presence_system`
`presence_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Presence | `/data[at0001]/events[at0002]/data[at0003]/items[at0062]` | | `rate_magnitude`
`rate_units` | quantity
`numeric`, `text` | yes | Rate | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]` | | `regularity`
`regularity_code`
`regularity_system`
`regularity_valueset_id` | coded text
`text`, `text`, `text`, `text` | yes | Regularity | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]` | | `depth`
`depth_code`
`depth_system`
`depth_valueset_id` | coded text
`text`, `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_interpretation`
`clinical_interpretation_code`
`clinical_interpretation_system`
`clinical_interpretation_valueset_id` | coded text
`text`, `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_position`
`body_position_code`
`body_position_system`
`body_position_valueset_id` | coded text
`text`, `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 ```sql 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`](/docs/tables/form) | cascade | | `form_id, form_block_id` | [`form_block`](/docs/tables/form_block) | cascade | | `presence_valueset_id, presence_code, presence_system, presence` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `regularity_valueset_id, regularity_code, regularity_system, regularity` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `depth_valueset_id, depth_code, depth_system, depth` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `clinical_interpretation_valueset_id, clinical_interpretation_code, clinical_interpretation_system, clinical_interpretation` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `body_position_valueset_id, body_position_code, body_position_system, body_position` | [`valueset_code`](/docs/tables/valueset_code) | restrict | | `inspired_oxygen` | [`inspired_oxygen`](/docs/tables/inspired_oxygen) | no action | ## Indexes - `respiration_form_id_idx` on `form_id` - `respiration_inspired_oxygen_idx` on `inspired_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 |