Person.Contact Table

Information

Name	Contact
Schema	Person
Row Count	0
Data Size
Index Size
Reserved Size
Unused Size
Created	29.3.2010. 21:58:18
Modified	29.3.2010. 21:58:56

Extended Properties

Name	Type	Property Name	Value
Contact	TABLE	MS_Description	Names of each employee, customer contact, and vendor contact.

Columns

Name	Data Type	Collation	Default
ContactID	int
NameStyle	bit		((0))
Title	nvarchar(8)	SQL_Latin1_General_CP1_CI_AS
FirstName	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
MiddleName	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
LastName	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
Suffix	nvarchar(10)	SQL_Latin1_General_CP1_CI_AS
EmailAddress	nvarchar(50)	SQL_Latin1_General_CP1_CI_AS
EmailPromotion	int		((0))
Phone	nvarchar(25)	SQL_Latin1_General_CP1_CI_AS
PasswordHash	varchar(128)	SQL_Latin1_General_CP1_CI_AS
PasswordSalt	varchar(10)	SQL_Latin1_General_CP1_CI_AS
AdditionalContactInfo	xml
rowguid	uniqueidentifier		(newid())
ModifiedDate	datetime		(getdate())

Indexes

Name	Type	Columns
PK_Contact_ContactID	Clustered	ContactID
AK_Contact_rowguid	NonClustered	rowguid
IX_Contact_EmailAddress	NonClustered	EmailAddress

Check Constraints

Name	Column	Enabled	Trusted	Expression
CK_Contact_EmailPromotion	EmailPromotion			([EmailPromotion]>=(0) AND [EmailPromotion]<=(2))

SQL Script

CREATE TABLE [Person].[Contact] (
    [ContactID] int NOT NULL IDENTITY,
    [NameStyle] bit NOT NULL DEFAULT ((0)),
    [Title] nvarchar(8) NULL,
    [FirstName] nvarchar(50) NOT NULL,
    [MiddleName] nvarchar(50) NULL,
    [LastName] nvarchar(50) NOT NULL,
    [Suffix] nvarchar(10) NULL,
    [EmailAddress] nvarchar(50) NULL,
    [EmailPromotion] int NOT NULL DEFAULT ((0)),
    [Phone] nvarchar(25) NULL,
    [PasswordHash] varchar(128) NOT NULL,
    [PasswordSalt] varchar(10) NOT NULL,
    [AdditionalContactInfo] xml NULL,
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_Contact_rowguid] on [Person].[Contact]([rowguid]);
CREATE INDEX [IX_Contact_EmailAddress] on [Person].[Contact]([EmailAddress]);