adverse_reaction_monitoring

Information about the outcome of monitoring for adverse reactions, during or after the administration of a substance.

Information about the outcome of monitoring for adverse reactions, during or after the administration of a substance.

Purpose. To record information about the outcome of monitoring for adverse reactions, during or after the administration of a substance.

Source

Columns

Constraints

check ((purpose_code is null and purpose_system is null and purpose_valueset_id is null) or (purpose is not null and purpose_code is not null and purpose_system is not null and purpose_valueset_id is not null))
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 ((reaction_code is null and reaction_system is null and reaction_valueset_id is null) or (reaction is not null and reaction_code is not null and reaction_system is not null and reaction_valueset_id is not null))
check ((method_code is null and method_system is null and method_valueset_id is null) or (method is not null and method_code is not null and method_system is not null and method_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• adverse_reaction_monitoring_substance_details via adverse_reaction_monitoring_id

Indexes

• adverse_reaction_monitoring_form_id_idx on form_id
• adverse_reaction_monitoring_reaction_event_idx on reaction_event

Child tables

1 table hang off adverse_reaction_monitoring, one row per repetition.

adverse_reaction_monitoring_substance_details

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

Unique

• adverse_reaction_monitoring_id, position
• adverse_reaction_monitoring_id, medication_detail_id

References

Indexes

• adverse_reaction_monitoring_substance_details_medication_9a3b3f on medication_detail_id

Value sets