categorical_loudness_scaling

A psychophysical method used to assess an individual's perception of loudness to acoustic stimuli of varying levels.

A psychophysical method used to assess an individual's perception of loudness to acoustic stimuli of varying levels.

Purpose. To record the responses from a categorical loudness scaling assessment and the derived loudness perception curve.

Source

Columns

Constraints

check ((frequency_of_test_stimulus_magnitude is null and frequency_of_test_stimulus_units is null) or (frequency_of_test_stimulus_magnitude is not null and frequency_of_test_stimulus_units is not null))
check (frequency_of_test_stimulus_magnitude is null or (frequency_of_test_stimulus_units = 'Hz' and frequency_of_test_stimulus_magnitude between 20 and 20000) or (frequency_of_test_stimulus_units = 'kHz' and frequency_of_test_stimulus_magnitude between 0.125 and 16))
check ((tested_side_code is null and tested_side_system is null and tested_side_valueset_id is null and tested_side is null) or (tested_side is not null and tested_side_code is not null and tested_side_system is not null and tested_side_valueset_id is not null))
check ((scaling_method_code is null and scaling_method_system is null and scaling_method_valueset_id is null) or (scaling_method is not null and scaling_method_code is not null and scaling_method_system is not null and scaling_method_valueset_id is not null))
check ((presentation_method_code is null and presentation_method_system is null and presentation_method_valueset_id is null) or (presentation_method is not null and presentation_method_code is not null and presentation_method_system is not null and presentation_method_valueset_id is not null))
check ((type_of_test_stimulus_code is null and type_of_test_stimulus_system is null and type_of_test_stimulus_valueset_id is null) or (type_of_test_stimulus is not null and type_of_test_stimulus_code is not null and type_of_test_stimulus_system is not null and type_of_test_stimulus_valueset_id is not null))
check ((test_environment_code is null and test_environment_system is null and test_environment_valueset_id is null) or (test_environment is not null and test_environment_code is not null and test_environment_system is not null and test_environment_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• categorical_loudness_scaling_measurement via categorical_loudness_scaling_id
• categorical_loudness_scaling_loudness_perception_curve via categorical_loudness_scaling_id
• categorical_loudness_scaling_no_test_result via categorical_loudness_scaling_id
• categorical_loudness_scaling_hearing_device_during_test via categorical_loudness_scaling_id
• categorical_loudness_scaling_test_environment_details via categorical_loudness_scaling_id

Indexes

• categorical_loudness_scaling_form_id_idx on form_id
• categorical_loudness_scaling_presentation_method_details_idx on presentation_method_details

Child tables

6 tables hang off categorical_loudness_scaling, one row per repetition.

categorical_loudness_scaling_measurement

Child table — one row per repetition, deleted with its parent.

Constraints

check ((stimulus_level_magnitude is null and stimulus_level_units is null) or (stimulus_level_magnitude is not null and stimulus_level_units is not null))
check (stimulus_level_magnitude is null or (stimulus_level_units = 'dB[SPL]{HL}' and stimulus_level_magnitude between -50 and 200))
check ((response_category_magnitude is null and response_category_units is null) or (response_category_magnitude is not null and response_category_units is not null))
check (response_category_magnitude is null or (response_category_units = '[arb''U]{CU}' and response_category_magnitude between 0 and 1000))

Unique

• categorical_loudness_scaling_id, position

References

categorical_loudness_scaling_loudness_perception_curve

Child table — one row per repetition, deleted with its parent.

Constraints

check ((lower_slope_value_magnitude is null and lower_slope_value_units is null) or (lower_slope_value_magnitude is not null and lower_slope_value_units is not null))
check (lower_slope_value_magnitude is null or (lower_slope_value_units = '[arb''U]{CU}/dB[SPL]{HL}' and lower_slope_value_magnitude between 0 and 100))
check ((upper_slope_value_magnitude is null and upper_slope_value_units is null) or (upper_slope_value_magnitude is not null and upper_slope_value_units is not null))
check (upper_slope_value_magnitude is null or (upper_slope_value_units = '[arb''U]{CU}/dB[SPL]{HL}' and upper_slope_value_magnitude between 0 and 100))

Unique

• categorical_loudness_scaling_id, position

References

Referenced by

• categorical_loudness_scaling_loudness_perception_curve_c_e5225e via categorical_loudness_scaling_loudness_perception_curve_id

categorical_loudness_scaling_loudness_perception_curve_c_e5225e

Child table — one row per repetition, deleted with its parent.

Constraints

check ((response_category_magnitude is null and response_category_units is null) or (response_category_magnitude is not null and response_category_units is not null))
check (response_category_magnitude is null or (response_category_units = '[arb''U]{CU}' and response_category_magnitude between 0 and 1000))
check ((stimulus_level_magnitude is null and stimulus_level_units is null) or (stimulus_level_magnitude is not null and stimulus_level_units is not null))
check (stimulus_level_magnitude is null or (stimulus_level_units = 'dB[SPL]{HL}' and stimulus_level_magnitude between -50 and 200))

Unique

• categorical_loudness_scaling_loudness_perception_curve_id, position

References

categorical_loudness_scaling_no_test_result

Child table — one row per repetition, deleted with its parent.

Unique

• categorical_loudness_scaling_id, position
• categorical_loudness_scaling_id, exclusion_exam_id

References

Indexes

• categorical_loudness_scaling_no_test_result_exclusion_ex_4c55fd on exclusion_exam_id

categorical_loudness_scaling_hearing_device_during_test

Child table — one row per repetition, deleted with its parent.

Constraints

check ((side_of_hearing_device_code is null and side_of_hearing_device_system is null and side_of_hearing_device_valueset_id is null and side_of_hearing_device is null) or (side_of_hearing_device is not null and side_of_hearing_device_code is not null and side_of_hearing_device_system is not null and side_of_hearing_device_valueset_id is not null))

Unique

• categorical_loudness_scaling_id, position

References

Indexes

• categorical_loudness_scaling_hearing_device_during_test__f37fff on hearing_device

categorical_loudness_scaling_test_environment_details

Child table — one row per repetition, deleted with its parent.

Unique

• categorical_loudness_scaling_id, position
• categorical_loudness_scaling_id, device_id

References

Indexes

• categorical_loudness_scaling_test_environment_details_de_673607 on device_id

Value sets