mini_bestest

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

Columns

Constraints

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

Indexes

• mini_bestest_form_id_idx on form_id

Value sets