Foreign Key Indexes
Fact	PrimarySchema	PrimaryObject	ForeignSchema	ForeignObject	ForeignColumn	SQLServerName	RegularColumn
37	Person	Person	HumanResources	Employee	[BusinessEntityID]	PK_Employee_BusinessEntityID	[BusinessEntityID]
37	HumanResources	Employee	HumanResources	EmployeeDepartmentHistory	[BusinessEntityID]	PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID	[BusinessEntityID], [DepartmentID], [ShiftID], [StartDate]
37	HumanResources	Department	HumanResources	EmployeeDepartmentHistory	[DepartmentID]	IX_EmployeeDepartmentHistory_DepartmentID	[DepartmentID]
37	HumanResources	Shift	HumanResources	EmployeeDepartmentHistory	[ShiftID]	IX_EmployeeDepartmentHistory_ShiftID	[ShiftID]
37	HumanResources	Employee	HumanResources	EmployeePayHistory	[BusinessEntityID]	PK_EmployeePayHistory_BusinessEntityID_RateChangeDate	[BusinessEntityID], [RateChangeDate]
37	HumanResources	Employee	HumanResources	JobCandidate	[BusinessEntityID]	IX_JobCandidate_BusinessEntityID	[BusinessEntityID]
37	Person	StateProvince	Person	Address	[StateProvinceID]	IX_Address_StateProvinceID	[StateProvinceID]
37	Person	Address	Person	BusinessEntityAddress	[AddressID]	IX_BusinessEntityAddress_AddressID	[AddressID]
37	Person	AddressType	Person	BusinessEntityAddress	[AddressTypeID]	IX_BusinessEntityAddress_AddressTypeID	[AddressTypeID]
37	Person	BusinessEntity	Person	BusinessEntityAddress	[BusinessEntityID]	PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID	[BusinessEntityID], [AddressID], [AddressTypeID]
37	Person	BusinessEntity	Person	BusinessEntityContact	[BusinessEntityID]	PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID	[BusinessEntityID], [PersonID], [ContactTypeID]
37	Person	ContactType	Person	BusinessEntityContact	[ContactTypeID]	IX_BusinessEntityContact_ContactTypeID	[ContactTypeID]
37	Person	Person	Person	BusinessEntityContact	[PersonID]	IX_BusinessEntityContact_PersonID	[PersonID]
37	Person	Person	Person	EmailAddress	[BusinessEntityID]	PK_EmailAddress_BusinessEntityID_EmailAddressID	[BusinessEntityID], [EmailAddressID]
37	Person	Person	Person	Password	[BusinessEntityID]	PK_Password_BusinessEntityID	[BusinessEntityID]
37	Person	BusinessEntity	Person	Person	[BusinessEntityID]	PK_Person_BusinessEntityID	[BusinessEntityID]
37	Person	Person	Person	PersonPhone	[BusinessEntityID]	PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID	[BusinessEntityID], [PhoneNumber], [PhoneNumberTypeID]
37	Person	PhoneNumberType	Person	PersonPhone	[PhoneNumberTypeID]
37	Person	CountryRegion	Person	StateProvince	[CountryRegionCode]
37	Sales	SalesTerritory	Person	StateProvince	[TerritoryID]
37	Production	Product	Production	BillOfMaterials	[ComponentID]
37	Production	Product	Production	BillOfMaterials	[ProductAssemblyID]	AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate	[ProductAssemblyID], [ComponentID], [StartDate]
37	Production	UnitMeasure	Production	BillOfMaterials	[UnitMeasureCode]	IX_BillOfMaterials_UnitMeasureCode	[UnitMeasureCode]
37	HumanResources	Employee	Production	Document	[Owner]
37	Production	ProductModel	Production	Product	[ProductModelID]
37	Production	ProductSubcategory	Production	Product	[ProductSubcategoryID]
37	Production	UnitMeasure	Production	Product	[SizeUnitMeasureCode]
37	Production	UnitMeasure	Production	Product	[WeightUnitMeasureCode]
37	Production	Product	Production	ProductCostHistory	[ProductID]	PK_ProductCostHistory_ProductID_StartDate	[ProductID], [StartDate]
37	Production	Document	Production	ProductDocument	[DocumentNode]
37	Production	Product	Production	ProductDocument	[ProductID]	PK_ProductDocument_ProductID_DocumentNode	[ProductID], [DocumentNode]
37	Production	Location	Production	ProductInventory	[LocationID]
37	Production	Product	Production	ProductInventory	[ProductID]	PK_ProductInventory_ProductID_LocationID	[ProductID], [LocationID]
37	Production	Product	Production	ProductListPriceHistory	[ProductID]	PK_ProductListPriceHistory_ProductID_StartDate	[ProductID], [StartDate]
37	Production	Illustration	Production	ProductModelIllustration	[IllustrationID]
37	Production	ProductModel	Production	ProductModelIllustration	[ProductModelID]	PK_ProductModelIllustration_ProductModelID_IllustrationID	[ProductModelID], [IllustrationID]
37	Production	Culture	Production	ProductModelProductDescriptionCulture	[CultureID]
37	Production	ProductDescription	Production	ProductModelProductDescriptionCulture	[ProductDescriptionID]
37	Production	ProductModel	Production	ProductModelProductDescriptionCulture	[ProductModelID]	PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID	[ProductModelID], [ProductDescriptionID], [CultureID]
37	Production	Product	Production	ProductProductPhoto	[ProductID]	PK_ProductProductPhoto_ProductID_ProductPhotoID	[ProductID], [ProductPhotoID]
37	Production	ProductPhoto	Production	ProductProductPhoto	[ProductPhotoID]
37	Production	Product	Production	ProductReview	[ProductID]	IX_ProductReview_ProductID_Name	[ProductID], [ReviewerName]
37	Production	ProductCategory	Production	ProductSubcategory	[ProductCategoryID]
37	Production	Product	Production	TransactionHistory	[ProductID]	IX_TransactionHistory_ProductID	[ProductID]
37	Production	Product	Production	WorkOrder	[ProductID]	IX_WorkOrder_ProductID	[ProductID]
37	Production	ScrapReason	Production	WorkOrder	[ScrapReasonID]	IX_WorkOrder_ScrapReasonID	[ScrapReasonID]
37	Production	Location	Production	WorkOrderRouting	[LocationID]
37	Production	WorkOrder	Production	WorkOrderRouting	[WorkOrderID]	PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence	[WorkOrderID], [ProductID], [OperationSequence]
37	Purchasing	Vendor	Purchasing	ProductVendor	[BusinessEntityID]	IX_ProductVendor_BusinessEntityID	[BusinessEntityID]
37	Production	Product	Purchasing	ProductVendor	[ProductID]	PK_ProductVendor_ProductID_BusinessEntityID	[ProductID], [BusinessEntityID]
37	Production	UnitMeasure	Purchasing	ProductVendor	[UnitMeasureCode]	IX_ProductVendor_UnitMeasureCode	[UnitMeasureCode]
37	Production	Product	Purchasing	PurchaseOrderDetail	[ProductID]	IX_PurchaseOrderDetail_ProductID	[ProductID]
37	Purchasing	PurchaseOrderHeader	Purchasing	PurchaseOrderDetail	[PurchaseOrderID]	PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID	[PurchaseOrderID], [PurchaseOrderDetailID]
37	HumanResources	Employee	Purchasing	PurchaseOrderHeader	[EmployeeID]	IX_PurchaseOrderHeader_EmployeeID	[EmployeeID]
37	Purchasing	ShipMethod	Purchasing	PurchaseOrderHeader	[ShipMethodID]
37	Purchasing	Vendor	Purchasing	PurchaseOrderHeader	[VendorID]	IX_PurchaseOrderHeader_VendorID	[VendorID]
37	Person	BusinessEntity	Purchasing	Vendor	[BusinessEntityID]	PK_Vendor_BusinessEntityID	[BusinessEntityID]
37	Person	CountryRegion	Sales	CountryRegionCurrency	[CountryRegionCode]	PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode	[CountryRegionCode], [CurrencyCode]
37	Sales	Currency	Sales	CountryRegionCurrency	[CurrencyCode]	IX_CountryRegionCurrency_CurrencyCode	[CurrencyCode]
37	Sales	Currency	Sales	CurrencyRate	[FromCurrencyCode]
37	Sales	Currency	Sales	CurrencyRate	[ToCurrencyCode]
37	Person	Person	Sales	Customer	[PersonID]
37	Sales	Store	Sales	Customer	[StoreID]
37	Sales	SalesTerritory	Sales	Customer	[TerritoryID]	IX_Customer_TerritoryID	[TerritoryID]
37	Person	Person	Sales	PersonCreditCard	[BusinessEntityID]	PK_PersonCreditCard_BusinessEntityID_CreditCardID	[BusinessEntityID], [CreditCardID]
37	Sales	CreditCard	Sales	PersonCreditCard	[CreditCardID]
37	Sales	SalesOrderHeader	Sales	SalesOrderDetail	[SalesOrderID]	PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID	[SalesOrderID], [SalesOrderDetailID]
37	Sales	SpecialOfferProduct	Sales	SalesOrderDetail	[SpecialOfferID], [ProductID]
37	Person	Address	Sales	SalesOrderHeader	[BillToAddressID]
37	Sales	CreditCard	Sales	SalesOrderHeader	[CreditCardID]
37	Sales	CurrencyRate	Sales	SalesOrderHeader	[CurrencyRateID]
37	Sales	Customer	Sales	SalesOrderHeader	[CustomerID]	IX_SalesOrderHeader_CustomerID	[CustomerID]
37	Sales	SalesPerson	Sales	SalesOrderHeader	[SalesPersonID]	IX_SalesOrderHeader_SalesPersonID	[SalesPersonID]
37	Purchasing	ShipMethod	Sales	SalesOrderHeader	[ShipMethodID]
37	Person	Address	Sales	SalesOrderHeader	[ShipToAddressID]
37	Sales	SalesTerritory	Sales	SalesOrderHeader	[TerritoryID]
37	Sales	SalesOrderHeader	Sales	SalesOrderHeaderSalesReason	[SalesOrderID]	PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID	[SalesOrderID], [SalesReasonID]
37	Sales	SalesReason	Sales	SalesOrderHeaderSalesReason	[SalesReasonID]
37	HumanResources	Employee	Sales	SalesPerson	[BusinessEntityID]	PK_SalesPerson_BusinessEntityID	[BusinessEntityID]
37	Sales	SalesTerritory	Sales	SalesPerson	[TerritoryID]
37	Sales	SalesPerson	Sales	SalesPersonQuotaHistory	[BusinessEntityID]	PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate	[BusinessEntityID], [QuotaDate]
37	Person	StateProvince	Sales	SalesTaxRate	[StateProvinceID]	AK_SalesTaxRate_StateProvinceID_TaxType	[StateProvinceID], [TaxType]
37	Person	CountryRegion	Sales	SalesTerritory	[CountryRegionCode]
37	Sales	SalesPerson	Sales	SalesTerritoryHistory	[BusinessEntityID]	PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID	[BusinessEntityID], [TerritoryID], [StartDate]
37	Sales	SalesTerritory	Sales	SalesTerritoryHistory	[TerritoryID]
37	Production	Product	Sales	ShoppingCartItem	[ProductID]
37	Production	Product	Sales	SpecialOfferProduct	[ProductID]	IX_SpecialOfferProduct_ProductID	[ProductID]
37	Sales	SpecialOffer	Sales	SpecialOfferProduct	[SpecialOfferID]	PK_SpecialOfferProduct_SpecialOfferID_ProductID	[SpecialOfferID], [ProductID]
37	Person	BusinessEntity	Sales	Store	[BusinessEntityID]	PK_Store_BusinessEntityID	[BusinessEntityID]
37	Sales	SalesPerson	Sales	Store	[SalesPersonID]	IX_Store_SalesPersonID	[SalesPersonID]