Contains objects related to names and addresses of customers, vendors, and employees
| Table | Description |
|---|---|
| Person.Address | Street address information for customers, employees, and vendors. |
| Person.AddressType | Types of addresses stored in the Address table. |
| Person.BusinessEntity | Source of the ID that connects vendors, customers, and employees with address and contact information. |
| Person.BusinessEntityAddress | Cross-reference table mapping customers, vendors, and employees to their addresses. |
| Person.BusinessEntityContact | Cross-reference table mapping stores, vendors, and employees to people |
| Person.ContactType | Lookup table containing the types of business entity contacts. |
| Person.CountryRegion | Lookup table containing the ISO standard codes for countries and regions. |
| Person.EmailAddress | Where to send a person email. |
| Person.Password | One way hashed authentication information |
| Person.Person | Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts. |
| Person.PersonPhone | Telephone number and type of a person. |
| Person.PhoneNumberType | Type of phone number of a person. |
| Person.StateProvince | State and province lookup table. |
| View | Description |
|---|---|
| Person.vAdditionalContactInfo | Displays the contact name and content from each element in the xml column AdditionalContactInfo for that person. |
| Person.vStateProvinceCountryRegion | Joins StateProvince table with CountryRegion table. |