Code on Time Project

I would like a small Project Created in Codeontime. * The database will consist of two tables. * A table which will contain a list of customers. This will contain all the customer contact detail information. * Another table will consist of Customer Communications , a list of emails or sms's sent to the customer. * The Web site will allow me to filter on Customers and send them an email or an SMS and the result is written to the communication table. * I can also navigate to a single customer record in edit mode and send that customer an email or SMS. * The email must be HTML format so when writing the email is should display a HTML editor. Must be written in <[login to view URL]> ## Deliverables Here are the tables CREATE TABLE [dbo].[Customer]( [CustomerID] [int] IDENTITY(1,1) NOT NULL, [NoSMS] [int] NULL, [NoEmails] [int] NULL, [Contact Title] [nvarchar] (255) NULL, [Contact First Name] [nvarchar] (255) NULL, [Contact Surname] [nvarchar] (255) NULL, [Company Name] [nvarchar] (255) NULL, [Address 1] [nvarchar] (255) NULL, [Address 2] [nvarchar] (255) NULL, [Address 3] [nvarchar] (255) NULL, [Address 4] [nvarchar] (255) NULL, [Combined] [nvarchar] (255) NULL, [Phone] [nvarchar] (255) NULL, [Fax] [nvarchar] (255) NULL, [Mobile No] [nvarchar] (255) NULL, [UserName] [char] (20) NULL, [Password] [nvarchar] (20) NULL, [Active] [bit] NULL, [Email] [nvarchar] (50) NULL, [Insurance] [nvarchar] (50) NULL, [Description] [nvarchar] (4000) NULL, [CreatedDate] [datetime] NULL, [Comment] [varchar] (100) NULL, [Status] [int] NULL ) CREATE TABLE [dbo].[Communication]( [CommunicationID] [int] IDENTITY(1,1) NOT NULL, [CustomerID] [int] NULL, [Type] [varchar] (50) NULL, [Subject] [varchar] (200) NULL, [Text] [varchar] (8000) NULL, [CreatedDate] [datetime] NULL, [CreatedBy] [varchar] (50) NULL, [UpdatedBy] [varchar] (50) NULL, [UpdatedDate] [datetime] NULL, )