Tables [dbo].[Account]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:00 AM Thursday, March 21, 2019
Last Modified1:20:42 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_Account_AccountID: AccountIDAccountIDint4
False
1 - 1
Foreign Keys FK_Account_ParentAccountID_Account_AccountID: [dbo].[Account].ParentAccountIDParentAccountIDint4
True
(NULL)
Namenvarchar(64)128
False
Locationnvarchar(32)64
True
Streetnvarchar(128)256
True
Citynvarchar(32)64
False
Statenvarchar(32)64
True
PostalCodevarchar(32)32
False
Countrynvarchar(64)128
False
PhoneNrvarchar(32)32
True
FaxNrvarchar(32)32
True
WebsiteUrlvarchar(64)64
True
Industrynvarchar(64)128
True
EmployeesNrint4
True
OnsiteUrlvarchar(64)64
True
CreationDatedatetime8
False
IncludeInViewerSyncsbit1
False
LastViewerSyncdatetime8
True
LastOnsiteReceivedatetime8
True
ERPAccountIDvarchar(1024)1024
True
LastERPPushdatetime8
True
LastERPPulldatetime8
True
CustIdvarchar(255)255
True
CustomerDiscountfloat8
True
ERPAccountDatavarchar(max)max
True
CRMAccountIDvarchar(1024)1024
True
LanguageLCIDint4
True
((1033))
LastWebAuditdatetime8
True
Deletedbit1
False
((0))
Foreign Keys FK_Account_DeletedByContactID_Contact_ContactID: [dbo].[Contact].DeletedByContactIDDeletedByContactIDint4
True
DeletionDatedatetime8
True
StreetDetailsnvarchar(128)256
True
IsLeafbit1
False
((1))
AccountGUIDuniqueidentifier16
False
(newid())
UpdateDatedatetime8
False
(getutcdate())
KeyNameKey ColumnsUnique
Cluster Primary Key PK_Account_AccountID: AccountIDPK_Account_AccountIDAccountID
True
NameColumns
FK_Account_DeletedByContactID_Contact_ContactIDDeletedByContactID->[dbo].[Contact].[ContactID]
FK_Account_ParentAccountID_Account_AccountIDParentAccountID->[dbo].[Account].[AccountID]
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