Search in table

Address

Street address information for customers, employees, and vendors.

AddressType

Types of addresses stored in the Address table.

BusinessEntity

Source of the ID that connects vendors, customers, and employees with address and contact information.

BusinessEntityAddress

Cross-reference table mapping customers, vendors, and employees to their addresses.

BusinessEntityContact

Cross-reference table mapping stores, vendors, and employees to people

ContactType

Lookup table containing the types of business entity contacts.

CountryRegion

Lookup table containing the ISO standard codes for countries and regions.

EmailAddress

Where to send a person email.

Password

One way hashed authentication information

Person

Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts.

Person_json

NULL

Person_Temporal

NULL

Person_Temporal_History

NULL

PersonPhone

Telephone number and type of a person.

PhoneNumberType

Type of phone number of a person.

StateProvince

State and province lookup table.

Table

The physical table is an implementation within a relational database and is linked via a trace to the logical data model. Physical tables are converted to table structures in (relational databases). That is why columns and associations are worked out for these tables. Multiple types of constraints or rules can be added to the tables, columns and associations. Think of primary and foreign keys, check constraints and the like.