Import Adventureworks Database

--

Version 1.0
Created date 19-12-2017

Address

Street address information for customers, employees, and vendors.

Author Bert Dingemans
Alias --
Stereotypes table
Details of Address

AddressType

Types of addresses stored in the Address table.

Author Bert Dingemans
Alias --
Stereotypes table
Details of AddressType

BusinessEntity

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

Author Bert Dingemans
Alias --
Stereotypes table
Details of BusinessEntity

BusinessEntityAddress

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

Author Bert Dingemans
Alias --
Stereotypes table
Details of BusinessEntityAddress

BusinessEntityContact

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

Author Bert Dingemans
Alias --
Stereotypes table
Details of BusinessEntityContact

ContactType

Lookup table containing the types of business entity contacts.

Author Bert Dingemans
Alias --
Stereotypes table
Details of ContactType

CountryRegion

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

Author Bert Dingemans
Alias --
Stereotypes table
Details of CountryRegion

EmailAddress

Where to send a person email.

Author Bert Dingemans
Alias --
Stereotypes table
Details of EmailAddress

Password

One way hashed authentication information

Author Bert Dingemans
Alias --
Stereotypes table
Details of Password

Person

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

Author Bert Dingemans
Alias --
Stereotypes table
Details of Person

Person_json

--

Author Bert Dingemans
Alias --
Stereotypes table
Details of Person_json

Person_Temporal

--

Author Bert Dingemans
Alias --
Stereotypes table
Details of Person_Temporal

Person_Temporal_History

--

Author Bert Dingemans
Alias --
Stereotypes table
Details of Person_Temporal_History

PersonPhone

Telephone number and type of a person.

Author Bert Dingemans
Alias --
Stereotypes table
Details of PersonPhone

PhoneNumberType

Type of phone number of a person.

Author Bert Dingemans
Alias --
Stereotypes table
Details of PhoneNumberType

StateProvince

State and province lookup table.

Author Bert Dingemans
Alias --
Stereotypes table
Details of StateProvince