adverse_reaction_event

Information about a specific adverse reaction event caused by exposure to a specific substance.

Information about a specific adverse reaction event caused by exposure to a specific substance.

Purpose. To record information about a specific adverse reaction event caused by exposure to a specific substance.

Source

Columns

Constraints

check ((specific_substance_code is null and specific_substance_system is null and specific_substance_valueset_id is null) or (specific_substance is not null and specific_substance_code is not null and specific_substance_system is not null and specific_substance_valueset_id is not null))
check ((certainty_code is null and certainty_system is null and certainty_valueset_id is null) or (certainty is not null and certainty_code is not null and certainty_system is not null and certainty_valueset_id is not null))
check ((manifestation_code is null and manifestation_system is null and manifestation_valueset_id is null) or (manifestation is not null and manifestation_code is not null and manifestation_system is not null and manifestation_valueset_id is not null))
check ((severity_of_reaction_code is null and severity_of_reaction_system is null and severity_of_reaction_valueset_id is null) or (severity_of_reaction is not null and severity_of_reaction_code is not null and severity_of_reaction_system is not null and severity_of_reaction_valueset_id is not null))
check ((route_of_exposure_code is null and route_of_exposure_system is null and route_of_exposure_valueset_id is null) or (route_of_exposure is not null and route_of_exposure_code is not null and route_of_exposure_system is not null and route_of_exposure_valueset_id is not null))

References

Referenced by

• adverse_reaction_event_reaction_details via adverse_reaction_event_id
• adverse_reaction_event_information_source via adverse_reaction_event_id
• adverse_reaction_monitoring via reaction_event
• adverse_reaction_risk_reaction_event_summary via adverse_reaction_event_id

Child tables

2 tables hang off adverse_reaction_event, one row per repetition.

adverse_reaction_event_reaction_details

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

Constraints

check (num_nonnulls(anatomical_location_id, anatomical_location_relative_id, attachment_id, ctcae_id, symptom_sign_id) = 1)

Unique

• adverse_reaction_event_id, position

References

Indexes

• adverse_reaction_event_reaction_details_anatomical_locat_e49822 on anatomical_location_id
• adverse_reaction_event_reaction_details_anatomical_locat_aa1ffa on anatomical_location_relative_id
• adverse_reaction_event_reaction_details_attachment_id_idx on attachment_id
• adverse_reaction_event_reaction_details_ctcae_id_idx on ctcae_id
• adverse_reaction_event_reaction_details_symptom_sign_id_idx on symptom_sign_id

adverse_reaction_event_information_source

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

Constraints

check (num_nonnulls(organization_id, person_id) = 1)

Unique

• adverse_reaction_event_id, position

References

Indexes

• adverse_reaction_event_information_source_organization_id_idx on organization_id
• adverse_reaction_event_information_source_person_id_idx on person_id

Value sets