Tables [dbo].[UnverifiedItem_Allergy]
Unverfied Allergy
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key CIX_UnverifiedItem_Allergy_UnverifiedItemID: UnverifiedItemIDForeign Keys FK_UnverifiedItem_Allergy_UnverifiedItemID_Unverified_Item_ID: [dbo].[Unverified_Item].UnverifiedItemIDUnverifiedItemID[dbo].[uniqueid]9NOT NULLUnverified Item Identifier. Link to Unverified_Item.ID
ReactionFuzzyWhenvarchar(50)50NULL allowedReaction Fuzzy date
ReactionFuzzySortAsdatetime8NULL allowedReaction Date
ReactionFuzzySpecificitychar(1)1NULL allowedReaction Date Type
 'D' - Date
 'F' - Fuzzy Date
Reaction1DE[dbo].[dict_id]5NOT NULLAllergy Reaction 1. Link to Allergen_Reaction_DE.ID
Reaction2DE[dbo].[dict_id]5NOT NULLAllergy Reaction 2. Link to Allergen_Reaction_DE.ID
Reaction3DE[dbo].[dict_id]5NOT NULLAllergy Reaction 3. Link to Allergen_Reaction_DE.ID
Reaction4DE[dbo].[dict_id]5NOT NULLAllergy Reaction 4. Link to Allergen_Reaction_DE.ID
Reaction5DE[dbo].[dict_id]5NOT NULLAllergy Reaction 5. Link to Allergen_Reaction_DE.ID
AllergyCategoryvarchar(255)255NOT NULL('')Allergy Category