AdventureWorks
PRIMARY File Group
AdventureWorks Database : PRIMARY File Group
Properties
Default FileGroup
Read Only
Tables
TableDescription
dbo.AWBuildVersionCurrent version number of the AdventureWorks sample database.
dbo.DatabaseLogAudit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
dbo.ErrorLogAudit 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.DepartmentLookup table containing the departments within the Adventure Works Cycles company.
HumanResources.EmployeeEmployee information such as salary, department, and title.
HumanResources.EmployeeAddressCross-reference table mapping employees to their address(es).
HumanResources.EmployeeDepartmentHistoryEmployee department transfers.
HumanResources.EmployeePayHistoryEmployee pay history.
HumanResources.JobCandidateRésumés submitted to Human Resources by job applicants.
HumanResources.ShiftWork shift lookup table.
Person.AddressStreet address information for customers, employees, and vendors.
Person.AddressTypeTypes of addresses stored in the Address table.
Person.ContactNames of each employee, customer contact, and vendor contact.
Person.ContactTypeLookup table containing the types of contacts stored in Contact.
Person.CountryRegionLookup table containing the ISO standard codes for countries and regions.
Person.StateProvinceState and province lookup table.
Production.BillOfMaterialsItems required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
Production.CultureLookup table containing the languages in which some AdventureWorks data is stored.
Production.DocumentProduct maintenance documents.
Production.IllustrationBicycle assembly diagrams.
Production.LocationProduct inventory and manufacturing locations.
Production.ProductProducts sold or used in the manfacturing of sold products.
Production.ProductCategoryHigh-level product categorization.
Production.ProductCostHistoryChanges in the cost of a product over time.
Production.ProductDescriptionProduct descriptions in several languages.
Production.ProductDocumentCross-reference table mapping products to related product documents.
Production.ProductInventoryProduct inventory information.
Production.ProductListPriceHistoryChanges in the list price of a product over time.
Production.ProductModelProduct model classification.
Production.ProductModelIllustrationCross-reference table mapping product models and illustrations.
Production.ProductModelProductDescriptionCultureCross-reference table mapping product descriptions and the language the description is written in.
Production.ProductPhotoProduct images.
Production.ProductProductPhotoCross-reference table mapping products and product photos.
Production.ProductReviewCustomer reviews of products they have purchased.
Production.ProductSubcategoryProduct subcategories. See ProductCategory table.
Production.ScrapReasonManufacturing failure reasons lookup table.
Production.TransactionHistoryRecord of each purchase order, sales order, or work order transaction year to date.
Production.TransactionHistoryArchiveTransactions for previous years.
Production.UnitMeasureUnit of measure lookup table.
Production.WorkOrderManufacturing work orders.
Production.WorkOrderRoutingWork order details.
Purchasing.ProductVendorCross-reference table mapping vendors with the products they supply.
Purchasing.PurchaseOrderDetailIndividual products associated with a specific purchase order. See PurchaseOrderHeader.
Purchasing.PurchaseOrderHeaderGeneral purchase order information. See PurchaseOrderDetail.
Purchasing.ShipMethodShipping company lookup table.
Purchasing.VendorCompanies from whom Adventure Works Cycles purchases parts or other goods.
Purchasing.VendorAddressCross-reference mapping vendors and addresses.
Purchasing.VendorContactCross-reference table mapping vendors and their employees.
Sales.ContactCreditCardCross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.
Sales.CountryRegionCurrencyCross-reference table mapping ISO currency codes to a country or region.
Sales.CreditCardCustomer credit card information.
Sales.CurrencyLookup table containing standard ISO currencies.
Sales.CurrencyRateCurrency exchange rates.
Sales.CustomerCurrent customer information. Also see the Individual and Store tables.
Sales.CustomerAddressCross-reference table mapping customers to their address(es).
Sales.IndividualDemographic data about customers that purchase Adventure Works products online.
Sales.SalesOrderDetailIndividual products associated with a specific sales order. See SalesOrderHeader.
Sales.SalesOrderHeaderGeneral sales order information.
Sales.SalesOrderHeaderSalesReasonCross-reference table mapping sales orders to sales reason codes.
Sales.SalesPersonSales representative current information.
Sales.SalesPersonQuotaHistorySales performance tracking.
Sales.SalesReasonLookup table of customer purchase reasons.
Sales.SalesTaxRateTax rate lookup table.
Sales.SalesTerritorySales territory lookup table.
Sales.SalesTerritoryHistorySales representative transfers to other sales territories.
Sales.ShoppingCartItemContains online customer orders until the order is submitted or cancelled.
Sales.SpecialOfferSale discounts lookup table.
Sales.SpecialOfferProductCross-reference table mapping products to special offer discounts.
Sales.StoreCustomers (resellers) of Adventure Works products.
Sales.StoreContactCross-reference table mapping stores and their employees.
Indexes
IndexDescriptionPrimaryUnique
AK_Address_rowguidUnique nonclustered index. Used to support replication samples. 
AK_AddressType_NameUnique nonclustered index. 
AK_AddressType_rowguidUnique nonclustered index. Used to support replication samples. 
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDateClustered index. 
AK_Contact_rowguidUnique nonclustered index. Used to support replication samples. 
AK_ContactType_NameUnique nonclustered index. 
AK_CountryRegion_NameUnique nonclustered index. 
AK_CreditCard_CardNumberUnique nonclustered index. 
AK_Culture_NameUnique nonclustered index. 
AK_Currency_NameUnique nonclustered index. 
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCodeUnique nonclustered index. 
AK_Customer_AccountNumberUnique nonclustered index. 
AK_Customer_rowguidUnique nonclustered index. Used to support replication samples. 
AK_CustomerAddress_rowguidUnique nonclustered index. Used to support replication samples. 
AK_Department_NameUnique nonclustered index. 
AK_Document_FileName_RevisionUnique nonclustered index. 
AK_Employee_LoginIDUnique nonclustered index. 
AK_Employee_NationalIDNumberUnique nonclustered index. 
AK_Employee_rowguidUnique nonclustered index. Used to support replication samples. 
AK_EmployeeAddress_rowguidUnique nonclustered index. Used to support replication samples. 
AK_Location_NameUnique nonclustered index. 
AK_Product_NameUnique nonclustered index. 
AK_Product_ProductNumberUnique nonclustered index. 
AK_Product_rowguidUnique nonclustered index. Used to support replication samples. 
AK_ProductCategory_NameUnique nonclustered index. 
AK_ProductCategory_rowguidUnique nonclustered index. Used to support replication samples. 
AK_ProductDescription_rowguidUnique nonclustered index. Used to support replication samples. 
AK_ProductModel_NameUnique nonclustered index. 
AK_ProductModel_rowguidUnique nonclustered index. Used to support replication samples. 
AK_ProductSubcategory_NameUnique nonclustered index. 
AK_ProductSubcategory_rowguidUnique nonclustered index. Used to support replication samples. 
AK_SalesOrderDetail_rowguidUnique nonclustered index. Used to support replication samples. 
AK_SalesOrderHeader_rowguidUnique nonclustered index. Used to support replication samples. 
AK_SalesOrderHeader_SalesOrderNumberUnique nonclustered index. 
AK_SalesPerson_rowguidUnique nonclustered index. Used to support replication samples. 
AK_SalesPersonQuotaHistory_rowguidUnique nonclustered index. Used to support replication samples. 
AK_SalesTaxRate_rowguidUnique nonclustered index. Used to support replication samples. 
AK_SalesTaxRate_StateProvinceID_TaxTypeUnique nonclustered index. 
AK_SalesTerritory_NameUnique nonclustered index. 
AK_SalesTerritory_rowguidUnique nonclustered index. Used to support replication samples. 
AK_SalesTerritoryHistory_rowguidUnique nonclustered index. Used to support replication samples. 
AK_ScrapReason_NameUnique nonclustered index. 
AK_Shift_NameUnique nonclustered index. 
AK_Shift_StartTime_EndTimeUnique nonclustered index. 
AK_ShipMethod_NameUnique nonclustered index. 
AK_ShipMethod_rowguidUnique nonclustered index. Used to support replication samples. 
AK_SpecialOffer_rowguidUnique nonclustered index. Used to support replication samples. 
AK_SpecialOfferProduct_rowguidUnique nonclustered index. Used to support replication samples. 
AK_StateProvince_NameUnique nonclustered index. 
AK_StateProvince_rowguidUnique nonclustered index. Used to support replication samples. 
AK_StateProvince_StateProvinceCode_CountryRegionCodeUnique nonclustered index. 
AK_Store_rowguidUnique nonclustered index. Used to support replication samples. 
AK_StoreContact_rowguidUnique nonclustered index. Used to support replication samples. 
AK_UnitMeasure_NameUnique nonclustered index. 
AK_Vendor_AccountNumberUnique nonclustered index. 
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCodeNonclustered index. 
IX_Address_StateProvinceIDNonclustered index.  
IX_BillOfMaterials_UnitMeasureCodeNonclustered index.  
IX_Contact_EmailAddressNonclustered index.  
IX_CountryRegionCurrency_CurrencyCodeNonclustered index.  
IX_Customer_TerritoryIDNonclustered index.  
IX_Employee_ManagerIDNonclustered index.  
IX_EmployeeDepartmentHistory_DepartmentIDNonclustered index.  
IX_EmployeeDepartmentHistory_ShiftIDNonclustered index.  
IX_JobCandidate_EmployeeIDNonclustered index.  
IX_ProductReview_ProductID_NameNonclustered index.  
IX_ProductVendor_UnitMeasureCodeNonclustered index.  
IX_ProductVendor_VendorIDNonclustered index.  
IX_PurchaseOrderDetail_ProductIDNonclustered index.  
IX_PurchaseOrderHeader_EmployeeIDNonclustered index.  
IX_PurchaseOrderHeader_VendorIDNonclustered index.  
IX_SalesOrderDetail_ProductIDNonclustered index.  
IX_SalesOrderHeader_CustomerIDNonclustered index.  
IX_SalesOrderHeader_SalesPersonIDNonclustered index.  
IX_ShoppingCartItem_ShoppingCartID_ProductIDNonclustered index.  
IX_SpecialOfferProduct_ProductIDNonclustered index.  
IX_Store_SalesPersonIDNonclustered index.  
IX_StoreContact_ContactIDNonclustered index.  
IX_StoreContact_ContactTypeIDNonclustered index.  
IX_TransactionHistory_ProductIDNonclustered index.  
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineIDNonclustered index.  
IX_TransactionHistoryArchive_ProductIDNonclustered index.  
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineIDNonclustered index.  
IX_VendorAddress_AddressIDNonclustered index.  
IX_VendorContact_ContactIDNonclustered index.  
IX_VendorContact_ContactTypeIDNonclustered index.  
IX_WorkOrder_ProductIDNonclustered index.  
IX_WorkOrder_ScrapReasonIDNonclustered index.  
IX_WorkOrderRouting_ProductIDNonclustered index.  
PK_Address_AddressIDPrimary key (clustered) constraint
PK_AddressType_AddressTypeIDPrimary key (clustered) constraint
PK_AWBuildVersion_SystemInformationIDPrimary key (clustered) constraint
PK_BillOfMaterials_BillOfMaterialsIDPrimary key (clustered) constraint
PK_Contact_ContactIDPrimary key (clustered) constraint
PK_ContactCreditCard_ContactID_CreditCardIDPrimary key (clustered) constraint
PK_ContactType_ContactTypeIDPrimary key (clustered) constraint
PK_CountryRegion_CountryRegionCodePrimary key (clustered) constraint
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCodePrimary key (clustered) constraint
PK_CreditCard_CreditCardIDPrimary key (clustered) constraint
PK_Culture_CultureIDPrimary key (clustered) constraint
PK_Currency_CurrencyCodePrimary key (clustered) constraint
PK_CurrencyRate_CurrencyRateIDPrimary key (clustered) constraint
PK_Customer_CustomerIDPrimary key (clustered) constraint
PK_CustomerAddress_CustomerID_AddressIDPrimary key (clustered) constraint
PK_DatabaseLog_DatabaseLogIDPrimary key (nonclustered) constraint
PK_Department_DepartmentIDPrimary key (clustered) constraint
PK_Document_DocumentIDPrimary key (clustered) constraint
PK_Employee_EmployeeIDPrimary key (clustered) constraint
PK_EmployeeAddress_EmployeeID_AddressIDPrimary key (clustered) constraint
PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentIDPrimary key (clustered) constraint
PK_EmployeePayHistory_EmployeeID_RateChangeDatePrimary key (clustered) constraint
PK_ErrorLog_ErrorLogIDPrimary key (clustered) constraint
PK_Illustration_IllustrationIDPrimary key (clustered) constraint
PK_Individual_CustomerIDPrimary key (clustered) constraint
PK_JobCandidate_JobCandidateIDPrimary key (clustered) constraint
PK_Location_LocationIDPrimary key (clustered) constraint
PK_Product_ProductIDPrimary key (clustered) constraint
PK_ProductCategory_ProductCategoryIDPrimary key (clustered) constraint
PK_ProductCostHistory_ProductID_StartDatePrimary key (clustered) constraint
PK_ProductDescription_ProductDescriptionIDPrimary key (clustered) constraint
PK_ProductDocument_ProductID_DocumentIDPrimary key (clustered) constraint
PK_ProductInventory_ProductID_LocationIDPrimary key (clustered) constraint
PK_ProductListPriceHistory_ProductID_StartDatePrimary key (clustered) constraint
PK_ProductModel_ProductModelIDPrimary key (clustered) constraint
PK_ProductModelIllustration_ProductModelID_IllustrationIDPrimary key (clustered) constraint
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureIDPrimary key (clustered) constraint
PK_ProductPhoto_ProductPhotoIDPrimary key (clustered) constraint
PK_ProductProductPhoto_ProductID_ProductPhotoIDPrimary key (clustered) constraint
PK_ProductReview_ProductReviewIDPrimary key (clustered) constraint
PK_ProductSubcategory_ProductSubcategoryIDPrimary key (clustered) constraint
PK_ProductVendor_ProductID_VendorIDPrimary key (clustered) constraint
PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailIDPrimary key (clustered) constraint
PK_PurchaseOrderHeader_PurchaseOrderIDPrimary key (clustered) constraint
PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailIDPrimary key (clustered) constraint
PK_SalesOrderHeader_SalesOrderIDPrimary key (clustered) constraint
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonIDPrimary key (clustered) constraint
PK_SalesPerson_SalesPersonIDPrimary key (clustered) constraint
PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDatePrimary key (clustered) constraint
PK_SalesReason_SalesReasonIDPrimary key (clustered) constraint
PK_SalesTaxRate_SalesTaxRateIDPrimary key (clustered) constraint
PK_SalesTerritory_TerritoryIDPrimary key (clustered) constraint
PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryIDPrimary key (clustered) constraint
PK_ScrapReason_ScrapReasonIDPrimary key (clustered) constraint
PK_Shift_ShiftIDPrimary key (clustered) constraint
PK_ShipMethod_ShipMethodIDPrimary key (clustered) constraint
PK_ShoppingCartItem_ShoppingCartItemIDPrimary key (clustered) constraint
PK_SpecialOffer_SpecialOfferIDPrimary key (clustered) constraint
PK_SpecialOfferProduct_SpecialOfferID_ProductIDPrimary key (clustered) constraint
PK_StateProvince_StateProvinceIDPrimary key (clustered) constraint
PK_Store_CustomerIDPrimary key (clustered) constraint
PK_StoreContact_CustomerID_ContactIDPrimary key (clustered) constraint
PK_TransactionHistory_TransactionIDPrimary key (clustered) constraint
PK_TransactionHistoryArchive_TransactionIDPrimary key (clustered) constraint
PK_UnitMeasure_UnitMeasureCodePrimary key (clustered) constraint
PK_Vendor_VendorIDPrimary key (clustered) constraint
PK_VendorAddress_VendorID_AddressIDPrimary key (clustered) constraint
PK_VendorContact_VendorID_ContactIDPrimary key (clustered) constraint
PK_WorkOrder_WorkOrderIDPrimary key (clustered) constraint
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequencePrimary key (clustered) constraint
See Also

Related Objects

AdventureWorks Database

 

 

© 2012 All Rights Reserved.

Send comments on this topic.