﻿<?xml version="1.0" encoding="utf-16"?>
<edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx">
  <edmx:DataServices>
    <Schema Namespace="CMPDO" xmlns="http://docs.oasis-open.org/odata/ns/edm">
      <EntityContainer Name="CMPDO">
        <EntitySet Name="Category" EntityType="CMPDO.Category" />
        <EntitySet Name="Customer" EntityType="CMPDO.Customer" />
        <EntitySet Name="Employee" EntityType="CMPDO.Employee">
          <NavigationPropertyBinding Path="Reportsto" Target="Employee" />
        </EntitySet>
        <EntitySet Name="Order" EntityType="CMPDO.Order">
          <NavigationPropertyBinding Path="Customersorders" Target="Customer" />
          <NavigationPropertyBinding Path="Employeesorders" Target="Employee" />
          <NavigationPropertyBinding Path="Shippersorders" Target="Shipper" />
        </EntitySet>
        <ActionImport Name="OrdiniPerAnno" Action="CMPDO.OrdiniPerAnno" EntitySet="Order" />
        <ActionImport Name="OrdiniPerCliente" Action="CMPDO.OrdiniPerCliente" EntitySet="Order" />
        <EntitySet Name="Orderdetail" EntityType="CMPDO.Orderdetail">
          <NavigationPropertyBinding Path="OrderdetailsOrders" Target="Order" />
          <NavigationPropertyBinding Path="ProductdetailsOrders" Target="Product" />
        </EntitySet>
        <EntitySet Name="Product" EntityType="CMPDO.Product">
          <NavigationPropertyBinding Path="Suppliersproducts" Target="Supplier" />
          <NavigationPropertyBinding Path="Categoriessproducts" Target="Category" />
        </EntitySet>
        <EntitySet Name="Shipper" EntityType="CMPDO.Shipper" />
        <EntitySet Name="Supplier" EntityType="CMPDO.Supplier" />
      </EntityContainer>
      <EntityType Name="Category">
        <Key>
          <PropertyRef Name="CategoryID" />
        </Key>
        <Property Name="CategoryID" Nullable="false" d5p1:StoreGeneratedPattern="Identity" Type="Edm.Int64" xmlns:d5p1="http://schemas.microsoft.com/ado/2009/02/edm/annotation" />
        <Property Name="CategoryName" Nullable="false" Type="Edm.String" MaxLength="15" />
        <Property Name="Description" Type="Edm.String" MaxLength="9999" />
        <Property Name="Picture" Type="Edm.Binary" />
        <NavigationProperty Name="Products" Type="Collection(CMPDO.Product)" Partner="Categoriessproducts" />
      </EntityType>
      <EntityType Name="Customer">
        <Key>
          <PropertyRef Name="CustomerID" />
        </Key>
        <Property Name="CustomerID" Nullable="false" Type="Edm.String" MaxLength="5" />
        <Property Name="CompanyName" Nullable="false" Type="Edm.String" MaxLength="40" />
        <Property Name="ContactName" Type="Edm.String" MaxLength="30" />
        <Property Name="ContactTitle" Type="Edm.String" MaxLength="30" />
        <Property Name="Address" Type="Edm.String" MaxLength="60" />
        <Property Name="City" Type="Edm.String" MaxLength="15" />
        <Property Name="Region" Type="Edm.String" MaxLength="15" />
        <Property Name="Postalcode" Type="Edm.String" MaxLength="10" />
        <Property Name="Country" Type="Edm.String" MaxLength="15" />
        <Property Name="Phone" Type="Edm.String" MaxLength="24" />
        <Property Name="Fax" Type="Edm.String" MaxLength="24" />
      </EntityType>
      <EntityType Name="Employee">
        <Key>
          <PropertyRef Name="EmployeeID" />
        </Key>
        <Property Name="EmployeeID" Nullable="false" d5p1:StoreGeneratedPattern="Identity" Type="Edm.Int64" xmlns:d5p1="http://schemas.microsoft.com/ado/2009/02/edm/annotation" />
        <Property Name="LastName" Nullable="false" Type="Edm.String" MaxLength="20" />
        <Property Name="FirstName" Nullable="false" Type="Edm.String" MaxLength="10" />
        <Property Name="Title" Type="Edm.String" MaxLength="30" />
        <Property Name="TitleOfCourtesy" Type="Edm.String" MaxLength="25" />
        <Property Name="BirthDate" Type="Edm.Date" />
        <Property Name="HireDate" Type="Edm.Date" />
        <Property Name="Address" Type="Edm.String" MaxLength="60" />
        <Property Name="City" Type="Edm.String" MaxLength="15" />
        <Property Name="Region" Type="Edm.String" MaxLength="15" />
        <Property Name="PostalCode" Type="Edm.String" MaxLength="10" />
        <Property Name="Country" Type="Edm.String" MaxLength="15" />
        <Property Name="HomePhone" Type="Edm.String" MaxLength="24" />
        <Property Name="Extension" Type="Edm.String" MaxLength="4" />
        <Property Name="Photo" Type="Edm.Binary" />
        <Property Name="Notes" Type="Edm.String" MaxLength="9999" />
        <Property Name="Reportsto" Type="Edm.Int64" />
        <NavigationProperty Name="Reportsto" Type="CMPDO.Employee">
          <ReferentialConstraint Property="Reportsto" ReferencedProperty="EmployeeID" />
        </NavigationProperty>
      </EntityType>
      <EntityType Name="Order">
        <Key>
          <PropertyRef Name="OrderID" />
        </Key>
        <Property Name="OrderID" Nullable="false" d5p1:StoreGeneratedPattern="Identity" Type="Edm.Int64" xmlns:d5p1="http://schemas.microsoft.com/ado/2009/02/edm/annotation" />
        <Property Name="CustomerID" Type="Edm.String" MaxLength="5" />
        <Property Name="EmployeeID" Type="Edm.Int64" />
        <Property Name="OrderDate" Type="Edm.Date" />
        <Property Name="RequiredDate" Type="Edm.Date" />
        <Property Name="ShippedDate" Type="Edm.Date" />
        <Property Name="ShipVia" Type="Edm.Int64" />
        <Property Name="Freight" Type="Edm.Decimal" Precision="19" Scale="6" />
        <Property Name="ShipName" Type="Edm.String" MaxLength="40" />
        <Property Name="ShipAddress" Type="Edm.String" MaxLength="60" />
        <Property Name="ShipCity" Type="Edm.String" MaxLength="15" />
        <Property Name="ShipRegion" Type="Edm.String" MaxLength="15" />
        <Property Name="ShipPostalCode" Type="Edm.String" MaxLength="10" />
        <Property Name="ShipCountry" Type="Edm.String" MaxLength="15" />
        <NavigationProperty Name="Customersorders" Type="CMPDO.Customer">
          <ReferentialConstraint Property="CustomerID" ReferencedProperty="CustomerID" />
        </NavigationProperty>
        <NavigationProperty Name="Employeesorders" Type="CMPDO.Employee">
          <ReferentialConstraint Property="EmployeeID" ReferencedProperty="EmployeeID" />
        </NavigationProperty>
        <NavigationProperty Name="Shippersorders" Type="CMPDO.Shipper">
          <ReferentialConstraint Property="ShipVia" ReferencedProperty="ShipperID" />
        </NavigationProperty>
        <NavigationProperty Name="OrderDetails" Type="Collection(CMPDO.Orderdetail)" Partner="OrderdetailsOrders" />
      </EntityType>
      <Action Name="OrdiniPerAnno">
        <ReturnType Type="Edm.String" />
      </Action>
      <Action Name="OrdiniPerCliente">
        <ReturnType Type="Edm.String" />
      </Action>
      <EntityType Name="Orderdetail">
        <Key>
          <PropertyRef Name="OrderID" />
          <PropertyRef Name="ProductID" />
        </Key>
        <Property Name="OrderID" Nullable="false" Type="Edm.Int64" />
        <Property Name="ProductID" Nullable="false" Type="Edm.Int64" />
        <Property Name="UnitPrice" Nullable="false" Type="Edm.Decimal" Precision="19" Scale="6" />
        <Property Name="Quantity" Nullable="false" Type="Edm.Int64" />
        <Property Name="Discount" Nullable="false" Type="Edm.Double" />
        <NavigationProperty Name="OrderdetailsOrders" Type="CMPDO.Order" Partner="OrderDetails">
          <ReferentialConstraint Property="OrderID" ReferencedProperty="OrderID" />
        </NavigationProperty>
        <NavigationProperty Name="ProductdetailsOrders" Type="CMPDO.Product">
          <ReferentialConstraint Property="ProductID" ReferencedProperty="ProductID" />
        </NavigationProperty>
      </EntityType>
      <EntityType Name="Product">
        <Key>
          <PropertyRef Name="ProductID" />
        </Key>
        <Property Name="ProductID" Nullable="false" d5p1:StoreGeneratedPattern="Identity" Type="Edm.Int64" xmlns:d5p1="http://schemas.microsoft.com/ado/2009/02/edm/annotation" />
        <Property Name="ProductName" Nullable="false" Type="Edm.String" MaxLength="40" />
        <Property Name="SupplierID" Type="Edm.Int64" />
        <Property Name="CategoryID" Type="Edm.Int64" />
        <Property Name="QuantityPerUnit" Type="Edm.String" MaxLength="20" />
        <Property Name="UnitPrice" Type="Edm.Decimal" Precision="19" Scale="6" />
        <Property Name="UnitsInStock" Type="Edm.Int32" />
        <Property Name="UnitsOnOrder" Type="Edm.Int32" />
        <Property Name="ReorderLevel" Type="Edm.Int32" />
        <Property Name="Discontinued" Nullable="false" Type="CMPDO.DiscontinuedTypes" />
        <NavigationProperty Name="Suppliersproducts" Type="CMPDO.Supplier">
          <ReferentialConstraint Property="SupplierID" ReferencedProperty="SupplierID" />
        </NavigationProperty>
        <NavigationProperty Name="Categoriessproducts" Type="CMPDO.Category" Partner="Products">
          <ReferentialConstraint Property="CategoryID" ReferencedProperty="CategoryID" />
        </NavigationProperty>
      </EntityType>
      <EnumType Name="DiscontinuedTypes">
        <Member Name="true" Value="-1" />
        <Member Name="false" Value="0" />
      </EnumType>
      <EntityType Name="Shipper">
        <Key>
          <PropertyRef Name="ShipperID" />
        </Key>
        <Property Name="ShipperID" Nullable="false" d5p1:StoreGeneratedPattern="Identity" Type="Edm.Int64" xmlns:d5p1="http://schemas.microsoft.com/ado/2009/02/edm/annotation" />
        <Property Name="CompanyName" Nullable="false" Type="Edm.String" MaxLength="40" />
        <Property Name="Phone" Type="Edm.String" MaxLength="24" />
      </EntityType>
      <EntityType Name="Supplier">
        <Key>
          <PropertyRef Name="SupplierID" />
        </Key>
        <Property Name="SupplierID" Nullable="false" d5p1:StoreGeneratedPattern="Identity" Type="Edm.Int64" xmlns:d5p1="http://schemas.microsoft.com/ado/2009/02/edm/annotation" />
        <Property Name="CompanyName" Nullable="false" Type="Edm.String" MaxLength="40" />
        <Property Name="ContactName" Type="Edm.String" MaxLength="30" />
        <Property Name="ContactTitle" Type="Edm.String" MaxLength="30" />
        <Property Name="Address" Type="Edm.String" MaxLength="60" />
        <Property Name="City" Type="Edm.String" MaxLength="15" />
        <Property Name="Region" Type="Edm.String" MaxLength="15" />
        <Property Name="Postalcode" Type="Edm.String" MaxLength="10" />
        <Property Name="Country" Type="Edm.String" MaxLength="15" />
        <Property Name="Phone" Type="Edm.String" MaxLength="24" />
        <Property Name="Fax" Type="Edm.String" MaxLength="24" />
        <Property Name="HomePage" Type="Edm.String" MaxLength="9999" />
      </EntityType>
    </Schema>
  </edmx:DataServices>
</edmx:Edmx>