Databases > AdventureWorks2019 > Tables > Person.PhoneNumberType

AdventureWorks2019

Person.PhoneNumberType

//
Type of phone number of a person.

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    PhoneNumberTypeID
    [int] IDENTITY (1,1) NOT NULL
  • //
    ${escapify(column.description)}
    Name
    [Name] NOT NULL
    //
    USER-DEFINED DATA TYPE
    [nvarchar](50) NULL
  • //
    ${escapify(column.description)}
    ModifiedDate
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • //
    Clustered index created by a primary key constraint.
    PK_PhoneNumberType_PhoneNumberTypeID
    UNIQUE CLUSTERED
    PhoneNumberTypeID

Sample Data

PhoneNumberTypeID
Name
ModifiedDate
1
Cell
2
Home
3
Work