Databases
>
AdventureWorks2019
>
Tables
> Person.PhoneNumberType
AdventureWorks2019
Person.PhoneNumberType
//
Type of phone number of a person.
Created:
5/8/2023
Modified:
5/8/2023
Save
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
12/13/2017
2
Home
12/13/2017
3
Work
12/13/2017