<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx">
  <edmx:Reference Uri="https://sap.github.io/odata-vocabularies/vocabularies/Common.xml">
    <edmx:Include Alias="Common" Namespace="com.sap.vocabularies.Common.v1"/>
  </edmx:Reference>
  <edmx:Reference Uri="https://oasis-tcs.github.io/odata-vocabularies/vocabularies/Org.OData.Core.V1.xml">
    <edmx:Include Alias="Core" Namespace="Org.OData.Core.V1"/>
  </edmx:Reference>
  <edmx:DataServices>
    <Schema Namespace="Northbreeze" xmlns="http://docs.oasis-open.org/odata/ns/edm">
      <EntityContainer Name="EntityContainer">
        <EntitySet Name="Products" EntityType="Northbreeze.Products">
          <NavigationPropertyBinding Path="Category" Target="Categories"/>
          <NavigationPropertyBinding Path="Supplier" Target="Suppliers"/>
        </EntitySet>
        <EntitySet Name="Suppliers" EntityType="Northbreeze.Suppliers">
          <NavigationPropertyBinding Path="Products" Target="Products"/>
        </EntitySet>
        <EntitySet Name="Categories" EntityType="Northbreeze.Categories">
          <NavigationPropertyBinding Path="Products" Target="Products"/>
        </EntitySet>
        <EntitySet Name="Summary_of_Sales_by_Years" EntityType="Northbreeze.Summary_of_Sales_by_Years"/>
        <EntitySet Name="TotalProducts" EntityType="Northbreeze.TotalProducts"/>
        <ActionImport Name="selectProduct" Action="Northbreeze.selectProduct"/>
      </EntityContainer>
      <EntityType Name="Products">
        <Key>
          <PropertyRef Name="ProductID"/>
        </Key>
        <Property Name="ProductID" Type="Edm.Int32" Nullable="false"/>
        <Property Name="ProductName" Type="Edm.String"/>
        <Property Name="QuantityPerUnit" Type="Edm.String"/>
        <Property Name="UnitPrice" Type="Edm.Decimal" Scale="variable"/>
        <NavigationProperty Name="Category" Type="Northbreeze.Categories" Partner="Products">
          <ReferentialConstraint Property="Category_CategoryID" ReferencedProperty="CategoryID"/>
        </NavigationProperty>
        <Property Name="Category_CategoryID" Type="Edm.Int32"/>
        <NavigationProperty Name="Supplier" Type="Northbreeze.Suppliers" Partner="Products">
          <ReferentialConstraint Property="Supplier_SupplierID" ReferencedProperty="SupplierID"/>
        </NavigationProperty>
        <Property Name="Supplier_SupplierID" Type="Edm.Int32"/>
        <Property Name="UnitsInStock" Type="Edm.Int32"/>
        <Property Name="UnitsOnOrder" Type="Edm.Int32"/>
        <Property Name="ReorderLevel" Type="Edm.Int32"/>
        <Property Name="Discontinued" Type="Edm.Boolean"/>
      </EntityType>
      <EntityType Name="Suppliers">
        <Key>
          <PropertyRef Name="SupplierID"/>
        </Key>
        <Property Name="SupplierID" Type="Edm.Int32" Nullable="false"/>
        <Property Name="CompanyName" Type="Edm.String"/>
        <Property Name="ContactName" Type="Edm.String"/>
        <Property Name="ContactTitle" Type="Edm.String"/>
        <Property Name="Address" Type="Edm.String"/>
        <Property Name="City" Type="Edm.String"/>
        <Property Name="Region" Type="Edm.String"/>
        <Property Name="PostalCode" Type="Edm.String"/>
        <Property Name="Country" Type="Edm.String"/>
        <Property Name="Phone" Type="Edm.String"/>
        <Property Name="Fax" Type="Edm.String"/>
        <Property Name="HomePage" Type="Edm.String"/>
        <NavigationProperty Name="Products" Type="Collection(Northbreeze.Products)" Partner="Supplier"/>
      </EntityType>
      <EntityType Name="Categories">
        <Key>
          <PropertyRef Name="CategoryID"/>
        </Key>
        <Property Name="CategoryID" Type="Edm.Int32" Nullable="false"/>
        <Property Name="CategoryName" Type="Edm.String"/>
        <Property Name="Description" Type="Edm.String"/>
        <NavigationProperty Name="Products" Type="Collection(Northbreeze.Products)" Partner="Category"/>
      </EntityType>
      <EntityType Name="Summary_of_Sales_by_Years">
        <Key>
          <PropertyRef Name="OrderID"/>
        </Key>
        <Property Name="OrderID" Type="Edm.Int32" Nullable="false"/>
        <Property Name="ShippedDate" Type="Edm.DateTimeOffset"/>
        <Property Name="Subtotal" Type="Edm.Decimal" Scale="variable"/>
      </EntityType>
      <EntityType Name="TotalProducts">
        <Property Name="count" Type="Edm.Int32"/>
      </EntityType>
      <Action Name="selectProduct" IsBound="false">
        <Parameter Name="communityid" Type="Edm.String"/>
        <ReturnType Type="Edm.String"/>
      </Action>
      <Annotations Target="Northbreeze.TotalProducts/count">
        <Annotation Term="Core.Computed" Bool="true"/>
      </Annotations>
    </Schema>
  </edmx:DataServices>
</edmx:Edmx>