About This Sample
AdventureWorks Database
Overview
Schemas
dbo Schema
Overview
Tables
dbo.AWBuildVersion Table
Indexes
PK_AWBuildVersion_SystemInformationID Index
dbo.DatabaseLog Table
Indexes
PK_DatabaseLog_DatabaseLogID Index
dbo.ErrorLog Table
Indexes
PK_ErrorLog_ErrorLogID Index
Stored Procedures
dbo.uspGetBillOfMaterials Stored Procedure
dbo.uspGetEmployeeManagers Stored Procedure
dbo.uspGetManagerEmployees Stored Procedure
dbo.uspGetWhereUsedProductID Stored Procedure
dbo.uspLogError Stored Procedure
dbo.uspPrintError Stored Procedure
dbo.uspSearchCandidateResumes Stored Procedure
User Defined Functions
dbo.ufnGetAccountingEndDate User Defined Function
dbo.ufnGetAccountingStartDate User Defined Function
dbo.ufnGetContactInformation User Defined Function
dbo.ufnGetDocumentStatusText User Defined Function
dbo.ufnGetProductDealerPrice User Defined Function
dbo.ufnGetProductListPrice User Defined Function
dbo.ufnGetProductStandardCost User Defined Function
dbo.ufnGetPurchaseOrderStatusText User Defined Function
dbo.ufnGetSalesOrderStatusText User Defined Function
dbo.ufnGetStock User Defined Function
dbo.ufnLeadingZeros User Defined Function
User Defined Data Types
dbo.AccountNumber User Defined Data Type
dbo.Flag User Defined Data Type
dbo.Name User Defined Data Type
dbo.NameStyle User Defined Data Type
dbo.OrderNumber User Defined Data Type
dbo.Phone User Defined Data Type
HumanResources Schema
Overview
Tables
HumanResources.Department Table
Indexes
AK_Department_Name Index
PK_Department_DepartmentID Index
Relationships
FK_EmployeeDepartmentHistory_Department_DepartmentID Relationship
HumanResources.Employee Table
Indexes
AK_Employee_LoginID Index
AK_Employee_NationalIDNumber Index
AK_Employee_rowguid Index
IX_Employee_OrganizationLevel_OrganizationNode Index
IX_Employee_OrganizationNode Index
PK_Employee_BusinessEntityID Index
Triggers
dEmployee Trigger
Relationships
FK_Document_Employee_Owner Relationship
FK_Employee_Person_BusinessEntityID Relationship
FK_EmployeeDepartmentHistory_Employee_BusinessEntityID Relationship
FK_EmployeePayHistory_Employee_BusinessEntityID Relationship
FK_JobCandidate_Employee_BusinessEntityID Relationship
FK_PurchaseOrderHeader_Employee_EmployeeID Relationship
FK_SalesPerson_Employee_BusinessEntityID Relationship
HumanResources.EmployeeDepartmentHistory Table
Indexes
IX_EmployeeDepartmentHistory_DepartmentID Index
IX_EmployeeDepartmentHistory_ShiftID Index
PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID Index
Relationships
FK_EmployeeDepartmentHistory_Department_DepartmentID Relationship
FK_EmployeeDepartmentHistory_Employee_BusinessEntityID Relationship
FK_EmployeeDepartmentHistory_Shift_ShiftID Relationship
HumanResources.EmployeePayHistory Table
Indexes
PK_EmployeePayHistory_BusinessEntityID_RateChangeDate Index
Relationships
FK_EmployeePayHistory_Employee_BusinessEntityID Relationship
HumanResources.JobCandidate Table
Indexes
IX_JobCandidate_BusinessEntityID Index
PK_JobCandidate_JobCandidateID Index
Relationships
FK_JobCandidate_Employee_BusinessEntityID Relationship
HumanResources.Shift Table
Indexes
AK_Shift_Name Index
AK_Shift_StartTime_EndTime Index
PK_Shift_ShiftID Index
Relationships
FK_EmployeeDepartmentHistory_Shift_ShiftID Relationship
Views
HumanResources.vEmployee View
HumanResources.vEmployeeDepartment View
HumanResources.vEmployeeDepartmentHistory View
HumanResources.vJobCandidate View
HumanResources.vJobCandidateEducation View
HumanResources.vJobCandidateEmployment View
Stored Procedures
HumanResources.uspUpdateEmployeeHireInfo Stored Procedure
HumanResources.uspUpdateEmployeeLogin Stored Procedure
HumanResources.uspUpdateEmployeePersonalInfo Stored Procedure
Person Schema
Overview
Tables
Person.Address Table
Indexes
AK_Address_rowguid Index
IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode Index
IX_Address_StateProvinceID Index
PK_Address_AddressID Index
Relationships
FK_Address_StateProvince_StateProvinceID Relationship
FK_BusinessEntityAddress_Address_AddressID Relationship
FK_SalesOrderHeader_Address_BillToAddressID Relationship
FK_SalesOrderHeader_Address_ShipToAddressID Relationship
Person.AddressType Table
Indexes
AK_AddressType_Name Index
AK_AddressType_rowguid Index
PK_AddressType_AddressTypeID Index
Relationships
FK_BusinessEntityAddress_AddressType_AddressTypeID Relationship
Person.BusinessEntity Table
Indexes
AK_BusinessEntity_rowguid Index
PK_BusinessEntity_BusinessEntityID Index
Relationships
FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID Relationship
FK_BusinessEntityContact_BusinessEntity_BusinessEntityID Relationship
FK_Person_BusinessEntity_BusinessEntityID Relationship
FK_Store_BusinessEntity_BusinessEntityID Relationship
FK_Vendor_BusinessEntity_BusinessEntityID Relationship
Person.BusinessEntityAddress Table
Indexes
AK_BusinessEntityAddress_rowguid Index
IX_BusinessEntityAddress_AddressID Index
IX_BusinessEntityAddress_AddressTypeID Index
PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID Index
Relationships
FK_BusinessEntityAddress_Address_AddressID Relationship
FK_BusinessEntityAddress_AddressType_AddressTypeID Relationship
FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID Relationship
Person.BusinessEntityContact Table
Indexes
AK_BusinessEntityContact_rowguid Index
IX_BusinessEntityContact_ContactTypeID Index
IX_BusinessEntityContact_PersonID Index
PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID Index
Relationships
FK_BusinessEntityContact_BusinessEntity_BusinessEntityID Relationship
FK_BusinessEntityContact_ContactType_ContactTypeID Relationship
FK_BusinessEntityContact_Person_PersonID Relationship
Person.ContactType Table
Indexes
AK_ContactType_Name Index
PK_ContactType_ContactTypeID Index
Relationships
FK_BusinessEntityContact_ContactType_ContactTypeID Relationship
Person.CountryRegion Table
Indexes
AK_CountryRegion_Name Index
PK_CountryRegion_CountryRegionCode Index
Relationships
FK_CountryRegionCurrency_CountryRegion_CountryRegionCode Relationship
FK_SalesTerritory_CountryRegion_CountryRegionCode Relationship
FK_StateProvince_CountryRegion_CountryRegionCode Relationship
Person.EmailAddress Table
Indexes
IX_EmailAddress_EmailAddress Index
PK_EmailAddress_BusinessEntityID_EmailAddressID Index
Relationships
FK_EmailAddress_Person_BusinessEntityID Relationship
Person.Password Table
Indexes
PK_Password_BusinessEntityID Index
Relationships
FK_Password_Person_BusinessEntityID Relationship
Person.Person Table
Indexes
AK_Person_rowguid Index
IX_Person_LastName_FirstName_MiddleName Index
PK_Person_BusinessEntityID Index
PXML_Person_AddContact Index
PXML_Person_Demographics Index
XMLPATH_Person_Demographics Index
XMLPROPERTY_Person_Demographics Index
XMLVALUE_Person_Demographics Index
Triggers
iuPerson Trigger
Relationships
FK_BusinessEntityContact_Person_PersonID Relationship
FK_Customer_Person_PersonID Relationship
FK_EmailAddress_Person_BusinessEntityID Relationship
FK_Employee_Person_BusinessEntityID Relationship
FK_Password_Person_BusinessEntityID Relationship
FK_Person_BusinessEntity_BusinessEntityID Relationship
FK_PersonCreditCard_Person_BusinessEntityID Relationship
FK_PersonPhone_Person_BusinessEntityID Relationship
Person.PersonPhone Table
Indexes
IX_PersonPhone_PhoneNumber Index
PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID Index
Relationships
FK_PersonPhone_Person_BusinessEntityID Relationship
FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID Relationship
Person.PhoneNumberType Table
Indexes
PK_PhoneNumberType_PhoneNumberTypeID Index
Relationships
FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID Relationship
Person.StateProvince Table
Indexes
AK_StateProvince_Name Index
AK_StateProvince_rowguid Index
AK_StateProvince_StateProvinceCode_CountryRegionCode Index
PK_StateProvince_StateProvinceID Index
Relationships
FK_Address_StateProvince_StateProvinceID Relationship
FK_SalesTaxRate_StateProvince_StateProvinceID Relationship
FK_StateProvince_CountryRegion_CountryRegionCode Relationship
FK_StateProvince_SalesTerritory_TerritoryID Relationship
Views
Person.vAdditionalContactInfo View
Person.vStateProvinceCountryRegion View
Production Schema
Overview
Tables
Production.BillOfMaterials Table
Indexes
AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate Index
IX_BillOfMaterials_UnitMeasureCode Index
PK_BillOfMaterials_BillOfMaterialsID Index
Relationships
FK_BillOfMaterials_Product_ComponentID Relationship
FK_BillOfMaterials_Product_ProductAssemblyID Relationship
FK_BillOfMaterials_UnitMeasure_UnitMeasureCode Relationship
Production.Culture Table
Indexes
AK_Culture_Name Index
PK_Culture_CultureID Index
Relationships
FK_ProductModelProductDescriptionCulture_Culture_CultureID Relationship
Production.Document Table
Indexes
AK_Document_DocumentLevel_DocumentNode Index
AK_Document_rowguid Index
IX_Document_FileName_Revision Index
PK_Document_DocumentNode Index
UQ__Document__F73921F7C5112C2E Index
Relationships
FK_Document_Employee_Owner Relationship
FK_ProductDocument_Document_DocumentNode Relationship
Production.Illustration Table
Indexes
PK_Illustration_IllustrationID Index
Relationships
FK_ProductModelIllustration_Illustration_IllustrationID Relationship
Production.Location Table
Indexes
AK_Location_Name Index
PK_Location_LocationID Index
Relationships
FK_ProductInventory_Location_LocationID Relationship
FK_WorkOrderRouting_Location_LocationID Relationship
Production.Product Table
Indexes
AK_Product_Name Index
AK_Product_ProductNumber Index
AK_Product_rowguid Index
PK_Product_ProductID Index
Relationships
FK_BillOfMaterials_Product_ComponentID Relationship
FK_BillOfMaterials_Product_ProductAssemblyID Relationship
FK_Product_ProductModel_ProductModelID Relationship
FK_Product_ProductSubcategory_ProductSubcategoryID Relationship
FK_Product_UnitMeasure_SizeUnitMeasureCode Relationship
FK_Product_UnitMeasure_WeightUnitMeasureCode Relationship
FK_ProductCostHistory_Product_ProductID Relationship
FK_ProductDocument_Product_ProductID Relationship
FK_ProductInventory_Product_ProductID Relationship
FK_ProductListPriceHistory_Product_ProductID Relationship
FK_ProductProductPhoto_Product_ProductID Relationship
FK_ProductReview_Product_ProductID Relationship
FK_ProductVendor_Product_ProductID Relationship
FK_PurchaseOrderDetail_Product_ProductID Relationship
FK_ShoppingCartItem_Product_ProductID Relationship
FK_SpecialOfferProduct_Product_ProductID Relationship
FK_TransactionHistory_Product_ProductID Relationship
FK_WorkOrder_Product_ProductID Relationship
Production.ProductCategory Table
Indexes
AK_ProductCategory_Name Index
AK_ProductCategory_rowguid Index
PK_ProductCategory_ProductCategoryID Index
Relationships
FK_ProductSubcategory_ProductCategory_ProductCategoryID Relationship
Production.ProductCostHistory Table
Indexes
PK_ProductCostHistory_ProductID_StartDate Index
Relationships
FK_ProductCostHistory_Product_ProductID Relationship
Production.ProductDescription Table
Indexes
AK_ProductDescription_rowguid Index
PK_ProductDescription_ProductDescriptionID Index
Relationships
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID Relationship
Production.ProductDocument Table
Indexes
PK_ProductDocument_ProductID_DocumentNode Index
Relationships
FK_ProductDocument_Document_DocumentNode Relationship
FK_ProductDocument_Product_ProductID Relationship
Production.ProductInventory Table
Indexes
PK_ProductInventory_ProductID_LocationID Index
Relationships
FK_ProductInventory_Location_LocationID Relationship
FK_ProductInventory_Product_ProductID Relationship
Production.ProductListPriceHistory Table
Indexes
PK_ProductListPriceHistory_ProductID_StartDate Index
Relationships
FK_ProductListPriceHistory_Product_ProductID Relationship
Production.ProductModel Table
Indexes
AK_ProductModel_Name Index
AK_ProductModel_rowguid Index
PK_ProductModel_ProductModelID Index
PXML_ProductModel_CatalogDescription Index
PXML_ProductModel_Instructions Index
Relationships
FK_Product_ProductModel_ProductModelID Relationship
FK_ProductModelIllustration_ProductModel_ProductModelID Relationship
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID Relationship
Production.ProductModelIllustration Table
Indexes
PK_ProductModelIllustration_ProductModelID_IllustrationID Index
Relationships
FK_ProductModelIllustration_Illustration_IllustrationID Relationship
FK_ProductModelIllustration_ProductModel_ProductModelID Relationship
Production.ProductModelProductDescriptionCulture Table
Indexes
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID Index
Relationships
FK_ProductModelProductDescriptionCulture_Culture_CultureID Relationship
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID Relationship
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID Relationship
Production.ProductPhoto Table
Indexes
PK_ProductPhoto_ProductPhotoID Index
Relationships
FK_ProductProductPhoto_ProductPhoto_ProductPhotoID Relationship
Production.ProductProductPhoto Table
Indexes
PK_ProductProductPhoto_ProductID_ProductPhotoID Index
Relationships
FK_ProductProductPhoto_Product_ProductID Relationship
FK_ProductProductPhoto_ProductPhoto_ProductPhotoID Relationship
Production.ProductReview Table
Indexes
IX_ProductReview_ProductID_Name Index
PK_ProductReview_ProductReviewID Index
Relationships
FK_ProductReview_Product_ProductID Relationship
Production.ProductSubcategory Table
Indexes
AK_ProductSubcategory_Name Index
AK_ProductSubcategory_rowguid Index
PK_ProductSubcategory_ProductSubcategoryID Index
Relationships
FK_Product_ProductSubcategory_ProductSubcategoryID Relationship
FK_ProductSubcategory_ProductCategory_ProductCategoryID Relationship
Production.ScrapReason Table
Indexes
AK_ScrapReason_Name Index
PK_ScrapReason_ScrapReasonID Index
Relationships
FK_WorkOrder_ScrapReason_ScrapReasonID Relationship
Production.TransactionHistory Table
Indexes
IX_TransactionHistory_ProductID Index
IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID Index
PK_TransactionHistory_TransactionID Index
Relationships
FK_TransactionHistory_Product_ProductID Relationship
Production.TransactionHistoryArchive Table
Indexes
IX_TransactionHistoryArchive_ProductID Index
IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID Index
PK_TransactionHistoryArchive_TransactionID Index
Production.UnitMeasure Table
Indexes
AK_UnitMeasure_Name Index
PK_UnitMeasure_UnitMeasureCode Index
Relationships
FK_BillOfMaterials_UnitMeasure_UnitMeasureCode Relationship
FK_Product_UnitMeasure_SizeUnitMeasureCode Relationship
FK_Product_UnitMeasure_WeightUnitMeasureCode Relationship
FK_ProductVendor_UnitMeasure_UnitMeasureCode Relationship
Production.WorkOrder Table
Indexes
IX_WorkOrder_ProductID Index
IX_WorkOrder_ScrapReasonID Index
PK_WorkOrder_WorkOrderID Index
Triggers
iWorkOrder Trigger
uWorkOrder Trigger
Relationships
FK_WorkOrder_Product_ProductID Relationship
FK_WorkOrder_ScrapReason_ScrapReasonID Relationship
FK_WorkOrderRouting_WorkOrder_WorkOrderID Relationship
Production.WorkOrderRouting Table
Indexes
IX_WorkOrderRouting_ProductID Index
PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence Index
Relationships
FK_WorkOrderRouting_Location_LocationID Relationship
FK_WorkOrderRouting_WorkOrder_WorkOrderID Relationship
Views
Production.vProductAndDescription View
Production.vProductModelCatalogDescription View
Production.vProductModelInstructions View
Purchasing Schema
Overview
Tables
Purchasing.ProductVendor Table
Indexes
IX_ProductVendor_BusinessEntityID Index
IX_ProductVendor_UnitMeasureCode Index
PK_ProductVendor_ProductID_BusinessEntityID Index
Relationships
FK_ProductVendor_Product_ProductID Relationship
FK_ProductVendor_UnitMeasure_UnitMeasureCode Relationship
FK_ProductVendor_Vendor_BusinessEntityID Relationship
Purchasing.PurchaseOrderDetail Table
Indexes
IX_PurchaseOrderDetail_ProductID Index
PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID Index
Triggers
iPurchaseOrderDetail Trigger
uPurchaseOrderDetail Trigger
Relationships
FK_PurchaseOrderDetail_Product_ProductID Relationship
FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID Relationship
Purchasing.PurchaseOrderHeader Table
Indexes
IX_PurchaseOrderHeader_EmployeeID Index
IX_PurchaseOrderHeader_VendorID Index
PK_PurchaseOrderHeader_PurchaseOrderID Index
Triggers
uPurchaseOrderHeader Trigger
Relationships
FK_PurchaseOrderHeader_Employee_EmployeeID Relationship
FK_PurchaseOrderHeader_ShipMethod_ShipMethodID Relationship
FK_PurchaseOrderHeader_Vendor_VendorID Relationship
Purchasing.ShipMethod Table
Indexes
AK_ShipMethod_Name Index
AK_ShipMethod_rowguid Index
PK_ShipMethod_ShipMethodID Index
Purchasing.Vendor Table
Indexes
AK_Vendor_AccountNumber Index
PK_Vendor_BusinessEntityID Index
Triggers
dVendor Trigger
Relationships
FK_Vendor_BusinessEntity_BusinessEntityID Relationship
Views
Purchasing.vVendorWithAddresses View
Purchasing.vVendorWithContacts View
Sales Schema
Overview
Tables
Sales.CountryRegionCurrency Table
Indexes
IX_CountryRegionCurrency_CurrencyCode Index
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode Index
Relationships
FK_CountryRegionCurrency_CountryRegion_CountryRegionCode Relationship
FK_CountryRegionCurrency_Currency_CurrencyCode Relationship
Sales.CreditCard Table
Indexes
AK_CreditCard_CardNumber Index
PK_CreditCard_CreditCardID Index
Sales.Currency Table
Indexes
AK_Currency_Name Index
PK_Currency_CurrencyCode Index
Sales.CurrencyRate Table
Indexes
AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode Index
PK_CurrencyRate_CurrencyRateID Index
Relationships
FK_CurrencyRate_Currency_FromCurrencyCode Relationship
FK_CurrencyRate_Currency_ToCurrencyCode Relationship
Sales.Customer Table
Indexes
AK_Customer_AccountNumber Index
AK_Customer_rowguid Index
IX_Customer_TerritoryID Index
PK_Customer_CustomerID Index
Relationships
FK_Customer_Person_PersonID Relationship
FK_Customer_SalesTerritory_TerritoryID Relationship
FK_Customer_Store_StoreID Relationship
Sales.PersonCreditCard Table
Indexes
PK_PersonCreditCard_BusinessEntityID_CreditCardID Index
Relationships
FK_PersonCreditCard_CreditCard_CreditCardID Relationship
FK_PersonCreditCard_Person_BusinessEntityID Relationship
Sales.SalesOrderDetail Table
Indexes
AK_SalesOrderDetail_rowguid Index
IX_SalesOrderDetail_ProductID Index
PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID Index
Triggers
iduSalesOrderDetail Trigger
Relationships
FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID Relationship
FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID Relationship
Sales.SalesOrderHeader Table
Indexes
AK_SalesOrderHeader_rowguid Index
AK_SalesOrderHeader_SalesOrderNumber Index
IX_SalesOrderHeader_CustomerID Index
IX_SalesOrderHeader_SalesPersonID Index
PK_SalesOrderHeader_SalesOrderID Index
Triggers
uSalesOrderHeader Trigger
Relationships
FK_SalesOrderHeader_Address_BillToAddressID Relationship
FK_SalesOrderHeader_Address_ShipToAddressID Relationship
FK_SalesOrderHeader_CreditCard_CreditCardID Relationship
FK_SalesOrderHeader_CurrencyRate_CurrencyRateID Relationship
FK_SalesOrderHeader_Customer_CustomerID Relationship
FK_SalesOrderHeader_SalesPerson_SalesPersonID Relationship
FK_SalesOrderHeader_SalesTerritory_TerritoryID Relationship
FK_SalesOrderHeader_ShipMethod_ShipMethodID Relationship
Sales.SalesOrderHeaderSalesReason Table
Indexes
PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID Index
Relationships
FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID Relationship
FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID Relationship
Sales.SalesPerson Table
Indexes
AK_SalesPerson_rowguid Index
PK_SalesPerson_BusinessEntityID Index
Relationships
FK_SalesPerson_Employee_BusinessEntityID Relationship
FK_SalesPerson_SalesTerritory_TerritoryID Relationship
Sales.SalesPersonQuotaHistory Table
Indexes
AK_SalesPersonQuotaHistory_rowguid Index
PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate Index
Relationships
FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID Relationship
Sales.SalesReason Table
Indexes
PK_SalesReason_SalesReasonID Index
Sales.SalesTaxRate Table
Indexes
AK_SalesTaxRate_rowguid Index
AK_SalesTaxRate_StateProvinceID_TaxType Index
PK_SalesTaxRate_SalesTaxRateID Index
Relationships
FK_SalesTaxRate_StateProvince_StateProvinceID Relationship
Sales.SalesTerritory Table
Indexes
AK_SalesTerritory_Name Index
AK_SalesTerritory_rowguid Index
PK_SalesTerritory_TerritoryID Index
Relationships
FK_SalesTerritory_CountryRegion_CountryRegionCode Relationship
Sales.SalesTerritoryHistory Table
Indexes
AK_SalesTerritoryHistory_rowguid Index
PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID Index
Relationships
FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID Relationship
FK_SalesTerritoryHistory_SalesTerritory_TerritoryID Relationship
Sales.ShoppingCartItem Table
Indexes
IX_ShoppingCartItem_ShoppingCartID_ProductID Index
PK_ShoppingCartItem_ShoppingCartItemID Index
Relationships
FK_ShoppingCartItem_Product_ProductID Relationship
Sales.SpecialOffer Table
Indexes
AK_SpecialOffer_rowguid Index
PK_SpecialOffer_SpecialOfferID Index
Sales.SpecialOfferProduct Table
Indexes
AK_SpecialOfferProduct_rowguid Index
IX_SpecialOfferProduct_ProductID Index
PK_SpecialOfferProduct_SpecialOfferID_ProductID Index
Relationships
FK_SpecialOfferProduct_Product_ProductID Relationship
FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID Relationship
Sales.Store Table
Indexes
AK_Store_rowguid Index
IX_Store_SalesPersonID Index
PK_Store_BusinessEntityID Index
PXML_Store_Demographics Index
Relationships
FK_Store_BusinessEntity_BusinessEntityID Relationship
FK_Store_SalesPerson_SalesPersonID Relationship
Views
Sales.vIndividualCustomer View
Sales.vPersonDemographics View
Sales.vSalesPerson View
Sales.vSalesPersonSalesByFiscalYears View
Sales.vStoreWithAddresses View
Sales.vStoreWithContacts View
Sales.vStoreWithDemographics View
Users
dbo User
guest User
INFORMATION_SCHEMA User
sys User
Roles
db_accessadmin Role
db_backupoperator Role
db_datareader Role
db_datawriter Role
db_ddladmin Role
db_denydatareader Role
db_denydatawriter Role
db_owner Role
db_securityadmin Role
public Role
File Groups
PRIMARY File Group
Full Text Catalogs
AW2016FullTextCatalog Full Text Catalog