Person.EmailAddress

Columns

• //

  ${escapify(column.description)}
  BusinessEntityID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  EmailAddressID
  [int] IDENTITY (1,1) NOT NULL
• //

  ${escapify(column.description)}
  EmailAddress
  [nvarchar](50) NULL
• //

  ${escapify(column.description)}
  rowguid
  [uniqueidentifier] NOT NULL DEFAULT (newid())
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_EmailAddress_BusinessEntityID_EmailAddressID
  UNIQUE CLUSTERED
  BusinessEntityID , EmailAddressID
• //

  Nonclustered index.
  IX_EmailAddress_EmailAddress
  NONCLUSTERED
  EmailAddress

Foreign Keys

• //

  Foreign key constraint referencing Person.BusinessEntityID.
  FK_EmailAddress_Person_BusinessEntityID
  Person.Person
  BusinessEntityID ⥱ BusinessEntityID

Sample Data