Generated using SQL Data Dictionary demo version.


Table Person.PersonPhone (19,972 rows)


Telephone number and type of a person.


  Column Data Type Identity Nullable Default
PK, FK BusinessEntityID int
Business entity identification number. Foreign key to Person.BusinessEntityID.
PK PhoneNumber Phone(nvarchar(25))
Telephone number identification number.
PK, FK PhoneNumberTypeID int
Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID.
ModifiedDate datetime getdate()
Date and time the record was last updated.

Indexes:


References:


Used by: