allergyintolerance_reaction_manifestation

Clinical symptoms/signs associated with an adverse reaction event (AllergyIntolerance.reaction[].manifestation[]). Previous version: allergy_intolerance_reaction_manifestation Primary Keys:

allergyintolerance_reaction_manifestation_id

Foreign Keys:

allergyintolerance_reaction_id - links to the allergyintolerance_reaction table

_{† Metriport Platform added}

Column	Data Type	Description
allergyintolerance_reaction_manifestation_id	varchar	Unique identifier for the manifestation
allergyintolerance_reaction_id	varchar	FK to the parent allergyintolerance_reaction record
text	varchar	Free-text description of the manifestation
snomed_code†	varchar	SNOMED CT code for the manifestation
snomed_display†	varchar	Human-readable SNOMED CT description

Related Tables: Parent:

allergyintolerance_reaction

Child:

allergyintolerance_reaction_manifestation_coding

Version diff

Renamed

allergy_intolerance_reaction_manifestation_id → allergyintolerance_reaction_manifestation_id
allergy_intolerance_reaction_id → allergyintolerance_reaction_id

Moved to separate tables

source_manifestation_code → allergyintolerance_reaction_manifestation_coding.code w/ code_rank = 1
source_manifestation_display → allergyintolerance_reaction_manifestation_coding.display w/ code_rank = 1
source_manifestation_system → allergyintolerance_reaction_manifestation_coding.system w/ code_rank = 1

allergyintolerance_reaction_substance_coding allergyintolerance_reaction_manifestation_coding

⌘I

​Version diff

Version diff