AdventureWorks 完整概念結構描述 (EDM)
本主題的 實體資料模型 (EDM) 範例會依據 AdventureWorks 範例資料庫定義實體和關聯。實體和關聯都是以概念結構定義語言 (CSDL) 定義。
CSDL 結構描述
此結構描述會定義一個可程式化物件模型，此物件模型對應到 AdventureWorks 資料庫中的資料表。下列結構描述是使用 EdmGen.exe 工具與儲存體和對應結構描述一起產生的，如 AdventureWorks 完整模型 (EDM) 中所示。
下列結構描述會定義建置可程式化物件所需的所有類型和關聯。
<?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="AdventureWorks" Alias="Self" xmlns="https://schemas.microsoft.com/ado/2006/04/edm">
<EntityContainer Name="AdventureWorksContext">
<EntitySet Name="AWBuildVersion" EntityType="AdventureWorks.AWBuildVersion" />
<EntitySet Name="DatabaseLog" EntityType="AdventureWorks.DatabaseLog" />
<EntitySet Name="ErrorLog" EntityType="AdventureWorks.ErrorLog" />
<EntitySet Name="Department" EntityType="AdventureWorks.Department" />
<EntitySet Name="Employee" EntityType="AdventureWorks.Employee" />
<EntitySet Name="EmployeeAddress" EntityType="AdventureWorks.EmployeeAddress" />
<EntitySet Name="EmployeeDepartmentHistory" EntityType="AdventureWorks.EmployeeDepartmentHistory" />
<EntitySet Name="EmployeePayHistory" EntityType="AdventureWorks.EmployeePayHistory" />
<EntitySet Name="JobCandidate" EntityType="AdventureWorks.JobCandidate" />
<EntitySet Name="SalesEmployee" EntityType="AdventureWorks.SalesEmployee" />
<EntitySet Name="Shift" EntityType="AdventureWorks.Shift" />
<EntitySet Name="Address" EntityType="AdventureWorks.Address" />
<EntitySet Name="AddressType" EntityType="AdventureWorks.AddressType" />
<EntitySet Name="Contact" EntityType="AdventureWorks.Contact" />
<EntitySet Name="ContactType" EntityType="AdventureWorks.ContactType" />
<EntitySet Name="CountryRegion" EntityType="AdventureWorks.CountryRegion" />
<EntitySet Name="StateProvince" EntityType="AdventureWorks.StateProvince" />
<EntitySet Name="BillOfMaterials" EntityType="AdventureWorks.BillOfMaterials" />
<EntitySet Name="Culture" EntityType="AdventureWorks.Culture" />
<EntitySet Name="Document" EntityType="AdventureWorks.Document" />
<EntitySet Name="Illustration" EntityType="AdventureWorks.Illustration" />
<EntitySet Name="Location" EntityType="AdventureWorks.Location" />
<EntitySet Name="Product" EntityType="AdventureWorks.Product" />
<EntitySet Name="ProductCategory" EntityType="AdventureWorks.ProductCategory" />
<EntitySet Name="ProductCostHistory" EntityType="AdventureWorks.ProductCostHistory" />
<EntitySet Name="ProductDescription" EntityType="AdventureWorks.ProductDescription" />
<EntitySet Name="ProductDocument" EntityType="AdventureWorks.ProductDocument" />
<EntitySet Name="ProductInventory" EntityType="AdventureWorks.ProductInventory" />
<EntitySet Name="ProductListPriceHistory" EntityType="AdventureWorks.ProductListPriceHistory" />
<EntitySet Name="ProductModel" EntityType="AdventureWorks.ProductModel" />
<EntitySet Name="ProductModelIllustration" EntityType="AdventureWorks.ProductModelIllustration" />
<EntitySet Name="ProductModelProductDescriptionCulture" EntityType="AdventureWorks.ProductModelProductDescriptionCulture" />
<EntitySet Name="ProductPhoto" EntityType="AdventureWorks.ProductPhoto" />
<EntitySet Name="ProductProductPhoto" EntityType="AdventureWorks.ProductProductPhoto" />
<EntitySet Name="ProductReview" EntityType="AdventureWorks.ProductReview" />
<EntitySet Name="ProductSubcategory" EntityType="AdventureWorks.ProductSubcategory" />
<EntitySet Name="ScrapReason" EntityType="AdventureWorks.ScrapReason" />
<EntitySet Name="TransactionHistory" EntityType="AdventureWorks.TransactionHistory" />
<EntitySet Name="TransactionHistoryArchive" EntityType="AdventureWorks.TransactionHistoryArchive" />
<EntitySet Name="UnitMeasure" EntityType="AdventureWorks.UnitMeasure" />
<EntitySet Name="WorkOrder" EntityType="AdventureWorks.WorkOrder" />
<EntitySet Name="WorkOrderRouting" EntityType="AdventureWorks.WorkOrderRouting" />
<EntitySet Name="ProductVendor" EntityType="AdventureWorks.ProductVendor" />
<EntitySet Name="PurchaseOrderDetail" EntityType="AdventureWorks.PurchaseOrderDetail" />
<EntitySet Name="PurchaseOrderHeader" EntityType="AdventureWorks.PurchaseOrderHeader" />
<EntitySet Name="ShipMethod" EntityType="AdventureWorks.ShipMethod" />
<EntitySet Name="Vendor" EntityType="AdventureWorks.Vendor" />
<EntitySet Name="VendorAddress" EntityType="AdventureWorks.VendorAddress" />
<EntitySet Name="VendorContact" EntityType="AdventureWorks.VendorContact" />
<EntitySet Name="ContactCreditCard" EntityType="AdventureWorks.ContactCreditCard" />
<EntitySet Name="CountryRegionCurrency" EntityType="AdventureWorks.CountryRegionCurrency" />
<EntitySet Name="CreditCard" EntityType="AdventureWorks.CreditCard" />
<EntitySet Name="Currency" EntityType="AdventureWorks.Currency" />
<EntitySet Name="CurrencyRate" EntityType="AdventureWorks.CurrencyRate" />
<EntitySet Name="Customer" EntityType="AdventureWorks.Customer" />
<EntitySet Name="CustomerAddress" EntityType="AdventureWorks.CustomerAddress" />
<EntitySet Name="Individual" EntityType="AdventureWorks.Individual" />
<EntitySet Name="SalesOrderDetail" EntityType="AdventureWorks.SalesOrderDetail" />
<EntitySet Name="SalesOrderHeader" EntityType="AdventureWorks.SalesOrderHeader" />
<EntitySet Name="SalesOrderHeaderSalesReason" EntityType="AdventureWorks.SalesOrderHeaderSalesReason" />
<EntitySet Name="SalesPerson" EntityType="AdventureWorks.SalesPerson" />
<EntitySet Name="SalesPersonQuotaHistory" EntityType="AdventureWorks.SalesPersonQuotaHistory" />
<EntitySet Name="SalesReason" EntityType="AdventureWorks.SalesReason" />
<EntitySet Name="SalesTaxRate" EntityType="AdventureWorks.SalesTaxRate" />
<EntitySet Name="SalesTerritory" EntityType="AdventureWorks.SalesTerritory" />
<EntitySet Name="SalesTerritoryHistory" EntityType="AdventureWorks.SalesTerritoryHistory" />
<EntitySet Name="ShoppingCartItem" EntityType="AdventureWorks.ShoppingCartItem" />
<EntitySet Name="SpecialOffer" EntityType="AdventureWorks.SpecialOffer" />
<EntitySet Name="SpecialOfferProduct" EntityType="AdventureWorks.SpecialOfferProduct" />
<EntitySet Name="Store" EntityType="AdventureWorks.Store" />
<EntitySet Name="StoreContact" EntityType="AdventureWorks.StoreContact" />
<EntitySet Name="vEmployee" EntityType="AdventureWorks.vEmployee" />
<EntitySet Name="vEmployeeDepartment" EntityType="AdventureWorks.vEmployeeDepartment" />
<EntitySet Name="vEmployeeDepartmentHistory" EntityType="AdventureWorks.vEmployeeDepartmentHistory" />
<EntitySet Name="vJobCandidate" EntityType="AdventureWorks.vJobCandidate" />
<EntitySet Name="vJobCandidateEducation" EntityType="AdventureWorks.vJobCandidateEducation" />
<EntitySet Name="vJobCandidateEmployment" EntityType="AdventureWorks.vJobCandidateEmployment" />
<EntitySet Name="vAdditionalContactInfo" EntityType="AdventureWorks.vAdditionalContactInfo" />
<EntitySet Name="vStateProvinceCountryRegion" EntityType="AdventureWorks.vStateProvinceCountryRegion" />
<EntitySet Name="vProductAndDescription" EntityType="AdventureWorks.vProductAndDescription" />
<EntitySet Name="vProductModelCatalogDescription" EntityType="AdventureWorks.vProductModelCatalogDescription" />
<EntitySet Name="vProductModelInstructions" EntityType="AdventureWorks.vProductModelInstructions" />
<EntitySet Name="vVendor" EntityType="AdventureWorks.vVendor" />
<EntitySet Name="vIndividualCustomer" EntityType="AdventureWorks.vIndividualCustomer" />
<EntitySet Name="vIndividualDemographics" EntityType="AdventureWorks.vIndividualDemographics" />
<EntitySet Name="vSalesPerson" EntityType="AdventureWorks.vSalesPerson" />
<EntitySet Name="vSalesPersonSalesByFiscalYears" EntityType="AdventureWorks.vSalesPersonSalesByFiscalYears" />
<EntitySet Name="vStoreWithDemographics" EntityType="AdventureWorks.vStoreWithDemographics" />
<AssociationSet Name="FK_EmployeeDepartmentHistory_Department_DepartmentID" Association="AdventureWorks.FK_EmployeeDepartmentHistory_Department_DepartmentID">
<End Role="Department" EntitySet="Department" />
<End Role="EmployeeDepartmentHistory" EntitySet="EmployeeDepartmentHistory" />
</AssociationSet>
<AssociationSet Name="FK_Employee_Contact_ContactID" Association="AdventureWorks.FK_Employee_Contact_ContactID">
<End Role="Contact" EntitySet="Contact" />
<End Role="Employee" EntitySet="Employee" />
</AssociationSet>
<AssociationSet Name="FK_Employee_Employee_ManagerID" Association="AdventureWorks.FK_Employee_Employee_ManagerID">
<End Role="Employee" EntitySet="Employee" />
<End Role="Employee1" EntitySet="Employee" />
</AssociationSet>
<AssociationSet Name="FK_EmployeeAddress_Employee_EmployeeID" Association="AdventureWorks.FK_EmployeeAddress_Employee_EmployeeID">
<End Role="Employee" EntitySet="Employee" />
<End Role="EmployeeAddress" EntitySet="EmployeeAddress" />
</AssociationSet>
<AssociationSet Name="FK_EmployeeDepartmentHistory_Employee_EmployeeID" Association="AdventureWorks.FK_EmployeeDepartmentHistory_Employee_EmployeeID">
<End Role="Employee" EntitySet="Employee" />
<End Role="EmployeeDepartmentHistory" EntitySet="EmployeeDepartmentHistory" />
</AssociationSet>
<AssociationSet Name="FK_EmployeePayHistory_Employee_EmployeeID" Association="AdventureWorks.FK_EmployeePayHistory_Employee_EmployeeID">
<End Role="Employee" EntitySet="Employee" />
<End Role="EmployeePayHistory" EntitySet="EmployeePayHistory" />
</AssociationSet>
<AssociationSet Name="FK_JobCandidate_Employee_EmployeeID" Association="AdventureWorks.FK_JobCandidate_Employee_EmployeeID">
<End Role="Employee" EntitySet="Employee" />
<End Role="JobCandidate" EntitySet="JobCandidate" />
</AssociationSet>
<AssociationSet Name="FK_PurchaseOrderHeader_Employee_EmployeeID" Association="AdventureWorks.FK_PurchaseOrderHeader_Employee_EmployeeID">
<End Role="Employee" EntitySet="Employee" />
<End Role="PurchaseOrderHeader" EntitySet="PurchaseOrderHeader" />
</AssociationSet>
<AssociationSet Name="FK_SalesPerson_Employee_SalesPersonID" Association="AdventureWorks.FK_SalesPerson_Employee_SalesPersonID">
<End Role="Employee" EntitySet="Employee" />
<End Role="SalesPerson" EntitySet="SalesPerson" />
</AssociationSet>
<AssociationSet Name="FK_EmployeeAddress_Address_AddressID" Association="AdventureWorks.FK_EmployeeAddress_Address_AddressID">
<End Role="Address" EntitySet="Address" />
<End Role="EmployeeAddress" EntitySet="EmployeeAddress" />
</AssociationSet>
<AssociationSet Name="FK_EmployeeDepartmentHistory_Shift_ShiftID" Association="AdventureWorks.FK_EmployeeDepartmentHistory_Shift_ShiftID">
<End Role="Shift" EntitySet="Shift" />
<End Role="EmployeeDepartmentHistory" EntitySet="EmployeeDepartmentHistory" />
</AssociationSet>
<AssociationSet Name="FK_Address_StateProvince_StateProvinceID" Association="AdventureWorks.FK_Address_StateProvince_StateProvinceID">
<End Role="StateProvince" EntitySet="StateProvince" />
<End Role="Address" EntitySet="Address" />
</AssociationSet>
<AssociationSet Name="FK_CustomerAddress_Address_AddressID" Association="AdventureWorks.FK_CustomerAddress_Address_AddressID">
<End Role="Address" EntitySet="Address" />
<End Role="CustomerAddress" EntitySet="CustomerAddress" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderHeader_Address_BillToAddressID" Association="AdventureWorks.FK_SalesOrderHeader_Address_BillToAddressID">
<End Role="Address" EntitySet="Address" />
<End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderHeader_Address_ShipToAddressID" Association="AdventureWorks.FK_SalesOrderHeader_Address_ShipToAddressID">
<End Role="Address" EntitySet="Address" />
<End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
</AssociationSet>
<AssociationSet Name="FK_VendorAddress_Address_AddressID" Association="AdventureWorks.FK_VendorAddress_Address_AddressID">
<End Role="Address" EntitySet="Address" />
<End Role="VendorAddress" EntitySet="VendorAddress" />
</AssociationSet>
<AssociationSet Name="FK_CustomerAddress_AddressType_AddressTypeID" Association="AdventureWorks.FK_CustomerAddress_AddressType_AddressTypeID">
<End Role="AddressType" EntitySet="AddressType" />
<End Role="CustomerAddress" EntitySet="CustomerAddress" />
</AssociationSet>
<AssociationSet Name="FK_VendorAddress_AddressType_AddressTypeID" Association="AdventureWorks.FK_VendorAddress_AddressType_AddressTypeID">
<End Role="AddressType" EntitySet="AddressType" />
<End Role="VendorAddress" EntitySet="VendorAddress" />
</AssociationSet>
<AssociationSet Name="FK_ContactCreditCard_Contact_ContactID" Association="AdventureWorks.FK_ContactCreditCard_Contact_ContactID">
<End Role="Contact" EntitySet="Contact" />
<End Role="ContactCreditCard" EntitySet="ContactCreditCard" />
</AssociationSet>
<AssociationSet Name="FK_Individual_Contact_ContactID" Association="AdventureWorks.FK_Individual_Contact_ContactID">
<End Role="Contact" EntitySet="Contact" />
<End Role="Individual" EntitySet="Individual" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderHeader_Contact_ContactID" Association="AdventureWorks.FK_SalesOrderHeader_Contact_ContactID">
<End Role="Contact" EntitySet="Contact" />
<End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
</AssociationSet>
<AssociationSet Name="FK_StoreContact_Contact_ContactID" Association="AdventureWorks.FK_StoreContact_Contact_ContactID">
<End Role="Contact" EntitySet="Contact" />
<End Role="StoreContact" EntitySet="StoreContact" />
</AssociationSet>
<AssociationSet Name="FK_VendorContact_Contact_ContactID" Association="AdventureWorks.FK_VendorContact_Contact_ContactID">
<End Role="Contact" EntitySet="Contact" />
<End Role="VendorContact" EntitySet="VendorContact" />
</AssociationSet>
<AssociationSet Name="FK_StoreContact_ContactType_ContactTypeID" Association="AdventureWorks.FK_StoreContact_ContactType_ContactTypeID">
<End Role="ContactType" EntitySet="ContactType" />
<End Role="StoreContact" EntitySet="StoreContact" />
</AssociationSet>
<AssociationSet Name="FK_VendorContact_ContactType_ContactTypeID" Association="AdventureWorks.FK_VendorContact_ContactType_ContactTypeID">
<End Role="ContactType" EntitySet="ContactType" />
<End Role="VendorContact" EntitySet="VendorContact" />
</AssociationSet>
<AssociationSet Name="FK_CountryRegionCurrency_CountryRegion_CountryRegionCode" Association="AdventureWorks.FK_CountryRegionCurrency_CountryRegion_CountryRegionCode">
<End Role="CountryRegion" EntitySet="CountryRegion" />
<End Role="CountryRegionCurrency" EntitySet="CountryRegionCurrency" />
</AssociationSet>
<AssociationSet Name="FK_StateProvince_CountryRegion_CountryRegionCode" Association="AdventureWorks.FK_StateProvince_CountryRegion_CountryRegionCode">
<End Role="CountryRegion" EntitySet="CountryRegion" />
<End Role="StateProvince" EntitySet="StateProvince" />
</AssociationSet>
<AssociationSet Name="FK_SalesTaxRate_StateProvince_StateProvinceID" Association="AdventureWorks.FK_SalesTaxRate_StateProvince_StateProvinceID">
<End Role="StateProvince" EntitySet="StateProvince" />
<End Role="SalesTaxRate" EntitySet="SalesTaxRate" />
</AssociationSet>
<AssociationSet Name="FK_StateProvince_SalesTerritory_TerritoryID" Association="AdventureWorks.FK_StateProvince_SalesTerritory_TerritoryID">
<End Role="SalesTerritory" EntitySet="SalesTerritory" />
<End Role="StateProvince" EntitySet="StateProvince" />
</AssociationSet>
<AssociationSet Name="FK_BillOfMaterials_Product_ComponentID" Association="AdventureWorks.FK_BillOfMaterials_Product_ComponentID">
<End Role="Product" EntitySet="Product" />
<End Role="BillOfMaterials" EntitySet="BillOfMaterials" />
</AssociationSet>
<AssociationSet Name="FK_BillOfMaterials_Product_ProductAssemblyID" Association="AdventureWorks.FK_BillOfMaterials_Product_ProductAssemblyID">
<End Role="Product" EntitySet="Product" />
<End Role="BillOfMaterials" EntitySet="BillOfMaterials" />
</AssociationSet>
<AssociationSet Name="FK_BillOfMaterials_UnitMeasure_UnitMeasureCode" Association="AdventureWorks.FK_BillOfMaterials_UnitMeasure_UnitMeasureCode">
<End Role="UnitMeasure" EntitySet="UnitMeasure" />
<End Role="BillOfMaterials" EntitySet="BillOfMaterials" />
</AssociationSet>
<AssociationSet Name="FK_ProductModelProductDescriptionCulture_Culture_CultureID" Association="AdventureWorks.FK_ProductModelProductDescriptionCulture_Culture_CultureID">
<End Role="Culture" EntitySet="Culture" />
<End Role="ProductModelProductDescriptionCulture" EntitySet="ProductModelProductDescriptionCulture" />
</AssociationSet>
<AssociationSet Name="FK_ProductDocument_Document_DocumentID" Association="AdventureWorks.FK_ProductDocument_Document_DocumentID">
<End Role="Document" EntitySet="Document" />
<End Role="ProductDocument" EntitySet="ProductDocument" />
</AssociationSet>
<AssociationSet Name="FK_ProductModelIllustration_Illustration_IllustrationID" Association="AdventureWorks.FK_ProductModelIllustration_Illustration_IllustrationID">
<End Role="Illustration" EntitySet="Illustration" />
<End Role="ProductModelIllustration" EntitySet="ProductModelIllustration" />
</AssociationSet>
<AssociationSet Name="FK_ProductInventory_Location_LocationID" Association="AdventureWorks.FK_ProductInventory_Location_LocationID">
<End Role="Location" EntitySet="Location" />
<End Role="ProductInventory" EntitySet="ProductInventory" />
</AssociationSet>
<AssociationSet Name="FK_WorkOrderRouting_Location_LocationID" Association="AdventureWorks.FK_WorkOrderRouting_Location_LocationID">
<End Role="Location" EntitySet="Location" />
<End Role="WorkOrderRouting" EntitySet="WorkOrderRouting" />
</AssociationSet>
<AssociationSet Name="FK_Product_ProductModel_ProductModelID" Association="AdventureWorks.FK_Product_ProductModel_ProductModelID">
<End Role="ProductModel" EntitySet="ProductModel" />
<End Role="Product" EntitySet="Product" />
</AssociationSet>
<AssociationSet Name="FK_Product_ProductSubcategory_ProductSubcategoryID" Association="AdventureWorks.FK_Product_ProductSubcategory_ProductSubcategoryID">
<End Role="ProductSubcategory" EntitySet="ProductSubcategory" />
<End Role="Product" EntitySet="Product" />
</AssociationSet>
<AssociationSet Name="FK_Product_UnitMeasure_SizeUnitMeasureCode" Association="AdventureWorks.FK_Product_UnitMeasure_SizeUnitMeasureCode">
<End Role="UnitMeasure" EntitySet="UnitMeasure" />
<End Role="Product" EntitySet="Product" />
</AssociationSet>
<AssociationSet Name="FK_Product_UnitMeasure_WeightUnitMeasureCode" Association="AdventureWorks.FK_Product_UnitMeasure_WeightUnitMeasureCode">
<End Role="UnitMeasure" EntitySet="UnitMeasure" />
<End Role="Product" EntitySet="Product" />
</AssociationSet>
<AssociationSet Name="FK_ProductCostHistory_Product_ProductID" Association="AdventureWorks.FK_ProductCostHistory_Product_ProductID">
<End Role="Product" EntitySet="Product" />
<End Role="ProductCostHistory" EntitySet="ProductCostHistory" />
</AssociationSet>
<AssociationSet Name="FK_ProductDocument_Product_ProductID" Association="AdventureWorks.FK_ProductDocument_Product_ProductID">
<End Role="Product" EntitySet="Product" />
<End Role="ProductDocument" EntitySet="ProductDocument" />
</AssociationSet>
<AssociationSet Name="FK_ProductInventory_Product_ProductID" Association="AdventureWorks.FK_ProductInventory_Product_ProductID">
<End Role="Product" EntitySet="Product" />
<End Role="ProductInventory" EntitySet="ProductInventory" />
</AssociationSet>
<AssociationSet Name="FK_ProductListPriceHistory_Product_ProductID" Association="AdventureWorks.FK_ProductListPriceHistory_Product_ProductID">
<End Role="Product" EntitySet="Product" />
<End Role="ProductListPriceHistory" EntitySet="ProductListPriceHistory" />
</AssociationSet>
<AssociationSet Name="FK_ProductProductPhoto_Product_ProductID" Association="AdventureWorks.FK_ProductProductPhoto_Product_ProductID">
<End Role="Product" EntitySet="Product" />
<End Role="ProductProductPhoto" EntitySet="ProductProductPhoto" />
</AssociationSet>
<AssociationSet Name="FK_ProductReview_Product_ProductID" Association="AdventureWorks.FK_ProductReview_Product_ProductID">
<End Role="Product" EntitySet="Product" />
<End Role="ProductReview" EntitySet="ProductReview" />
</AssociationSet>
<AssociationSet Name="FK_ProductVendor_Product_ProductID" Association="AdventureWorks.FK_ProductVendor_Product_ProductID">
<End Role="Product" EntitySet="Product" />
<End Role="ProductVendor" EntitySet="ProductVendor" />
</AssociationSet>
<AssociationSet Name="FK_PurchaseOrderDetail_Product_ProductID" Association="AdventureWorks.FK_PurchaseOrderDetail_Product_ProductID">
<End Role="Product" EntitySet="Product" />
<End Role="PurchaseOrderDetail" EntitySet="PurchaseOrderDetail" />
</AssociationSet>
<AssociationSet Name="FK_ShoppingCartItem_Product_ProductID" Association="AdventureWorks.FK_ShoppingCartItem_Product_ProductID">
<End Role="Product" EntitySet="Product" />
<End Role="ShoppingCartItem" EntitySet="ShoppingCartItem" />
</AssociationSet>
<AssociationSet Name="FK_SpecialOfferProduct_Product_ProductID" Association="AdventureWorks.FK_SpecialOfferProduct_Product_ProductID">
<End Role="Product" EntitySet="Product" />
<End Role="SpecialOfferProduct" EntitySet="SpecialOfferProduct" />
</AssociationSet>
<AssociationSet Name="FK_TransactionHistory_Product_ProductID" Association="AdventureWorks.FK_TransactionHistory_Product_ProductID">
<End Role="Product" EntitySet="Product" />
<End Role="TransactionHistory" EntitySet="TransactionHistory" />
</AssociationSet>
<AssociationSet Name="FK_WorkOrder_Product_ProductID" Association="AdventureWorks.FK_WorkOrder_Product_ProductID">
<End Role="Product" EntitySet="Product" />
<End Role="WorkOrder" EntitySet="WorkOrder" />
</AssociationSet>
<AssociationSet Name="FK_ProductSubcategory_ProductCategory_ProductCategoryID" Association="AdventureWorks.FK_ProductSubcategory_ProductCategory_ProductCategoryID">
<End Role="ProductCategory" EntitySet="ProductCategory" />
<End Role="ProductSubcategory" EntitySet="ProductSubcategory" />
</AssociationSet>
<AssociationSet Name="FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID" Association="AdventureWorks.FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID">
<End Role="ProductDescription" EntitySet="ProductDescription" />
<End Role="ProductModelProductDescriptionCulture" EntitySet="ProductModelProductDescriptionCulture" />
</AssociationSet>
<AssociationSet Name="FK_ProductModelIllustration_ProductModel_ProductModelID" Association="AdventureWorks.FK_ProductModelIllustration_ProductModel_ProductModelID">
<End Role="ProductModel" EntitySet="ProductModel" />
<End Role="ProductModelIllustration" EntitySet="ProductModelIllustration" />
</AssociationSet>
<AssociationSet Name="FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID" Association="AdventureWorks.FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID">
<End Role="ProductModel" EntitySet="ProductModel" />
<End Role="ProductModelProductDescriptionCulture" EntitySet="ProductModelProductDescriptionCulture" />
</AssociationSet>
<AssociationSet Name="FK_ProductProductPhoto_ProductPhoto_ProductPhotoID" Association="AdventureWorks.FK_ProductProductPhoto_ProductPhoto_ProductPhotoID">
<End Role="ProductPhoto" EntitySet="ProductPhoto" />
<End Role="ProductProductPhoto" EntitySet="ProductProductPhoto" />
</AssociationSet>
<AssociationSet Name="FK_WorkOrder_ScrapReason_ScrapReasonID" Association="AdventureWorks.FK_WorkOrder_ScrapReason_ScrapReasonID">
<End Role="ScrapReason" EntitySet="ScrapReason" />
<End Role="WorkOrder" EntitySet="WorkOrder" />
</AssociationSet>
<AssociationSet Name="FK_ProductVendor_UnitMeasure_UnitMeasureCode" Association="AdventureWorks.FK_ProductVendor_UnitMeasure_UnitMeasureCode">
<End Role="UnitMeasure" EntitySet="UnitMeasure" />
<End Role="ProductVendor" EntitySet="ProductVendor" />
</AssociationSet>
<AssociationSet Name="FK_WorkOrderRouting_WorkOrder_WorkOrderID" Association="AdventureWorks.FK_WorkOrderRouting_WorkOrder_WorkOrderID">
<End Role="WorkOrder" EntitySet="WorkOrder" />
<End Role="WorkOrderRouting" EntitySet="WorkOrderRouting" />
</AssociationSet>
<AssociationSet Name="FK_ProductVendor_Vendor_VendorID" Association="AdventureWorks.FK_ProductVendor_Vendor_VendorID">
<End Role="Vendor" EntitySet="Vendor" />
<End Role="ProductVendor" EntitySet="ProductVendor" />
</AssociationSet>
<AssociationSet Name="FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID" Association="AdventureWorks.FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID">
<End Role="PurchaseOrderHeader" EntitySet="PurchaseOrderHeader" />
<End Role="PurchaseOrderDetail" EntitySet="PurchaseOrderDetail" />
</AssociationSet>
<AssociationSet Name="FK_PurchaseOrderHeader_ShipMethod_ShipMethodID" Association="AdventureWorks.FK_PurchaseOrderHeader_ShipMethod_ShipMethodID">
<End Role="ShipMethod" EntitySet="ShipMethod" />
<End Role="PurchaseOrderHeader" EntitySet="PurchaseOrderHeader" />
</AssociationSet>
<AssociationSet Name="FK_PurchaseOrderHeader_Vendor_VendorID" Association="AdventureWorks.FK_PurchaseOrderHeader_Vendor_VendorID">
<End Role="Vendor" EntitySet="Vendor" />
<End Role="PurchaseOrderHeader" EntitySet="PurchaseOrderHeader" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderHeader_ShipMethod_ShipMethodID" Association="AdventureWorks.FK_SalesOrderHeader_ShipMethod_ShipMethodID">
<End Role="ShipMethod" EntitySet="ShipMethod" />
<End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
</AssociationSet>
<AssociationSet Name="FK_VendorAddress_Vendor_VendorID" Association="AdventureWorks.FK_VendorAddress_Vendor_VendorID">
<End Role="Vendor" EntitySet="Vendor" />
<End Role="VendorAddress" EntitySet="VendorAddress" />
</AssociationSet>
<AssociationSet Name="FK_VendorContact_Vendor_VendorID" Association="AdventureWorks.FK_VendorContact_Vendor_VendorID">
<End Role="Vendor" EntitySet="Vendor" />
<End Role="VendorContact" EntitySet="VendorContact" />
</AssociationSet>
<AssociationSet Name="FK_ContactCreditCard_CreditCard_CreditCardID" Association="AdventureWorks.FK_ContactCreditCard_CreditCard_CreditCardID">
<End Role="CreditCard" EntitySet="CreditCard" />
<End Role="ContactCreditCard" EntitySet="ContactCreditCard" />
</AssociationSet>
<AssociationSet Name="FK_CountryRegionCurrency_Currency_CurrencyCode" Association="AdventureWorks.FK_CountryRegionCurrency_Currency_CurrencyCode">
<End Role="Currency" EntitySet="Currency" />
<End Role="CountryRegionCurrency" EntitySet="CountryRegionCurrency" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderHeader_CreditCard_CreditCardID" Association="AdventureWorks.FK_SalesOrderHeader_CreditCard_CreditCardID">
<End Role="CreditCard" EntitySet="CreditCard" />
<End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
</AssociationSet>
<AssociationSet Name="FK_CurrencyRate_Currency_FromCurrencyCode" Association="AdventureWorks.FK_CurrencyRate_Currency_FromCurrencyCode">
<End Role="Currency" EntitySet="Currency" />
<End Role="CurrencyRate" EntitySet="CurrencyRate" />
</AssociationSet>
<AssociationSet Name="FK_CurrencyRate_Currency_ToCurrencyCode" Association="AdventureWorks.FK_CurrencyRate_Currency_ToCurrencyCode">
<End Role="Currency" EntitySet="Currency" />
<End Role="CurrencyRate" EntitySet="CurrencyRate" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderHeader_CurrencyRate_CurrencyRateID" Association="AdventureWorks.FK_SalesOrderHeader_CurrencyRate_CurrencyRateID">
<End Role="CurrencyRate" EntitySet="CurrencyRate" />
<End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
</AssociationSet>
<AssociationSet Name="FK_Customer_SalesTerritory_TerritoryID" Association="AdventureWorks.FK_Customer_SalesTerritory_TerritoryID">
<End Role="SalesTerritory" EntitySet="SalesTerritory" />
<End Role="Customer" EntitySet="Customer" />
</AssociationSet>
<AssociationSet Name="FK_CustomerAddress_Customer_CustomerID" Association="AdventureWorks.FK_CustomerAddress_Customer_CustomerID">
<End Role="Customer" EntitySet="Customer" />
<End Role="CustomerAddress" EntitySet="CustomerAddress" />
</AssociationSet>
<AssociationSet Name="FK_Individual_Customer_CustomerID" Association="AdventureWorks.FK_Individual_Customer_CustomerID">
<End Role="Customer" EntitySet="Customer" />
<End Role="Individual" EntitySet="Individual" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderHeader_Customer_CustomerID" Association="AdventureWorks.FK_SalesOrderHeader_Customer_CustomerID">
<End Role="Customer" EntitySet="Customer" />
<End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
</AssociationSet>
<AssociationSet Name="FK_Store_Customer_CustomerID" Association="AdventureWorks.FK_Store_Customer_CustomerID">
<End Role="Customer" EntitySet="Customer" />
<End Role="Store" EntitySet="Store" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID" Association="AdventureWorks.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID">
<End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
<End Role="SalesOrderDetail" EntitySet="SalesOrderDetail" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID" Association="AdventureWorks.FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID">
<End Role="SpecialOfferProduct" EntitySet="SpecialOfferProduct" />
<End Role="SalesOrderDetail" EntitySet="SalesOrderDetail" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderHeader_SalesPerson_SalesPersonID" Association="AdventureWorks.FK_SalesOrderHeader_SalesPerson_SalesPersonID">
<End Role="SalesPerson" EntitySet="SalesPerson" />
<End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderHeader_SalesTerritory_TerritoryID" Association="AdventureWorks.FK_SalesOrderHeader_SalesTerritory_TerritoryID">
<End Role="SalesTerritory" EntitySet="SalesTerritory" />
<End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID" Association="AdventureWorks.FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID">
<End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
<End Role="SalesOrderHeaderSalesReason" EntitySet="SalesOrderHeaderSalesReason" />
</AssociationSet>
<AssociationSet Name="FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID" Association="AdventureWorks.FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID">
<End Role="SalesReason" EntitySet="SalesReason" />
<End Role="SalesOrderHeaderSalesReason" EntitySet="SalesOrderHeaderSalesReason" />
</AssociationSet>
<AssociationSet Name="FK_SalesPerson_SalesTerritory_TerritoryID" Association="AdventureWorks.FK_SalesPerson_SalesTerritory_TerritoryID">
<End Role="SalesTerritory" EntitySet="SalesTerritory" />
<End Role="SalesPerson" EntitySet="SalesPerson" />
</AssociationSet>
<AssociationSet Name="FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID" Association="AdventureWorks.FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID">
<End Role="SalesPerson" EntitySet="SalesPerson" />
<End Role="SalesPersonQuotaHistory" EntitySet="SalesPersonQuotaHistory" />
</AssociationSet>
<AssociationSet Name="FK_SalesTerritoryHistory_SalesPerson_SalesPersonID" Association="AdventureWorks.FK_SalesTerritoryHistory_SalesPerson_SalesPersonID">
<End Role="SalesPerson" EntitySet="SalesPerson" />
<End Role="SalesTerritoryHistory" EntitySet="SalesTerritoryHistory" />
</AssociationSet>
<AssociationSet Name="FK_Store_SalesPerson_SalesPersonID" Association="AdventureWorks.FK_Store_SalesPerson_SalesPersonID">
<End Role="SalesPerson" EntitySet="SalesPerson" />
<End Role="Store" EntitySet="Store" />
</AssociationSet>
<AssociationSet Name="FK_SalesTerritoryHistory_SalesTerritory_TerritoryID" Association="AdventureWorks.FK_SalesTerritoryHistory_SalesTerritory_TerritoryID">
<End Role="SalesTerritory" EntitySet="SalesTerritory" />
<End Role="SalesTerritoryHistory" EntitySet="SalesTerritoryHistory" />
</AssociationSet>
<AssociationSet Name="FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID" Association="AdventureWorks.FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID">
<End Role="SpecialOffer" EntitySet="SpecialOffer" />
<End Role="SpecialOfferProduct" EntitySet="SpecialOfferProduct" />
</AssociationSet>
<AssociationSet Name="FK_StoreContact_Store_CustomerID" Association="AdventureWorks.FK_StoreContact_Store_CustomerID">
<End Role="Store" EntitySet="Store" />
<End Role="StoreContact" EntitySet="StoreContact" />
</AssociationSet>
</EntityContainer>
<EntityType Name="AWBuildVersion">
<Key>
<PropertyRef Name="SystemInformationID" />
</Key>
<Property Name="SystemInformationID" Type="Byte" Nullable="false" />
<Property Name="Database_Version" Type="String" Nullable="false" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="VersionDate" Type="DateTime" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
</EntityType>
<EntityType Name="DatabaseLog">
<Key>
<PropertyRef Name="DatabaseLogID" />
</Key>
<Property Name="DatabaseLogID" Type="Int32" Nullable="false" />
<Property Name="PostTime" Type="DateTime" Nullable="false" />
<Property Name="DatabaseUser" Type="String" Nullable="false" MaxLength="128" Unicode="true" FixedLength="false" />
<Property Name="Event" Type="String" Nullable="false" MaxLength="128" Unicode="true" FixedLength="false" />
<Property Name="Schema" Type="String" MaxLength="128" Unicode="true" FixedLength="false" />
<Property Name="Object" Type="String" MaxLength="128" Unicode="true" FixedLength="false" />
<Property Name="TSQL" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="XmlEvent" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
</EntityType>
<EntityType Name="ErrorLog">
<Key>
<PropertyRef Name="ErrorLogID" />
</Key>
<Property Name="ErrorLogID" Type="Int32" Nullable="false" />
<Property Name="ErrorTime" Type="DateTime" Nullable="false" />
<Property Name="UserName" Type="String" Nullable="false" MaxLength="128" Unicode="true" FixedLength="false" />
<Property Name="ErrorNumber" Type="Int32" Nullable="false" />
<Property Name="ErrorSeverity" Type="Int32" />
<Property Name="ErrorState" Type="Int32" />
<Property Name="ErrorProcedure" Type="String" MaxLength="126" Unicode="true" FixedLength="false" />
<Property Name="ErrorLine" Type="Int32" />
<Property Name="ErrorMessage" Type="String" Nullable="false" MaxLength="4000" Unicode="true" FixedLength="false" />
</EntityType>
<EntityType Name="Department">
<Key>
<PropertyRef Name="DepartmentID" />
</Key>
<Property Name="DepartmentID" Type="Int16" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="GroupName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="EmployeeDepartmentHistory" Relationship="AdventureWorks.FK_EmployeeDepartmentHistory_Department_DepartmentID" FromRole="Department" ToRole="EmployeeDepartmentHistory" />
</EntityType>
<EntityType Name="Employee">
<Key>
<PropertyRef Name="EmployeeID" />
</Key>
<Property Name="EmployeeID" Type="Int32" Nullable="false" />
<Property Name="NationalIDNumber" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="LoginID" Type="String" Nullable="false" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="Title" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="BirthDate" Type="DateTime" Nullable="false" />
<Property Name="MaritalStatus" Type="String" Nullable="false" MaxLength="1" Unicode="true" FixedLength="true" />
<Property Name="Gender" Type="String" Nullable="false" MaxLength="1" Unicode="true" FixedLength="true" />
<Property Name="HireDate" Type="DateTime" Nullable="false" />
<Property Name="SalariedFlag" Type="Boolean" Nullable="false" />
<Property Name="VacationHours" Type="Int16" Nullable="false" />
<Property Name="SickLeaveHours" Type="Int16" Nullable="false" />
<Property Name="CurrentFlag" Type="Boolean" Nullable="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Contact" Relationship="AdventureWorks.FK_Employee_Contact_ContactID" FromRole="Employee" ToRole="Contact" />
<NavigationProperty Name="Employee1" Relationship="AdventureWorks.FK_Employee_Employee_ManagerID" FromRole="Employee" ToRole="Employee1" />
<NavigationProperty Name="Employee2" Relationship="AdventureWorks.FK_Employee_Employee_ManagerID" FromRole="Employee1" ToRole="Employee" />
<NavigationProperty Name="EmployeeAddress" Relationship="AdventureWorks.FK_EmployeeAddress_Employee_EmployeeID" FromRole="Employee" ToRole="EmployeeAddress" />
<NavigationProperty Name="EmployeeDepartmentHistory" Relationship="AdventureWorks.FK_EmployeeDepartmentHistory_Employee_EmployeeID" FromRole="Employee" ToRole="EmployeeDepartmentHistory" />
<NavigationProperty Name="EmployeePayHistory" Relationship="AdventureWorks.FK_EmployeePayHistory_Employee_EmployeeID" FromRole="Employee" ToRole="EmployeePayHistory" />
<NavigationProperty Name="JobCandidate" Relationship="AdventureWorks.FK_JobCandidate_Employee_EmployeeID" FromRole="Employee" ToRole="JobCandidate" />
<NavigationProperty Name="PurchaseOrderHeader" Relationship="AdventureWorks.FK_PurchaseOrderHeader_Employee_EmployeeID" FromRole="Employee" ToRole="PurchaseOrderHeader" />
<NavigationProperty Name="SalesPerson" Relationship="AdventureWorks.FK_SalesPerson_Employee_SalesPersonID" FromRole="Employee" ToRole="SalesPerson" />
</EntityType>
<EntityType Name="EmployeeAddress">
<Key>
<PropertyRef Name="EmployeeID" />
<PropertyRef Name="AddressID" />
</Key>
<Property Name="EmployeeID" Type="Int32" Nullable="false" />
<Property Name="AddressID" Type="Int32" Nullable="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Employee" Relationship="AdventureWorks.FK_EmployeeAddress_Employee_EmployeeID" FromRole="EmployeeAddress" ToRole="Employee" />
<NavigationProperty Name="Address" Relationship="AdventureWorks.FK_EmployeeAddress_Address_AddressID" FromRole="EmployeeAddress" ToRole="Address" />
</EntityType>
<EntityType Name="EmployeeDepartmentHistory">
<Key>
<PropertyRef Name="EmployeeID" />
<PropertyRef Name="DepartmentID" />
<PropertyRef Name="ShiftID" />
<PropertyRef Name="StartDate" />
</Key>
<Property Name="EmployeeID" Type="Int32" Nullable="false" />
<Property Name="DepartmentID" Type="Int16" Nullable="false" />
<Property Name="ShiftID" Type="Byte" Nullable="false" />
<Property Name="StartDate" Type="DateTime" Nullable="false" />
<Property Name="EndDate" Type="DateTime" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Department" Relationship="AdventureWorks.FK_EmployeeDepartmentHistory_Department_DepartmentID" FromRole="EmployeeDepartmentHistory" ToRole="Department" />
<NavigationProperty Name="Employee" Relationship="AdventureWorks.FK_EmployeeDepartmentHistory_Employee_EmployeeID" FromRole="EmployeeDepartmentHistory" ToRole="Employee" />
<NavigationProperty Name="Shift" Relationship="AdventureWorks.FK_EmployeeDepartmentHistory_Shift_ShiftID" FromRole="EmployeeDepartmentHistory" ToRole="Shift" />
</EntityType>
<EntityType Name="EmployeePayHistory">
<Key>
<PropertyRef Name="EmployeeID" />
<PropertyRef Name="RateChangeDate" />
</Key>
<Property Name="EmployeeID" Type="Int32" Nullable="false" />
<Property Name="RateChangeDate" Type="DateTime" Nullable="false" />
<Property Name="Rate" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="PayFrequency" Type="Byte" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Employee" Relationship="AdventureWorks.FK_EmployeePayHistory_Employee_EmployeeID" FromRole="EmployeePayHistory" ToRole="Employee" />
</EntityType>
<EntityType Name="JobCandidate">
<Key>
<PropertyRef Name="JobCandidateID" />
</Key>
<Property Name="JobCandidateID" Type="Int32" Nullable="false" />
<Property Name="Resume" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Employee" Relationship="AdventureWorks.FK_JobCandidate_Employee_EmployeeID" FromRole="JobCandidate" ToRole="Employee" />
</EntityType>
<EntityType Name="SalesEmployee">
<Key>
<PropertyRef Name="ID" />
</Key>
<Property Name="ID" Type="Int32" Nullable="false" />
<Property Name="ExpenseAcctNumber" Type="Guid" />
<Property Name="CarLicenseNumber" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
</EntityType>
<EntityType Name="Shift">
<Key>
<PropertyRef Name="ShiftID" />
</Key>
<Property Name="ShiftID" Type="Byte" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="StartTime" Type="DateTime" Nullable="false" />
<Property Name="EndTime" Type="DateTime" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="EmployeeDepartmentHistory" Relationship="AdventureWorks.FK_EmployeeDepartmentHistory_Shift_ShiftID" FromRole="Shift" ToRole="EmployeeDepartmentHistory" />
</EntityType>
<EntityType Name="Address">
<Key>
<PropertyRef Name="AddressID" />
</Key>
<Property Name="AddressID" Type="Int32" Nullable="false" />
<Property Name="AddressLine1" Type="String" Nullable="false" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="AddressLine2" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="City" Type="String" Nullable="false" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="PostalCode" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="EmployeeAddress" Relationship="AdventureWorks.FK_EmployeeAddress_Address_AddressID" FromRole="Address" ToRole="EmployeeAddress" />
<NavigationProperty Name="StateProvince" Relationship="AdventureWorks.FK_Address_StateProvince_StateProvinceID" FromRole="Address" ToRole="StateProvince" />
<NavigationProperty Name="CustomerAddress" Relationship="AdventureWorks.FK_CustomerAddress_Address_AddressID" FromRole="Address" ToRole="CustomerAddress" />
<NavigationProperty Name="SalesOrderHeader" Relationship="AdventureWorks.FK_SalesOrderHeader_Address_BillToAddressID" FromRole="Address" ToRole="SalesOrderHeader" />
<NavigationProperty Name="SalesOrderHeader1" Relationship="AdventureWorks.FK_SalesOrderHeader_Address_ShipToAddressID" FromRole="Address" ToRole="SalesOrderHeader" />
<NavigationProperty Name="VendorAddress" Relationship="AdventureWorks.FK_VendorAddress_Address_AddressID" FromRole="Address" ToRole="VendorAddress" />
</EntityType>
<EntityType Name="AddressType">
<Key>
<PropertyRef Name="AddressTypeID" />
</Key>
<Property Name="AddressTypeID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="CustomerAddress" Relationship="AdventureWorks.FK_CustomerAddress_AddressType_AddressTypeID" FromRole="AddressType" ToRole="CustomerAddress" />
<NavigationProperty Name="VendorAddress" Relationship="AdventureWorks.FK_VendorAddress_AddressType_AddressTypeID" FromRole="AddressType" ToRole="VendorAddress" />
</EntityType>
<EntityType Name="Contact">
<Key>
<PropertyRef Name="ContactID" />
</Key>
<Property Name="ContactID" Type="Int32" Nullable="false" />
<Property Name="NameStyle" Type="Boolean" Nullable="false" />
<Property Name="Title" Type="String" MaxLength="8" Unicode="true" FixedLength="false" />
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="MiddleName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="LastName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Suffix" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="EmailAddress" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="EmailPromotion" Type="Int32" Nullable="false" />
<Property Name="Phone" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="PasswordHash" Type="String" Nullable="false" MaxLength="128" Unicode="false" FixedLength="false" />
<Property Name="PasswordSalt" Type="String" Nullable="false" MaxLength="10" Unicode="false" FixedLength="false" />
<Property Name="AdditionalContactInfo" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Employee" Relationship="AdventureWorks.FK_Employee_Contact_ContactID" FromRole="Contact" ToRole="Employee" />
<NavigationProperty Name="ContactCreditCard" Relationship="AdventureWorks.FK_ContactCreditCard_Contact_ContactID" FromRole="Contact" ToRole="ContactCreditCard" />
<NavigationProperty Name="Individual" Relationship="AdventureWorks.FK_Individual_Contact_ContactID" FromRole="Contact" ToRole="Individual" />
<NavigationProperty Name="SalesOrderHeader" Relationship="AdventureWorks.FK_SalesOrderHeader_Contact_ContactID" FromRole="Contact" ToRole="SalesOrderHeader" />
<NavigationProperty Name="StoreContact" Relationship="AdventureWorks.FK_StoreContact_Contact_ContactID" FromRole="Contact" ToRole="StoreContact" />
<NavigationProperty Name="VendorContact" Relationship="AdventureWorks.FK_VendorContact_Contact_ContactID" FromRole="Contact" ToRole="VendorContact" />
</EntityType>
<EntityType Name="ContactType">
<Key>
<PropertyRef Name="ContactTypeID" />
</Key>
<Property Name="ContactTypeID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="StoreContact" Relationship="AdventureWorks.FK_StoreContact_ContactType_ContactTypeID" FromRole="ContactType" ToRole="StoreContact" />
<NavigationProperty Name="VendorContact" Relationship="AdventureWorks.FK_VendorContact_ContactType_ContactTypeID" FromRole="ContactType" ToRole="VendorContact" />
</EntityType>
<EntityType Name="CountryRegion">
<Key>
<PropertyRef Name="CountryRegionCode" />
</Key>
<Property Name="CountryRegionCode" Type="String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="CountryRegionCurrency" Relationship="AdventureWorks.FK_CountryRegionCurrency_CountryRegion_CountryRegionCode" FromRole="CountryRegion" ToRole="CountryRegionCurrency" />
<NavigationProperty Name="StateProvince" Relationship="AdventureWorks.FK_StateProvince_CountryRegion_CountryRegionCode" FromRole="CountryRegion" ToRole="StateProvince" />
</EntityType>
<EntityType Name="StateProvince">
<Key>
<PropertyRef Name="StateProvinceID" />
</Key>
<Property Name="StateProvinceID" Type="Int32" Nullable="false" />
<Property Name="StateProvinceCode" Type="String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="true" />
<Property Name="IsOnlyStateProvinceFlag" Type="Boolean" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Address" Relationship="AdventureWorks.FK_Address_StateProvince_StateProvinceID" FromRole="StateProvince" ToRole="Address" />
<NavigationProperty Name="CountryRegion" Relationship="AdventureWorks.FK_StateProvince_CountryRegion_CountryRegionCode" FromRole="StateProvince" ToRole="CountryRegion" />
<NavigationProperty Name="SalesTaxRate" Relationship="AdventureWorks.FK_SalesTaxRate_StateProvince_StateProvinceID" FromRole="StateProvince" ToRole="SalesTaxRate" />
<NavigationProperty Name="SalesTerritory" Relationship="AdventureWorks.FK_StateProvince_SalesTerritory_TerritoryID" FromRole="StateProvince" ToRole="SalesTerritory" />
</EntityType>
<EntityType Name="BillOfMaterials">
<Key>
<PropertyRef Name="BillOfMaterialsID" />
</Key>
<Property Name="BillOfMaterialsID" Type="Int32" Nullable="false" />
<Property Name="StartDate" Type="DateTime" Nullable="false" />
<Property Name="EndDate" Type="DateTime" />
<Property Name="BOMLevel" Type="Int16" Nullable="false" />
<Property Name="PerAssemblyQty" Type="Decimal" Nullable="false" Precision="8" Scale="2" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_BillOfMaterials_Product_ComponentID" FromRole="BillOfMaterials" ToRole="Product" />
<NavigationProperty Name="Product1" Relationship="AdventureWorks.FK_BillOfMaterials_Product_ProductAssemblyID" FromRole="BillOfMaterials" ToRole="Product" />
<NavigationProperty Name="UnitMeasure" Relationship="AdventureWorks.FK_BillOfMaterials_UnitMeasure_UnitMeasureCode" FromRole="BillOfMaterials" ToRole="UnitMeasure" />
</EntityType>
<EntityType Name="Culture">
<Key>
<PropertyRef Name="CultureID" />
</Key>
<Property Name="CultureID" Type="String" Nullable="false" MaxLength="6" Unicode="true" FixedLength="true" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="ProductModelProductDescriptionCulture" Relationship="AdventureWorks.FK_ProductModelProductDescriptionCulture_Culture_CultureID" FromRole="Culture" ToRole="ProductModelProductDescriptionCulture" />
</EntityType>
<EntityType Name="Document">
<Key>
<PropertyRef Name="DocumentID" />
</Key>
<Property Name="DocumentID" Type="Int32" Nullable="false" />
<Property Name="Title" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="FileName" Type="String" Nullable="false" MaxLength="400" Unicode="true" FixedLength="false" />
<Property Name="FileExtension" Type="String" Nullable="false" MaxLength="8" Unicode="true" FixedLength="false" />
<Property Name="Revision" Type="String" Nullable="false" MaxLength="5" Unicode="true" FixedLength="true" />
<Property Name="ChangeNumber" Type="Int32" Nullable="false" />
<Property Name="Status" Type="Byte" Nullable="false" />
<Property Name="DocumentSummary" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Document1" Type="Binary" MaxLength="Max" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="ProductDocument" Relationship="AdventureWorks.FK_ProductDocument_Document_DocumentID" FromRole="Document" ToRole="ProductDocument" />
</EntityType>
<EntityType Name="Illustration">
<Key>
<PropertyRef Name="IllustrationID" />
</Key>
<Property Name="IllustrationID" Type="Int32" Nullable="false" />
<Property Name="Diagram" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="ProductModelIllustration" Relationship="AdventureWorks.FK_ProductModelIllustration_Illustration_IllustrationID" FromRole="Illustration" ToRole="ProductModelIllustration" />
</EntityType>
<EntityType Name="Location">
<Key>
<PropertyRef Name="LocationID" />
</Key>
<Property Name="LocationID" Type="Int16" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="CostRate" Type="Decimal" Nullable="false" Precision="10" Scale="4" />
<Property Name="Availability" Type="Decimal" Nullable="false" Precision="8" Scale="2" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="ProductInventory" Relationship="AdventureWorks.FK_ProductInventory_Location_LocationID" FromRole="Location" ToRole="ProductInventory" />
<NavigationProperty Name="WorkOrderRouting" Relationship="AdventureWorks.FK_WorkOrderRouting_Location_LocationID" FromRole="Location" ToRole="WorkOrderRouting" />
</EntityType>
<EntityType Name="Product">
<Key>
<PropertyRef Name="ProductID" />
</Key>
<Property Name="ProductID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ProductNumber" Type="String" Nullable="false" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="MakeFlag" Type="Boolean" Nullable="false" />
<Property Name="FinishedGoodsFlag" Type="Boolean" Nullable="false" />
<Property Name="Color" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="SafetyStockLevel" Type="Int16" Nullable="false" />
<Property Name="ReorderPoint" Type="Int16" Nullable="false" />
<Property Name="StandardCost" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="ListPrice" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="Size" Type="String" MaxLength="5" Unicode="true" FixedLength="false" />
<Property Name="Weight" Type="Decimal" Precision="8" Scale="2" />
<Property Name="DaysToManufacture" Type="Int32" Nullable="false" />
<Property Name="ProductLine" Type="String" MaxLength="2" Unicode="true" FixedLength="true" />
<Property Name="Class" Type="String" MaxLength="2" Unicode="true" FixedLength="true" />
<Property Name="Style" Type="String" MaxLength="2" Unicode="true" FixedLength="true" />
<Property Name="SellStartDate" Type="DateTime" Nullable="false" />
<Property Name="SellEndDate" Type="DateTime" />
<Property Name="DiscontinuedDate" Type="DateTime" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="BillOfMaterials" Relationship="AdventureWorks.FK_BillOfMaterials_Product_ComponentID" FromRole="Product" ToRole="BillOfMaterials" />
<NavigationProperty Name="BillOfMaterials1" Relationship="AdventureWorks.FK_BillOfMaterials_Product_ProductAssemblyID" FromRole="Product" ToRole="BillOfMaterials" />
<NavigationProperty Name="ProductModel" Relationship="AdventureWorks.FK_Product_ProductModel_ProductModelID" FromRole="Product" ToRole="ProductModel" />
<NavigationProperty Name="ProductSubcategory" Relationship="AdventureWorks.FK_Product_ProductSubcategory_ProductSubcategoryID" FromRole="Product" ToRole="ProductSubcategory" />
<NavigationProperty Name="UnitMeasure" Relationship="AdventureWorks.FK_Product_UnitMeasure_SizeUnitMeasureCode" FromRole="Product" ToRole="UnitMeasure" />
<NavigationProperty Name="UnitMeasure1" Relationship="AdventureWorks.FK_Product_UnitMeasure_WeightUnitMeasureCode" FromRole="Product" ToRole="UnitMeasure" />
<NavigationProperty Name="ProductCostHistory" Relationship="AdventureWorks.FK_ProductCostHistory_Product_ProductID" FromRole="Product" ToRole="ProductCostHistory" />
<NavigationProperty Name="ProductDocument" Relationship="AdventureWorks.FK_ProductDocument_Product_ProductID" FromRole="Product" ToRole="ProductDocument" />
<NavigationProperty Name="ProductInventory" Relationship="AdventureWorks.FK_ProductInventory_Product_ProductID" FromRole="Product" ToRole="ProductInventory" />
<NavigationProperty Name="ProductListPriceHistory" Relationship="AdventureWorks.FK_ProductListPriceHistory_Product_ProductID" FromRole="Product" ToRole="ProductListPriceHistory" />
<NavigationProperty Name="ProductProductPhoto" Relationship="AdventureWorks.FK_ProductProductPhoto_Product_ProductID" FromRole="Product" ToRole="ProductProductPhoto" />
<NavigationProperty Name="ProductReview" Relationship="AdventureWorks.FK_ProductReview_Product_ProductID" FromRole="Product" ToRole="ProductReview" />
<NavigationProperty Name="ProductVendor" Relationship="AdventureWorks.FK_ProductVendor_Product_ProductID" FromRole="Product" ToRole="ProductVendor" />
<NavigationProperty Name="PurchaseOrderDetail" Relationship="AdventureWorks.FK_PurchaseOrderDetail_Product_ProductID" FromRole="Product" ToRole="PurchaseOrderDetail" />
<NavigationProperty Name="ShoppingCartItem" Relationship="AdventureWorks.FK_ShoppingCartItem_Product_ProductID" FromRole="Product" ToRole="ShoppingCartItem" />
<NavigationProperty Name="SpecialOfferProduct" Relationship="AdventureWorks.FK_SpecialOfferProduct_Product_ProductID" FromRole="Product" ToRole="SpecialOfferProduct" />
<NavigationProperty Name="TransactionHistory" Relationship="AdventureWorks.FK_TransactionHistory_Product_ProductID" FromRole="Product" ToRole="TransactionHistory" />
<NavigationProperty Name="WorkOrder" Relationship="AdventureWorks.FK_WorkOrder_Product_ProductID" FromRole="Product" ToRole="WorkOrder" />
</EntityType>
<EntityType Name="ProductCategory">
<Key>
<PropertyRef Name="ProductCategoryID" />
</Key>
<Property Name="ProductCategoryID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="ProductSubcategory" Relationship="AdventureWorks.FK_ProductSubcategory_ProductCategory_ProductCategoryID" FromRole="ProductCategory" ToRole="ProductSubcategory" />
</EntityType>
<EntityType Name="ProductCostHistory">
<Key>
<PropertyRef Name="ProductID" />
<PropertyRef Name="StartDate" />
</Key>
<Property Name="ProductID" Type="Int32" Nullable="false" />
<Property Name="StartDate" Type="DateTime" Nullable="false" />
<Property Name="EndDate" Type="DateTime" />
<Property Name="StandardCost" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_ProductCostHistory_Product_ProductID" FromRole="ProductCostHistory" ToRole="Product" />
</EntityType>
<EntityType Name="ProductDescription">
<Key>
<PropertyRef Name="ProductDescriptionID" />
</Key>
<Property Name="ProductDescriptionID" Type="Int32" Nullable="false" />
<Property Name="Description" Type="String" Nullable="false" MaxLength="400" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="ProductModelProductDescriptionCulture" Relationship="AdventureWorks.FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID" FromRole="ProductDescription" ToRole="ProductModelProductDescriptionCulture" />
</EntityType>
<EntityType Name="ProductDocument">
<Key>
<PropertyRef Name="ProductID" />
<PropertyRef Name="DocumentID" />
</Key>
<Property Name="ProductID" Type="Int32" Nullable="false" />
<Property Name="DocumentID" Type="Int32" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Document" Relationship="AdventureWorks.FK_ProductDocument_Document_DocumentID" FromRole="ProductDocument" ToRole="Document" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_ProductDocument_Product_ProductID" FromRole="ProductDocument" ToRole="Product" />
</EntityType>
<EntityType Name="ProductInventory">
<Key>
<PropertyRef Name="ProductID" />
<PropertyRef Name="LocationID" />
</Key>
<Property Name="ProductID" Type="Int32" Nullable="false" />
<Property Name="LocationID" Type="Int16" Nullable="false" />
<Property Name="Shelf" Type="String" Nullable="false" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="Bin" Type="Byte" Nullable="false" />
<Property Name="Quantity" Type="Int16" Nullable="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Location" Relationship="AdventureWorks.FK_ProductInventory_Location_LocationID" FromRole="ProductInventory" ToRole="Location" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_ProductInventory_Product_ProductID" FromRole="ProductInventory" ToRole="Product" />
</EntityType>
<EntityType Name="ProductListPriceHistory">
<Key>
<PropertyRef Name="ProductID" />
<PropertyRef Name="StartDate" />
</Key>
<Property Name="ProductID" Type="Int32" Nullable="false" />
<Property Name="StartDate" Type="DateTime" Nullable="false" />
<Property Name="EndDate" Type="DateTime" />
<Property Name="ListPrice" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_ProductListPriceHistory_Product_ProductID" FromRole="ProductListPriceHistory" ToRole="Product" />
</EntityType>
<EntityType Name="ProductModel">
<Key>
<PropertyRef Name="ProductModelID" />
</Key>
<Property Name="ProductModelID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="CatalogDescription" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Instructions" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_Product_ProductModel_ProductModelID" FromRole="ProductModel" ToRole="Product" />
<NavigationProperty Name="ProductModelIllustration" Relationship="AdventureWorks.FK_ProductModelIllustration_ProductModel_ProductModelID" FromRole="ProductModel" ToRole="ProductModelIllustration" />
<NavigationProperty Name="ProductModelProductDescriptionCulture" Relationship="AdventureWorks.FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID" FromRole="ProductModel" ToRole="ProductModelProductDescriptionCulture" />
</EntityType>
<EntityType Name="ProductModelIllustration">
<Key>
<PropertyRef Name="ProductModelID" />
<PropertyRef Name="IllustrationID" />
</Key>
<Property Name="ProductModelID" Type="Int32" Nullable="false" />
<Property Name="IllustrationID" Type="Int32" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Illustration" Relationship="AdventureWorks.FK_ProductModelIllustration_Illustration_IllustrationID" FromRole="ProductModelIllustration" ToRole="Illustration" />
<NavigationProperty Name="ProductModel" Relationship="AdventureWorks.FK_ProductModelIllustration_ProductModel_ProductModelID" FromRole="ProductModelIllustration" ToRole="ProductModel" />
</EntityType>
<EntityType Name="ProductModelProductDescriptionCulture">
<Key>
<PropertyRef Name="ProductModelID" />
<PropertyRef Name="ProductDescriptionID" />
<PropertyRef Name="CultureID" />
</Key>
<Property Name="ProductModelID" Type="Int32" Nullable="false" />
<Property Name="ProductDescriptionID" Type="Int32" Nullable="false" />
<Property Name="CultureID" Type="String" Nullable="false" MaxLength="6" Unicode="true" FixedLength="true" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Culture" Relationship="AdventureWorks.FK_ProductModelProductDescriptionCulture_Culture_CultureID" FromRole="ProductModelProductDescriptionCulture" ToRole="Culture" />
<NavigationProperty Name="ProductDescription" Relationship="AdventureWorks.FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID" FromRole="ProductModelProductDescriptionCulture" ToRole="ProductDescription" />
<NavigationProperty Name="ProductModel" Relationship="AdventureWorks.FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID" FromRole="ProductModelProductDescriptionCulture" ToRole="ProductModel" />
</EntityType>
<EntityType Name="ProductPhoto">
<Key>
<PropertyRef Name="ProductPhotoID" />
</Key>
<Property Name="ProductPhotoID" Type="Int32" Nullable="false" />
<Property Name="ThumbNailPhoto" Type="Binary" MaxLength="Max" FixedLength="false" />
<Property Name="ThumbnailPhotoFileName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="LargePhoto" Type="Binary" MaxLength="Max" FixedLength="false" />
<Property Name="LargePhotoFileName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="ProductProductPhoto" Relationship="AdventureWorks.FK_ProductProductPhoto_ProductPhoto_ProductPhotoID" FromRole="ProductPhoto" ToRole="ProductProductPhoto" />
</EntityType>
<EntityType Name="ProductProductPhoto">
<Key>
<PropertyRef Name="ProductID" />
<PropertyRef Name="ProductPhotoID" />
</Key>
<Property Name="ProductID" Type="Int32" Nullable="false" />
<Property Name="ProductPhotoID" Type="Int32" Nullable="false" />
<Property Name="Primary" Type="Boolean" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_ProductProductPhoto_Product_ProductID" FromRole="ProductProductPhoto" ToRole="Product" />
<NavigationProperty Name="ProductPhoto" Relationship="AdventureWorks.FK_ProductProductPhoto_ProductPhoto_ProductPhotoID" FromRole="ProductProductPhoto" ToRole="ProductPhoto" />
</EntityType>
<EntityType Name="ProductReview">
<Key>
<PropertyRef Name="ProductReviewID" />
</Key>
<Property Name="ProductReviewID" Type="Int32" Nullable="false" />
<Property Name="ReviewerName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ReviewDate" Type="DateTime" Nullable="false" />
<Property Name="EmailAddress" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Rating" Type="Int32" Nullable="false" />
<Property Name="Comments" Type="String" MaxLength="3850" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_ProductReview_Product_ProductID" FromRole="ProductReview" ToRole="Product" />
</EntityType>
<EntityType Name="ProductSubcategory">
<Key>
<PropertyRef Name="ProductSubcategoryID" />
</Key>
<Property Name="ProductSubcategoryID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_Product_ProductSubcategory_ProductSubcategoryID" FromRole="ProductSubcategory" ToRole="Product" />
<NavigationProperty Name="ProductCategory" Relationship="AdventureWorks.FK_ProductSubcategory_ProductCategory_ProductCategoryID" FromRole="ProductSubcategory" ToRole="ProductCategory" />
</EntityType>
<EntityType Name="ScrapReason">
<Key>
<PropertyRef Name="ScrapReasonID" />
</Key>
<Property Name="ScrapReasonID" Type="Int16" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="WorkOrder" Relationship="AdventureWorks.FK_WorkOrder_ScrapReason_ScrapReasonID" FromRole="ScrapReason" ToRole="WorkOrder" />
</EntityType>
<EntityType Name="TransactionHistory">
<Key>
<PropertyRef Name="TransactionID" />
</Key>
<Property Name="TransactionID" Type="Int32" Nullable="false" />
<Property Name="ReferenceOrderID" Type="Int32" Nullable="false" />
<Property Name="ReferenceOrderLineID" Type="Int32" Nullable="false" />
<Property Name="TransactionDate" Type="DateTime" Nullable="false" />
<Property Name="TransactionType" Type="String" Nullable="false" MaxLength="1" Unicode="true" FixedLength="true" />
<Property Name="Quantity" Type="Int32" Nullable="false" />
<Property Name="ActualCost" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_TransactionHistory_Product_ProductID" FromRole="TransactionHistory" ToRole="Product" />
</EntityType>
<EntityType Name="TransactionHistoryArchive">
<Key>
<PropertyRef Name="TransactionID" />
</Key>
<Property Name="TransactionID" Type="Int32" Nullable="false" />
<Property Name="ProductID" Type="Int32" Nullable="false" />
<Property Name="ReferenceOrderID" Type="Int32" Nullable="false" />
<Property Name="ReferenceOrderLineID" Type="Int32" Nullable="false" />
<Property Name="TransactionDate" Type="DateTime" Nullable="false" />
<Property Name="TransactionType" Type="String" Nullable="false" MaxLength="1" Unicode="true" FixedLength="true" />
<Property Name="Quantity" Type="Int32" Nullable="false" />
<Property Name="ActualCost" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
</EntityType>
<EntityType Name="UnitMeasure">
<Key>
<PropertyRef Name="UnitMeasureCode" />
</Key>
<Property Name="UnitMeasureCode" Type="String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="true" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="BillOfMaterials" Relationship="AdventureWorks.FK_BillOfMaterials_UnitMeasure_UnitMeasureCode" FromRole="UnitMeasure" ToRole="BillOfMaterials" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_Product_UnitMeasure_SizeUnitMeasureCode" FromRole="UnitMeasure" ToRole="Product" />
<NavigationProperty Name="Product1" Relationship="AdventureWorks.FK_Product_UnitMeasure_WeightUnitMeasureCode" FromRole="UnitMeasure" ToRole="Product" />
<NavigationProperty Name="ProductVendor" Relationship="AdventureWorks.FK_ProductVendor_UnitMeasure_UnitMeasureCode" FromRole="UnitMeasure" ToRole="ProductVendor" />
</EntityType>
<EntityType Name="WorkOrder">
<Key>
<PropertyRef Name="WorkOrderID" />
</Key>
<Property Name="WorkOrderID" Type="Int32" Nullable="false" />
<Property Name="OrderQty" Type="Int32" Nullable="false" />
<Property Name="StockedQty" Type="Int32" Nullable="false" />
<Property Name="ScrappedQty" Type="Int16" Nullable="false" />
<Property Name="StartDate" Type="DateTime" Nullable="false" />
<Property Name="EndDate" Type="DateTime" />
<Property Name="DueDate" Type="DateTime" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_WorkOrder_Product_ProductID" FromRole="WorkOrder" ToRole="Product" />
<NavigationProperty Name="ScrapReason" Relationship="AdventureWorks.FK_WorkOrder_ScrapReason_ScrapReasonID" FromRole="WorkOrder" ToRole="ScrapReason" />
<NavigationProperty Name="WorkOrderRouting" Relationship="AdventureWorks.FK_WorkOrderRouting_WorkOrder_WorkOrderID" FromRole="WorkOrder" ToRole="WorkOrderRouting" />
</EntityType>
<EntityType Name="WorkOrderRouting">
<Key>
<PropertyRef Name="WorkOrderID" />
<PropertyRef Name="ProductID" />
<PropertyRef Name="OperationSequence" />
</Key>
<Property Name="WorkOrderID" Type="Int32" Nullable="false" />
<Property Name="ProductID" Type="Int32" Nullable="false" />
<Property Name="OperationSequence" Type="Int16" Nullable="false" />
<Property Name="ScheduledStartDate" Type="DateTime" Nullable="false" />
<Property Name="ScheduledEndDate" Type="DateTime" Nullable="false" />
<Property Name="ActualStartDate" Type="DateTime" />
<Property Name="ActualEndDate" Type="DateTime" />
<Property Name="ActualResourceHrs" Type="Decimal" Precision="9" Scale="4" />
<Property Name="PlannedCost" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="ActualCost" Type="Decimal" Precision="19" Scale="4" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Location" Relationship="AdventureWorks.FK_WorkOrderRouting_Location_LocationID" FromRole="WorkOrderRouting" ToRole="Location" />
<NavigationProperty Name="WorkOrder" Relationship="AdventureWorks.FK_WorkOrderRouting_WorkOrder_WorkOrderID" FromRole="WorkOrderRouting" ToRole="WorkOrder" />
</EntityType>
<EntityType Name="ProductVendor">
<Key>
<PropertyRef Name="ProductID" />
<PropertyRef Name="VendorID" />
</Key>
<Property Name="ProductID" Type="Int32" Nullable="false" />
<Property Name="VendorID" Type="Int32" Nullable="false" />
<Property Name="AverageLeadTime" Type="Int32" Nullable="false" />
<Property Name="StandardPrice" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="LastReceiptCost" Type="Decimal" Precision="19" Scale="4" />
<Property Name="LastReceiptDate" Type="DateTime" />
<Property Name="MinOrderQty" Type="Int32" Nullable="false" />
<Property Name="MaxOrderQty" Type="Int32" Nullable="false" />
<Property Name="OnOrderQty" Type="Int32" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_ProductVendor_Product_ProductID" FromRole="ProductVendor" ToRole="Product" />
<NavigationProperty Name="UnitMeasure" Relationship="AdventureWorks.FK_ProductVendor_UnitMeasure_UnitMeasureCode" FromRole="ProductVendor" ToRole="UnitMeasure" />
<NavigationProperty Name="Vendor" Relationship="AdventureWorks.FK_ProductVendor_Vendor_VendorID" FromRole="ProductVendor" ToRole="Vendor" />
</EntityType>
<EntityType Name="PurchaseOrderDetail">
<Key>
<PropertyRef Name="PurchaseOrderID" />
<PropertyRef Name="PurchaseOrderDetailID" />
</Key>
<Property Name="PurchaseOrderID" Type="Int32" Nullable="false" />
<Property Name="PurchaseOrderDetailID" Type="Int32" Nullable="false" />
<Property Name="DueDate" Type="DateTime" Nullable="false" />
<Property Name="OrderQty" Type="Int16" Nullable="false" />
<Property Name="UnitPrice" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="LineTotal" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="ReceivedQty" Type="Decimal" Nullable="false" Precision="8" Scale="2" />
<Property Name="RejectedQty" Type="Decimal" Nullable="false" Precision="8" Scale="2" />
<Property Name="StockedQty" Type="Decimal" Nullable="false" Precision="9" Scale="2" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_PurchaseOrderDetail_Product_ProductID" FromRole="PurchaseOrderDetail" ToRole="Product" />
<NavigationProperty Name="PurchaseOrderHeader" Relationship="AdventureWorks.FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID" FromRole="PurchaseOrderDetail" ToRole="PurchaseOrderHeader" />
</EntityType>
<EntityType Name="PurchaseOrderHeader">
<Key>
<PropertyRef Name="PurchaseOrderID" />
</Key>
<Property Name="PurchaseOrderID" Type="Int32" Nullable="false" />
<Property Name="RevisionNumber" Type="Byte" Nullable="false" />
<Property Name="Status" Type="Byte" Nullable="false" />
<Property Name="OrderDate" Type="DateTime" Nullable="false" />
<Property Name="ShipDate" Type="DateTime" />
<Property Name="SubTotal" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="TaxAmt" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="Freight" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="TotalDue" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Employee" Relationship="AdventureWorks.FK_PurchaseOrderHeader_Employee_EmployeeID" FromRole="PurchaseOrderHeader" ToRole="Employee" />
<NavigationProperty Name="PurchaseOrderDetail" Relationship="AdventureWorks.FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID" FromRole="PurchaseOrderHeader" ToRole="PurchaseOrderDetail" />
<NavigationProperty Name="ShipMethod" Relationship="AdventureWorks.FK_PurchaseOrderHeader_ShipMethod_ShipMethodID" FromRole="PurchaseOrderHeader" ToRole="ShipMethod" />
<NavigationProperty Name="Vendor" Relationship="AdventureWorks.FK_PurchaseOrderHeader_Vendor_VendorID" FromRole="PurchaseOrderHeader" ToRole="Vendor" />
</EntityType>
<EntityType Name="ShipMethod">
<Key>
<PropertyRef Name="ShipMethodID" />
</Key>
<Property Name="ShipMethodID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ShipBase" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="ShipRate" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="PurchaseOrderHeader" Relationship="AdventureWorks.FK_PurchaseOrderHeader_ShipMethod_ShipMethodID" FromRole="ShipMethod" ToRole="PurchaseOrderHeader" />
<NavigationProperty Name="SalesOrderHeader" Relationship="AdventureWorks.FK_SalesOrderHeader_ShipMethod_ShipMethodID" FromRole="ShipMethod" ToRole="SalesOrderHeader" />
</EntityType>
<EntityType Name="Vendor">
<Key>
<PropertyRef Name="VendorID" />
</Key>
<Property Name="VendorID" Type="Int32" Nullable="false" />
<Property Name="AccountNumber" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="CreditRating" Type="Byte" Nullable="false" />
<Property Name="PreferredVendorStatus" Type="Boolean" Nullable="false" />
<Property Name="ActiveFlag" Type="Boolean" Nullable="false" />
<Property Name="PurchasingWebServiceURL" Type="String" MaxLength="1024" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="ProductVendor" Relationship="AdventureWorks.FK_ProductVendor_Vendor_VendorID" FromRole="Vendor" ToRole="ProductVendor" />
<NavigationProperty Name="PurchaseOrderHeader" Relationship="AdventureWorks.FK_PurchaseOrderHeader_Vendor_VendorID" FromRole="Vendor" ToRole="PurchaseOrderHeader" />
<NavigationProperty Name="VendorAddress" Relationship="AdventureWorks.FK_VendorAddress_Vendor_VendorID" FromRole="Vendor" ToRole="VendorAddress" />
<NavigationProperty Name="VendorContact" Relationship="AdventureWorks.FK_VendorContact_Vendor_VendorID" FromRole="Vendor" ToRole="VendorContact" />
</EntityType>
<EntityType Name="VendorAddress">
<Key>
<PropertyRef Name="VendorID" />
<PropertyRef Name="AddressID" />
</Key>
<Property Name="VendorID" Type="Int32" Nullable="false" />
<Property Name="AddressID" Type="Int32" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Address" Relationship="AdventureWorks.FK_VendorAddress_Address_AddressID" FromRole="VendorAddress" ToRole="Address" />
<NavigationProperty Name="AddressType" Relationship="AdventureWorks.FK_VendorAddress_AddressType_AddressTypeID" FromRole="VendorAddress" ToRole="AddressType" />
<NavigationProperty Name="Vendor" Relationship="AdventureWorks.FK_VendorAddress_Vendor_VendorID" FromRole="VendorAddress" ToRole="Vendor" />
</EntityType>
<EntityType Name="VendorContact">
<Key>
<PropertyRef Name="VendorID" />
<PropertyRef Name="ContactID" />
</Key>
<Property Name="VendorID" Type="Int32" Nullable="false" />
<Property Name="ContactID" Type="Int32" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Contact" Relationship="AdventureWorks.FK_VendorContact_Contact_ContactID" FromRole="VendorContact" ToRole="Contact" />
<NavigationProperty Name="ContactType" Relationship="AdventureWorks.FK_VendorContact_ContactType_ContactTypeID" FromRole="VendorContact" ToRole="ContactType" />
<NavigationProperty Name="Vendor" Relationship="AdventureWorks.FK_VendorContact_Vendor_VendorID" FromRole="VendorContact" ToRole="Vendor" />
</EntityType>
<EntityType Name="ContactCreditCard">
<Key>
<PropertyRef Name="ContactID" />
<PropertyRef Name="CreditCardID" />
</Key>
<Property Name="ContactID" Type="Int32" Nullable="false" />
<Property Name="CreditCardID" Type="Int32" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Contact" Relationship="AdventureWorks.FK_ContactCreditCard_Contact_ContactID" FromRole="ContactCreditCard" ToRole="Contact" />
<NavigationProperty Name="CreditCard" Relationship="AdventureWorks.FK_ContactCreditCard_CreditCard_CreditCardID" FromRole="ContactCreditCard" ToRole="CreditCard" />
</EntityType>
<EntityType Name="CountryRegionCurrency">
<Key>
<PropertyRef Name="CountryRegionCode" />
<PropertyRef Name="CurrencyCode" />
</Key>
<Property Name="CountryRegionCode" Type="String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
<Property Name="CurrencyCode" Type="String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="true" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="CountryRegion" Relationship="AdventureWorks.FK_CountryRegionCurrency_CountryRegion_CountryRegionCode" FromRole="CountryRegionCurrency" ToRole="CountryRegion" />
<NavigationProperty Name="Currency" Relationship="AdventureWorks.FK_CountryRegionCurrency_Currency_CurrencyCode" FromRole="CountryRegionCurrency" ToRole="Currency" />
</EntityType>
<EntityType Name="CreditCard">
<Key>
<PropertyRef Name="CreditCardID" />
</Key>
<Property Name="CreditCardID" Type="Int32" Nullable="false" />
<Property Name="CardType" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="CardNumber" Type="String" Nullable="false" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="ExpMonth" Type="Byte" Nullable="false" />
<Property Name="ExpYear" Type="Int16" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="ContactCreditCard" Relationship="AdventureWorks.FK_ContactCreditCard_CreditCard_CreditCardID" FromRole="CreditCard" ToRole="ContactCreditCard" />
<NavigationProperty Name="SalesOrderHeader" Relationship="AdventureWorks.FK_SalesOrderHeader_CreditCard_CreditCardID" FromRole="CreditCard" ToRole="SalesOrderHeader" />
</EntityType>
<EntityType Name="Currency">
<Key>
<PropertyRef Name="CurrencyCode" />
</Key>
<Property Name="CurrencyCode" Type="String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="true" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="CountryRegionCurrency" Relationship="AdventureWorks.FK_CountryRegionCurrency_Currency_CurrencyCode" FromRole="Currency" ToRole="CountryRegionCurrency" />
<NavigationProperty Name="CurrencyRate" Relationship="AdventureWorks.FK_CurrencyRate_Currency_FromCurrencyCode" FromRole="Currency" ToRole="CurrencyRate" />
<NavigationProperty Name="CurrencyRate1" Relationship="AdventureWorks.FK_CurrencyRate_Currency_ToCurrencyCode" FromRole="Currency" ToRole="CurrencyRate" />
</EntityType>
<EntityType Name="CurrencyRate">
<Key>
<PropertyRef Name="CurrencyRateID" />
</Key>
<Property Name="CurrencyRateID" Type="Int32" Nullable="false" />
<Property Name="CurrencyRateDate" Type="DateTime" Nullable="false" />
<Property Name="AverageRate" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="EndOfDayRate" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Currency" Relationship="AdventureWorks.FK_CurrencyRate_Currency_FromCurrencyCode" FromRole="CurrencyRate" ToRole="Currency" />
<NavigationProperty Name="Currency1" Relationship="AdventureWorks.FK_CurrencyRate_Currency_ToCurrencyCode" FromRole="CurrencyRate" ToRole="Currency" />
<NavigationProperty Name="SalesOrderHeader" Relationship="AdventureWorks.FK_SalesOrderHeader_CurrencyRate_CurrencyRateID" FromRole="CurrencyRate" ToRole="SalesOrderHeader" />
</EntityType>
<EntityType Name="Customer">
<Key>
<PropertyRef Name="CustomerID" />
</Key>
<Property Name="CustomerID" Type="Int32" Nullable="false" />
<Property Name="AccountNumber" Type="String" Nullable="false" MaxLength="10" Unicode="false" FixedLength="false" />
<Property Name="CustomerType" Type="String" Nullable="false" MaxLength="1" Unicode="true" FixedLength="true" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="SalesTerritory" Relationship="AdventureWorks.FK_Customer_SalesTerritory_TerritoryID" FromRole="Customer" ToRole="SalesTerritory" />
<NavigationProperty Name="CustomerAddress" Relationship="AdventureWorks.FK_CustomerAddress_Customer_CustomerID" FromRole="Customer" ToRole="CustomerAddress" />
<NavigationProperty Name="Individual" Relationship="AdventureWorks.FK_Individual_Customer_CustomerID" FromRole="Customer" ToRole="Individual" />
<NavigationProperty Name="SalesOrderHeader" Relationship="AdventureWorks.FK_SalesOrderHeader_Customer_CustomerID" FromRole="Customer" ToRole="SalesOrderHeader" />
<NavigationProperty Name="Store" Relationship="AdventureWorks.FK_Store_Customer_CustomerID" FromRole="Customer" ToRole="Store" />
</EntityType>
<EntityType Name="CustomerAddress">
<Key>
<PropertyRef Name="CustomerID" />
<PropertyRef Name="AddressID" />
</Key>
<Property Name="CustomerID" Type="Int32" Nullable="false" />
<Property Name="AddressID" Type="Int32" Nullable="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Address" Relationship="AdventureWorks.FK_CustomerAddress_Address_AddressID" FromRole="CustomerAddress" ToRole="Address" />
<NavigationProperty Name="AddressType" Relationship="AdventureWorks.FK_CustomerAddress_AddressType_AddressTypeID" FromRole="CustomerAddress" ToRole="AddressType" />
<NavigationProperty Name="Customer" Relationship="AdventureWorks.FK_CustomerAddress_Customer_CustomerID" FromRole="CustomerAddress" ToRole="Customer" />
</EntityType>
<EntityType Name="Individual">
<Key>
<PropertyRef Name="CustomerID" />
</Key>
<Property Name="CustomerID" Type="Int32" Nullable="false" />
<Property Name="Demographics" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Contact" Relationship="AdventureWorks.FK_Individual_Contact_ContactID" FromRole="Individual" ToRole="Contact" />
<NavigationProperty Name="Customer" Relationship="AdventureWorks.FK_Individual_Customer_CustomerID" FromRole="Individual" ToRole="Customer" />
</EntityType>
<EntityType Name="SalesOrderDetail">
<Key>
<PropertyRef Name="SalesOrderID" />
<PropertyRef Name="SalesOrderDetailID" />
</Key>
<Property Name="SalesOrderID" Type="Int32" Nullable="false" />
<Property Name="SalesOrderDetailID" Type="Int32" Nullable="false" />
<Property Name="CarrierTrackingNumber" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="OrderQty" Type="Int16" Nullable="false" />
<Property Name="UnitPrice" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="UnitPriceDiscount" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="LineTotal" Type="Decimal" Nullable="false" Precision="38" Scale="6" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="SalesOrderHeader" Relationship="AdventureWorks.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID" FromRole="SalesOrderDetail" ToRole="SalesOrderHeader" />
<NavigationProperty Name="SpecialOfferProduct" Relationship="AdventureWorks.FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID" FromRole="SalesOrderDetail" ToRole="SpecialOfferProduct" />
</EntityType>
<EntityType Name="SalesOrderHeader">
<Key>
<PropertyRef Name="SalesOrderID" />
</Key>
<Property Name="SalesOrderID" Type="Int32" Nullable="false" />
<Property Name="RevisionNumber" Type="Byte" Nullable="false" />
<Property Name="OrderDate" Type="DateTime" Nullable="false" />
<Property Name="DueDate" Type="DateTime" Nullable="false" />
<Property Name="ShipDate" Type="DateTime" />
<Property Name="Status" Type="Byte" Nullable="false" />
<Property Name="OnlineOrderFlag" Type="Boolean" Nullable="false" />
<Property Name="SalesOrderNumber" Type="String" Nullable="false" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="PurchaseOrderNumber" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="AccountNumber" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="CreditCardApprovalCode" Type="String" MaxLength="15" Unicode="false" FixedLength="false" />
<Property Name="SubTotal" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="TaxAmt" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="Freight" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="TotalDue" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="Comment" Type="String" MaxLength="128" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Address" Relationship="AdventureWorks.FK_SalesOrderHeader_Address_BillToAddressID" FromRole="SalesOrderHeader" ToRole="Address" />
<NavigationProperty Name="Address1" Relationship="AdventureWorks.FK_SalesOrderHeader_Address_ShipToAddressID" FromRole="SalesOrderHeader" ToRole="Address" />
<NavigationProperty Name="Contact" Relationship="AdventureWorks.FK_SalesOrderHeader_Contact_ContactID" FromRole="SalesOrderHeader" ToRole="Contact" />
<NavigationProperty Name="ShipMethod" Relationship="AdventureWorks.FK_SalesOrderHeader_ShipMethod_ShipMethodID" FromRole="SalesOrderHeader" ToRole="ShipMethod" />
<NavigationProperty Name="CreditCard" Relationship="AdventureWorks.FK_SalesOrderHeader_CreditCard_CreditCardID" FromRole="SalesOrderHeader" ToRole="CreditCard" />
<NavigationProperty Name="CurrencyRate" Relationship="AdventureWorks.FK_SalesOrderHeader_CurrencyRate_CurrencyRateID" FromRole="SalesOrderHeader" ToRole="CurrencyRate" />
<NavigationProperty Name="Customer" Relationship="AdventureWorks.FK_SalesOrderHeader_Customer_CustomerID" FromRole="SalesOrderHeader" ToRole="Customer" />
<NavigationProperty Name="SalesOrderDetail" Relationship="AdventureWorks.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID" FromRole="SalesOrderHeader" ToRole="SalesOrderDetail" />
<NavigationProperty Name="SalesPerson" Relationship="AdventureWorks.FK_SalesOrderHeader_SalesPerson_SalesPersonID" FromRole="SalesOrderHeader" ToRole="SalesPerson" />
<NavigationProperty Name="SalesTerritory" Relationship="AdventureWorks.FK_SalesOrderHeader_SalesTerritory_TerritoryID" FromRole="SalesOrderHeader" ToRole="SalesTerritory" />
<NavigationProperty Name="SalesOrderHeaderSalesReason" Relationship="AdventureWorks.FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID" FromRole="SalesOrderHeader" ToRole="SalesOrderHeaderSalesReason" />
</EntityType>
<EntityType Name="SalesOrderHeaderSalesReason">
<Key>
<PropertyRef Name="SalesOrderID" />
<PropertyRef Name="SalesReasonID" />
</Key>
<Property Name="SalesOrderID" Type="Int32" Nullable="false" />
<Property Name="SalesReasonID" Type="Int32" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="SalesOrderHeader" Relationship="AdventureWorks.FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID" FromRole="SalesOrderHeaderSalesReason" ToRole="SalesOrderHeader" />
<NavigationProperty Name="SalesReason" Relationship="AdventureWorks.FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID" FromRole="SalesOrderHeaderSalesReason" ToRole="SalesReason" />
</EntityType>
<EntityType Name="SalesPerson">
<Key>
<PropertyRef Name="SalesPersonID" />
</Key>
<Property Name="SalesPersonID" Type="Int32" Nullable="false" />
<Property Name="SalesQuota" Type="Decimal" Precision="19" Scale="4" />
<Property Name="Bonus" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="CommissionPct" Type="Decimal" Nullable="false" Precision="10" Scale="4" />
<Property Name="SalesYTD" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="SalesLastYear" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Employee" Relationship="AdventureWorks.FK_SalesPerson_Employee_SalesPersonID" FromRole="SalesPerson" ToRole="Employee" />
<NavigationProperty Name="SalesOrderHeader" Relationship="AdventureWorks.FK_SalesOrderHeader_SalesPerson_SalesPersonID" FromRole="SalesPerson" ToRole="SalesOrderHeader" />
<NavigationProperty Name="SalesTerritory" Relationship="AdventureWorks.FK_SalesPerson_SalesTerritory_TerritoryID" FromRole="SalesPerson" ToRole="SalesTerritory" />
<NavigationProperty Name="SalesPersonQuotaHistory" Relationship="AdventureWorks.FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID" FromRole="SalesPerson" ToRole="SalesPersonQuotaHistory" />
<NavigationProperty Name="SalesTerritoryHistory" Relationship="AdventureWorks.FK_SalesTerritoryHistory_SalesPerson_SalesPersonID" FromRole="SalesPerson" ToRole="SalesTerritoryHistory" />
<NavigationProperty Name="Store" Relationship="AdventureWorks.FK_Store_SalesPerson_SalesPersonID" FromRole="SalesPerson" ToRole="Store" />
</EntityType>
<EntityType Name="SalesPersonQuotaHistory">
<Key>
<PropertyRef Name="SalesPersonID" />
<PropertyRef Name="QuotaDate" />
</Key>
<Property Name="SalesPersonID" Type="Int32" Nullable="false" />
<Property Name="QuotaDate" Type="DateTime" Nullable="false" />
<Property Name="SalesQuota" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="SalesPerson" Relationship="AdventureWorks.FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID" FromRole="SalesPersonQuotaHistory" ToRole="SalesPerson" />
</EntityType>
<EntityType Name="SalesReason">
<Key>
<PropertyRef Name="SalesReasonID" />
</Key>
<Property Name="SalesReasonID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ReasonType" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="SalesOrderHeaderSalesReason" Relationship="AdventureWorks.FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID" FromRole="SalesReason" ToRole="SalesOrderHeaderSalesReason" />
</EntityType>
<EntityType Name="SalesTaxRate">
<Key>
<PropertyRef Name="SalesTaxRateID" />
</Key>
<Property Name="SalesTaxRateID" Type="Int32" Nullable="false" />
<Property Name="TaxType" Type="Byte" Nullable="false" />
<Property Name="TaxRate" Type="Decimal" Nullable="false" Precision="10" Scale="4" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="StateProvince" Relationship="AdventureWorks.FK_SalesTaxRate_StateProvince_StateProvinceID" FromRole="SalesTaxRate" ToRole="StateProvince" />
</EntityType>
<EntityType Name="SalesTerritory">
<Key>
<PropertyRef Name="TerritoryID" />
</Key>
<Property Name="TerritoryID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="CountryRegionCode" Type="String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
<Property Name="Group" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="SalesYTD" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="SalesLastYear" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="CostYTD" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="CostLastYear" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="StateProvince" Relationship="AdventureWorks.FK_StateProvince_SalesTerritory_TerritoryID" FromRole="SalesTerritory" ToRole="StateProvince" />
<NavigationProperty Name="Customer" Relationship="AdventureWorks.FK_Customer_SalesTerritory_TerritoryID" FromRole="SalesTerritory" ToRole="Customer" />
<NavigationProperty Name="SalesOrderHeader" Relationship="AdventureWorks.FK_SalesOrderHeader_SalesTerritory_TerritoryID" FromRole="SalesTerritory" ToRole="SalesOrderHeader" />
<NavigationProperty Name="SalesPerson" Relationship="AdventureWorks.FK_SalesPerson_SalesTerritory_TerritoryID" FromRole="SalesTerritory" ToRole="SalesPerson" />
<NavigationProperty Name="SalesTerritoryHistory" Relationship="AdventureWorks.FK_SalesTerritoryHistory_SalesTerritory_TerritoryID" FromRole="SalesTerritory" ToRole="SalesTerritoryHistory" />
</EntityType>
<EntityType Name="SalesTerritoryHistory">
<Key>
<PropertyRef Name="SalesPersonID" />
<PropertyRef Name="TerritoryID" />
<PropertyRef Name="StartDate" />
</Key>
<Property Name="SalesPersonID" Type="Int32" Nullable="false" />
<Property Name="TerritoryID" Type="Int32" Nullable="false" />
<Property Name="StartDate" Type="DateTime" Nullable="false" />
<Property Name="EndDate" Type="DateTime" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="SalesPerson" Relationship="AdventureWorks.FK_SalesTerritoryHistory_SalesPerson_SalesPersonID" FromRole="SalesTerritoryHistory" ToRole="SalesPerson" />
<NavigationProperty Name="SalesTerritory" Relationship="AdventureWorks.FK_SalesTerritoryHistory_SalesTerritory_TerritoryID" FromRole="SalesTerritoryHistory" ToRole="SalesTerritory" />
</EntityType>
<EntityType Name="ShoppingCartItem">
<Key>
<PropertyRef Name="ShoppingCartItemID" />
</Key>
<Property Name="ShoppingCartItemID" Type="Int32" Nullable="false" />
<Property Name="ShoppingCartID" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Quantity" Type="Int32" Nullable="false" />
<Property Name="DateCreated" Type="DateTime" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_ShoppingCartItem_Product_ProductID" FromRole="ShoppingCartItem" ToRole="Product" />
</EntityType>
<EntityType Name="SpecialOffer">
<Key>
<PropertyRef Name="SpecialOfferID" />
</Key>
<Property Name="SpecialOfferID" Type="Int32" Nullable="false" />
<Property Name="Description" Type="String" Nullable="false" MaxLength="255" Unicode="true" FixedLength="false" />
<Property Name="DiscountPct" Type="Decimal" Nullable="false" Precision="10" Scale="4" />
<Property Name="Type" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Category" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="StartDate" Type="DateTime" Nullable="false" />
<Property Name="EndDate" Type="DateTime" Nullable="false" />
<Property Name="MinQty" Type="Int32" Nullable="false" />
<Property Name="MaxQty" Type="Int32" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="SpecialOfferProduct" Relationship="AdventureWorks.FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID" FromRole="SpecialOffer" ToRole="SpecialOfferProduct" />
</EntityType>
<EntityType Name="SpecialOfferProduct">
<Key>
<PropertyRef Name="SpecialOfferID" />
<PropertyRef Name="ProductID" />
</Key>
<Property Name="SpecialOfferID" Type="Int32" Nullable="false" />
<Property Name="ProductID" Type="Int32" Nullable="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Product" Relationship="AdventureWorks.FK_SpecialOfferProduct_Product_ProductID" FromRole="SpecialOfferProduct" ToRole="Product" />
<NavigationProperty Name="SalesOrderDetail" Relationship="AdventureWorks.FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID" FromRole="SpecialOfferProduct" ToRole="SalesOrderDetail" />
<NavigationProperty Name="SpecialOffer" Relationship="AdventureWorks.FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID" FromRole="SpecialOfferProduct" ToRole="SpecialOffer" />
</EntityType>
<EntityType Name="Store">
<Key>
<PropertyRef Name="CustomerID" />
</Key>
<Property Name="CustomerID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Demographics" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Customer" Relationship="AdventureWorks.FK_Store_Customer_CustomerID" FromRole="Store" ToRole="Customer" />
<NavigationProperty Name="SalesPerson" Relationship="AdventureWorks.FK_Store_SalesPerson_SalesPersonID" FromRole="Store" ToRole="SalesPerson" />
<NavigationProperty Name="StoreContact" Relationship="AdventureWorks.FK_StoreContact_Store_CustomerID" FromRole="Store" ToRole="StoreContact" />
</EntityType>
<EntityType Name="StoreContact">
<Key>
<PropertyRef Name="CustomerID" />
<PropertyRef Name="ContactID" />
</Key>
<Property Name="CustomerID" Type="Int32" Nullable="false" />
<Property Name="ContactID" Type="Int32" Nullable="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
<NavigationProperty Name="Contact" Relationship="AdventureWorks.FK_StoreContact_Contact_ContactID" FromRole="StoreContact" ToRole="Contact" />
<NavigationProperty Name="ContactType" Relationship="AdventureWorks.FK_StoreContact_ContactType_ContactTypeID" FromRole="StoreContact" ToRole="ContactType" />
<NavigationProperty Name="Store" Relationship="AdventureWorks.FK_StoreContact_Store_CustomerID" FromRole="StoreContact" ToRole="Store" />
</EntityType>
<EntityType Name="vEmployee">
<Key>
<PropertyRef Name="EmployeeID" />
<PropertyRef Name="FirstName" />
<PropertyRef Name="LastName" />
<PropertyRef Name="JobTitle" />
<PropertyRef Name="EmailPromotion" />
<PropertyRef Name="AddressLine1" />
<PropertyRef Name="City" />
<PropertyRef Name="StateProvinceName" />
<PropertyRef Name="PostalCode" />
<PropertyRef Name="CountryRegionName" />
</Key>
<Property Name="EmployeeID" Type="Int32" Nullable="false" />
<Property Name="Title" Type="String" MaxLength="8" Unicode="true" FixedLength="false" />
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="MiddleName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="LastName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Suffix" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="JobTitle" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Phone" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="EmailAddress" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="EmailPromotion" Type="Int32" Nullable="false" />
<Property Name="AddressLine1" Type="String" Nullable="false" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="AddressLine2" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="City" Type="String" Nullable="false" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="StateProvinceName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="PostalCode" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="CountryRegionName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="AdditionalContactInfo" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
</EntityType>
<EntityType Name="vEmployeeDepartment">
<Key>
<PropertyRef Name="EmployeeID" />
<PropertyRef Name="FirstName" />
<PropertyRef Name="LastName" />
<PropertyRef Name="JobTitle" />
<PropertyRef Name="Department" />
<PropertyRef Name="GroupName" />
<PropertyRef Name="StartDate" />
</Key>
<Property Name="EmployeeID" Type="Int32" Nullable="false" />
<Property Name="Title" Type="String" MaxLength="8" Unicode="true" FixedLength="false" />
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="MiddleName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="LastName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Suffix" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="JobTitle" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Department" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="GroupName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="StartDate" Type="DateTime" Nullable="false" />
</EntityType>
<EntityType Name="vEmployeeDepartmentHistory">
<Key>
<PropertyRef Name="EmployeeID" />
<PropertyRef Name="FirstName" />
<PropertyRef Name="LastName" />
<PropertyRef Name="Shift" />
<PropertyRef Name="Department" />
<PropertyRef Name="GroupName" />
<PropertyRef Name="StartDate" />
</Key>
<Property Name="EmployeeID" Type="Int32" Nullable="false" />
<Property Name="Title" Type="String" MaxLength="8" Unicode="true" FixedLength="false" />
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="MiddleName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="LastName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Suffix" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="Shift" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Department" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="GroupName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="StartDate" Type="DateTime" Nullable="false" />
<Property Name="EndDate" Type="DateTime" />
</EntityType>
<EntityType Name="vJobCandidate">
<Key>
<PropertyRef Name="JobCandidateID" />
<PropertyRef Name="ModifiedDate" />
</Key>
<Property Name="JobCandidateID" Type="Int32" Nullable="false" />
<Property Name="EmployeeID" Type="Int32" />
<Property Name="Name_Prefix" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="Name_First" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="Name_Middle" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="Name_Last" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="Name_Suffix" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="Skills" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Addr_Type" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="Addr_Loc_CountryRegion" Type="String" MaxLength="100" Unicode="true" FixedLength="false" />
<Property Name="Addr_Loc_State" Type="String" MaxLength="100" Unicode="true" FixedLength="false" />
<Property Name="Addr_Loc_City" Type="String" MaxLength="100" Unicode="true" FixedLength="false" />
<Property Name="Addr_PostalCode" Type="String" MaxLength="20" Unicode="true" FixedLength="false" />
<Property Name="EMail" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="WebSite" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
</EntityType>
<EntityType Name="vJobCandidateEducation">
<Key>
<PropertyRef Name="JobCandidateID" />
</Key>
<Property Name="JobCandidateID" Type="Int32" Nullable="false" />
<Property Name="Edu_Level" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Edu_StartDate" Type="DateTime" />
<Property Name="Edu_EndDate" Type="DateTime" />
<Property Name="Edu_Degree" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Edu_Major" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Edu_Minor" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Edu_GPA" Type="String" MaxLength="5" Unicode="true" FixedLength="false" />
<Property Name="Edu_GPAScale" Type="String" MaxLength="5" Unicode="true" FixedLength="false" />
<Property Name="Edu_School" Type="String" MaxLength="100" Unicode="true" FixedLength="false" />
<Property Name="Edu_Loc_CountryRegion" Type="String" MaxLength="100" Unicode="true" FixedLength="false" />
<Property Name="Edu_Loc_State" Type="String" MaxLength="100" Unicode="true" FixedLength="false" />
<Property Name="Edu_Loc_City" Type="String" MaxLength="100" Unicode="true" FixedLength="false" />
</EntityType>
<EntityType Name="vJobCandidateEmployment">
<Key>
<PropertyRef Name="JobCandidateID" />
</Key>
<Property Name="JobCandidateID" Type="Int32" Nullable="false" />
<Property Name="Emp_StartDate" Type="DateTime" />
<Property Name="Emp_EndDate" Type="DateTime" />
<Property Name="Emp_OrgName" Type="String" MaxLength="100" Unicode="true" FixedLength="false" />
<Property Name="Emp_JobTitle" Type="String" MaxLength="100" Unicode="true" FixedLength="false" />
<Property Name="Emp_Responsibility" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Emp_FunctionCategory" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Emp_IndustryCategory" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Emp_Loc_CountryRegion" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Emp_Loc_State" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Emp_Loc_City" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
</EntityType>
<EntityType Name="vAdditionalContactInfo">
<Key>
<PropertyRef Name="ContactID" />
<PropertyRef Name="FirstName" />
<PropertyRef Name="LastName" />
<PropertyRef Name="rowguid" />
<PropertyRef Name="ModifiedDate" />
</Key>
<Property Name="ContactID" Type="Int32" Nullable="false" />
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="MiddleName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="LastName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="TelephoneNumber" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="TelephoneSpecialInstructions" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Street" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="City" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="StateProvince" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="PostalCode" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="CountryRegion" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="HomeAddressSpecialInstructions" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="EMailAddress" Type="String" MaxLength="128" Unicode="true" FixedLength="false" />
<Property Name="EMailSpecialInstructions" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="EMailTelephoneNumber" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
</EntityType>
<EntityType Name="vStateProvinceCountryRegion">
<Key>
<PropertyRef Name="StateProvinceID" />
<PropertyRef Name="StateProvinceCode" />
<PropertyRef Name="IsOnlyStateProvinceFlag" />
<PropertyRef Name="StateProvinceName" />
<PropertyRef Name="TerritoryID" />
<PropertyRef Name="CountryRegionCode" />
<PropertyRef Name="CountryRegionName" />
</Key>
<Property Name="StateProvinceID" Type="Int32" Nullable="false" />
<Property Name="StateProvinceCode" Type="String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="true" />
<Property Name="IsOnlyStateProvinceFlag" Type="Boolean" Nullable="false" />
<Property Name="StateProvinceName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="TerritoryID" Type="Int32" Nullable="false" />
<Property Name="CountryRegionCode" Type="String" Nullable="false" MaxLength="3" Unicode="true" FixedLength="false" />
<Property Name="CountryRegionName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
</EntityType>
<EntityType Name="vProductAndDescription">
<Key>
<PropertyRef Name="ProductID" />
<PropertyRef Name="Name" />
<PropertyRef Name="ProductModel" />
<PropertyRef Name="CultureID" />
<PropertyRef Name="Description" />
</Key>
<Property Name="ProductID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ProductModel" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="CultureID" Type="String" Nullable="false" MaxLength="6" Unicode="true" FixedLength="true" />
<Property Name="Description" Type="String" Nullable="false" MaxLength="400" Unicode="true" FixedLength="false" />
</EntityType>
<EntityType Name="vProductModelCatalogDescription">
<Key>
<PropertyRef Name="ProductModelID" />
<PropertyRef Name="Name" />
<PropertyRef Name="rowguid" />
<PropertyRef Name="ModifiedDate" />
</Key>
<Property Name="ProductModelID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Summary" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Manufacturer" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Copyright" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="ProductURL" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="WarrantyPeriod" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="WarrantyDescription" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="NoOfYears" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="MaintenanceDescription" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="Wheel" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="Saddle" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="Pedal" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="BikeFrame" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="Crankset" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="PictureAngle" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="PictureSize" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="ProductPhotoID" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="Material" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="Color" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="ProductLine" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="Style" Type="String" MaxLength="256" Unicode="true" FixedLength="false" />
<Property Name="RiderExperience" Type="String" MaxLength="1024" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
</EntityType>
<EntityType Name="vProductModelInstructions">
<Key>
<PropertyRef Name="ProductModelID" />
<PropertyRef Name="Name" />
<PropertyRef Name="rowguid" />
<PropertyRef Name="ModifiedDate" />
</Key>
<Property Name="ProductModelID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Instructions" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
<Property Name="LocationID" Type="Int32" />
<Property Name="SetupHours" Type="Decimal" Precision="9" Scale="4" />
<Property Name="MachineHours" Type="Decimal" Precision="9" Scale="4" />
<Property Name="LaborHours" Type="Decimal" Precision="9" Scale="4" />
<Property Name="LotSize" Type="Int32" />
<Property Name="Step" Type="String" MaxLength="1024" Unicode="true" FixedLength="false" />
<Property Name="rowguid" Type="Guid" Nullable="false" />
<Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
</EntityType>
<EntityType Name="vVendor">
<Key>
<PropertyRef Name="VendorID" />
<PropertyRef Name="Name" />
<PropertyRef Name="ContactType" />
<PropertyRef Name="FirstName" />
<PropertyRef Name="LastName" />
<PropertyRef Name="EmailPromotion" />
<PropertyRef Name="AddressLine1" />
<PropertyRef Name="City" />
<PropertyRef Name="StateProvinceName" />
<PropertyRef Name="PostalCode" />
<PropertyRef Name="CountryRegionName" />
</Key>
<Property Name="VendorID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ContactType" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Title" Type="String" MaxLength="8" Unicode="true" FixedLength="false" />
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="MiddleName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="LastName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Suffix" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="Phone" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="EmailAddress" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="EmailPromotion" Type="Int32" Nullable="false" />
<Property Name="AddressLine1" Type="String" Nullable="false" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="AddressLine2" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="City" Type="String" Nullable="false" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="StateProvinceName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="PostalCode" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="CountryRegionName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
</EntityType>
<EntityType Name="vIndividualCustomer">
<Key>
<PropertyRef Name="CustomerID" />
<PropertyRef Name="FirstName" />
<PropertyRef Name="LastName" />
<PropertyRef Name="EmailPromotion" />
<PropertyRef Name="AddressType" />
<PropertyRef Name="AddressLine1" />
<PropertyRef Name="City" />
<PropertyRef Name="StateProvinceName" />
<PropertyRef Name="PostalCode" />
<PropertyRef Name="CountryRegionName" />
</Key>
<Property Name="CustomerID" Type="Int32" Nullable="false" />
<Property Name="Title" Type="String" MaxLength="8" Unicode="true" FixedLength="false" />
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="MiddleName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="LastName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Suffix" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="Phone" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="EmailAddress" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="EmailPromotion" Type="Int32" Nullable="false" />
<Property Name="AddressType" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="AddressLine1" Type="String" Nullable="false" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="AddressLine2" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="City" Type="String" Nullable="false" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="StateProvinceName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="PostalCode" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="CountryRegionName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Demographics" Type="String" MaxLength="Max" Unicode="true" FixedLength="false" />
</EntityType>
<EntityType Name="vIndividualDemographics">
<Key>
<PropertyRef Name="CustomerID" />
</Key>
<Property Name="CustomerID" Type="Int32" Nullable="false" />
<Property Name="TotalPurchaseYTD" Type="Decimal" Precision="19" Scale="4" />
<Property Name="DateFirstPurchase" Type="DateTime" />
<Property Name="BirthDate" Type="DateTime" />
<Property Name="MaritalStatus" Type="String" MaxLength="1" Unicode="true" FixedLength="false" />
<Property Name="YearlyIncome" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="Gender" Type="String" MaxLength="1" Unicode="true" FixedLength="false" />
<Property Name="TotalChildren" Type="Int32" />
<Property Name="NumberChildrenAtHome" Type="Int32" />
<Property Name="Education" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="Occupation" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="HomeOwnerFlag" Type="Boolean" />
<Property Name="NumberCarsOwned" Type="Int32" />
</EntityType>
<EntityType Name="vSalesPerson">
<Key>
<PropertyRef Name="SalesPersonID" />
<PropertyRef Name="FirstName" />
<PropertyRef Name="LastName" />
<PropertyRef Name="JobTitle" />
<PropertyRef Name="EmailPromotion" />
<PropertyRef Name="AddressLine1" />
<PropertyRef Name="City" />
<PropertyRef Name="StateProvinceName" />
<PropertyRef Name="PostalCode" />
<PropertyRef Name="CountryRegionName" />
<PropertyRef Name="SalesYTD" />
<PropertyRef Name="SalesLastYear" />
</Key>
<Property Name="SalesPersonID" Type="Int32" Nullable="false" />
<Property Name="Title" Type="String" MaxLength="8" Unicode="true" FixedLength="false" />
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="MiddleName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="LastName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Suffix" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="JobTitle" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Phone" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="EmailAddress" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="EmailPromotion" Type="Int32" Nullable="false" />
<Property Name="AddressLine1" Type="String" Nullable="false" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="AddressLine2" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="City" Type="String" Nullable="false" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="StateProvinceName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="PostalCode" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="CountryRegionName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="TerritoryName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="TerritoryGroup" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="SalesQuota" Type="Decimal" Precision="19" Scale="4" />
<Property Name="SalesYTD" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
<Property Name="SalesLastYear" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
</EntityType>
<EntityType Name="vSalesPersonSalesByFiscalYears">
<Key>
<PropertyRef Name="Title" />
<PropertyRef Name="SalesTerritory" />
</Key>
<Property Name="SalesPersonID" Type="Int32" />
<Property Name="FullName" Type="String" MaxLength="152" Unicode="true" FixedLength="false" />
<Property Name="Title" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="SalesTerritory" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="C2002" Type="Decimal" Precision="19" Scale="4" />
<Property Name="C2003" Type="Decimal" Precision="19" Scale="4" />
<Property Name="C2004" Type="Decimal" Precision="19" Scale="4" />
</EntityType>
<EntityType Name="vStoreWithDemographics">
<Key>
<PropertyRef Name="CustomerID" />
<PropertyRef Name="Name" />
<PropertyRef Name="ContactType" />
<PropertyRef Name="FirstName" />
<PropertyRef Name="LastName" />
<PropertyRef Name="EmailPromotion" />
<PropertyRef Name="AddressType" />
<PropertyRef Name="AddressLine1" />
<PropertyRef Name="City" />
<PropertyRef Name="StateProvinceName" />
<PropertyRef Name="PostalCode" />
<PropertyRef Name="CountryRegionName" />
</Key>
<Property Name="CustomerID" Type="Int32" Nullable="false" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="ContactType" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Title" Type="String" MaxLength="8" Unicode="true" FixedLength="false" />
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="MiddleName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="LastName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="Suffix" Type="String" MaxLength="10" Unicode="true" FixedLength="false" />
<Property Name="Phone" Type="String" MaxLength="25" Unicode="true" FixedLength="false" />
<Property Name="EmailAddress" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="EmailPromotion" Type="Int32" Nullable="false" />
<Property Name="AddressType" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="AddressLine1" Type="String" Nullable="false" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="AddressLine2" Type="String" MaxLength="60" Unicode="true" FixedLength="false" />
<Property Name="City" Type="String" Nullable="false" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="StateProvinceName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="PostalCode" Type="String" Nullable="false" MaxLength="15" Unicode="true" FixedLength="false" />
<Property Name="CountryRegionName" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="AnnualSales" Type="Decimal" Precision="19" Scale="4" />
<Property Name="AnnualRevenue" Type="Decimal" Precision="19" Scale="4" />
<Property Name="BankName" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="BusinessType" Type="String" MaxLength="5" Unicode="true" FixedLength="false" />
<Property Name="YearOpened" Type="Int32" />
<Property Name="Specialty" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="SquareFeet" Type="Int32" />
<Property Name="Brands" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="Internet" Type="String" MaxLength="30" Unicode="true" FixedLength="false" />
<Property Name="NumberEmployees" Type="Int32" />
</EntityType>
<Association Name="FK_EmployeeDepartmentHistory_Department_DepartmentID">
<End Role="Department" Type="AdventureWorks.Department" Multiplicity="1" />
<End Role="EmployeeDepartmentHistory" Type="AdventureWorks.EmployeeDepartmentHistory" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Department">
<PropertyRef Name="DepartmentID" />
</Principal>
<Dependent Role="EmployeeDepartmentHistory">
<PropertyRef Name="DepartmentID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Employee_Contact_ContactID">
<End Role="Contact" Type="AdventureWorks.Contact" Multiplicity="1" />
<End Role="Employee" Type="AdventureWorks.Employee" Multiplicity="*" />
</Association>
<Association Name="FK_Employee_Employee_ManagerID">
<End Role="Employee" Type="AdventureWorks.Employee" Multiplicity="0..1" />
<End Role="Employee1" Type="AdventureWorks.Employee" Multiplicity="*" />
</Association>
<Association Name="FK_EmployeeAddress_Employee_EmployeeID">
<End Role="Employee" Type="AdventureWorks.Employee" Multiplicity="1" />
<End Role="EmployeeAddress" Type="AdventureWorks.EmployeeAddress" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Employee">
<PropertyRef Name="EmployeeID" />
</Principal>
<Dependent Role="EmployeeAddress">
<PropertyRef Name="EmployeeID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_EmployeeDepartmentHistory_Employee_EmployeeID">
<End Role="Employee" Type="AdventureWorks.Employee" Multiplicity="1" />
<End Role="EmployeeDepartmentHistory" Type="AdventureWorks.EmployeeDepartmentHistory" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Employee">
<PropertyRef Name="EmployeeID" />
</Principal>
<Dependent Role="EmployeeDepartmentHistory">
<PropertyRef Name="EmployeeID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_EmployeePayHistory_Employee_EmployeeID">
<End Role="Employee" Type="AdventureWorks.Employee" Multiplicity="1" />
<End Role="EmployeePayHistory" Type="AdventureWorks.EmployeePayHistory" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Employee">
<PropertyRef Name="EmployeeID" />
</Principal>
<Dependent Role="EmployeePayHistory">
<PropertyRef Name="EmployeeID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_JobCandidate_Employee_EmployeeID">
<End Role="Employee" Type="AdventureWorks.Employee" Multiplicity="0..1" />
<End Role="JobCandidate" Type="AdventureWorks.JobCandidate" Multiplicity="*" />
</Association>
<Association Name="FK_PurchaseOrderHeader_Employee_EmployeeID">
<End Role="Employee" Type="AdventureWorks.Employee" Multiplicity="1" />
<End Role="PurchaseOrderHeader" Type="AdventureWorks.PurchaseOrderHeader" Multiplicity="*" />
</Association>
<Association Name="FK_SalesPerson_Employee_SalesPersonID">
<End Role="Employee" Type="AdventureWorks.Employee" Multiplicity="1" />
<End Role="SalesPerson" Type="AdventureWorks.SalesPerson" Multiplicity="0..1" />
<ReferentialConstraint>
<Principal Role="Employee">
<PropertyRef Name="EmployeeID" />
</Principal>
<Dependent Role="SalesPerson">
<PropertyRef Name="SalesPersonID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_EmployeeAddress_Address_AddressID">
<End Role="Address" Type="AdventureWorks.Address" Multiplicity="1" />
<End Role="EmployeeAddress" Type="AdventureWorks.EmployeeAddress" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Address">
<PropertyRef Name="AddressID" />
</Principal>
<Dependent Role="EmployeeAddress">
<PropertyRef Name="AddressID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_EmployeeDepartmentHistory_Shift_ShiftID">
<End Role="Shift" Type="AdventureWorks.Shift" Multiplicity="1" />
<End Role="EmployeeDepartmentHistory" Type="AdventureWorks.EmployeeDepartmentHistory" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Shift">
<PropertyRef Name="ShiftID" />
</Principal>
<Dependent Role="EmployeeDepartmentHistory">
<PropertyRef Name="ShiftID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Address_StateProvince_StateProvinceID">
<End Role="StateProvince" Type="AdventureWorks.StateProvince" Multiplicity="1" />
<End Role="Address" Type="AdventureWorks.Address" Multiplicity="*" />
</Association>
<Association Name="FK_CustomerAddress_Address_AddressID">
<End Role="Address" Type="AdventureWorks.Address" Multiplicity="1" />
<End Role="CustomerAddress" Type="AdventureWorks.CustomerAddress" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Address">
<PropertyRef Name="AddressID" />
</Principal>
<Dependent Role="CustomerAddress">
<PropertyRef Name="AddressID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_SalesOrderHeader_Address_BillToAddressID">
<End Role="Address" Type="AdventureWorks.Address" Multiplicity="1" />
<End Role="SalesOrderHeader" Type="AdventureWorks.SalesOrderHeader" Multiplicity="*" />
</Association>
<Association Name="FK_SalesOrderHeader_Address_ShipToAddressID">
<End Role="Address" Type="AdventureWorks.Address" Multiplicity="1" />
<End Role="SalesOrderHeader" Type="AdventureWorks.SalesOrderHeader" Multiplicity="*" />
</Association>
<Association Name="FK_VendorAddress_Address_AddressID">
<End Role="Address" Type="AdventureWorks.Address" Multiplicity="1" />
<End Role="VendorAddress" Type="AdventureWorks.VendorAddress" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Address">
<PropertyRef Name="AddressID" />
</Principal>
<Dependent Role="VendorAddress">
<PropertyRef Name="AddressID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_CustomerAddress_AddressType_AddressTypeID">
<End Role="AddressType" Type="AdventureWorks.AddressType" Multiplicity="1" />
<End Role="CustomerAddress" Type="AdventureWorks.CustomerAddress" Multiplicity="*" />
</Association>
<Association Name="FK_VendorAddress_AddressType_AddressTypeID">
<End Role="AddressType" Type="AdventureWorks.AddressType" Multiplicity="1" />
<End Role="VendorAddress" Type="AdventureWorks.VendorAddress" Multiplicity="*" />
</Association>
<Association Name="FK_ContactCreditCard_Contact_ContactID">
<End Role="Contact" Type="AdventureWorks.Contact" Multiplicity="1" />
<End Role="ContactCreditCard" Type="AdventureWorks.ContactCreditCard" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Contact">
<PropertyRef Name="ContactID" />
</Principal>
<Dependent Role="ContactCreditCard">
<PropertyRef Name="ContactID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Individual_Contact_ContactID">
<End Role="Contact" Type="AdventureWorks.Contact" Multiplicity="1" />
<End Role="Individual" Type="AdventureWorks.Individual" Multiplicity="*" />
</Association>
<Association Name="FK_SalesOrderHeader_Contact_ContactID">
<End Role="Contact" Type="AdventureWorks.Contact" Multiplicity="1" />
<End Role="SalesOrderHeader" Type="AdventureWorks.SalesOrderHeader" Multiplicity="*" />
</Association>
<Association Name="FK_StoreContact_Contact_ContactID">
<End Role="Contact" Type="AdventureWorks.Contact" Multiplicity="1" />
<End Role="StoreContact" Type="AdventureWorks.StoreContact" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Contact">
<PropertyRef Name="ContactID" />
</Principal>
<Dependent Role="StoreContact">
<PropertyRef Name="ContactID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_VendorContact_Contact_ContactID">
<End Role="Contact" Type="AdventureWorks.Contact" Multiplicity="1" />
<End Role="VendorContact" Type="AdventureWorks.VendorContact" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Contact">
<PropertyRef Name="ContactID" />
</Principal>
<Dependent Role="VendorContact">
<PropertyRef Name="ContactID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_StoreContact_ContactType_ContactTypeID">
<End Role="ContactType" Type="AdventureWorks.ContactType" Multiplicity="1" />
<End Role="StoreContact" Type="AdventureWorks.StoreContact" Multiplicity="*" />
</Association>
<Association Name="FK_VendorContact_ContactType_ContactTypeID">
<End Role="ContactType" Type="AdventureWorks.ContactType" Multiplicity="1" />
<End Role="VendorContact" Type="AdventureWorks.VendorContact" Multiplicity="*" />
</Association>
<Association Name="FK_CountryRegionCurrency_CountryRegion_CountryRegionCode">
<End Role="CountryRegion" Type="AdventureWorks.CountryRegion" Multiplicity="1" />
<End Role="CountryRegionCurrency" Type="AdventureWorks.CountryRegionCurrency" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="CountryRegion">
<PropertyRef Name="CountryRegionCode" />
</Principal>
<Dependent Role="CountryRegionCurrency">
<PropertyRef Name="CountryRegionCode" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_StateProvince_CountryRegion_CountryRegionCode">
<End Role="CountryRegion" Type="AdventureWorks.CountryRegion" Multiplicity="1" />
<End Role="StateProvince" Type="AdventureWorks.StateProvince" Multiplicity="*" />
</Association>
<Association Name="FK_SalesTaxRate_StateProvince_StateProvinceID">
<End Role="StateProvince" Type="AdventureWorks.StateProvince" Multiplicity="1" />
<End Role="SalesTaxRate" Type="AdventureWorks.SalesTaxRate" Multiplicity="*" />
</Association>
<Association Name="FK_StateProvince_SalesTerritory_TerritoryID">
<End Role="SalesTerritory" Type="AdventureWorks.SalesTerritory" Multiplicity="1" />
<End Role="StateProvince" Type="AdventureWorks.StateProvince" Multiplicity="*" />
</Association>
<Association Name="FK_BillOfMaterials_Product_ComponentID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="BillOfMaterials" Type="AdventureWorks.BillOfMaterials" Multiplicity="*" />
</Association>
<Association Name="FK_BillOfMaterials_Product_ProductAssemblyID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="0..1" />
<End Role="BillOfMaterials" Type="AdventureWorks.BillOfMaterials" Multiplicity="*" />
</Association>
<Association Name="FK_BillOfMaterials_UnitMeasure_UnitMeasureCode">
<End Role="UnitMeasure" Type="AdventureWorks.UnitMeasure" Multiplicity="1" />
<End Role="BillOfMaterials" Type="AdventureWorks.BillOfMaterials" Multiplicity="*" />
</Association>
<Association Name="FK_ProductModelProductDescriptionCulture_Culture_CultureID">
<End Role="Culture" Type="AdventureWorks.Culture" Multiplicity="1" />
<End Role="ProductModelProductDescriptionCulture" Type="AdventureWorks.ProductModelProductDescriptionCulture" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Culture">
<PropertyRef Name="CultureID" />
</Principal>
<Dependent Role="ProductModelProductDescriptionCulture">
<PropertyRef Name="CultureID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ProductDocument_Document_DocumentID">
<End Role="Document" Type="AdventureWorks.Document" Multiplicity="1" />
<End Role="ProductDocument" Type="AdventureWorks.ProductDocument" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Document">
<PropertyRef Name="DocumentID" />
</Principal>
<Dependent Role="ProductDocument">
<PropertyRef Name="DocumentID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ProductModelIllustration_Illustration_IllustrationID">
<End Role="Illustration" Type="AdventureWorks.Illustration" Multiplicity="1" />
<End Role="ProductModelIllustration" Type="AdventureWorks.ProductModelIllustration" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Illustration">
<PropertyRef Name="IllustrationID" />
</Principal>
<Dependent Role="ProductModelIllustration">
<PropertyRef Name="IllustrationID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ProductInventory_Location_LocationID">
<End Role="Location" Type="AdventureWorks.Location" Multiplicity="1" />
<End Role="ProductInventory" Type="AdventureWorks.ProductInventory" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Location">
<PropertyRef Name="LocationID" />
</Principal>
<Dependent Role="ProductInventory">
<PropertyRef Name="LocationID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_WorkOrderRouting_Location_LocationID">
<End Role="Location" Type="AdventureWorks.Location" Multiplicity="1" />
<End Role="WorkOrderRouting" Type="AdventureWorks.WorkOrderRouting" Multiplicity="*" />
</Association>
<Association Name="FK_Product_ProductModel_ProductModelID">
<End Role="ProductModel" Type="AdventureWorks.ProductModel" Multiplicity="0..1" />
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="*" />
</Association>
<Association Name="FK_Product_ProductSubcategory_ProductSubcategoryID">
<End Role="ProductSubcategory" Type="AdventureWorks.ProductSubcategory" Multiplicity="0..1" />
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="*" />
</Association>
<Association Name="FK_Product_UnitMeasure_SizeUnitMeasureCode">
<End Role="UnitMeasure" Type="AdventureWorks.UnitMeasure" Multiplicity="0..1" />
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="*" />
</Association>
<Association Name="FK_Product_UnitMeasure_WeightUnitMeasureCode">
<End Role="UnitMeasure" Type="AdventureWorks.UnitMeasure" Multiplicity="0..1" />
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="*" />
</Association>
<Association Name="FK_ProductCostHistory_Product_ProductID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="ProductCostHistory" Type="AdventureWorks.ProductCostHistory" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Product">
<PropertyRef Name="ProductID" />
</Principal>
<Dependent Role="ProductCostHistory">
<PropertyRef Name="ProductID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ProductDocument_Product_ProductID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="ProductDocument" Type="AdventureWorks.ProductDocument" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Product">
<PropertyRef Name="ProductID" />
</Principal>
<Dependent Role="ProductDocument">
<PropertyRef Name="ProductID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ProductInventory_Product_ProductID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="ProductInventory" Type="AdventureWorks.ProductInventory" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Product">
<PropertyRef Name="ProductID" />
</Principal>
<Dependent Role="ProductInventory">
<PropertyRef Name="ProductID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ProductListPriceHistory_Product_ProductID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="ProductListPriceHistory" Type="AdventureWorks.ProductListPriceHistory" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Product">
<PropertyRef Name="ProductID" />
</Principal>
<Dependent Role="ProductListPriceHistory">
<PropertyRef Name="ProductID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ProductProductPhoto_Product_ProductID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="ProductProductPhoto" Type="AdventureWorks.ProductProductPhoto" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Product">
<PropertyRef Name="ProductID" />
</Principal>
<Dependent Role="ProductProductPhoto">
<PropertyRef Name="ProductID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ProductReview_Product_ProductID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="ProductReview" Type="AdventureWorks.ProductReview" Multiplicity="*" />
</Association>
<Association Name="FK_ProductVendor_Product_ProductID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="ProductVendor" Type="AdventureWorks.ProductVendor" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Product">
<PropertyRef Name="ProductID" />
</Principal>
<Dependent Role="ProductVendor">
<PropertyRef Name="ProductID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_PurchaseOrderDetail_Product_ProductID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="PurchaseOrderDetail" Type="AdventureWorks.PurchaseOrderDetail" Multiplicity="*" />
</Association>
<Association Name="FK_ShoppingCartItem_Product_ProductID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="ShoppingCartItem" Type="AdventureWorks.ShoppingCartItem" Multiplicity="*" />
</Association>
<Association Name="FK_SpecialOfferProduct_Product_ProductID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="SpecialOfferProduct" Type="AdventureWorks.SpecialOfferProduct" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Product">
<PropertyRef Name="ProductID" />
</Principal>
<Dependent Role="SpecialOfferProduct">
<PropertyRef Name="ProductID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_TransactionHistory_Product_ProductID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="TransactionHistory" Type="AdventureWorks.TransactionHistory" Multiplicity="*" />
</Association>
<Association Name="FK_WorkOrder_Product_ProductID">
<End Role="Product" Type="AdventureWorks.Product" Multiplicity="1" />
<End Role="WorkOrder" Type="AdventureWorks.WorkOrder" Multiplicity="*" />
</Association>
<Association Name="FK_ProductSubcategory_ProductCategory_ProductCategoryID">
<End Role="ProductCategory" Type="AdventureWorks.ProductCategory" Multiplicity="1" />
<End Role="ProductSubcategory" Type="AdventureWorks.ProductSubcategory" Multiplicity="*" />
</Association>
<Association Name="FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID">
<End Role="ProductDescription" Type="AdventureWorks.ProductDescription" Multiplicity="1" />
<End Role="ProductModelProductDescriptionCulture" Type="AdventureWorks.ProductModelProductDescriptionCulture" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="ProductDescription">
<PropertyRef Name="ProductDescriptionID" />
</Principal>
<Dependent Role="ProductModelProductDescriptionCulture">
<PropertyRef Name="ProductDescriptionID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ProductModelIllustration_ProductModel_ProductModelID">
<End Role="ProductModel" Type="AdventureWorks.ProductModel" Multiplicity="1" />
<End Role="ProductModelIllustration" Type="AdventureWorks.ProductModelIllustration" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="ProductModel">
<PropertyRef Name="ProductModelID" />
</Principal>
<Dependent Role="ProductModelIllustration">
<PropertyRef Name="ProductModelID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID">
<End Role="ProductModel" Type="AdventureWorks.ProductModel" Multiplicity="1" />
<End Role="ProductModelProductDescriptionCulture" Type="AdventureWorks.ProductModelProductDescriptionCulture" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="ProductModel">
<PropertyRef Name="ProductModelID" />
</Principal>
<Dependent Role="ProductModelProductDescriptionCulture">
<PropertyRef Name="ProductModelID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ProductProductPhoto_ProductPhoto_ProductPhotoID">
<End Role="ProductPhoto" Type="AdventureWorks.ProductPhoto" Multiplicity="1" />
<End Role="ProductProductPhoto" Type="AdventureWorks.ProductProductPhoto" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="ProductPhoto">
<PropertyRef Name="ProductPhotoID" />
</Principal>
<Dependent Role="ProductProductPhoto">
<PropertyRef Name="ProductPhotoID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_WorkOrder_ScrapReason_ScrapReasonID">
<End Role="ScrapReason" Type="AdventureWorks.ScrapReason" Multiplicity="0..1" />
<End Role="WorkOrder" Type="AdventureWorks.WorkOrder" Multiplicity="*" />
</Association>
<Association Name="FK_ProductVendor_UnitMeasure_UnitMeasureCode">
<End Role="UnitMeasure" Type="AdventureWorks.UnitMeasure" Multiplicity="1" />
<End Role="ProductVendor" Type="AdventureWorks.ProductVendor" Multiplicity="*" />
</Association>
<Association Name="FK_WorkOrderRouting_WorkOrder_WorkOrderID">
<End Role="WorkOrder" Type="AdventureWorks.WorkOrder" Multiplicity="1" />
<End Role="WorkOrderRouting" Type="AdventureWorks.WorkOrderRouting" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="WorkOrder">
<PropertyRef Name="WorkOrderID" />
</Principal>
<Dependent Role="WorkOrderRouting">
<PropertyRef Name="WorkOrderID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ProductVendor_Vendor_VendorID">
<End Role="Vendor" Type="AdventureWorks.Vendor" Multiplicity="1" />
<End Role="ProductVendor" Type="AdventureWorks.ProductVendor" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Vendor">
<PropertyRef Name="VendorID" />
</Principal>
<Dependent Role="ProductVendor">
<PropertyRef Name="VendorID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID">
<End Role="PurchaseOrderHeader" Type="AdventureWorks.PurchaseOrderHeader" Multiplicity="1" />
<End Role="PurchaseOrderDetail" Type="AdventureWorks.PurchaseOrderDetail" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="PurchaseOrderHeader">
<PropertyRef Name="PurchaseOrderID" />
</Principal>
<Dependent Role="PurchaseOrderDetail">
<PropertyRef Name="PurchaseOrderID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_PurchaseOrderHeader_ShipMethod_ShipMethodID">
<End Role="ShipMethod" Type="AdventureWorks.ShipMethod" Multiplicity="1" />
<End Role="PurchaseOrderHeader" Type="AdventureWorks.PurchaseOrderHeader" Multiplicity="*" />
</Association>
<Association Name="FK_PurchaseOrderHeader_Vendor_VendorID">
<End Role="Vendor" Type="AdventureWorks.Vendor" Multiplicity="1" />
<End Role="PurchaseOrderHeader" Type="AdventureWorks.PurchaseOrderHeader" Multiplicity="*" />
</Association>
<Association Name="FK_SalesOrderHeader_ShipMethod_ShipMethodID">
<End Role="ShipMethod" Type="AdventureWorks.ShipMethod" Multiplicity="1" />
<End Role="SalesOrderHeader" Type="AdventureWorks.SalesOrderHeader" Multiplicity="*" />
</Association>
<Association Name="FK_VendorAddress_Vendor_VendorID">
<End Role="Vendor" Type="AdventureWorks.Vendor" Multiplicity="1" />
<End Role="VendorAddress" Type="AdventureWorks.VendorAddress" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Vendor">
<PropertyRef Name="VendorID" />
</Principal>
<Dependent Role="VendorAddress">
<PropertyRef Name="VendorID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_VendorContact_Vendor_VendorID">
<End Role="Vendor" Type="AdventureWorks.Vendor" Multiplicity="1" />
<End Role="VendorContact" Type="AdventureWorks.VendorContact" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Vendor">
<PropertyRef Name="VendorID" />
</Principal>
<Dependent Role="VendorContact">
<PropertyRef Name="VendorID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_ContactCreditCard_CreditCard_CreditCardID">
<End Role="CreditCard" Type="AdventureWorks.CreditCard" Multiplicity="1" />
<End Role="ContactCreditCard" Type="AdventureWorks.ContactCreditCard" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="CreditCard">
<PropertyRef Name="CreditCardID" />
</Principal>
<Dependent Role="ContactCreditCard">
<PropertyRef Name="CreditCardID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_CountryRegionCurrency_Currency_CurrencyCode">
<End Role="Currency" Type="AdventureWorks.Currency" Multiplicity="1" />
<End Role="CountryRegionCurrency" Type="AdventureWorks.CountryRegionCurrency" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Currency">
<PropertyRef Name="CurrencyCode" />
</Principal>
<Dependent Role="CountryRegionCurrency">
<PropertyRef Name="CurrencyCode" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_SalesOrderHeader_CreditCard_CreditCardID">
<End Role="CreditCard" Type="AdventureWorks.CreditCard" Multiplicity="0..1" />
<End Role="SalesOrderHeader" Type="AdventureWorks.SalesOrderHeader" Multiplicity="*" />
</Association>
<Association Name="FK_CurrencyRate_Currency_FromCurrencyCode">
<End Role="Currency" Type="AdventureWorks.Currency" Multiplicity="1" />
<End Role="CurrencyRate" Type="AdventureWorks.CurrencyRate" Multiplicity="*" />
</Association>
<Association Name="FK_CurrencyRate_Currency_ToCurrencyCode">
<End Role="Currency" Type="AdventureWorks.Currency" Multiplicity="1" />
<End Role="CurrencyRate" Type="AdventureWorks.CurrencyRate" Multiplicity="*" />
</Association>
<Association Name="FK_SalesOrderHeader_CurrencyRate_CurrencyRateID">
<End Role="CurrencyRate" Type="AdventureWorks.CurrencyRate" Multiplicity="0..1" />
<End Role="SalesOrderHeader" Type="AdventureWorks.SalesOrderHeader" Multiplicity="*" />
</Association>
<Association Name="FK_Customer_SalesTerritory_TerritoryID">
<End Role="SalesTerritory" Type="AdventureWorks.SalesTerritory" Multiplicity="0..1" />
<End Role="Customer" Type="AdventureWorks.Customer" Multiplicity="*" />
</Association>
<Association Name="FK_CustomerAddress_Customer_CustomerID">
<End Role="Customer" Type="AdventureWorks.Customer" Multiplicity="1" />
<End Role="CustomerAddress" Type="AdventureWorks.CustomerAddress" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Customer">
<PropertyRef Name="CustomerID" />
</Principal>
<Dependent Role="CustomerAddress">
<PropertyRef Name="CustomerID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Individual_Customer_CustomerID">
<End Role="Customer" Type="AdventureWorks.Customer" Multiplicity="1" />
<End Role="Individual" Type="AdventureWorks.Individual" Multiplicity="0..1" />
<ReferentialConstraint>
<Principal Role="Customer">
<PropertyRef Name="CustomerID" />
</Principal>
<Dependent Role="Individual">
<PropertyRef Name="CustomerID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_SalesOrderHeader_Customer_CustomerID">
<End Role="Customer" Type="AdventureWorks.Customer" Multiplicity="1" />
<End Role="SalesOrderHeader" Type="AdventureWorks.SalesOrderHeader" Multiplicity="*" />
</Association>
<Association Name="FK_Store_Customer_CustomerID">
<End Role="Customer" Type="AdventureWorks.Customer" Multiplicity="1" />
<End Role="Store" Type="AdventureWorks.Store" Multiplicity="0..1" />
<ReferentialConstraint>
<Principal Role="Customer">
<PropertyRef Name="CustomerID" />
</Principal>
<Dependent Role="Store">
<PropertyRef Name="CustomerID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID">
<End Role="SalesOrderHeader" Type="AdventureWorks.SalesOrderHeader" Multiplicity="1">
<OnDelete Action="Cascade" />
</End>
<End Role="SalesOrderDetail" Type="AdventureWorks.SalesOrderDetail" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="SalesOrderHeader">
<PropertyRef Name="SalesOrderID" />
</Principal>
<Dependent Role="SalesOrderDetail">
<PropertyRef Name="SalesOrderID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID">
<End Role="SpecialOfferProduct" Type="AdventureWorks.SpecialOfferProduct" Multiplicity="1" />
<End Role="SalesOrderDetail" Type="AdventureWorks.SalesOrderDetail" Multiplicity="*" />
</Association>
<Association Name="FK_SalesOrderHeader_SalesPerson_SalesPersonID">
<End Role="SalesPerson" Type="AdventureWorks.SalesPerson" Multiplicity="0..1" />
<End Role="SalesOrderHeader" Type="AdventureWorks.SalesOrderHeader" Multiplicity="*" />
</Association>
<Association Name="FK_SalesOrderHeader_SalesTerritory_TerritoryID">
<End Role="SalesTerritory" Type="AdventureWorks.SalesTerritory" Multiplicity="0..1" />
<End Role="SalesOrderHeader" Type="AdventureWorks.SalesOrderHeader" Multiplicity="*" />
</Association>
<Association Name="FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID">
<End Role="SalesOrderHeader" Type="AdventureWorks.SalesOrderHeader" Multiplicity="1">
<OnDelete Action="Cascade" />
</End>
<End Role="SalesOrderHeaderSalesReason" Type="AdventureWorks.SalesOrderHeaderSalesReason" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="SalesOrderHeader">
<PropertyRef Name="SalesOrderID" />
</Principal>
<Dependent Role="SalesOrderHeaderSalesReason">
<PropertyRef Name="SalesOrderID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID">
<End Role="SalesReason" Type="AdventureWorks.SalesReason" Multiplicity="1" />
<End Role="SalesOrderHeaderSalesReason" Type="AdventureWorks.SalesOrderHeaderSalesReason" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="SalesReason">
<PropertyRef Name="SalesReasonID" />
</Principal>
<Dependent Role="SalesOrderHeaderSalesReason">
<PropertyRef Name="SalesReasonID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_SalesPerson_SalesTerritory_TerritoryID">
<End Role="SalesTerritory" Type="AdventureWorks.SalesTerritory" Multiplicity="0..1" />
<End Role="SalesPerson" Type="AdventureWorks.SalesPerson" Multiplicity="*" />
</Association>
<Association Name="FK_SalesPersonQuotaHistory_SalesPerson_SalesPersonID">
<End Role="SalesPerson" Type="AdventureWorks.SalesPerson" Multiplicity="1" />
<End Role="SalesPersonQuotaHistory" Type="AdventureWorks.SalesPersonQuotaHistory" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="SalesPerson">
<PropertyRef Name="SalesPersonID" />
</Principal>
<Dependent Role="SalesPersonQuotaHistory">
<PropertyRef Name="SalesPersonID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_SalesTerritoryHistory_SalesPerson_SalesPersonID">
<End Role="SalesPerson" Type="AdventureWorks.SalesPerson" Multiplicity="1" />
<End Role="SalesTerritoryHistory" Type="AdventureWorks.SalesTerritoryHistory" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="SalesPerson">
<PropertyRef Name="SalesPersonID" />
</Principal>
<Dependent Role="SalesTerritoryHistory">
<PropertyRef Name="SalesPersonID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Store_SalesPerson_SalesPersonID">
<End Role="SalesPerson" Type="AdventureWorks.SalesPerson" Multiplicity="0..1" />
<End Role="Store" Type="AdventureWorks.Store" Multiplicity="*" />
</Association>
<Association Name="FK_SalesTerritoryHistory_SalesTerritory_TerritoryID">
<End Role="SalesTerritory" Type="AdventureWorks.SalesTerritory" Multiplicity="1" />
<End Role="SalesTerritoryHistory" Type="AdventureWorks.SalesTerritoryHistory" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="SalesTerritory">
<PropertyRef Name="TerritoryID" />
</Principal>
<Dependent Role="SalesTerritoryHistory">
<PropertyRef Name="TerritoryID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID">
<End Role="SpecialOffer" Type="AdventureWorks.SpecialOffer" Multiplicity="1" />
<End Role="SpecialOfferProduct" Type="AdventureWorks.SpecialOfferProduct" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="SpecialOffer">
<PropertyRef Name="SpecialOfferID" />
</Principal>
<Dependent Role="SpecialOfferProduct">
<PropertyRef Name="SpecialOfferID" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_StoreContact_Store_CustomerID">
<End Role="Store" Type="AdventureWorks.Store" Multiplicity="1" />
<End Role="StoreContact" Type="AdventureWorks.StoreContact" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Store">
<PropertyRef Name="CustomerID" />
</Principal>
<Dependent Role="StoreContact">
<PropertyRef Name="CustomerID" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema>