![adventureworks2012 personttype adventureworks2012 personttype](https://gccontent.blob.core.windows.net/gccontent/blogs/legacy/c1/2010/5/1205.TheModelDiagramSM_thumb_05C5C979.png)
Foreign key to BusinessEntity.BusinessEntityID. Pk PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID ( BusinessEntityID, AddressID, AddressTypeID )Ĭlustered index created by a primary key constraint.
![adventureworks2012 personttype adventureworks2012 personttype](https://sqlperformance.com/wp-content/uploads/2015/01/image.png)
d BusinessEntityAddress Table Person.BusinessEntityAddressĬross-reference table mapping customers, vendors, and employees to their addresses. Name of the telephone number type t ModifiedDate datetime ModifiedDateĭate and time the record was last updated. Referred by PersonPhone ( PhoneNumberTypeID ) Name name Name Primary key for telephone number type records. Pk PK_PhoneNumberType_PhoneNumberTypeID ( PhoneNumberTypeID )Ĭlustered index created by a primary key constraint. StateProvince ref CountryRegion ( CountryRegionCode ) PhoneNumberType Table Person.PhoneNumberType PersonPhone ref PhoneNumberType ( PhoneNumberTypeID ) Fk FK_Address_StateProvince_StateProvinceIDĪddress ref StateProvince ( StateProvinceID ) Fk FK_StateProvince_CountryRegion_CountryRegionCode PersonPhone ref Person ( BusinessEntityID ) Fk FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID
#ADVENTUREWORKS2012 PERSONTTYPE PASSWORD#
Password ref Person ( BusinessEntityID ) Fk FK_EmailAddress_Person_BusinessEntityIDĮmailAddress ref Person ( BusinessEntityID ) Fk FK_PersonPhone_Person_BusinessEntityID Fk FK_BusinessEntityAddress_Address_AddressIDīusinessEntityAddress ref Address ( AddressID ) Fk FK_BusinessEntityAddress_AddressType_AddressTypeIDīusinessEntityAddress ref AddressType ( AddressTypeID ) Fk FK_BusinessEntityAddress_BusinessEntity_BusinessEntityIDīusinessEntityAddress ref BusinessEntity ( BusinessEntityID ) Fk FK_BusinessEntit圜ontact_BusinessEntity_BusinessEntityIDīusinessEntit圜ontact ref BusinessEntity ( BusinessEntityID ) Fk FK_BusinessEntit圜ontact_ContactType_ContactTypeIDīusinessEntit圜ontact ref ContactType ( ContactTypeID ) Fk FK_BusinessEntit圜ontact_Person_PersonIDīusinessEntit圜ontact ref Person ( PersonID -> BusinessEntityID ) Fk FK_Password_Person_BusinessEntityID
![adventureworks2012 personttype adventureworks2012 personttype](https://qawithexperts.com/Images/Upload/07-05-2018/paging-in-sql-server-min.png)
1 Person Move the mouse over tables & columns to read the comments.