| Default FileGroup |  |
| Read Only |  |
Properties
Tables
| Table | Description |
|---|---|
| dbo.AWBuildVersion | Current version number of the AdventureWorks 2016 sample database. |
| dbo.DatabaseLog | Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. |
| dbo.ErrorLog | Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct. |
| HumanResources.Department | Lookup table containing the departments within the Adventure Works Cycles company. |
| HumanResources.Employee | Employee information such as salary, department, and title. |
| HumanResources.EmployeeDepartmentHistory | Employee department transfers. |
| HumanResources.EmployeePayHistory | Employee pay history. |
| HumanResources.JobCandidate | Résumés submitted to Human Resources by job applicants. |
| HumanResources.Shift | Work shift lookup table. |
| 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. |
| Production.BillOfMaterials | Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components. |
| Production.Culture | Lookup table containing the languages in which some AdventureWorks data is stored. |
| Production.Document | Product maintenance documents. |
| Production.Illustration | Bicycle assembly diagrams. |
| Production.Location | Product inventory and manufacturing locations. |
| Production.Product | Products sold or used in the manfacturing of sold products. |
| Production.ProductCategory | High-level product categorization. |
| Production.ProductCostHistory | Changes in the cost of a product over time. |
| Production.ProductDescription | Product descriptions in several languages. |
| Production.ProductDocument | Cross-reference table mapping products to related product documents. |
| Production.ProductInventory | Product inventory information. |
| Production.ProductListPriceHistory | Changes in the list price of a product over time. |
| Production.ProductModel | Product model classification. |
| Production.ProductModelIllustration | Cross-reference table mapping product models and illustrations. |
| Production.ProductModelProductDescriptionCulture | Cross-reference table mapping product descriptions and the language the description is written in. |
| Production.ProductPhoto | Product images. |
| Production.ProductProductPhoto | Cross-reference table mapping products and product photos. |
| Production.ProductReview | Customer reviews of products they have purchased. |
| Production.ProductSubcategory | Product subcategories. See ProductCategory table. |
| Production.ScrapReason | Manufacturing failure reasons lookup table. |
| Production.TransactionHistory | Record of each purchase order, sales order, or work order transaction year to date. |
| Production.TransactionHistoryArchive | Transactions for previous years. |
| Production.UnitMeasure | Unit of measure lookup table. |
| Production.WorkOrder | Manufacturing work orders. |
| Production.WorkOrderRouting | Work order details. |
| Purchasing.ProductVendor | Vendors are added to the table before any POs are processed. |
| Purchasing.PurchaseOrderDetail | Individual products associated with a specific purchase order. See PurchaseOrderHeader. |
| Purchasing.PurchaseOrderHeader | General purchase order information. See PurchaseOrderDetail. |
| Purchasing.ShipMethod | Shipping company lookup table. |
| Purchasing.Vendor | Companies from whom Adventure Works Cycles purchases parts or other goods. |
| Sales.CountryRegionCurrency | Cross-reference table mapping ISO currency codes to a country or region. |
| Sales.CreditCard | Customer credit card information. |
| Sales.Currency | Lookup table containing standard ISO currencies. |
| Sales.CurrencyRate | Currency exchange rates. |
| Sales.Customer | Current customer information. Also see the Person and Store tables. |
| Sales.PersonCreditCard | Cross-reference table mapping people to their credit card information in the CreditCard table. |
| Sales.SalesOrderDetail | Individual products associated with a specific sales order. See SalesOrderHeader. |
| Sales.SalesOrderHeader | General sales order information. |
| Sales.SalesOrderHeaderSalesReason | Cross-reference table mapping sales orders to sales reason codes. |
| Sales.SalesPerson | Sales representative current information. |
| Sales.SalesPersonQuotaHistory | Sales performance tracking. |
| Sales.SalesReason | Lookup table of customer purchase reasons. |
| Sales.SalesTaxRate | Tax rate lookup table. |
| Sales.SalesTerritory | Sales territory lookup table. |
| Sales.SalesTerritoryHistory | Sales representative transfers to other sales territories. |
| Sales.ShoppingCartItem | Contains online customer orders until the order is submitted or cancelled. |
| Sales.SpecialOffer | Sale discounts lookup table. |
| Sales.SpecialOfferProduct | Cross-reference table mapping products to special offer discounts. |
| Sales.Store | Customers (resellers) of Adventure Works products. |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| AK_Address_rowguid | Unique nonclustered index. Used to support replication samples. |  | |
| AK_AddressType_Name | Unique nonclustered index. | | |
| AK_AddressType_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate | Clustered index. | | |
| AK_BusinessEntity_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_BusinessEntityAddress_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_BusinessEntityContact_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_ContactType_Name | Unique nonclustered index. | | |
| AK_CountryRegion_Name | Unique nonclustered index. | | |
| AK_CreditCard_CardNumber | Unique nonclustered index. | | |
| AK_Culture_Name | Unique nonclustered index. | | |
| AK_Currency_Name | Unique nonclustered index. | | |
| AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode | Unique nonclustered index. | | |
| AK_Customer_AccountNumber | Unique nonclustered index. | | |
| AK_Customer_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_Department_Name | Unique nonclustered index. | | |
| AK_Document_DocumentLevel_DocumentNode | Unique nonclustered index. | | |
| AK_Document_rowguid | Unique nonclustered index. Used to support FileStream. | | |
| AK_Employee_LoginID | Unique nonclustered index. | | |
| AK_Employee_NationalIDNumber | Unique nonclustered index. | | |
| AK_Employee_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_Location_Name | Unique nonclustered index. | | |
| AK_Person_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_Product_Name | Unique nonclustered index. | | |
| AK_Product_ProductNumber | Unique nonclustered index. | | |
| AK_Product_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_ProductCategory_Name | Unique nonclustered index. | | |
| AK_ProductCategory_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_ProductDescription_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_ProductModel_Name | Unique nonclustered index. | | |
| AK_ProductModel_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_ProductSubcategory_Name | Unique nonclustered index. | | |
| AK_ProductSubcategory_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_SalesOrderDetail_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_SalesOrderHeader_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_SalesOrderHeader_SalesOrderNumber | Unique nonclustered index. | | |
| AK_SalesPerson_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_SalesPersonQuotaHistory_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_SalesTaxRate_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_SalesTaxRate_StateProvinceID_TaxType | Unique nonclustered index. | | |
| AK_SalesTerritory_Name | Unique nonclustered index. | | |
| AK_SalesTerritory_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_SalesTerritoryHistory_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_ScrapReason_Name | Unique nonclustered index. | | |
| AK_Shift_Name | Unique nonclustered index. | | |
| AK_Shift_StartTime_EndTime | Unique nonclustered index. | | |
| AK_ShipMethod_Name | Unique nonclustered index. | | |
| AK_ShipMethod_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_SpecialOffer_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_SpecialOfferProduct_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_StateProvince_Name | Unique nonclustered index. | | |
| AK_StateProvince_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_StateProvince_StateProvinceCode_CountryRegionCode | Unique nonclustered index. | | |
| AK_Store_rowguid | Unique nonclustered index. Used to support replication samples. | | |
| AK_UnitMeasure_Name | Unique nonclustered index. | | |
| AK_Vendor_AccountNumber | Unique nonclustered index. | | |
| IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode | Nonclustered index. | | |
| IX_Address_StateProvinceID | Nonclustered index. | ||
| IX_BillOfMaterials_UnitMeasureCode | Nonclustered index. | ||
| IX_BusinessEntityAddress_AddressID | Nonclustered index. | ||
| IX_BusinessEntityAddress_AddressTypeID | Nonclustered index. | ||
| IX_BusinessEntityContact_ContactTypeID | Nonclustered index. | ||
| IX_BusinessEntityContact_PersonID | Nonclustered index. | ||
| IX_CountryRegionCurrency_CurrencyCode | Nonclustered index. | ||
| IX_Customer_TerritoryID | Nonclustered index. | ||
| IX_Document_FileName_Revision | Unique nonclustered index. | ||
| IX_EmailAddress_EmailAddress | Nonclustered index. | ||
| IX_Employee_OrganizationLevel_OrganizationNode | Unique nonclustered index. | ||
| IX_Employee_OrganizationNode | Unique nonclustered index. | ||
| IX_EmployeeDepartmentHistory_DepartmentID | Nonclustered index. | ||
| IX_EmployeeDepartmentHistory_ShiftID | Nonclustered index. | ||
| IX_JobCandidate_BusinessEntityID | Nonclustered index. | ||
| IX_Person_LastName_FirstName_MiddleName | |||
| IX_PersonPhone_PhoneNumber | Nonclustered index. | ||
| IX_ProductReview_ProductID_Name | Nonclustered index. | ||
| IX_ProductVendor_BusinessEntityID | Nonclustered index. | ||
| IX_ProductVendor_UnitMeasureCode | Nonclustered index. | ||
| IX_PurchaseOrderDetail_ProductID | Nonclustered index. | ||
| IX_PurchaseOrderHeader_EmployeeID | Nonclustered index. | ||
| IX_PurchaseOrderHeader_VendorID | Nonclustered index. | ||
| IX_SalesOrderDetail_ProductID | Nonclustered index. | ||
| IX_SalesOrderHeader_CustomerID | Nonclustered index. | ||
| IX_SalesOrderHeader_SalesPersonID | Nonclustered index. | ||
| IX_ShoppingCartItem_ShoppingCartID_ProductID | Nonclustered index. | ||
| IX_SpecialOfferProduct_ProductID | Nonclustered index. | ||
| IX_Store_SalesPersonID | Nonclustered index. | ||
| IX_TransactionHistory_ProductID | Nonclustered index. | ||
| IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID | Nonclustered index. | ||
| IX_TransactionHistoryArchive_ProductID | Nonclustered index. | ||
| IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID | Nonclustered index. | ||
| IX_WorkOrder_ProductID | Nonclustered index. | ||
| IX_WorkOrder_ScrapReasonID | Nonclustered index. | ||
| IX_WorkOrderRouting_ProductID | Nonclustered index. | ||
| PK_Address_AddressID | Primary key (clustered) constraint | | |
| PK_AddressType_AddressTypeID | Primary key (clustered) constraint | | |
| PK_AWBuildVersion_SystemInformationID | Primary key (clustered) constraint | | |
| PK_BillOfMaterials_BillOfMaterialsID | Primary key (clustered) constraint | | |
| PK_BusinessEntity_BusinessEntityID | Primary key (clustered) constraint | | |
| PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID | Primary key (clustered) constraint | | |
| PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID | Primary key (clustered) constraint | | |
| PK_ContactType_ContactTypeID | Primary key (clustered) constraint | | |
| PK_CountryRegion_CountryRegionCode | Primary key (clustered) constraint | | |
| PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode | Primary key (clustered) constraint | | |
| PK_CreditCard_CreditCardID | Primary key (clustered) constraint | | |
| PK_Culture_CultureID | Primary key (clustered) constraint | | |
| PK_Currency_CurrencyCode | Primary key (clustered) constraint | | |
| PK_CurrencyRate_CurrencyRateID | Primary key (clustered) constraint | | |
| PK_Customer_CustomerID | Primary key (clustered) constraint | | |
| PK_DatabaseLog_DatabaseLogID | Primary key (nonclustered) constraint | | |
| PK_Department_DepartmentID | Primary key (clustered) constraint | | |
| PK_Document_DocumentNode | Primary key (clustered) constraint | | |
| PK_EmailAddress_BusinessEntityID_EmailAddressID | Primary key (clustered) constraint | | |
| PK_Employee_BusinessEntityID | Primary key (clustered) constraint | | |
| PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID | Primary key (clustered) constraint | | |
| PK_EmployeePayHistory_BusinessEntityID_RateChangeDate | Primary key (clustered) constraint | | |
| PK_ErrorLog_ErrorLogID | Primary key (clustered) constraint | | |
| PK_Illustration_IllustrationID | Primary key (clustered) constraint | | |
| PK_JobCandidate_JobCandidateID | Primary key (clustered) constraint | | |
| PK_Location_LocationID | Primary key (clustered) constraint | | |
| PK_Password_BusinessEntityID | Primary key (clustered) constraint | | |
| PK_Person_BusinessEntityID | Primary key (clustered) constraint | | |
| PK_PersonCreditCard_BusinessEntityID_CreditCardID | Primary key (clustered) constraint | | |
| PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID | Primary key (clustered) constraint | | |
| PK_PhoneNumberType_PhoneNumberTypeID | Primary key (clustered) constraint | | |
| PK_Product_ProductID | Primary key (clustered) constraint | | |
| PK_ProductCategory_ProductCategoryID | Primary key (clustered) constraint | | |
| PK_ProductCostHistory_ProductID_StartDate | Primary key (clustered) constraint | | |
| PK_ProductDescription_ProductDescriptionID | Primary key (clustered) constraint | | |
| PK_ProductDocument_ProductID_DocumentNode | Primary key (clustered) constraint | | |
| PK_ProductInventory_ProductID_LocationID | Primary key (clustered) constraint | | |
| PK_ProductListPriceHistory_ProductID_StartDate | Primary key (clustered) constraint | | |
| PK_ProductModel_ProductModelID | Primary key (clustered) constraint | | |
| PK_ProductModelIllustration_ProductModelID_IllustrationID | Primary key (clustered) constraint | | |
| PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID | Primary key (clustered) constraint | | |
| PK_ProductPhoto_ProductPhotoID | Primary key (clustered) constraint | | |
| PK_ProductProductPhoto_ProductID_ProductPhotoID | Primary key (clustered) constraint | | |
| PK_ProductReview_ProductReviewID | Primary key (clustered) constraint | | |
| PK_ProductSubcategory_ProductSubcategoryID | Primary key (clustered) constraint | | |
| PK_ProductVendor_ProductID_BusinessEntityID | Primary key (clustered) constraint | | |
| PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID | Primary key (clustered) constraint | | |
| PK_PurchaseOrderHeader_PurchaseOrderID | Primary key (clustered) constraint | | |
| PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID | Primary key (clustered) constraint | | |
| PK_SalesOrderHeader_SalesOrderID | Primary key (clustered) constraint | | |
| PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID | Primary key (clustered) constraint | | |
| PK_SalesPerson_BusinessEntityID | Primary key (clustered) constraint | | |
| PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate | Primary key (clustered) constraint | | |
| PK_SalesReason_SalesReasonID | Primary key (clustered) constraint | | |
| PK_SalesTaxRate_SalesTaxRateID | Primary key (clustered) constraint | | |
| PK_SalesTerritory_TerritoryID | Primary key (clustered) constraint | | |
| PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID | Primary key (clustered) constraint | | |
| PK_ScrapReason_ScrapReasonID | Primary key (clustered) constraint | | |
| PK_Shift_ShiftID | Primary key (clustered) constraint | | |
| PK_ShipMethod_ShipMethodID | Primary key (clustered) constraint | | |
| PK_ShoppingCartItem_ShoppingCartItemID | Primary key (clustered) constraint | | |
| PK_SpecialOffer_SpecialOfferID | Primary key (clustered) constraint | | |
| PK_SpecialOfferProduct_SpecialOfferID_ProductID | Primary key (clustered) constraint | | |
| PK_StateProvince_StateProvinceID | Primary key (clustered) constraint | | |
| PK_Store_BusinessEntityID | Primary key (clustered) constraint | | |
| PK_TransactionHistory_TransactionID | Primary key (clustered) constraint | | |
| PK_TransactionHistoryArchive_TransactionID | Primary key (clustered) constraint | | |
| PK_UnitMeasure_UnitMeasureCode | Primary key (clustered) constraint | | |
| PK_Vendor_BusinessEntityID | Primary key (clustered) constraint | | |
| PK_WorkOrder_WorkOrderID | Primary key (clustered) constraint | | |
| PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence | Primary key (clustered) constraint | | |
| PXML_Person_AddContact | Primary XML index. | ||
| PXML_Person_Demographics | Primary XML index. | ||
| PXML_ProductModel_CatalogDescription | Primary XML index. | ||
| PXML_ProductModel_Instructions | Primary XML index. | ||
| PXML_Store_Demographics | Primary XML index. | ||
| UQ__Document__F73921F7C5112C2E | | ||
| XMLPATH_Person_Demographics | Secondary XML index for path. | ||
| XMLPROPERTY_Person_Demographics | Secondary XML index for property. | ||
| XMLVALUE_Person_Demographics | Secondary XML index for value. |
See Also