Tables [dbo].[Allergy_Reactions]
Extension to the Allergy table for storing part of instance data such as severity items. In future, the reaction data too will be moved to this table.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_Allergy_Reactions_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Allergy_Reactions table.
Cluster Key CIX_Allergy_Reactions_AllergyID: AllergyIDForeign Keys FK_Allergy_Reactions_AllergyID_Allergy_ID: [dbo].[Allergy].AllergyIDAllergyID[dbo].[uniqueid]9NOT NULLAllergy. Link to Allergy.ID
Foreign Keys FK_Allergy_Reactions_ReactionSeverityDE: [dbo].[Reaction_Severity_DE].ReactionSeverityDEReactionSeverityDE[dbo].[dict_id]5NOT NULLSeverity. Link to Reaction_Severity_DE.ID.
ReactionSequencetinyint1NOT NULLSequence number that connects to respective reaction.
LastUpdatedDTTMdatetime8NOT NULLLast modified time stamp.