Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Allergy_Reactions
Touchworks 25.2
[dbo].[Allergy_Reactions]
MS_Description
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.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Allergy_Reactions table.
AllergyID
[dbo].[uniqueid]
9
NOT NULL
Allergy. Link to Allergy.ID
ReactionSeverityDE
[dbo].[dict_id]
5
NOT NULL
Severity. Link to Reaction_Severity_DE.ID.
ReactionSequence
tinyint
1
NOT NULL
Sequence number that connects to respective reaction.
LastUpdatedDTTM
datetime
8
NOT NULL
Last modified time stamp.