CREATE TABLE [dbo].[CMContacts]
(
[ContactID] [int] NOT NULL,
[ContactNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LastName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FirstName] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MiddleName] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PrefName] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PrefFullName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Zip] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Phone1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Phone2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Fax] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Email] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Active] [bit] NOT NULL,
[SalesRepID] [int] NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_CMContacts_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_CMContacts_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[PreferedContactMethodID] [int] NULL,
[EmailType] [bit] NULL,
[IncludeMeterInstructions] [bit] NOT NULL CONSTRAINT [DF_CMContacts_IncludeMeterInstructions] DEFAULT ((1)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_CMContacts_NoteFlag] DEFAULT ((0)),
[NoteCount] [int] NOT NULL CONSTRAINT [DF_CMContacts_NoteCount] DEFAULT ((0)),
[Attn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CMContacts_Attn] DEFAULT (''),
[SendShippingConfirmations] [bit] NOT NULL CONSTRAINT [DF_CMContacts_SendShippingConfirmations] DEFAULT ((0)),
[IncludeEquipRemarksInCommunication] [bit] NOT NULL CONSTRAINT [DF_CMContacts_IncludeEquipRemarksInCommunication] DEFAULT ((0)),
[TempWebPass] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TempWebPassDate] [datetime] NULL,
[TempWebPassEncType] [int] NULL,
[WebLogin] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CMContacts_WebLogin] DEFAULT (''),
[WebPass] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CMContacts_WebPass] DEFAULT (''),
[WebPassEncType] [int] NOT NULL CONSTRAINT [DF_CMContacts_WebPassEncType] DEFAULT ((1)),
[AllEmails] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CMContacts_AllEmails] DEFAULT (''),
[EinfoEnabled] [bit] NOT NULL CONSTRAINT [DF_CMContacts_EinfoEnabled] DEFAULT ((1)),
[HideDuplicateWarning] [bit] NULL CONSTRAINT [DF_CMContacts_HideDuplicateWarning] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CMContacts] ADD CONSTRAINT [PK_CMContacts] PRIMARY KEY CLUSTERED ([ContactID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CMContacts] ADD CONSTRAINT [FK_CMContacts_NoteID_CMContactNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[CMContactNotes] ([NoteID])
GO
ALTER TABLE [dbo].[CMContacts] ADD CONSTRAINT [FK_CMContacts_PreferedContactMethodID_CMContactMethods] FOREIGN KEY ([PreferedContactMethodID]) REFERENCES [dbo].[CMContactMethods] ([ContactMethodID])
GO
ALTER TABLE [dbo].[CMContacts] ADD CONSTRAINT [FK_CMContacts_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO