| AdventureWorks Database : Person Schema |
| Table | Description |
|---|---|
| Person.Address | Street address information for customers, employees, and vendors. |
| Person.AddressType | Types of addresses stored in the Address table. |
| Person.Contact | Names of each employee, customer contact, and vendor contact. |
| Person.ContactType | Lookup table containing the types of contacts stored in Contact. |
| Person.CountryRegion | Lookup table containing the ISO standard codes for countries and regions. |
| 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. |