AllergyIntolerance.reaction[]).
Previous version: allergy_intolerance_reaction
Primary Keys:
- allergyintolerance_reaction_id
- 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) |
Version diff
Renamedallergy_intolerance_reaction_id→allergyintolerance_reaction_idallergy_intolerance_id→allergyintolerance_idonset_date→onsetsnomed_code→substance_snomed_codesnomed_display→substance_snomed_display
source_substance_code→allergyintolerance_reaction_substance_coding.codew/code_rank = 1source_substance_display→allergyintolerance_reaction_substance_coding.displayw/code_rank = 1source_substance_system→allergyintolerance_reaction_substance_coding.systemw/code_rank = 1