Foreign Keys To Consider
Fact	PrimarySchema	PrimaryObject	ForeignSchema	ForeignObject	ForeignColumn
36	Sales	SalesPerson	HumanResources	Employee	[BusinessEntityID]
36	Person	Password	HumanResources	Employee	[BusinessEntityID]
36	Sales	Store	HumanResources	Employee	[BusinessEntityID]
36	Person	BusinessEntity	HumanResources	Employee	[BusinessEntityID]
36	Purchasing	Vendor	HumanResources	Employee	[BusinessEntityID]
36	Purchasing	Vendor	HumanResources	EmployeeDepartmentHistory	[BusinessEntityID]
36	Person	BusinessEntity	HumanResources	EmployeeDepartmentHistory	[BusinessEntityID]
36	Sales	Store	HumanResources	EmployeeDepartmentHistory	[BusinessEntityID]
36	Person	Person	HumanResources	EmployeeDepartmentHistory	[BusinessEntityID]
36	Person	Password	HumanResources	EmployeeDepartmentHistory	[BusinessEntityID]
36	Sales	SalesPerson	HumanResources	EmployeeDepartmentHistory	[BusinessEntityID]
36	Person	Password	HumanResources	EmployeePayHistory	[BusinessEntityID]
36	Sales	SalesPerson	HumanResources	EmployeePayHistory	[BusinessEntityID]
36	Person	Person	HumanResources	EmployeePayHistory	[BusinessEntityID]
36	Sales	Store	HumanResources	EmployeePayHistory	[BusinessEntityID]
36	Person	BusinessEntity	HumanResources	EmployeePayHistory	[BusinessEntityID]
36	Purchasing	Vendor	HumanResources	EmployeePayHistory	[BusinessEntityID]
36	Purchasing	Vendor	HumanResources	JobCandidate	[BusinessEntityID]
36	Person	BusinessEntity	HumanResources	JobCandidate	[BusinessEntityID]
36	Sales	Store	HumanResources	JobCandidate	[BusinessEntityID]
36	Person	Person	HumanResources	JobCandidate	[BusinessEntityID]
36	Sales	SalesPerson	HumanResources	JobCandidate	[BusinessEntityID]
36	Person	Password	HumanResources	JobCandidate	[BusinessEntityID]
36	Sales	SalesPerson	Person	BusinessEntity	[BusinessEntityID]
36	Person	Password	Person	BusinessEntity	[BusinessEntityID]
36	Sales	Store	Person	BusinessEntity	[BusinessEntityID]
36	Person	Person	Person	BusinessEntity	[BusinessEntityID]
36	Purchasing	Vendor	Person	BusinessEntity	[BusinessEntityID]
36	HumanResources	Employee	Person	BusinessEntity	[BusinessEntityID]
36	HumanResources	Employee	Person	BusinessEntityAddress	[BusinessEntityID]
36	Purchasing	Vendor	Person	BusinessEntityAddress	[BusinessEntityID]
36	Person	Person	Person	BusinessEntityAddress	[BusinessEntityID]
36	Sales	Store	Person	BusinessEntityAddress	[BusinessEntityID]
36	Person	Password	Person	BusinessEntityAddress	[BusinessEntityID]
36	Sales	SalesPerson	Person	BusinessEntityAddress	[BusinessEntityID]
36	Sales	SalesPerson	Person	BusinessEntityContact	[BusinessEntityID]
36	Person	Password	Person	BusinessEntityContact	[BusinessEntityID]
36	Sales	Store	Person	BusinessEntityContact	[BusinessEntityID]
36	Purchasing	Vendor	Person	BusinessEntityContact	[BusinessEntityID]
36	HumanResources	Employee	Person	BusinessEntityContact	[BusinessEntityID]
36	Purchasing	Vendor	Person	EmailAddress	[BusinessEntityID]
36	Person	BusinessEntity	Person	EmailAddress	[BusinessEntityID]
36	HumanResources	Employee	Person	EmailAddress	[BusinessEntityID]
36	Person	Password	Person	EmailAddress	[BusinessEntityID]
36	Sales	Store	Person	EmailAddress	[BusinessEntityID]
36	Sales	SalesPerson	Person	EmailAddress	[BusinessEntityID]
36	Sales	SalesPerson	Person	Password	[BusinessEntityID]
36	Sales	Store	Person	Password	[BusinessEntityID]
36	HumanResources	Employee	Person	Password	[BusinessEntityID]
36	Person	BusinessEntity	Person	Password	[BusinessEntityID]
36	Purchasing	Vendor	Person	Password	[BusinessEntityID]
36	Purchasing	Vendor	Person	Person	[BusinessEntityID]
36	HumanResources	Employee	Person	Person	[BusinessEntityID]
36	Sales	Store	Person	Person	[BusinessEntityID]
36	Sales	SalesPerson	Person	Person	[BusinessEntityID]
36	Person	Password	Person	Person	[BusinessEntityID]
36	Person	Password	Person	PersonPhone	[BusinessEntityID]
36	Sales	SalesPerson	Person	PersonPhone	[BusinessEntityID]
36	Sales	Store	Person	PersonPhone	[BusinessEntityID]
36	HumanResources	Employee	Person	PersonPhone	[BusinessEntityID]
36	Purchasing	Vendor	Person	PersonPhone	[BusinessEntityID]
36	Person	BusinessEntity	Person	PersonPhone	[BusinessEntityID]
36	Production	ProductListPriceHistory	Production	ProductCostHistory	[ProductID], [StartDate]
36	Production	ProductCostHistory	Production	ProductListPriceHistory	[ProductID], [StartDate]
36	Production	TransactionHistoryArchive	Production	TransactionHistory	[TransactionID]
36	Production	Product	Production	TransactionHistoryArchive	[ProductID]
36	Production	TransactionHistory	Production	TransactionHistoryArchive	[TransactionID]
36	Production	ProductCostHistory	Production	WorkOrder	[ProductID], [StartDate]
36	Production	ProductListPriceHistory	Production	WorkOrder	[ProductID], [StartDate]
36	Production	Product	Production	WorkOrderRouting	[ProductID]
36	Production	ProductInventory	Production	WorkOrderRouting	[ProductID], [LocationID]
36	Person	Person	Purchasing	ProductVendor	[BusinessEntityID]
36	Sales	Store	Purchasing	ProductVendor	[BusinessEntityID]
36	Sales	SalesPerson	Purchasing	ProductVendor	[BusinessEntityID]
36	Person	Password	Purchasing	ProductVendor	[BusinessEntityID]
36	Person	BusinessEntity	Purchasing	ProductVendor	[BusinessEntityID]
36	HumanResources	Employee	Purchasing	ProductVendor	[BusinessEntityID]
36	HumanResources	Employee	Purchasing	Vendor	[BusinessEntityID]
36	Person	Password	Purchasing	Vendor	[BusinessEntityID]
36	Sales	SalesPerson	Purchasing	Vendor	[BusinessEntityID]
36	Sales	Store	Purchasing	Vendor	[BusinessEntityID]
36	Person	Person	Purchasing	Vendor	[BusinessEntityID]
36	Sales	Store	Sales	PersonCreditCard	[BusinessEntityID]
36	Sales	SalesPerson	Sales	PersonCreditCard	[BusinessEntityID]
36	Person	Password	Sales	PersonCreditCard	[BusinessEntityID]
36	HumanResources	Employee	Sales	PersonCreditCard	[BusinessEntityID]
36	Person	BusinessEntity	Sales	PersonCreditCard	[BusinessEntityID]
36	Purchasing	Vendor	Sales	PersonCreditCard	[BusinessEntityID]
36	Production	Product	Sales	SalesOrderDetail	[ProductID]
36	Sales	SpecialOffer	Sales	SalesOrderDetail	[SpecialOfferID]
36	Sales	Store	Sales	SalesPerson	[BusinessEntityID]
36	Person	BusinessEntity	Sales	SalesPerson	[BusinessEntityID]
36	Person	Person	Sales	SalesPerson	[BusinessEntityID]
36	Person	Password	Sales	SalesPerson	[BusinessEntityID]
36	Purchasing	Vendor	Sales	SalesPerson	[BusinessEntityID]
36	Purchasing	Vendor	Sales	SalesPersonQuotaHistory	[BusinessEntityID]
36	Person	BusinessEntity	Sales	SalesPersonQuotaHistory	[BusinessEntityID]
36	HumanResources	Employee	Sales	SalesPersonQuotaHistory	[BusinessEntityID]
36	Person	Password	Sales	SalesPersonQuotaHistory	[BusinessEntityID]
36	Person	Person	Sales	SalesPersonQuotaHistory	[BusinessEntityID]
36	Sales	Store	Sales	SalesPersonQuotaHistory	[BusinessEntityID]
36	Sales	Store	Sales	SalesTerritoryHistory	[BusinessEntityID]
36	Person	Person	Sales	SalesTerritoryHistory	[BusinessEntityID]
36	Person	Password	Sales	SalesTerritoryHistory	[BusinessEntityID]
36	HumanResources	Employee	Sales	SalesTerritoryHistory	[BusinessEntityID]
36	Person	BusinessEntity	Sales	SalesTerritoryHistory	[BusinessEntityID]
36	Purchasing	Vendor	Sales	SalesTerritoryHistory	[BusinessEntityID]
36	Purchasing	Vendor	Sales	Store	[BusinessEntityID]
36	HumanResources	Employee	Sales	Store	[BusinessEntityID]
36	Person	Password	Sales	Store	[BusinessEntityID]
36	Person	Person	Sales	Store	[BusinessEntityID]