LISTING 1: Creating the Contact Table

CREATE TABLE [dbo].[Contact] (
	[ContactID] [int] IDENTITY (1, 1) NOT NULL ,
	[ADTPID] [char] (10) NULL ,
	[InterestListFlag] [char] (1) NULL ,
	[InstructorFlag] [char] (1) NULL ,
	[PrimaryContact] [char] (1) NULL ,
	[TrainingProspect] [char] (1) NULL ,
	[ConsultingProspect] [char] (1) NULL ,
	[CompanyName] [char] (100) NULL ,
	[FirstName] [char] (50) NULL ,
	[LastName] [char] (70) NULL ,
	[Title] [char] (150) NULL ,
	[Address1] [char] (150) NULL ,
	[Address2] [char] (100) NULL ,
	[City] [varchar] (75) NULL ,
	[StateProvince] [char] (100) NULL ,
	[ZIP] [char] (60) NULL ,
	[Country] [varchar] (75) NULL ,
	[Phone] [char] (40) NULL ,
	[MobilePhone] [char] (40) NULL ,
	[Pager] [char] (40) NULL ,
	[Fax] [char] (40) NULL ,
	[Email] [char] (70) NULL ,
	[Comments] [text] NULL ,
	[DateAdded] [datetime] NULL ,
	[PendingVerification] [char] (1) NULL ,
	[WebSite] [char] (100) NULL ,
	[MetContactAt] [char] (100) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]