health_risk

Assessment of the potential and likelihood of future adverse health effects as determined by identified risk factors.

Assessment of the potential and likelihood of future adverse health effects as determined by identified risk factors.

Purpose. To record known risk factors for an identified disease, condition, or other potentially adverse health issue, and/or an evaluation of the likelihood of the individual experiencing it in the future. This archetype has been deliberately left open and broad in scope.

Source

Columns

Constraints

check ((health_risk_code is null and health_risk_system is null and health_risk_valueset_id is null) or (health_risk is not null and health_risk_code is not null and health_risk_system is not null and health_risk_valueset_id is not null))
check ((risk_assessment_code is null and risk_assessment_system is null and risk_assessment_valueset_id is null) or (risk_assessment is not null and risk_assessment_code is not null and risk_assessment_system is not null and risk_assessment_valueset_id is not null))
check ((assessment_type_code is null and assessment_type_system is null and assessment_type_valueset_id is null and assessment_type is null) or (assessment_type is not null and assessment_type_code is not null and assessment_type_system is not null and assessment_type_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• health_risk_risk_factors via health_risk_id

Indexes

• health_risk_form_id_idx on form_id

Child tables

2 tables hang off health_risk, one row per repetition.

health_risk_risk_factors

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

Constraints

check ((risk_factor_code is null and risk_factor_system is null and risk_factor_valueset_id is null) or (risk_factor is not null and risk_factor_code is not null and risk_factor_system is not null and risk_factor_valueset_id is not null))
check ((presence_code is null and presence_system is null and presence_valueset_id is null and presence is null) or (presence is not null and presence_code is not null and presence_system is not null and presence_valueset_id is not null))

Unique

• health_risk_id, position

References

Referenced by

• health_risk_risk_factors_detail via health_risk_risk_factors_id

health_risk_risk_factors_detail

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

Unique

• health_risk_risk_factors_id, position
• health_risk_risk_factors_id, family_prevalence_id

References

Indexes

• health_risk_risk_factors_detail_family_prevalence_id_idx on family_prevalence_id

Value sets