Schéma conceptuel complet AdventureWorks (EDM)
L'exemple de modèle EDM (Modèle de données d'entité) de cette rubrique définit des entités et des associations basées sur l'exemple de base de données AdventureWorks. Les entités et les associations sont définies en langage CSDL (Conceptual Schema Definition Language).
Schéma CSDL
Ce schéma définit un modèle objet programmable qui correspond aux tables dans la base de données AdventureWorks. Le schéma ci-dessous a été généré avec les schémas de stockage et de mappage à l'aide de l'outil EdmGen.exe, tel qu'indiqué dans Modèle complet AdventureWorks (EDM).
Le schéma suivant définit tous les types et associations nécessaires pour générer des objets programmables.
<?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>