allergyintolerance_reaction

Details about each adverse reaction event linked to the allergy/intolerance (AllergyIntolerance.reaction[]). Previous version: allergy_intolerance_reaction Primary Keys:

allergyintolerance_reaction_id

Foreign Keys:

allergyintolerance_id - links to the allergyintolerance table

_{† Metriport Platform added}

Column	Data Type	Description
allergyintolerance_reaction_id	varchar	Unique identifier for the reaction
allergyintolerance_id	varchar	FK to the parent allergyintolerance record
onset	datetime	Date when the reaction began
substance_text	varchar	Free-text description of the substance
substance_snomed_code†	varchar	SNOMED CT code for the substance responsible for the event
substance_snomed_display†	varchar	Human-readable SNOMED CT description of the substance
severity	varchar	Severity of the reaction (mild, moderate, severe)

Related Tables: Parent:

allergyintolerance

Child:

Version diff

Renamed

allergy_intolerance_reaction_id → allergyintolerance_reaction_id
allergy_intolerance_id → allergyintolerance_id
onset_date → onset
snomed_code → substance_snomed_code
snomed_display → substance_snomed_display

Moved to separate tables

source_substance_code → allergyintolerance_reaction_substance_coding.code w/ code_rank = 1
source_substance_display → allergyintolerance_reaction_substance_coding.display w/ code_rank = 1
source_substance_system → allergyintolerance_reaction_substance_coding.system w/ code_rank = 1

allergyintolerance_clinicalstatus_coding allergyintolerance_reaction_substance_coding

⌘I

​Version diff

Version diff