Person.PersonPhone

Columns

• //

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

  ${escapify(column.description)}
  PhoneNumber
  [Phone] NOT NULL

  //

  USER-DEFINED DATA TYPE

  [nvarchar](25) NULL
• //

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

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

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID
  UNIQUE CLUSTERED
  BusinessEntityID , PhoneNumber , PhoneNumberTypeID
• //

  Nonclustered index.
  IX_PersonPhone_PhoneNumber
  NONCLUSTERED
  PhoneNumber

Foreign Keys

• //

  Foreign key constraint referencing Person.BusinessEntityID.
  FK_PersonPhone_Person_BusinessEntityID
  Person.Person
  BusinessEntityID ⥱ BusinessEntityID
• //

  Foreign key constraint referencing PhoneNumberType.PhoneNumberTypeID.
  FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID
  Person.PhoneNumberType
  PhoneNumberTypeID ⥱ PhoneNumberTypeID

Sample Data