PRIMARY File Group

In This Topic

Properties

Default FileGroup
Read Only

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.

Related Objects

AdventureWorks Database

Send comments on this topic.