CREATE TABLE [dbo].[SAProspects]
(
[ProspectID] [int] NOT NULL IDENTITY(1, 1),
[ProspectName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CrmProspectID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[SalesRepID] [int] NOT NULL,
[Attn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Country] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Phone1] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Phone2] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fax] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Email] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebSite] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreatorID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SAProspects_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SAProspects_LastUpdate] DEFAULT (getdate()),
[Remarks] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[County] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaxCodeID] [int] NULL,
[PriceLevelID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAProspects] ADD CONSTRAINT [PK_SAProspects] PRIMARY KEY CLUSTERED ([ProspectID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAProspects] ADD CONSTRAINT [FK_SAProspects_PriceLevelID_ARPriceLevels] FOREIGN KEY ([PriceLevelID]) REFERENCES [dbo].[ARPriceLevels] ([PriceLevelID])
GO
ALTER TABLE [dbo].[SAProspects] ADD CONSTRAINT [FK_SAProspects_SalesRepID_ShAgents] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ShAgents] ([AgentID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[SAProspects] ADD CONSTRAINT [FK_SAProspects_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO