problem_diagnosis

Details about a single identified health condition, injury, disability or any other issue which impacts on the physical, mental and/or social well-being of an individual.

Details about a single identified health condition, injury, disability or any other issue which impacts on the physical, mental and/or social well-being of an individual.

Purpose. For recording details about a single, identified health problem or diagnosis.

Source

Columns

Constraints

check ((problem_diagnosis_name_code is null and problem_diagnosis_name_system is null and problem_diagnosis_name_valueset_id is null) or (problem_diagnosis_name is not null and problem_diagnosis_name_code is not null and problem_diagnosis_name_system is not null and problem_diagnosis_name_valueset_id is not null))
check ((variant_code is null and variant_system is null and variant_valueset_id is null) or (variant is not null and variant_code is not null and variant_system is not null and variant_valueset_id is not null))
check ((body_site_code is null and body_site_system is null and body_site_valueset_id is null) or (body_site is not null and body_site_code is not null and body_site_system is not null and body_site_valueset_id is not null))
check ((cause_code is null and cause_system is null and cause_valueset_id is null) or (cause is not null and cause_code is not null and cause_system is not null and cause_valueset_id is not null))
check ((severity_code is null and severity_system is null and severity_valueset_id is null) or (severity is not null and severity_code is not null and severity_system is not null and severity_valueset_id is not null))
check ((diagnostic_certainty_code is null and diagnostic_certainty_system is null and diagnostic_certainty_valueset_id is null) or (diagnostic_certainty is not null and diagnostic_certainty_code is not null and diagnostic_certainty_system is not null and diagnostic_certainty_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• problem_diagnosis_structured_body_site via problem_diagnosis_id
• problem_diagnosis_status via problem_diagnosis_id

Indexes

• problem_diagnosis_form_id_idx on form_id

Child tables

2 tables hang off problem_diagnosis, one row per repetition.

problem_diagnosis_structured_body_site

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

Constraints

check (num_nonnulls(anatomical_location_id, anatomical_location_circle_id, anatomical_location_relative_id) = 1)

Unique

• problem_diagnosis_id, position

References

Indexes

• problem_diagnosis_structured_body_site_anatomical_locati_0e4c9d on anatomical_location_id
• problem_diagnosis_structured_body_site_anatomical_locati_f80316 on anatomical_location_circle_id
• problem_diagnosis_structured_body_site_anatomical_locati_2cddcd on anatomical_location_relative_id

problem_diagnosis_status

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

Unique

• problem_diagnosis_id, position
• problem_diagnosis_id, problem_qualifier_id

References

Indexes

• problem_diagnosis_status_problem_qualifier_id_idx on problem_qualifier_id

Value sets