Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.MedOffer_Image
Touchworks 25.2
[dbo].[MedOffer_Image]
MS_Description
eCoupon images in binary format that are tied to Medication Offer records
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
OfferExternalID
varchar(255)
255
NOT NULL
External ID from vendor representing a coupon offer
OriginatingMedicationID
[dbo].[uniqueid]
9
NOT NULL
ID of the original dbo.Medication record tied to this medOffer. Link to Medication.ID.
OfferImage
varbinary(max)
max
NULL allowed
The .jpg coupon image converted to a byte array
CreatedDTTM
datetime
8
NULL allowed
Date/Time that the entry was added
MedOfferTypeDE
[dbo].[dict_id]
5
NOT NULL
((0))
Type of coupon offer. Link to Medication_Type_DE.ID.