AdventureWorks Complete Conceptual Schema (EDM)

.NET Framework 3.5

The Entity Data Model (EDM) example in this topic defines entities and associations based on the AdventureWorks sample database. Entities and associations are defined in conceptual schema definition language (CSDL).

CSDL Schema

This schema defines a programmable object model corresponding to the tables in the AdventureWorks database. The following schema was generated along with the storage and mapping schemas by using the tool EdmGen.exe as shown in AdventureWorks Complete Model (EDM).

The following schema defines all of the types and associations needed to build programmable objects.

<?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="AdventureWorks" Alias="Self" xmlns="http://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>


See Also

Other Resources

EDM Specifications

Show: