Allergy Intolerance Reaction - Metriport

The allergy_intolerance_reaction table records individual reactions that have occurred for an allergy/intolerance. Each allergy/intolerance can have multiple reactions. Primary Keys:

allergy_intolerance_reaction_id

Foreign Keys:

allergy_intolerance_id - links to the allergy intolerance table

Column	Data Type	Description
allergy_intolerance_reaction_id	varchar	Unique identifier for the allergy intolerance reaction
allergy_intolerance_id	varchar	Unique identifier for the allergy intolerance
snomed_code	varchar	SNOMED CT code for the specific substance or pharmaceutical product considered to be responsible for event
snomed_display	varchar	Human-readable description of SNOMED CT code
source_substance_code	varchar	Original code of the specific substance or pharmaceutical product considered to be responsible for event
source_substance_display	varchar	Original display of the specific substance or pharmaceutical product considered to be responsible for event
source_substance_system	varchar	Original system of the specific substance or pharmaceutical product considered to be responsible for event
onset_date	datetime	Date when the allergy/intolerance reaction began
severity	varchar	Severity of the reaction. Possible values: – `mild`: The reaction is mild in nature. – `moderate`: The reaction is moderate in nature. – `severe`: The reaction is severe in nature.

Related Tables:

Allergy Intolerance Reaction Manifestation - Records of specific manifestations of this reaction

⌘I