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,
)