CREATE TABLE [dbo].[Account]
(
[AccountID] [int] NOT NULL IDENTITY(1, 1),
[ParentAccountID] [int] NULL CONSTRAINT [DF_Account_ParentAccountID] DEFAULT (NULL),
[Name] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Location] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Street] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PostalCode] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PhoneNr] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FaxNr] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WebsiteUrl] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Industry] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EmployeesNr] [int] NULL,
[OnsiteUrl] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreationDate] [datetime] NOT NULL,
[IncludeInViewerSyncs] [bit] NOT NULL,
[LastViewerSync] [datetime] NULL,
[LastOnsiteReceive] [datetime] NULL,
[ERPAccountID] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastERPPush] [datetime] NULL,
[LastERPPull] [datetime] NULL,
[CustId] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerDiscount] [float] NULL,
[ERPAccountData] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CRMAccountID] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LanguageLCID] [int] NULL CONSTRAINT [DF_Account_LanguageLCID] DEFAULT ((1033)),
[LastWebAudit] [datetime] NULL,
[Deleted] [bit] NOT NULL CONSTRAINT [DF_Account_Deleted] DEFAULT ((0)),
[DeletedByContactID] [int] NULL,
[DeletionDate] [datetime] NULL,
[StreetDetails] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsLeaf] [bit] NOT NULL CONSTRAINT [DF_Account_IsLeaf] DEFAULT ((1)),
[AccountGUID] [uniqueidentifier] NOT NULL CONSTRAINT [DF__Account__Account__1209AD79] DEFAULT (newid()),
[UpdateDate] [datetime] NOT NULL CONSTRAINT [DF__Account__UpdateD__12FDD1B2] DEFAULT (getutcdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Account] ADD CONSTRAINT [PK_Account_AccountID] PRIMARY KEY CLUSTERED ([AccountID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Account] ADD CONSTRAINT [FK_Account_DeletedByContactID_Contact_ContactID] FOREIGN KEY ([DeletedByContactID]) REFERENCES [dbo].[Contact] ([ContactID])
GO
ALTER TABLE [dbo].[Account] ADD CONSTRAINT [FK_Account_ParentAccountID_Account_AccountID] FOREIGN KEY ([ParentAccountID]) REFERENCES [dbo].[Account] ([AccountID])
GO