Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the MedOffer table |
| OfferUrl | varchar(max) | max | NULL allowed | | | Generated coupon/voucher URL used to view and print in PDF format. |
| OfferImageUrl | varchar(max) | max | NULL allowed | | | Generated coupon/voucher URL used to view and print in JPG format |
| PharmacyNotes | varchar(512) | 512 | NULL allowed | | | Dxc-generated notes to be sent to pharmacy for electronically submitted prescriptions. |
| CreatedDTTM | datetime | 8 | NULL allowed | | | Date/time the coupon was created (ie, retrieved from DXC) |
 | OfferExternalID | varchar(255) | 255 | NULL allowed | | | External ID from vendor representing a coupon offer. |
| SerializedOfferRequest | varchar(max) | max | NULL allowed | | | Serialized MedOffer object from DXC service |
 ![Foreign Keys FK_MedOffer_OriginatingID_Medication_ID: [dbo].[Medication].OriginatingID Foreign Keys FK_MedOffer_OriginatingID_Medication_ID: [dbo].[Medication].OriginatingID](../../../../Images/fk.png) | OriginatingID | [dbo].[uniqueid] | 9 | NOT NULL | | | Originating Medication. Link to Medication.ID |
 | OfferCancelDTTM | datetime | 8 | NOT NULL | | | Time stamp after which the offer can no longer be claimed |
| PrescribingUrl | varchar(max) | max | NOT NULL | | ('') | URL to Prescribing Information distributed by the pharmaceutical company. |
| StructuredOffer | varchar(max) | max | NULL allowed | | | eCoupon in a JSON format |
 ![Foreign Keys FK_MedOffer_MedOfferTypeDE_MedOffer_Type_DE_ID: [dbo].[MedOffer_Type_DE].MedOfferTypeDE Foreign Keys FK_MedOffer_MedOfferTypeDE_MedOffer_Type_DE_ID: [dbo].[MedOffer_Type_DE].MedOfferTypeDE](../../../../Images/fk.png) | MedOfferTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Type of coupon offer. Link to Medication_Type_DE.ID. |