Schema reference / Tables / view MDX source
braden_scale
The Braden scale is a tool used to assess the risk of pressure ulcer development in adults and children over the age of five years.
The Braden scale is a tool used to assess the risk of pressure ulcer development in adults and children over the age of five years.
Purpose. To record information about factors used to assess the risk of pressure ulcer development, and the total Braden Scale score.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-OBSERVATION.braden_scale.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. | — |
sensory_perceptionsensory_perception_codesensory_perception_systemsensory_perception_numericsensory_perception_valueset_id | coded texttext, text, text, numeric, text | yes | Sensory perception | /data[at0001]/events[at0002]/data[at0003]/items[at0004] |
moisturemoisture_codemoisture_systemmoisture_numericmoisture_valueset_id | coded texttext, text, text, numeric, text | yes | Moisture | /data[at0001]/events[at0002]/data[at0003]/items[at0009] |
activityactivity_codeactivity_systemactivity_numericactivity_valueset_id | coded texttext, text, text, numeric, text | yes | Activity | /data[at0001]/events[at0002]/data[at0003]/items[at0010] |
mobilitymobility_codemobility_systemmobility_numericmobility_valueset_id | coded texttext, text, text, numeric, text | yes | Mobility | /data[at0001]/events[at0002]/data[at0003]/items[at0019] |
nutritionnutrition_codenutrition_systemnutrition_numericnutrition_valueset_id | coded texttext, text, text, numeric, text | yes | Nutrition | /data[at0001]/events[at0002]/data[at0003]/items[at0020] |
friction_and_shearfriction_and_shear_codefriction_and_shear_systemfriction_and_shear_numericfriction_and_shear_valueset_id | coded texttext, text, text, numeric, text | yes | Friction and shear | /data[at0001]/events[at0002]/data[at0003]/items[at0021] |
comment | text | yes | Comment | /data[at0001]/events[at0002]/data[at0003]/items[at0034] |
total_score | integer | yes | Total score | /data[at0001]/events[at0002]/data[at0003]/items[at0022] |
Constraints
check ((sensory_perception_code is null and sensory_perception_system is null and sensory_perception_numeric is null and sensory_perception is null) or (sensory_perception_valueset_id is not null and sensory_perception_code is not null and sensory_perception_system is not null and sensory_perception_numeric is not null and sensory_perception is not null))
check ((moisture_code is null and moisture_system is null and moisture_numeric is null and moisture is null) or (moisture_valueset_id is not null and moisture_code is not null and moisture_system is not null and moisture_numeric is not null and moisture is not null))
check ((activity_code is null and activity_system is null and activity_numeric is null and activity is null) or (activity_valueset_id is not null and activity_code is not null and activity_system is not null and activity_numeric is not null and activity is not null))
check ((mobility_code is null and mobility_system is null and mobility_numeric is null and mobility is null) or (mobility_valueset_id is not null and mobility_code is not null and mobility_system is not null and mobility_numeric is not null and mobility is not null))
check ((nutrition_code is null and nutrition_system is null and nutrition_numeric is null and nutrition is null) or (nutrition_valueset_id is not null and nutrition_code is not null and nutrition_system is not null and nutrition_numeric is not null and nutrition is not null))
check ((friction_and_shear_code is null and friction_and_shear_system is null and friction_and_shear_numeric is null and friction_and_shear is null) or (friction_and_shear_valueset_id is not null and friction_and_shear_code is not null and friction_and_shear_system is not null and friction_and_shear_numeric is not null and friction_and_shear is not null))
check (total_score is null or total_score between 6 and 23)Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
sensory_perception_valueset_id, sensory_perception_code, sensory_perception_system, sensory_perception, sensory_perception_numeric | valueset_code | restrict |
moisture_valueset_id, moisture_code, moisture_system, moisture, moisture_numeric | valueset_code | restrict |
activity_valueset_id, activity_code, activity_system, activity, activity_numeric | valueset_code | restrict |
mobility_valueset_id, mobility_code, mobility_system, mobility, mobility_numeric | valueset_code | restrict |
nutrition_valueset_id, nutrition_code, nutrition_system, nutrition, nutrition_numeric | valueset_code | restrict |
friction_and_shear_valueset_id, friction_and_shear_code, friction_and_shear_system, friction_and_shear, friction_and_shear_numeric | valueset_code | restrict |
Indexes
braden_scale_form_id_idxonform_id
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-OBSERVATION.braden_scale.v1/activity | 4 |
org.openehr::openEHR-EHR-OBSERVATION.braden_scale.v1/friction_and_shear | 3 |
org.openehr::openEHR-EHR-OBSERVATION.braden_scale.v1/mobility | 4 |
org.openehr::openEHR-EHR-OBSERVATION.braden_scale.v1/moisture | 4 |
org.openehr::openEHR-EHR-OBSERVATION.braden_scale.v1/nutrition | 4 |
org.openehr::openEHR-EHR-OBSERVATION.braden_scale.v1/sensory_perception | 4 |