Campaign

Table: Campaign

CREATE TABLE [dbo].[Campaign]

([Campaign_ID] [varchar](18) NOT NULL, [Campaign_Name] [varchar](255) NULL, [Campaign_Status] [varchar](18) NULL, [Campaign_Body] [varchar](1000) NULL, [Campaign_Description] [varchar](1000) NULL)

Sample Data

Table: Campaign Members

CREATE TABLE [dbo].[Campaign_Members]

( [CampaignMem_ID] [varchar](18) NOT NULL, [Campaign_ID] [varchar](18) NOT NULL, [Lead_ID] [varchar](18) NULL, [Clicked_Through] [bit] NULL, [Campaign_Mem_Status] [varchar](18) NULL, [Contact_ID] [varchar](18) NULL, [Date_Sent] [date] NULL)

Sample Data

Page updated

Google Sites

Report abuse