adverse_reaction_risk

Clinical assessment of the propensity for an individual to experience a harmful or undesirable physiological response if exposed, or re-exposed, to a substance.

Clinical assessment of the propensity for an individual to experience a harmful or undesirable physiological response if exposed, or re-exposed, to a substance.

Purpose. To record the clinical assessment of the propensity for an individual to experience an adverse reaction if exposed, or re-exposed, to a specified substance or class of substances.

Source

Columns

Constraints

check ((substance_code is null and substance_system is null and substance_valueset_id is null) or (substance is not null and substance_code is not null and substance_system is not null and substance_valueset_id is not null))
check ((active_inactive_status_code is null and active_inactive_status_system is null and active_inactive_status_valueset_id is null) or (active_inactive_status is not null and active_inactive_status_code is not null and active_inactive_status_system is not null and active_inactive_status_valueset_id is not null))
check ((verification_status_code is null and verification_status_system is null and verification_status_valueset_id is null) or (verification_status is not null and verification_status_code is not null and verification_status_system is not null and verification_status_valueset_id is not null))
check ((criticality_code is null and criticality_system is null and criticality_valueset_id is null) or (criticality is not null and criticality_code is not null and criticality_system is not null and criticality_valueset_id is not null))
check ((category_code is null and category_system is null and category_valueset_id is null) or (category is not null and category_code is not null and category_system is not null and category_valueset_id is not null))
check ((reaction_mechanism_code is null and reaction_mechanism_system is null and reaction_mechanism_valueset_id is null) or (reaction_mechanism is not null and reaction_mechanism_code is not null and reaction_mechanism_system is not null and reaction_mechanism_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• adverse_reaction_risk_reaction_event_summary via adverse_reaction_risk_id

Indexes

• adverse_reaction_risk_form_id_idx on form_id

Child tables

1 table hang off adverse_reaction_risk, one row per repetition.

adverse_reaction_risk_reaction_event_summary

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

Unique

• adverse_reaction_risk_id, position
• adverse_reaction_risk_id, adverse_reaction_event_id

References

Indexes

• adverse_reaction_risk_reaction_event_summary_adverse_rea_dc1156 on adverse_reaction_event_id

Value sets