light_projection_test

The assessment of an individual's ability to discriminate the directions of a light stimulus presented from different positions relative to a single eye.

The assessment of an individual's ability to discriminate the directions of a light stimulus presented from different positions relative to a single eye.

Purpose. To record the results of a light projection test for a single eye.

Source

Columns

Constraints

check ((eye_examined_code is null and eye_examined_system is null and eye_examined_valueset_id is null and eye_examined is null) or (eye_examined is not null and eye_examined_code is not null and eye_examined_system is not null and eye_examined_valueset_id is not null))
check ((overall_result_code is null and overall_result_system is null and overall_result_valueset_id is null and overall_result is null) or (overall_result is not null and overall_result_code is not null and overall_result_system is not null and overall_result_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• light_projection_test_per_light_position via light_projection_test_id

Indexes

• light_projection_test_form_id_idx on form_id

Child tables

1 table hang off light_projection_test, one row per repetition.

light_projection_test_per_light_position

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

Constraints

check ((light_position_code is null and light_position_system is null and light_position_valueset_id is null) or (light_position is not null and light_position_code is not null and light_position_system is not null and light_position_valueset_id is not null))
check ((response_code is null and response_system is null and response_valueset_id is null) or (response is not null and response_code is not null and response_system is not null and response_valueset_id is not null))
check ((correctness_code is null and correctness_system is null and correctness_valueset_id is null and correctness is null) or (correctness is not null and correctness_code is not null and correctness_system is not null and correctness_valueset_id is not null))

Unique

• light_projection_test_id, position

References

Value sets