Table: Promo Code
CREATE TABLE [dbo].[Promo_Code]
([PromoCode_ID] [varchar](18) NOT NULL, [Promo_code] [varchar](18) NOT NULL, [PromoCode_Status] [varchar](18) NOT NULL, [Start_Date] [datetime] NOT NULL, [End_Date] [datetime] NOT NULL, [CreatedById] [varchar](18) NOT NULL, [CreatedDate] [datetime] NOT NULL, [LastModifiedById] [varchar](18) NOT NULL, [Discount] [varchar](18) NOT NULL, [Description] [varchar](255) NULL, [LastModifiedDate] [timestamp] NOT NULL)
Sample Data