Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.UnverifiedItem_Allergy
Touchworks 25.2
[dbo].[UnverifiedItem_Allergy]
MS_Description
Unverfied Allergy
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
UnverifiedItemID
[dbo].[uniqueid]
9
NOT NULL
Unverified Item Identifier. Link to Unverified_Item.ID
ReactionFuzzyWhen
varchar(50)
50
NULL allowed
Reaction Fuzzy date
ReactionFuzzySortAs
datetime
8
NULL allowed
Reaction Date
ReactionFuzzySpecificity
char(1)
1
NULL allowed
Reaction Date Type
'D' - Date
'F' - Fuzzy Date
Reaction1DE
[dbo].[dict_id]
5
NOT NULL
Allergy Reaction 1. Link to Allergen_Reaction_DE.ID
Reaction2DE
[dbo].[dict_id]
5
NOT NULL
Allergy Reaction 2. Link to Allergen_Reaction_DE.ID
Reaction3DE
[dbo].[dict_id]
5
NOT NULL
Allergy Reaction 3. Link to Allergen_Reaction_DE.ID
Reaction4DE
[dbo].[dict_id]
5
NOT NULL
Allergy Reaction 4. Link to Allergen_Reaction_DE.ID
Reaction5DE
[dbo].[dict_id]
5
NOT NULL
Allergy Reaction 5. Link to Allergen_Reaction_DE.ID
AllergyCategory
varchar(255)
255
NOT NULL
('')
Allergy Category