Tables [dbo].[MedOffer_Image]
eCoupon images in binary format that are tied to Medication Offer records
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_MedOffer_Image: OfferExternalID\MedOfferTypeDEOfferExternalIDvarchar(255)255NOT NULLExternal ID from vendor representing a coupon offer
Indexes NIX_MedOffer_Image_OriginatingMedicationIDOriginatingMedicationID[dbo].[uniqueid]9NOT NULLID of the original dbo.Medication record tied to this medOffer. Link to Medication.ID.
OfferImagevarbinary(max)maxNULL allowedThe .jpg coupon image converted to a byte array
Indexes nix_MedOffer_Image_CreatedDTTMCreatedDTTMdatetime8NULL allowedDate/Time that the entry was added
Cluster Primary Key PK_MedOffer_Image: OfferExternalID\MedOfferTypeDEForeign Keys FK_MedOffer_Image_MedOfferTypeDE_MedOffer_Type_DE_ID: [dbo].[MedOffer_Type_DE].MedOfferTypeDEMedOfferTypeDE[dbo].[dict_id]5NOT NULL((0))Type of coupon offer. Link to Medication_Type_DE.ID.