Foreign Keys
Fact	PrimarySchema	PrimaryObject	PrimaryColumn	SQLServerName	create_date	modify_date	is_disabled	is_not_trusted	ForeignSchema	ForeignObject	ForeignColumn	ON_DELETE	ON_UPDATE
13	HumanResources	Department	[DepartmentID]	FK_EmployeeDepartmentHistory_Department_DepartmentID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	HumanResources	EmployeeDepartmentHistory	[DepartmentID]
13	HumanResources	Employee	[BusinessEntityID]	FK_EmployeeDepartmentHistory_Employee_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	HumanResources	EmployeeDepartmentHistory	[BusinessEntityID]
13	HumanResources	Employee	[BusinessEntityID]	FK_EmployeePayHistory_Employee_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	HumanResources	EmployeePayHistory	[BusinessEntityID]
13	HumanResources	Employee	[BusinessEntityID]	FK_JobCandidate_Employee_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	HumanResources	JobCandidate	[BusinessEntityID]
13	HumanResources	Employee	[BusinessEntityID]	FK_Document_Employee_Owner	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	Document	[Owner]
13	HumanResources	Employee	[BusinessEntityID]	FK_PurchaseOrderHeader_Employee_EmployeeID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Purchasing	PurchaseOrderHeader	[EmployeeID]
13	HumanResources	Employee	[BusinessEntityID]	FK_SalesPerson_Employee_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesPerson	[BusinessEntityID]
13	HumanResources	Shift	[ShiftID]	FK_EmployeeDepartmentHistory_Shift_ShiftID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	HumanResources	EmployeeDepartmentHistory	[ShiftID]
13	Person	Address	[AddressID]	FK_BusinessEntityAddress_Address_AddressID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	BusinessEntityAddress	[AddressID]
13	Person	Address	[AddressID]	FK_SalesOrderHeader_Address_BillToAddressID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesOrderHeader	[BillToAddressID]
13	Person	Address	[AddressID]	FK_SalesOrderHeader_Address_ShipToAddressID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesOrderHeader	[ShipToAddressID]
13	Person	AddressType	[AddressTypeID]	FK_BusinessEntityAddress_AddressType_AddressTypeID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	BusinessEntityAddress	[AddressTypeID]
13	Person	BusinessEntity	[BusinessEntityID]	FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	BusinessEntityAddress	[BusinessEntityID]
13	Person	BusinessEntity	[BusinessEntityID]	FK_BusinessEntityContact_BusinessEntity_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	BusinessEntityContact	[BusinessEntityID]
13	Person	BusinessEntity	[BusinessEntityID]	FK_Person_BusinessEntity_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	Person	[BusinessEntityID]
13	Person	BusinessEntity	[BusinessEntityID]	FK_Vendor_BusinessEntity_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Purchasing	Vendor	[BusinessEntityID]
13	Person	BusinessEntity	[BusinessEntityID]	FK_Store_BusinessEntity_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	Store	[BusinessEntityID]
13	Person	ContactType	[ContactTypeID]	FK_BusinessEntityContact_ContactType_ContactTypeID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	BusinessEntityContact	[ContactTypeID]
13	Person	CountryRegion	[CountryRegionCode]	FK_StateProvince_CountryRegion_CountryRegionCode	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	StateProvince	[CountryRegionCode]
13	Person	CountryRegion	[CountryRegionCode]	FK_CountryRegionCurrency_CountryRegion_CountryRegionCode	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	CountryRegionCurrency	[CountryRegionCode]
13	Person	CountryRegion	[CountryRegionCode]	FK_SalesTerritory_CountryRegion_CountryRegionCode	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesTerritory	[CountryRegionCode]
13	Person	Person	[BusinessEntityID]	FK_Employee_Person_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	HumanResources	Employee	[BusinessEntityID]
13	Person	Person	[BusinessEntityID]	FK_BusinessEntityContact_Person_PersonID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	BusinessEntityContact	[PersonID]
13	Person	Person	[BusinessEntityID]	FK_EmailAddress_Person_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	EmailAddress	[BusinessEntityID]
13	Person	Person	[BusinessEntityID]	FK_Password_Person_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	Password	[BusinessEntityID]
13	Person	Person	[BusinessEntityID]	FK_PersonPhone_Person_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	PersonPhone	[BusinessEntityID]
13	Person	Person	[BusinessEntityID]	FK_Customer_Person_PersonID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	Customer	[PersonID]
13	Person	Person	[BusinessEntityID]	FK_PersonCreditCard_Person_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	PersonCreditCard	[BusinessEntityID]
13	Person	PhoneNumberType	[PhoneNumberTypeID]	FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	PersonPhone	[PhoneNumberTypeID]
13	Person	StateProvince	[StateProvinceID]	FK_Address_StateProvince_StateProvinceID	2017-10-27 14:33:13	2017-10-27 14:33:13	False	False	Person	Address	[StateProvinceID]
13	Person	StateProvince	[StateProvinceID]	FK_SalesTaxRate_StateProvince_StateProvinceID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesTaxRate	[StateProvinceID]
13	Production	Culture	[CultureID]	FK_ProductModelProductDescriptionCulture_Culture_CultureID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductModelProductDescriptionCulture	[CultureID]
13	Production	Document	[DocumentNode]	FK_ProductDocument_Document_DocumentNode	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductDocument	[DocumentNode]
13	Production	Illustration	[IllustrationID]	FK_ProductModelIllustration_Illustration_IllustrationID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductModelIllustration	[IllustrationID]
13	Production	Location	[LocationID]	FK_ProductInventory_Location_LocationID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductInventory	[LocationID]
13	Production	Location	[LocationID]	FK_WorkOrderRouting_Location_LocationID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	WorkOrderRouting	[LocationID]
13	Production	Product	[ProductID]	FK_BillOfMaterials_Product_ComponentID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	BillOfMaterials	[ComponentID]
13	Production	Product	[ProductID]	FK_BillOfMaterials_Product_ProductAssemblyID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	BillOfMaterials	[ProductAssemblyID]
13	Production	Product	[ProductID]	FK_ProductCostHistory_Product_ProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductCostHistory	[ProductID]
13	Production	Product	[ProductID]	FK_ProductDocument_Product_ProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductDocument	[ProductID]
13	Production	Product	[ProductID]	FK_ProductInventory_Product_ProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductInventory	[ProductID]
13	Production	Product	[ProductID]	FK_ProductListPriceHistory_Product_ProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductListPriceHistory	[ProductID]
13	Production	Product	[ProductID]	FK_ProductProductPhoto_Product_ProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductProductPhoto	[ProductID]
13	Production	Product	[ProductID]	FK_ProductReview_Product_ProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductReview	[ProductID]
13	Production	Product	[ProductID]	FK_TransactionHistory_Product_ProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	TransactionHistory	[ProductID]
13	Production	Product	[ProductID]	FK_WorkOrder_Product_ProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	WorkOrder	[ProductID]
13	Production	Product	[ProductID]	FK_ProductVendor_Product_ProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Purchasing	ProductVendor	[ProductID]
13	Production	Product	[ProductID]	FK_PurchaseOrderDetail_Product_ProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Purchasing	PurchaseOrderDetail	[ProductID]
13	Production	Product	[ProductID]	FK_ShoppingCartItem_Product_ProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	ShoppingCartItem	[ProductID]
13	Production	Product	[ProductID]	FK_SpecialOfferProduct_Product_ProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SpecialOfferProduct	[ProductID]
13	Production	ProductCategory	[ProductCategoryID]	FK_ProductSubcategory_ProductCategory_ProductCategoryID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductSubcategory	[ProductCategoryID]
13	Production	ProductDescription	[ProductDescriptionID]	FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductModelProductDescriptionCulture	[ProductDescriptionID]
13	Production	ProductModel	[ProductModelID]	FK_Product_ProductModel_ProductModelID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	Product	[ProductModelID]
13	Production	ProductModel	[ProductModelID]	FK_ProductModelIllustration_ProductModel_ProductModelID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductModelIllustration	[ProductModelID]
13	Production	ProductModel	[ProductModelID]	FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductModelProductDescriptionCulture	[ProductModelID]
13	Production	ProductPhoto	[ProductPhotoID]	FK_ProductProductPhoto_ProductPhoto_ProductPhotoID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	ProductProductPhoto	[ProductPhotoID]
13	Production	ProductSubcategory	[ProductSubcategoryID]	FK_Product_ProductSubcategory_ProductSubcategoryID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	Product	[ProductSubcategoryID]
13	Production	ScrapReason	[ScrapReasonID]	FK_WorkOrder_ScrapReason_ScrapReasonID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	WorkOrder	[ScrapReasonID]
13	Production	UnitMeasure	[UnitMeasureCode]	FK_BillOfMaterials_UnitMeasure_UnitMeasureCode	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	BillOfMaterials	[UnitMeasureCode]
13	Production	UnitMeasure	[UnitMeasureCode]	FK_Product_UnitMeasure_SizeUnitMeasureCode	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	Product	[SizeUnitMeasureCode]
13	Production	UnitMeasure	[UnitMeasureCode]	FK_Product_UnitMeasure_WeightUnitMeasureCode	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	Product	[WeightUnitMeasureCode]
13	Production	UnitMeasure	[UnitMeasureCode]	FK_ProductVendor_UnitMeasure_UnitMeasureCode	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Purchasing	ProductVendor	[UnitMeasureCode]
13	Production	WorkOrder	[WorkOrderID]	FK_WorkOrderRouting_WorkOrder_WorkOrderID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Production	WorkOrderRouting	[WorkOrderID]
13	Purchasing	PurchaseOrderHeader	[PurchaseOrderID]	FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Purchasing	PurchaseOrderDetail	[PurchaseOrderID]
13	Purchasing	ShipMethod	[ShipMethodID]	FK_PurchaseOrderHeader_ShipMethod_ShipMethodID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Purchasing	PurchaseOrderHeader	[ShipMethodID]
13	Purchasing	ShipMethod	[ShipMethodID]	FK_SalesOrderHeader_ShipMethod_ShipMethodID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesOrderHeader	[ShipMethodID]
13	Purchasing	Vendor	[BusinessEntityID]	FK_ProductVendor_Vendor_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Purchasing	ProductVendor	[BusinessEntityID]
13	Purchasing	Vendor	[BusinessEntityID]	FK_PurchaseOrderHeader_Vendor_VendorID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Purchasing	PurchaseOrderHeader	[VendorID]
13	Sales	CreditCard	[CreditCardID]	FK_PersonCreditCard_CreditCard_CreditCardID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	PersonCreditCard	[CreditCardID]
13	Sales	CreditCard	[CreditCardID]	FK_SalesOrderHeader_CreditCard_CreditCardID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesOrderHeader	[CreditCardID]
13	Sales	Currency	[CurrencyCode]	FK_CountryRegionCurrency_Currency_CurrencyCode	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	CountryRegionCurrency	[CurrencyCode]
13	Sales	Currency	[CurrencyCode]	FK_CurrencyRate_Currency_FromCurrencyCode	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	CurrencyRate	[FromCurrencyCode]
13	Sales	Currency	[CurrencyCode]	FK_CurrencyRate_Currency_ToCurrencyCode	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	CurrencyRate	[ToCurrencyCode]
13	Sales	CurrencyRate	[CurrencyRateID]	FK_SalesOrderHeader_CurrencyRate_CurrencyRateID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesOrderHeader	[CurrencyRateID]
13	Sales	Customer	[CustomerID]	FK_SalesOrderHeader_Customer_CustomerID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesOrderHeader	[CustomerID]
13	Sales	SalesOrderHeader	[SalesOrderID]	FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesOrderDetail	[SalesOrderID]	CASCADE
13	Sales	SalesOrderHeader	[SalesOrderID]	FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesOrderHeaderSalesReason	[SalesOrderID]	CASCADE
13	Sales	SalesPerson	[BusinessEntityID]	FK_SalesOrderHeader_SalesPerson_SalesPersonID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesOrderHeader	[SalesPersonID]
13	Sales	SalesPerson	[BusinessEntityID]	FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesPersonQuotaHistory	[BusinessEntityID]
13	Sales	SalesPerson	[BusinessEntityID]	FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesTerritoryHistory	[BusinessEntityID]
13	Sales	SalesPerson	[BusinessEntityID]	FK_Store_SalesPerson_SalesPersonID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	Store	[SalesPersonID]
13	Sales	SalesReason	[SalesReasonID]	FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesOrderHeaderSalesReason	[SalesReasonID]
13	Sales	SalesTerritory	[TerritoryID]	FK_StateProvince_SalesTerritory_TerritoryID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Person	StateProvince	[TerritoryID]
13	Sales	SalesTerritory	[TerritoryID]	FK_Customer_SalesTerritory_TerritoryID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	Customer	[TerritoryID]
13	Sales	SalesTerritory	[TerritoryID]	FK_SalesOrderHeader_SalesTerritory_TerritoryID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesOrderHeader	[TerritoryID]
13	Sales	SalesTerritory	[TerritoryID]	FK_SalesPerson_SalesTerritory_TerritoryID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesPerson	[TerritoryID]
13	Sales	SalesTerritory	[TerritoryID]	FK_SalesTerritoryHistory_SalesTerritory_TerritoryID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesTerritoryHistory	[TerritoryID]
13	Sales	SpecialOffer	[SpecialOfferID]	FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SpecialOfferProduct	[SpecialOfferID]
13	Sales	SpecialOfferProduct	[SpecialOfferID], [ProductID]	FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	SalesOrderDetail	[SpecialOfferID], [ProductID]
13	Sales	Store	[BusinessEntityID]	FK_Customer_Store_StoreID	2017-10-27 14:33:14	2017-10-27 14:33:14	False	False	Sales	Customer	[StoreID]