Tables [dbo].[Contact]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:01 AM Thursday, March 21, 2019
Last Modified1:20:37 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_Contact_ContactID: ContactIDContactIDint4
False
1 - 1
Namenvarchar(128)256
False
Emailvarchar(128)128
False
Titlenvarchar(128)256
True
PhoneNrvarchar(64)64
True
Passwordvarchar(128)128
False
PasswordFormatint4
True
PasswordHashAlgorithmvarchar(10)10
True
PasswordSaltvarchar(128)128
True
IsApprovedbit1
False
CreationDatedatetime8
False
LastLoginDatedatetime8
True
LastPasswordChangedDatedatetime8
True
FailedPasswordAttemptCountint4
False
FailedPasswordAttemptWindowStartdatetime8
True
Commentnvarchar(255)510
True
Foreign Keys FK_Contact_UserPermissionsID_UserPermissions_UserPermissionsID: [dbo].[UserPermissions].UserPermissionsIDUserPermissionsIDint4
False
((5))
PreferredLCIDsmallint2
False
((1033))
HasAcceptedTermsAndConditionsbit1
False
((0))
HasAcknowledgedServerMaintenancebit1
False
((0))
StartupTutorialEnabledbit1
False
((1))
IncludeHierarchybit1
False
((0))
UseDetailedAccountSelectorbit1
False
((0))
Statesmallint2
False
((0))
KeyNameKey ColumnsUnique
Cluster Primary Key PK_Contact_ContactID: ContactIDPK_Contact_ContactIDContactID
True
NameColumns
FK_Contact_UserPermissionsID_UserPermissions_UserPermissionsIDUserPermissionsID->[dbo].[UserPermissions].[UserPermissionsID]
CREATE TABLE [dbo].[Contact]
(
[ContactID] [int] NOT NULL IDENTITY(1, 1),
[Name] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Email] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Title] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhoneNr] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Password] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PasswordFormat] [int] NULL,
[PasswordHashAlgorithm] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PasswordSalt] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsApproved] [bit] NOT NULL,
[CreationDate] [datetime] NOT NULL,
[LastLoginDate] [datetime] NULL,
[LastPasswordChangedDate] [datetime] NULL,
[FailedPasswordAttemptCount] [int] NOT NULL,
[FailedPasswordAttemptWindowStart] [datetime] NULL,
[Comment] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserPermissionsID] [int] NOT NULL CONSTRAINT [DF_Contact_UserPermissionsID] DEFAULT ((5)),
[PreferredLCID] [smallint] NOT NULL CONSTRAINT [DF_Contact_PreferredLCID] DEFAULT ((1033)),
[HasAcceptedTermsAndConditions] [bit] NOT NULL CONSTRAINT [DF_Contact_HasAcceptedTermsAndConditions] DEFAULT ((0)),
[HasAcknowledgedServerMaintenance] [bit] NOT NULL CONSTRAINT [DF_Contact_HasAcknowledgedServerMaintenance] DEFAULT ((0)),
[StartupTutorialEnabled] [bit] NOT NULL CONSTRAINT [DF_Contact_StartupTutorialEnabled] DEFAULT ((1)),
[IncludeHierarchy] [bit] NOT NULL CONSTRAINT [DF_Contact_IncludeHierarchy] DEFAULT ((0)),
[UseDetailedAccountSelector] [bit] NOT NULL CONSTRAINT [DF_Contact_UseDetailedAccountSelector] DEFAULT ((0)),
[State] [smallint] NOT NULL CONSTRAINT [DF_Contact_State] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Contact] ADD CONSTRAINT [PK_Contact_ContactID] PRIMARY KEY CLUSTERED  ([ContactID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Contact] ADD CONSTRAINT [FK_Contact_UserPermissionsID_UserPermissions_UserPermissionsID] FOREIGN KEY ([UserPermissionsID]) REFERENCES [dbo].[UserPermissions] ([UserPermissionsID])
GO