Person.PersonPhone - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Person
Name	PersonPhone
Module	People

Telephone number and type of a person.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		BusinessEntityID	int			Person.Person	Business entity identification number. Foreign key to Person.BusinessEntityID.
Business entity identification number. Foreign key to Person.BusinessEntityID. References: Person.Person
	2		PhoneNumber	nvarchar(25)				Telephone number identification number.
Telephone number identification number.
	3		PhoneNumberTypeID	int			Person.PhoneNumberType	Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID.
Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID. References: Person.PhoneNumberType
	4		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Person.PersonPhone		Person.Person	Person.PersonPhone.BusinessEntityID = Person.Person.BusinessEntityID	FK_PersonPhone_Person_BusinessEntityID Foreign key constraint referencing Person.BusinessEntityID.
Person.PersonPhone.BusinessEntityID = Person.Person.BusinessEntityID Name: FK_PersonPhone_Person_BusinessEntityID Foreign key constraint referencing Person.BusinessEntityID.
Person.PersonPhone		Person.PhoneNumberType	Person.PersonPhone.PhoneNumberTypeID = Person.PhoneNumberType.PhoneNumberTypeID	FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID Foreign key constraint referencing PhoneNumberType.PhoneNumberTypeID.
Person.PersonPhone.PhoneNumberTypeID = Person.PhoneNumberType.PhoneNumberTypeID Name: FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID Foreign key constraint referencing PhoneNumberType.PhoneNumberTypeID.

Unique keys

	Key name	Columns	Description
	PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID	BusinessEntityID, PhoneNumber, PhoneNumberTypeID	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
Person.PersonPhone
Person.Person
Person.PhoneNumberType

Used by

Name
Person.PersonPhone
HumanResources.vEmployee
Purchasing.vVendorWithContacts
Sales.vIndividualCustomer
Sales.vSalesPerson
Sales.vStoreWithContacts

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56