---
title: "mini_bestest"
description: "A quantitative balance assessment tool."
---

A quantitative balance assessment tool.

**Purpose.** To record results for each component parameter, sub scores and their total sum for the Mini-BESTest.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.mini_bestest.v1` | 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. | — |
| `anticipatory__1_sit_to_stand`<br />`anticipatory__1_sit_to_stand_code`<br />`anticipatory__1_sit_to_stand_system`<br />`anticipatory__1_sit_to_stand_numeric`<br />`anticipatory__1_sit_to_stand_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | 1. Sit to stand | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]/items[at0006]` |
| `anticipatory__2_rise_to_toes`<br />`anticipatory__2_rise_to_toes_code`<br />`anticipatory__2_rise_to_toes_system`<br />`anticipatory__2_rise_to_toes_numeric`<br />`anticipatory__2_rise_to_toes_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | 2. Rise to toes | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]/items[at0010]` |
| `anticipatory__3_stand_on_one_leg_time_left_leg_acced5_magnitude`<br />`anticipatory__3_stand_on_one_leg_time_left_leg_acced5_units` | quantity<br />`numeric`, `text` | yes | Time left leg trial 1 | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]/items[at0015]/items[at0024]` |
| `anticipatory__3_stand_on_one_leg_time_left_leg_9fb541_magnitude`<br />`anticipatory__3_stand_on_one_leg_time_left_leg_9fb541_units` | quantity<br />`numeric`, `text` | yes | Time left leg trial 2 | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]/items[at0015]/items[at0025]` |
| `anticipatory__3_stand_on_one_leg_left_stand__453eae`<br />`anticipatory__3_stand_on_one_leg_left_stand__453eae_code`<br />`anticipatory__3_stand_on_one_leg_left_stand__453eae_system`<br />`anticipatory__3_stand_on_one_leg_left_stand__453eae_numeric`<br />`anticipatory__3_stand_on_one_leg_left_stand__453eae_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Left stand on one leg | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]/items[at0015]/items[at0016]` |
| `anticipatory__3_stand_on_one_leg_time_right_le_c86b76_magnitude`<br />`anticipatory__3_stand_on_one_leg_time_right_le_c86b76_units` | quantity<br />`numeric`, `text` | yes | Time right leg trial 1 | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]/items[at0015]/items[at0026]` |
| `anticipatory__3_stand_on_one_leg_time_right_le_6d3e77_magnitude`<br />`anticipatory__3_stand_on_one_leg_time_right_le_6d3e77_units` | quantity<br />`numeric`, `text` | yes | Time right leg trial 2 | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]/items[at0015]/items[at0027]` |
| `anticipatory__3_stand_on_one_leg_right_stand_efb020`<br />`anticipatory__3_stand_on_one_leg_right_stand_efb020_code`<br />`anticipatory__3_stand_on_one_leg_right_stand_efb020_system`<br />`anticipatory__3_stand_on_one_leg_right_stand_efb020_numeric`<br />`anticipatory__3_stand_on_one_leg_right_stand_efb020_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Right stand on one leg | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]/items[at0015]/items[at0020]` |
| `anticipatory_sub_score` | `integer` | yes | Sub score | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]/items[at0028]` |
| `reactive_postural_control__4_compensatory_st_7c78bc`<br />`reactive_postural_control__4_compensatory_st_7c78bc_code`<br />`reactive_postural_control__4_compensatory_st_7c78bc_system`<br />`reactive_postural_control__4_compensatory_st_7c78bc_numeric`<br />`reactive_postural_control__4_compensatory_st_7c78bc_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | 4. Compensatory stepping correction - forward | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0030]` |
| `reactive_postural_control__5_compensatory_st_647be0`<br />`reactive_postural_control__5_compensatory_st_647be0_code`<br />`reactive_postural_control__5_compensatory_st_647be0_system`<br />`reactive_postural_control__5_compensatory_st_647be0_numeric`<br />`reactive_postural_control__5_compensatory_st_647be0_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | 5. Compensatory stepping correction - backward | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0034]` |
| `reactive_postural_control__6_compensatory_st_204367`<br />`reactive_postural_control__6_compensatory_st_204367_code`<br />`reactive_postural_control__6_compensatory_st_204367_system`<br />`reactive_postural_control__6_compensatory_st_204367_numeric`<br />`reactive_postural_control__6_compensatory_st_204367_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Left | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0039]/items[at0040]` |
| `reactive_postural_control__6_compensatory_st_f3fd1a`<br />`reactive_postural_control__6_compensatory_st_f3fd1a_code`<br />`reactive_postural_control__6_compensatory_st_f3fd1a_system`<br />`reactive_postural_control__6_compensatory_st_f3fd1a_numeric`<br />`reactive_postural_control__6_compensatory_st_f3fd1a_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Right | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0039]/items[at0044]` |
| `reactive_postural_control_sub_score` | `integer` | yes | Sub score | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0052]` |
| `sensory_orientation_stance_time_eyes_open_magnitude`<br />`sensory_orientation_stance_time_eyes_open_units` | quantity<br />`numeric`, `text` | yes | Stance time - eyes open | `/data[at0001]/events[at0002]/data[at0003]/items[at0055]/items[at0102]` |
| `sensory_orientation__7_stance_feet_together__8fd517`<br />`sensory_orientation__7_stance_feet_together__8fd517_code`<br />`sensory_orientation__7_stance_feet_together__8fd517_system`<br />`sensory_orientation__7_stance_feet_together__8fd517_numeric`<br />`sensory_orientation__7_stance_feet_together__8fd517_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | 7. Stance (feet together); eyes open, firm surface | `/data[at0001]/events[at0002]/data[at0003]/items[at0055]/items[at0056]` |
| `sensory_orientation_stance_time_eyes_closed_magnitude`<br />`sensory_orientation_stance_time_eyes_closed_units` | quantity<br />`numeric`, `text` | yes | Stance time - eyes closed | `/data[at0001]/events[at0002]/data[at0003]/items[at0055]/items[at0103]` |
| `sensory_orientation__8_stance_feet_together__194111`<br />`sensory_orientation__8_stance_feet_together__194111_code`<br />`sensory_orientation__8_stance_feet_together__194111_system`<br />`sensory_orientation__8_stance_feet_together__194111_numeric`<br />`sensory_orientation__8_stance_feet_together__194111_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | 8. Stance (feet together); eyes closed, foam surface | `/data[at0001]/events[at0002]/data[at0003]/items[at0055]/items[at0060]` |
| `sensory_orientation_incline_time_magnitude`<br />`sensory_orientation_incline_time_units` | quantity<br />`numeric`, `text` | yes | Incline time | `/data[at0001]/events[at0002]/data[at0003]/items[at0055]/items[at0104]` |
| `sensory_orientation__9_incline_eyes_closed`<br />`sensory_orientation__9_incline_eyes_closed_code`<br />`sensory_orientation__9_incline_eyes_closed_system`<br />`sensory_orientation__9_incline_eyes_closed_numeric`<br />`sensory_orientation__9_incline_eyes_closed_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | 9. Incline - eyes closed | `/data[at0001]/events[at0002]/data[at0003]/items[at0055]/items[at0064]` |
| `sensory_orientation_sub_score` | `integer` | yes | Sub score | `/data[at0001]/events[at0002]/data[at0003]/items[at0055]/items[at0068]` |
| `dynamic_gait__10_change_in_gait_speed`<br />`dynamic_gait__10_change_in_gait_speed_code`<br />`dynamic_gait__10_change_in_gait_speed_system`<br />`dynamic_gait__10_change_in_gait_speed_numeric`<br />`dynamic_gait__10_change_in_gait_speed_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | 10. Change in gait speed | `/data[at0001]/events[at0002]/data[at0003]/items[at0069]/items[at0070]` |
| `dynamic_gait__11_walk_with_head_turns_horizontal`<br />`dynamic_gait__11_walk_with_head_turns_horizontal_code`<br />`dynamic_gait__11_walk_with_head_turns_horizontal_system`<br />`dynamic_gait__11_walk_with_head_turns_horizontal_numeric`<br />`dynamic_gait__11_walk_with_head_turns_horizontal_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | 11. Walk with head turns - horizontal | `/data[at0001]/events[at0002]/data[at0003]/items[at0069]/items[at0079]` |
| `dynamic_gait__12_walk_with_pivot_turns`<br />`dynamic_gait__12_walk_with_pivot_turns_code`<br />`dynamic_gait__12_walk_with_pivot_turns_system`<br />`dynamic_gait__12_walk_with_pivot_turns_numeric`<br />`dynamic_gait__12_walk_with_pivot_turns_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | 12. Walk with pivot turns | `/data[at0001]/events[at0002]/data[at0003]/items[at0069]/items[at0074]` |
| `dynamic_gait__13_step_over_obstacles`<br />`dynamic_gait__13_step_over_obstacles_code`<br />`dynamic_gait__13_step_over_obstacles_system`<br />`dynamic_gait__13_step_over_obstacles_numeric`<br />`dynamic_gait__13_step_over_obstacles_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | 13. Step over obstacles | `/data[at0001]/events[at0002]/data[at0003]/items[at0069]/items[at0083]` |
| `dynamic_gait__14_timed_up_go_with_dual_task_3__f0e4fd_magnitude`<br />`dynamic_gait__14_timed_up_go_with_dual_task_3__f0e4fd_units` | quantity<br />`numeric`, `text` | yes | Time TUG | `/data[at0001]/events[at0002]/data[at0003]/items[at0069]/items[at0088]/items[at0097]` |
| `dynamic_gait__14_timed_up_go_with_dual_task_3__e7036f_magnitude`<br />`dynamic_gait__14_timed_up_go_with_dual_task_3__e7036f_units` | quantity<br />`numeric`, `text` | yes | Time Dual Task TUG | `/data[at0001]/events[at0002]/data[at0003]/items[at0069]/items[at0088]/items[at0098]` |
| `dynamic_gait__14_timed_up_go_with_dual_task_3__8c2788_magnitude`<br />`dynamic_gait__14_timed_up_go_with_dual_task_3__8c2788_units` | quantity<br />`numeric`, `text` | yes | Speed change | `/data[at0001]/events[at0002]/data[at0003]/items[at0069]/items[at0088]/items[at0105]` |
| `dynamic_gait__14_timed_up_go_with_dual_task__257783`<br />`dynamic_gait__14_timed_up_go_with_dual_task__257783_code`<br />`dynamic_gait__14_timed_up_go_with_dual_task__257783_system`<br />`dynamic_gait__14_timed_up_go_with_dual_task__257783_numeric`<br />`dynamic_gait__14_timed_up_go_with_dual_task__257783_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Dual Task TUG | `/data[at0001]/events[at0002]/data[at0003]/items[at0069]/items[at0088]/items[at0093]` |
| `dynamic_gait_sub_score` | `integer` | yes | Sub score | `/data[at0001]/events[at0002]/data[at0003]/items[at0069]/items[at0099]` |
| `total_score` | `integer` | yes | Total score | `/data[at0001]/events[at0002]/data[at0003]/items[at0100]` |

## Constraints

```sql
check ((anticipatory__1_sit_to_stand_code is null and anticipatory__1_sit_to_stand_system is null and anticipatory__1_sit_to_stand_numeric is null and anticipatory__1_sit_to_stand is null) or (anticipatory__1_sit_to_stand_valueset_id is not null and anticipatory__1_sit_to_stand_code is not null and anticipatory__1_sit_to_stand_system is not null and anticipatory__1_sit_to_stand_numeric is not null and anticipatory__1_sit_to_stand is not null))
check ((anticipatory__2_rise_to_toes_code is null and anticipatory__2_rise_to_toes_system is null and anticipatory__2_rise_to_toes_numeric is null and anticipatory__2_rise_to_toes is null) or (anticipatory__2_rise_to_toes_valueset_id is not null and anticipatory__2_rise_to_toes_code is not null and anticipatory__2_rise_to_toes_system is not null and anticipatory__2_rise_to_toes_numeric is not null and anticipatory__2_rise_to_toes is not null))
check ((anticipatory__3_stand_on_one_leg_time_left_leg_acced5_magnitude is null and anticipatory__3_stand_on_one_leg_time_left_leg_acced5_units is null) or (anticipatory__3_stand_on_one_leg_time_left_leg_acced5_magnitude is not null and anticipatory__3_stand_on_one_leg_time_left_leg_acced5_units is not null))
check (anticipatory__3_stand_on_one_leg_time_left_leg_acced5_magnitude is null or (anticipatory__3_stand_on_one_leg_time_left_leg_acced5_units = 's' and anticipatory__3_stand_on_one_leg_time_left_leg_acced5_magnitude >= 0))
check ((anticipatory__3_stand_on_one_leg_time_left_leg_9fb541_magnitude is null and anticipatory__3_stand_on_one_leg_time_left_leg_9fb541_units is null) or (anticipatory__3_stand_on_one_leg_time_left_leg_9fb541_magnitude is not null and anticipatory__3_stand_on_one_leg_time_left_leg_9fb541_units is not null))
check (anticipatory__3_stand_on_one_leg_time_left_leg_9fb541_magnitude is null or (anticipatory__3_stand_on_one_leg_time_left_leg_9fb541_units = 's' and anticipatory__3_stand_on_one_leg_time_left_leg_9fb541_magnitude >= 0))
check ((anticipatory__3_stand_on_one_leg_left_stand__453eae_code is null and anticipatory__3_stand_on_one_leg_left_stand__453eae_system is null and anticipatory__3_stand_on_one_leg_left_stand__453eae_numeric is null and anticipatory__3_stand_on_one_leg_left_stand__453eae is null) or (anticipatory__3_stand_on_one_leg_left_stand__453eae_valueset_id is not null and anticipatory__3_stand_on_one_leg_left_stand__453eae_code is not null and anticipatory__3_stand_on_one_leg_left_stand__453eae_system is not null and anticipatory__3_stand_on_one_leg_left_stand__453eae_numeric is not null and anticipatory__3_stand_on_one_leg_left_stand__453eae is not null))
check ((anticipatory__3_stand_on_one_leg_time_right_le_c86b76_magnitude is null and anticipatory__3_stand_on_one_leg_time_right_le_c86b76_units is null) or (anticipatory__3_stand_on_one_leg_time_right_le_c86b76_magnitude is not null and anticipatory__3_stand_on_one_leg_time_right_le_c86b76_units is not null))
check (anticipatory__3_stand_on_one_leg_time_right_le_c86b76_magnitude is null or (anticipatory__3_stand_on_one_leg_time_right_le_c86b76_units = 's' and anticipatory__3_stand_on_one_leg_time_right_le_c86b76_magnitude >= 0))
check ((anticipatory__3_stand_on_one_leg_time_right_le_6d3e77_magnitude is null and anticipatory__3_stand_on_one_leg_time_right_le_6d3e77_units is null) or (anticipatory__3_stand_on_one_leg_time_right_le_6d3e77_magnitude is not null and anticipatory__3_stand_on_one_leg_time_right_le_6d3e77_units is not null))
check (anticipatory__3_stand_on_one_leg_time_right_le_6d3e77_magnitude is null or (anticipatory__3_stand_on_one_leg_time_right_le_6d3e77_units = 's' and anticipatory__3_stand_on_one_leg_time_right_le_6d3e77_magnitude >= 0))
check ((anticipatory__3_stand_on_one_leg_right_stand_efb020_code is null and anticipatory__3_stand_on_one_leg_right_stand_efb020_system is null and anticipatory__3_stand_on_one_leg_right_stand_efb020_numeric is null and anticipatory__3_stand_on_one_leg_right_stand_efb020 is null) or (anticipatory__3_stand_on_one_leg_right_stand_efb020_valueset_id is not null and anticipatory__3_stand_on_one_leg_right_stand_efb020_code is not null and anticipatory__3_stand_on_one_leg_right_stand_efb020_system is not null and anticipatory__3_stand_on_one_leg_right_stand_efb020_numeric is not null and anticipatory__3_stand_on_one_leg_right_stand_efb020 is not null))
check (anticipatory_sub_score is null or anticipatory_sub_score between 0 and 6)
check ((reactive_postural_control__4_compensatory_st_7c78bc_code is null and reactive_postural_control__4_compensatory_st_7c78bc_system is null and reactive_postural_control__4_compensatory_st_7c78bc_numeric is null and reactive_postural_control__4_compensatory_st_7c78bc is null) or (reactive_postural_control__4_compensatory_st_7c78bc_valueset_id is not null and reactive_postural_control__4_compensatory_st_7c78bc_code is not null and reactive_postural_control__4_compensatory_st_7c78bc_system is not null and reactive_postural_control__4_compensatory_st_7c78bc_numeric is not null and reactive_postural_control__4_compensatory_st_7c78bc is not null))
check ((reactive_postural_control__5_compensatory_st_647be0_code is null and reactive_postural_control__5_compensatory_st_647be0_system is null and reactive_postural_control__5_compensatory_st_647be0_numeric is null and reactive_postural_control__5_compensatory_st_647be0 is null) or (reactive_postural_control__5_compensatory_st_647be0_valueset_id is not null and reactive_postural_control__5_compensatory_st_647be0_code is not null and reactive_postural_control__5_compensatory_st_647be0_system is not null and reactive_postural_control__5_compensatory_st_647be0_numeric is not null and reactive_postural_control__5_compensatory_st_647be0 is not null))
check ((reactive_postural_control__6_compensatory_st_204367_code is null and reactive_postural_control__6_compensatory_st_204367_system is null and reactive_postural_control__6_compensatory_st_204367_numeric is null and reactive_postural_control__6_compensatory_st_204367 is null) or (reactive_postural_control__6_compensatory_st_204367_valueset_id is not null and reactive_postural_control__6_compensatory_st_204367_code is not null and reactive_postural_control__6_compensatory_st_204367_system is not null and reactive_postural_control__6_compensatory_st_204367_numeric is not null and reactive_postural_control__6_compensatory_st_204367 is not null))
check ((reactive_postural_control__6_compensatory_st_f3fd1a_code is null and reactive_postural_control__6_compensatory_st_f3fd1a_system is null and reactive_postural_control__6_compensatory_st_f3fd1a_numeric is null and reactive_postural_control__6_compensatory_st_f3fd1a is null) or (reactive_postural_control__6_compensatory_st_f3fd1a_valueset_id is not null and reactive_postural_control__6_compensatory_st_f3fd1a_code is not null and reactive_postural_control__6_compensatory_st_f3fd1a_system is not null and reactive_postural_control__6_compensatory_st_f3fd1a_numeric is not null and reactive_postural_control__6_compensatory_st_f3fd1a is not null))
check (reactive_postural_control_sub_score is null or reactive_postural_control_sub_score between 0 and 6)
check ((sensory_orientation_stance_time_eyes_open_magnitude is null and sensory_orientation_stance_time_eyes_open_units is null) or (sensory_orientation_stance_time_eyes_open_magnitude is not null and sensory_orientation_stance_time_eyes_open_units is not null))
check (sensory_orientation_stance_time_eyes_open_magnitude is null or (sensory_orientation_stance_time_eyes_open_units = 's' and sensory_orientation_stance_time_eyes_open_magnitude >= 0))
check ((sensory_orientation__7_stance_feet_together__8fd517_code is null and sensory_orientation__7_stance_feet_together__8fd517_system is null and sensory_orientation__7_stance_feet_together__8fd517_numeric is null and sensory_orientation__7_stance_feet_together__8fd517 is null) or (sensory_orientation__7_stance_feet_together__8fd517_valueset_id is not null and sensory_orientation__7_stance_feet_together__8fd517_code is not null and sensory_orientation__7_stance_feet_together__8fd517_system is not null and sensory_orientation__7_stance_feet_together__8fd517_numeric is not null and sensory_orientation__7_stance_feet_together__8fd517 is not null))
check ((sensory_orientation_stance_time_eyes_closed_magnitude is null and sensory_orientation_stance_time_eyes_closed_units is null) or (sensory_orientation_stance_time_eyes_closed_magnitude is not null and sensory_orientation_stance_time_eyes_closed_units is not null))
check (sensory_orientation_stance_time_eyes_closed_magnitude is null or (sensory_orientation_stance_time_eyes_closed_units = 's' and sensory_orientation_stance_time_eyes_closed_magnitude >= 0))
check ((sensory_orientation__8_stance_feet_together__194111_code is null and sensory_orientation__8_stance_feet_together__194111_system is null and sensory_orientation__8_stance_feet_together__194111_numeric is null and sensory_orientation__8_stance_feet_together__194111 is null) or (sensory_orientation__8_stance_feet_together__194111_valueset_id is not null and sensory_orientation__8_stance_feet_together__194111_code is not null and sensory_orientation__8_stance_feet_together__194111_system is not null and sensory_orientation__8_stance_feet_together__194111_numeric is not null and sensory_orientation__8_stance_feet_together__194111 is not null))
check ((sensory_orientation_incline_time_magnitude is null and sensory_orientation_incline_time_units is null) or (sensory_orientation_incline_time_magnitude is not null and sensory_orientation_incline_time_units is not null))
check (sensory_orientation_incline_time_magnitude is null or (sensory_orientation_incline_time_units = 's' and sensory_orientation_incline_time_magnitude >= 0))
check ((sensory_orientation__9_incline_eyes_closed_code is null and sensory_orientation__9_incline_eyes_closed_system is null and sensory_orientation__9_incline_eyes_closed_numeric is null and sensory_orientation__9_incline_eyes_closed is null) or (sensory_orientation__9_incline_eyes_closed_valueset_id is not null and sensory_orientation__9_incline_eyes_closed_code is not null and sensory_orientation__9_incline_eyes_closed_system is not null and sensory_orientation__9_incline_eyes_closed_numeric is not null and sensory_orientation__9_incline_eyes_closed is not null))
check (sensory_orientation_sub_score is null or sensory_orientation_sub_score between 0 and 6)
check ((dynamic_gait__10_change_in_gait_speed_code is null and dynamic_gait__10_change_in_gait_speed_system is null and dynamic_gait__10_change_in_gait_speed_numeric is null and dynamic_gait__10_change_in_gait_speed is null) or (dynamic_gait__10_change_in_gait_speed_valueset_id is not null and dynamic_gait__10_change_in_gait_speed_code is not null and dynamic_gait__10_change_in_gait_speed_system is not null and dynamic_gait__10_change_in_gait_speed_numeric is not null and dynamic_gait__10_change_in_gait_speed is not null))
check ((dynamic_gait__11_walk_with_head_turns_horizontal_code is null and dynamic_gait__11_walk_with_head_turns_horizontal_system is null and dynamic_gait__11_walk_with_head_turns_horizontal_numeric is null and dynamic_gait__11_walk_with_head_turns_horizontal is null) or (dynamic_gait__11_walk_with_head_turns_horizontal_valueset_id is not null and dynamic_gait__11_walk_with_head_turns_horizontal_code is not null and dynamic_gait__11_walk_with_head_turns_horizontal_system is not null and dynamic_gait__11_walk_with_head_turns_horizontal_numeric is not null and dynamic_gait__11_walk_with_head_turns_horizontal is not null))
check ((dynamic_gait__12_walk_with_pivot_turns_code is null and dynamic_gait__12_walk_with_pivot_turns_system is null and dynamic_gait__12_walk_with_pivot_turns_numeric is null and dynamic_gait__12_walk_with_pivot_turns is null) or (dynamic_gait__12_walk_with_pivot_turns_valueset_id is not null and dynamic_gait__12_walk_with_pivot_turns_code is not null and dynamic_gait__12_walk_with_pivot_turns_system is not null and dynamic_gait__12_walk_with_pivot_turns_numeric is not null and dynamic_gait__12_walk_with_pivot_turns is not null))
check ((dynamic_gait__13_step_over_obstacles_code is null and dynamic_gait__13_step_over_obstacles_system is null and dynamic_gait__13_step_over_obstacles_numeric is null and dynamic_gait__13_step_over_obstacles is null) or (dynamic_gait__13_step_over_obstacles_valueset_id is not null and dynamic_gait__13_step_over_obstacles_code is not null and dynamic_gait__13_step_over_obstacles_system is not null and dynamic_gait__13_step_over_obstacles_numeric is not null and dynamic_gait__13_step_over_obstacles is not null))
check ((dynamic_gait__14_timed_up_go_with_dual_task_3__f0e4fd_magnitude is null and dynamic_gait__14_timed_up_go_with_dual_task_3__f0e4fd_units is null) or (dynamic_gait__14_timed_up_go_with_dual_task_3__f0e4fd_magnitude is not null and dynamic_gait__14_timed_up_go_with_dual_task_3__f0e4fd_units is not null))
check (dynamic_gait__14_timed_up_go_with_dual_task_3__f0e4fd_magnitude is null or (dynamic_gait__14_timed_up_go_with_dual_task_3__f0e4fd_units = 's' and dynamic_gait__14_timed_up_go_with_dual_task_3__f0e4fd_magnitude >= 0))
check ((dynamic_gait__14_timed_up_go_with_dual_task_3__e7036f_magnitude is null and dynamic_gait__14_timed_up_go_with_dual_task_3__e7036f_units is null) or (dynamic_gait__14_timed_up_go_with_dual_task_3__e7036f_magnitude is not null and dynamic_gait__14_timed_up_go_with_dual_task_3__e7036f_units is not null))
check (dynamic_gait__14_timed_up_go_with_dual_task_3__e7036f_magnitude is null or (dynamic_gait__14_timed_up_go_with_dual_task_3__e7036f_units = 's' and dynamic_gait__14_timed_up_go_with_dual_task_3__e7036f_magnitude >= 0))
check ((dynamic_gait__14_timed_up_go_with_dual_task_3__8c2788_magnitude is null and dynamic_gait__14_timed_up_go_with_dual_task_3__8c2788_units is null) or (dynamic_gait__14_timed_up_go_with_dual_task_3__8c2788_magnitude is not null and dynamic_gait__14_timed_up_go_with_dual_task_3__8c2788_units is not null))
check ((dynamic_gait__14_timed_up_go_with_dual_task__257783_code is null and dynamic_gait__14_timed_up_go_with_dual_task__257783_system is null and dynamic_gait__14_timed_up_go_with_dual_task__257783_numeric is null and dynamic_gait__14_timed_up_go_with_dual_task__257783 is null) or (dynamic_gait__14_timed_up_go_with_dual_task__257783_valueset_id is not null and dynamic_gait__14_timed_up_go_with_dual_task__257783_code is not null and dynamic_gait__14_timed_up_go_with_dual_task__257783_system is not null and dynamic_gait__14_timed_up_go_with_dual_task__257783_numeric is not null and dynamic_gait__14_timed_up_go_with_dual_task__257783 is not null))
check (dynamic_gait_sub_score is null or dynamic_gait_sub_score between 0 and 10)
check (total_score is null or total_score between 0 and 28)
```

## 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 |
| `anticipatory__1_sit_to_stand_valueset_id, anticipatory__1_sit_to_stand_code, anticipatory__1_sit_to_stand_system, anticipatory__1_sit_to_stand, anticipatory__1_sit_to_stand_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `anticipatory__2_rise_to_toes_valueset_id, anticipatory__2_rise_to_toes_code, anticipatory__2_rise_to_toes_system, anticipatory__2_rise_to_toes, anticipatory__2_rise_to_toes_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `anticipatory__3_stand_on_one_leg_left_stand__453eae_valueset_id, anticipatory__3_stand_on_one_leg_left_stand__453eae_code, anticipatory__3_stand_on_one_leg_left_stand__453eae_system, anticipatory__3_stand_on_one_leg_left_stand__453eae, anticipatory__3_stand_on_one_leg_left_stand__453eae_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `anticipatory__3_stand_on_one_leg_right_stand_efb020_valueset_id, anticipatory__3_stand_on_one_leg_right_stand_efb020_code, anticipatory__3_stand_on_one_leg_right_stand_efb020_system, anticipatory__3_stand_on_one_leg_right_stand_efb020, anticipatory__3_stand_on_one_leg_right_stand_efb020_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `reactive_postural_control__4_compensatory_st_7c78bc_valueset_id, reactive_postural_control__4_compensatory_st_7c78bc_code, reactive_postural_control__4_compensatory_st_7c78bc_system, reactive_postural_control__4_compensatory_st_7c78bc, reactive_postural_control__4_compensatory_st_7c78bc_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `reactive_postural_control__5_compensatory_st_647be0_valueset_id, reactive_postural_control__5_compensatory_st_647be0_code, reactive_postural_control__5_compensatory_st_647be0_system, reactive_postural_control__5_compensatory_st_647be0, reactive_postural_control__5_compensatory_st_647be0_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `reactive_postural_control__6_compensatory_st_204367_valueset_id, reactive_postural_control__6_compensatory_st_204367_code, reactive_postural_control__6_compensatory_st_204367_system, reactive_postural_control__6_compensatory_st_204367, reactive_postural_control__6_compensatory_st_204367_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `reactive_postural_control__6_compensatory_st_f3fd1a_valueset_id, reactive_postural_control__6_compensatory_st_f3fd1a_code, reactive_postural_control__6_compensatory_st_f3fd1a_system, reactive_postural_control__6_compensatory_st_f3fd1a, reactive_postural_control__6_compensatory_st_f3fd1a_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `sensory_orientation__7_stance_feet_together__8fd517_valueset_id, sensory_orientation__7_stance_feet_together__8fd517_code, sensory_orientation__7_stance_feet_together__8fd517_system, sensory_orientation__7_stance_feet_together__8fd517, sensory_orientation__7_stance_feet_together__8fd517_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `sensory_orientation__8_stance_feet_together__194111_valueset_id, sensory_orientation__8_stance_feet_together__194111_code, sensory_orientation__8_stance_feet_together__194111_system, sensory_orientation__8_stance_feet_together__194111, sensory_orientation__8_stance_feet_together__194111_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `sensory_orientation__9_incline_eyes_closed_valueset_id, sensory_orientation__9_incline_eyes_closed_code, sensory_orientation__9_incline_eyes_closed_system, sensory_orientation__9_incline_eyes_closed, sensory_orientation__9_incline_eyes_closed_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `dynamic_gait__10_change_in_gait_speed_valueset_id, dynamic_gait__10_change_in_gait_speed_code, dynamic_gait__10_change_in_gait_speed_system, dynamic_gait__10_change_in_gait_speed, dynamic_gait__10_change_in_gait_speed_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `dynamic_gait__11_walk_with_head_turns_horizontal_valueset_id, dynamic_gait__11_walk_with_head_turns_horizontal_code, dynamic_gait__11_walk_with_head_turns_horizontal_system, dynamic_gait__11_walk_with_head_turns_horizontal, dynamic_gait__11_walk_with_head_turns_horizontal_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `dynamic_gait__12_walk_with_pivot_turns_valueset_id, dynamic_gait__12_walk_with_pivot_turns_code, dynamic_gait__12_walk_with_pivot_turns_system, dynamic_gait__12_walk_with_pivot_turns, dynamic_gait__12_walk_with_pivot_turns_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `dynamic_gait__13_step_over_obstacles_valueset_id, dynamic_gait__13_step_over_obstacles_code, dynamic_gait__13_step_over_obstacles_system, dynamic_gait__13_step_over_obstacles, dynamic_gait__13_step_over_obstacles_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `dynamic_gait__14_timed_up_go_with_dual_task__257783_valueset_id, dynamic_gait__14_timed_up_go_with_dual_task__257783_code, dynamic_gait__14_timed_up_go_with_dual_task__257783_system, dynamic_gait__14_timed_up_go_with_dual_task__257783, dynamic_gait__14_timed_up_go_with_dual_task__257783_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Indexes

- `mini_bestest_form_id_idx` on `form_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/_10_change_in_gait_speed` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/_11_walk_with_head_turns_horizontal` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/_12_walk_with_pivot_turns` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/_13_step_over_obstacles` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/_1_sit_to_stand` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/_2_rise_to_toes` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/_4_compensatory_stepping_correction_forward` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/_5_compensatory_stepping_correction_backward` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/_7_stance_feet_together_eyes_open_firm_surface` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/_8_stance_feet_together_eyes_closed_foam_surface` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/_9_incline_eyes_closed` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/dual_task_tug` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/left_stand_on_one_leg` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/left_value` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/right_stand_on_one_leg` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.mini_bestest.v1/right_value` | 3 |

