Slice/StoreServer/ModelStore.edmx

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
    <Schema Namespace="gr672_pgvModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <EntityType Name="Cashier">
          <Key>
            <PropertyRef Name="CashierID" />
          </Key>
          <Property Name="CashierID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="IDStore" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Employee">
          <Key>
            <PropertyRef Name="EmployeeID" />
          </Key>
          <Property Name="EmployeeID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="LastName" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="MiddleName" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Code" Type="nvarchar" MaxLength="5" Nullable="false" />
        </EntityType>
        <EntityType Name="EmployeeInStore">
          <Key>
            <PropertyRef Name="IDEmployeeInStore" />
          </Key>
          <Property Name="IDStore" Type="int" Nullable="false" />
          <Property Name="IDEmployee" Type="int" Nullable="false" />
          <Property Name="IDEmployeeInStore" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
        </EntityType>
        <EntityType Name="Order">
          <Key>
            <PropertyRef Name="OrderID" />
          </Key>
          <Property Name="OrderID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Date" Type="date" Nullable="false" />
          <Property Name="IDWorkShift" Type="int" Nullable="false" />
          <Property Name="State" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="PaymentMetod">
          <Key>
            <PropertyRef Name="PaymentMetodID" />
          </Key>
          <Property Name="PaymentMetodID" Type="int" Nullable="false" />
          <Property Name="PaymentMetodName" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="PaymentOrder">
          <Key>
            <PropertyRef Name="PaymentID" />
          </Key>
          <Property Name="PaymentID" Type="int" Nullable="false" />
          <Property Name="IDPaymentMetod" Type="int" Nullable="false" />
          <Property Name="IDOrder" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Product">
          <Key>
            <PropertyRef Name="ProductID" />
          </Key>
          <Property Name="ProductID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="NameProduct" Type="nvarchar(max)" Nullable="false" />
          <Property Name="Weight" Type="int" Nullable="false" />
          <Property Name="Packaging" Type="int" Nullable="false" />
          <Property Name="PriceOfOne" Type="money" Nullable="false" />
          <Property Name="BarCode" Type="nvarchar(max)" Nullable="false" />
        </EntityType>
        <EntityType Name="ProductInOrder">
          <Key>
            <PropertyRef Name="IDOrder" />
            <PropertyRef Name="IDProduct" />
          </Key>
          <Property Name="IDOrder" Type="int" Nullable="false" />
          <Property Name="IDProduct" Type="int" Nullable="false" />
          <Property Name="AmountProduct" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="ProductInStore">
          <Key>
            <PropertyRef Name="ProductInStoreID" />
          </Key>
          <Property Name="ProductInStoreID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="IDStore" Type="int" Nullable="false" />
          <Property Name="IDProduct" Type="int" Nullable="false" />
          <Property Name="RemainsProduct" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Store">
          <Key>
            <PropertyRef Name="StoreID" />
          </Key>
          <Property Name="StoreID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Address" Type="nvarchar(max)" Nullable="false" />
        </EntityType>
        <EntityType Name="WorkShift">
          <Key>
            <PropertyRef Name="WorkShiftID" />
          </Key>
          <Property Name="WorkShiftID" Type="int" Nullable="false" />
          <Property Name="IDCashier" Type="int" Nullable="false" />
          <Property Name="IDEmployee" Type="int" Nullable="false" />
          <Property Name="StartDateAndTimeWork" Type="datetime" Nullable="false" />
          <Property Name="EndDateAndTimeWork" Type="datetime" />
        </EntityType>
        <Association Name="FK_Cashier_Store">
          <End Role="Store" Type="Self.Store" Multiplicity="1" />
          <End Role="Cashier" Type="Self.Cashier" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Store">
              <PropertyRef Name="StoreID" />
            </Principal>
            <Dependent Role="Cashier">
              <PropertyRef Name="IDStore" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeInStore_Employee">
          <End Role="Employee" Type="Self.Employee" Multiplicity="1" />
          <End Role="EmployeeInStore" Type="Self.EmployeeInStore" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employee">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeInStore">
              <PropertyRef Name="IDEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeInStore_Store">
          <End Role="Store" Type="Self.Store" Multiplicity="1" />
          <End Role="EmployeeInStore" Type="Self.EmployeeInStore" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Store">
              <PropertyRef Name="StoreID" />
            </Principal>
            <Dependent Role="EmployeeInStore">
              <PropertyRef Name="IDStore" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Order_WorkShift">
          <End Role="WorkShift" Type="Self.WorkShift" Multiplicity="1" />
          <End Role="Order" Type="Self.Order" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="WorkShift">
              <PropertyRef Name="WorkShiftID" />
            </Principal>
            <Dependent Role="Order">
              <PropertyRef Name="IDWorkShift" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_PaymentOrder_Order">
          <End Role="Order" Type="Self.Order" Multiplicity="1" />
          <End Role="PaymentOrder" Type="Self.PaymentOrder" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Order">
              <PropertyRef Name="OrderID" />
            </Principal>
            <Dependent Role="PaymentOrder">
              <PropertyRef Name="IDOrder" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_PaymentOrder_PaymentMetod">
          <End Role="PaymentMetod" Type="Self.PaymentMetod" Multiplicity="1" />
          <End Role="PaymentOrder" Type="Self.PaymentOrder" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="PaymentMetod">
              <PropertyRef Name="PaymentMetodID" />
            </Principal>
            <Dependent Role="PaymentOrder">
              <PropertyRef Name="IDPaymentMetod" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ProductInOrder_Order">
          <End Role="Order" Type="Self.Order" Multiplicity="1" />
          <End Role="ProductInOrder" Type="Self.ProductInOrder" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Order">
              <PropertyRef Name="OrderID" />
            </Principal>
            <Dependent Role="ProductInOrder">
              <PropertyRef Name="IDOrder" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ProductInOrder_ProductInStore">
          <End Role="ProductInStore" Type="Self.ProductInStore" Multiplicity="1" />
          <End Role="ProductInOrder" Type="Self.ProductInOrder" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ProductInStore">
              <PropertyRef Name="ProductInStoreID" />
            </Principal>
            <Dependent Role="ProductInOrder">
              <PropertyRef Name="IDProduct" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ProductInStore_Product">
          <End Role="Product" Type="Self.Product" Multiplicity="1" />
          <End Role="ProductInStore" Type="Self.ProductInStore" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Product">
              <PropertyRef Name="ProductID" />
            </Principal>
            <Dependent Role="ProductInStore">
              <PropertyRef Name="IDProduct" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ProductInStore_Store">
          <End Role="Store" Type="Self.Store" Multiplicity="1" />
          <End Role="ProductInStore" Type="Self.ProductInStore" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Store">
              <PropertyRef Name="StoreID" />
            </Principal>
            <Dependent Role="ProductInStore">
              <PropertyRef Name="IDStore" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_WorkShift_Cashier">
          <End Role="Cashier" Type="Self.Cashier" Multiplicity="1" />
          <End Role="WorkShift" Type="Self.WorkShift" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Cashier">
              <PropertyRef Name="CashierID" />
            </Principal>
            <Dependent Role="WorkShift">
              <PropertyRef Name="IDCashier" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_WorkShift_EmployeeInStore">
          <End Role="EmployeeInStore" Type="Self.EmployeeInStore" Multiplicity="1" />
          <End Role="WorkShift" Type="Self.WorkShift" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeInStore">
              <PropertyRef Name="IDEmployeeInStore" />
            </Principal>
            <Dependent Role="WorkShift">
              <PropertyRef Name="IDEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="gr672_pgvModelStoreContainer">
          <EntitySet Name="Cashier" EntityType="Self.Cashier" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Employee" EntityType="Self.Employee" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="EmployeeInStore" EntityType="Self.EmployeeInStore" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Order" EntityType="Self.Order" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="PaymentMetod" EntityType="Self.PaymentMetod" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="PaymentOrder" EntityType="Self.PaymentOrder" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Product" EntityType="Self.Product" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ProductInOrder" EntityType="Self.ProductInOrder" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ProductInStore" EntityType="Self.ProductInStore" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Store" EntityType="Self.Store" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="WorkShift" EntityType="Self.WorkShift" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_Cashier_Store" Association="Self.FK_Cashier_Store">
            <End Role="Store" EntitySet="Store" />
            <End Role="Cashier" EntitySet="Cashier" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeInStore_Employee" Association="Self.FK_EmployeeInStore_Employee">
            <End Role="Employee" EntitySet="Employee" />
            <End Role="EmployeeInStore" EntitySet="EmployeeInStore" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeInStore_Store" Association="Self.FK_EmployeeInStore_Store">
            <End Role="Store" EntitySet="Store" />
            <End Role="EmployeeInStore" EntitySet="EmployeeInStore" />
          </AssociationSet>
          <AssociationSet Name="FK_Order_WorkShift" Association="Self.FK_Order_WorkShift">
            <End Role="WorkShift" EntitySet="WorkShift" />
            <End Role="Order" EntitySet="Order" />
          </AssociationSet>
          <AssociationSet Name="FK_PaymentOrder_Order" Association="Self.FK_PaymentOrder_Order">
            <End Role="Order" EntitySet="Order" />
            <End Role="PaymentOrder" EntitySet="PaymentOrder" />
          </AssociationSet>
          <AssociationSet Name="FK_PaymentOrder_PaymentMetod" Association="Self.FK_PaymentOrder_PaymentMetod">
            <End Role="PaymentMetod" EntitySet="PaymentMetod" />
            <End Role="PaymentOrder" EntitySet="PaymentOrder" />
          </AssociationSet>
          <AssociationSet Name="FK_ProductInOrder_Order" Association="Self.FK_ProductInOrder_Order">
            <End Role="Order" EntitySet="Order" />
            <End Role="ProductInOrder" EntitySet="ProductInOrder" />
          </AssociationSet>
          <AssociationSet Name="FK_ProductInOrder_ProductInStore" Association="Self.FK_ProductInOrder_ProductInStore">
            <End Role="ProductInStore" EntitySet="ProductInStore" />
            <End Role="ProductInOrder" EntitySet="ProductInOrder" />
          </AssociationSet>
          <AssociationSet Name="FK_ProductInStore_Product" Association="Self.FK_ProductInStore_Product">
            <End Role="Product" EntitySet="Product" />
            <End Role="ProductInStore" EntitySet="ProductInStore" />
          </AssociationSet>
          <AssociationSet Name="FK_ProductInStore_Store" Association="Self.FK_ProductInStore_Store">
            <End Role="Store" EntitySet="Store" />
            <End Role="ProductInStore" EntitySet="ProductInStore" />
          </AssociationSet>
          <AssociationSet Name="FK_WorkShift_Cashier" Association="Self.FK_WorkShift_Cashier">
            <End Role="Cashier" EntitySet="Cashier" />
            <End Role="WorkShift" EntitySet="WorkShift" />
          </AssociationSet>
          <AssociationSet Name="FK_WorkShift_EmployeeInStore" Association="Self.FK_WorkShift_EmployeeInStore">
            <End Role="EmployeeInStore" EntitySet="EmployeeInStore" />
            <End Role="WorkShift" EntitySet="WorkShift" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="gr672_pgvModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityType Name="Employee">
          <Key>
            <PropertyRef Name="EmployeeID" />
          </Key>
          <Property Name="EmployeeID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="LastName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="MiddleName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Code" Type="String" MaxLength="5" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="EmployeeInStore" Relationship="gr672_pgvModel.FK_EmployeeInStore_Employee" FromRole="Employee" ToRole="EmployeeInStore" />
        </EntityType>
        <EntityType Name="Order">
          <Key>
            <PropertyRef Name="OrderID" />
          </Key>
          <Property Name="OrderID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Date" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="IDWorkShift" Type="Int32" Nullable="false" />
          <Property Name="State" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="WorkShift" Relationship="Self.FK_Order_WorkShift" FromRole="Order" ToRole="WorkShift" />
          <NavigationProperty Name="PaymentOrder" Relationship="Self.FK_PaymentOrder_Order" FromRole="Order" ToRole="PaymentOrder" />
          <NavigationProperty Name="ProductInOrder" Relationship="Self.FK_ProductInOrder_Order" FromRole="Order" ToRole="ProductInOrder" />
        </EntityType>
        <EntityType Name="PaymentMetod">
          <Key>
            <PropertyRef Name="PaymentMetodID" />
          </Key>
          <Property Name="PaymentMetodID" Type="Int32" Nullable="false" />
          <Property Name="PaymentMetodName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="PaymentOrder" Relationship="Self.FK_PaymentOrder_PaymentMetod" FromRole="PaymentMetod" ToRole="PaymentOrder" />
        </EntityType>
        <EntityType Name="PaymentOrder">
          <Key>
            <PropertyRef Name="PaymentID" />
          </Key>
          <Property Name="PaymentID" Type="Int32" Nullable="false" />
          <Property Name="IDPaymentMetod" Type="Int32" Nullable="false" />
          <Property Name="IDOrder" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Order" Relationship="Self.FK_PaymentOrder_Order" FromRole="PaymentOrder" ToRole="Order" />
          <NavigationProperty Name="PaymentMetod" Relationship="Self.FK_PaymentOrder_PaymentMetod" FromRole="PaymentOrder" ToRole="PaymentMetod" />
        </EntityType>
        <EntityType Name="Product">
          <Key>
            <PropertyRef Name="ProductID" />
          </Key>
          <Property Name="ProductID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="NameProduct" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Weight" Type="Int32" Nullable="false" />
          <Property Name="Packaging" Type="Int32" Nullable="false" />
          <Property Name="PriceOfOne" Type="Decimal" Precision="19" Scale="4" Nullable="false" />
          <Property Name="BarCode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="ProductInStore" Relationship="Self.FK_ProductInStore_Product" FromRole="Product" ToRole="ProductInStore" />
        </EntityType>
        <EntityType Name="ProductInOrder">
          <Key>
            <PropertyRef Name="IDOrder" />
            <PropertyRef Name="IDProduct" />
          </Key>
          <Property Name="IDOrder" Type="Int32" Nullable="false" />
          <Property Name="IDProduct" Type="Int32" Nullable="false" />
          <Property Name="AmountProduct" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Order" Relationship="Self.FK_ProductInOrder_Order" FromRole="ProductInOrder" ToRole="Order" />
          <NavigationProperty Name="ProductInStore" Relationship="Self.FK_ProductInOrder_ProductInStore" FromRole="ProductInOrder" ToRole="ProductInStore" />
        </EntityType>
        <EntityType Name="ProductInStore">
          <Key>
            <PropertyRef Name="ProductInStoreID" />
          </Key>
          <Property Name="ProductInStoreID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="IDStore" Type="Int32" Nullable="false" />
          <Property Name="IDProduct" Type="Int32" Nullable="false" />
          <Property Name="RemainsProduct" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Product" Relationship="Self.FK_ProductInStore_Product" FromRole="ProductInStore" ToRole="Product" />
          <NavigationProperty Name="ProductInOrder" Relationship="Self.FK_ProductInOrder_ProductInStore" FromRole="ProductInStore" ToRole="ProductInOrder" />
          <NavigationProperty Name="Store" Relationship="Self.FK_ProductInStore_Store" FromRole="ProductInStore" ToRole="Store" />
        </EntityType>
        <EntityType Name="Store">
          <Key>
            <PropertyRef Name="StoreID" />
          </Key>
          <Property Name="StoreID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Address" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="ProductInStore" Relationship="Self.FK_ProductInStore_Store" FromRole="Store" ToRole="ProductInStore" />
          <NavigationProperty Name="Cashier" Relationship="gr672_pgvModel.FK_Cashier_Store" FromRole="Store" ToRole="Cashier" />
          <NavigationProperty Name="EmployeeInStore" Relationship="gr672_pgvModel.FK_EmployeeInStore_Store" FromRole="Store" ToRole="EmployeeInStore" />
        </EntityType>
        <EntityType Name="WorkShift">
          <Key>
            <PropertyRef Name="WorkShiftID" />
          </Key>
          <Property Name="WorkShiftID" Type="Int32" Nullable="false" />
          <Property Name="IDCashier" Type="Int32" Nullable="false" />
          <Property Name="IDEmployee" Type="Int32" Nullable="false" />
          <Property Name="StartDateAndTimeWork" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="EndDateAndTimeWork" Type="DateTime" Precision="3" />
          <NavigationProperty Name="Order" Relationship="Self.FK_Order_WorkShift" FromRole="WorkShift" ToRole="Order" />
          <NavigationProperty Name="Cashier" Relationship="gr672_pgvModel.FK_WorkShift_Cashier" FromRole="WorkShift" ToRole="Cashier" />
          <NavigationProperty Name="EmployeeInStore" Relationship="gr672_pgvModel.FK_WorkShift_EmployeeInStore" FromRole="WorkShift" ToRole="EmployeeInStore" />
        </EntityType>
        <Association Name="FK_Order_WorkShift">
          <End Role="WorkShift" Type="Self.WorkShift" Multiplicity="1" />
          <End Role="Order" Type="Self.Order" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="WorkShift">
              <PropertyRef Name="WorkShiftID" />
            </Principal>
            <Dependent Role="Order">
              <PropertyRef Name="IDWorkShift" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_PaymentOrder_Order">
          <End Role="Order" Type="Self.Order" Multiplicity="1" />
          <End Role="PaymentOrder" Type="Self.PaymentOrder" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Order">
              <PropertyRef Name="OrderID" />
            </Principal>
            <Dependent Role="PaymentOrder">
              <PropertyRef Name="IDOrder" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ProductInOrder_Order">
          <End Role="Order" Type="Self.Order" Multiplicity="1" />
          <End Role="ProductInOrder" Type="Self.ProductInOrder" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Order">
              <PropertyRef Name="OrderID" />
            </Principal>
            <Dependent Role="ProductInOrder">
              <PropertyRef Name="IDOrder" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_PaymentOrder_PaymentMetod">
          <End Role="PaymentMetod" Type="Self.PaymentMetod" Multiplicity="1" />
          <End Role="PaymentOrder" Type="Self.PaymentOrder" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="PaymentMetod">
              <PropertyRef Name="PaymentMetodID" />
            </Principal>
            <Dependent Role="PaymentOrder">
              <PropertyRef Name="IDPaymentMetod" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ProductInStore_Product">
          <End Role="Product" Type="Self.Product" Multiplicity="1" />
          <End Role="ProductInStore" Type="Self.ProductInStore" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Product">
              <PropertyRef Name="ProductID" />
            </Principal>
            <Dependent Role="ProductInStore">
              <PropertyRef Name="IDProduct" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ProductInOrder_ProductInStore">
          <End Role="ProductInStore" Type="Self.ProductInStore" Multiplicity="1" />
          <End Role="ProductInOrder" Type="Self.ProductInOrder" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ProductInStore">
              <PropertyRef Name="ProductInStoreID" />
            </Principal>
            <Dependent Role="ProductInOrder">
              <PropertyRef Name="IDProduct" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ProductInStore_Store">
          <End Role="Store" Type="Self.Store" Multiplicity="1" />
          <End Role="ProductInStore" Type="Self.ProductInStore" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Store">
              <PropertyRef Name="StoreID" />
            </Principal>
            <Dependent Role="ProductInStore">
              <PropertyRef Name="IDStore" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="gr672_pgvEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Employee" EntityType="Self.Employee" />
          <EntitySet Name="Order" EntityType="Self.Order" />
          <EntitySet Name="PaymentMetod" EntityType="Self.PaymentMetod" />
          <EntitySet Name="PaymentOrder" EntityType="Self.PaymentOrder" />
          <EntitySet Name="Product" EntityType="Self.Product" />
          <EntitySet Name="ProductInOrder" EntityType="Self.ProductInOrder" />
          <EntitySet Name="ProductInStore" EntityType="Self.ProductInStore" />
          <EntitySet Name="Store" EntityType="Self.Store" />
          <EntitySet Name="WorkShift" EntityType="Self.WorkShift" />
          <AssociationSet Name="FK_Order_WorkShift" Association="Self.FK_Order_WorkShift">
            <End Role="WorkShift" EntitySet="WorkShift" />
            <End Role="Order" EntitySet="Order" />
          </AssociationSet>
          <AssociationSet Name="FK_PaymentOrder_Order" Association="Self.FK_PaymentOrder_Order">
            <End Role="Order" EntitySet="Order" />
            <End Role="PaymentOrder" EntitySet="PaymentOrder" />
          </AssociationSet>
          <AssociationSet Name="FK_ProductInOrder_Order" Association="Self.FK_ProductInOrder_Order">
            <End Role="Order" EntitySet="Order" />
            <End Role="ProductInOrder" EntitySet="ProductInOrder" />
          </AssociationSet>
          <AssociationSet Name="FK_PaymentOrder_PaymentMetod" Association="Self.FK_PaymentOrder_PaymentMetod">
            <End Role="PaymentMetod" EntitySet="PaymentMetod" />
            <End Role="PaymentOrder" EntitySet="PaymentOrder" />
          </AssociationSet>
          <AssociationSet Name="FK_ProductInStore_Product" Association="Self.FK_ProductInStore_Product">
            <End Role="Product" EntitySet="Product" />
            <End Role="ProductInStore" EntitySet="ProductInStore" />
          </AssociationSet>
          <AssociationSet Name="FK_ProductInOrder_ProductInStore" Association="Self.FK_ProductInOrder_ProductInStore">
            <End Role="ProductInStore" EntitySet="ProductInStore" />
            <End Role="ProductInOrder" EntitySet="ProductInOrder" />
          </AssociationSet>
          <AssociationSet Name="FK_ProductInStore_Store" Association="Self.FK_ProductInStore_Store">
            <End Role="Store" EntitySet="Store" />
            <End Role="ProductInStore" EntitySet="ProductInStore" />
          </AssociationSet>
          <EntitySet Name="Cashier" EntityType="gr672_pgvModel.Cashier" />
          <AssociationSet Name="FK_Cashier_Store" Association="gr672_pgvModel.FK_Cashier_Store">
            <End Role="Store" EntitySet="Store" />
            <End Role="Cashier" EntitySet="Cashier" />
          </AssociationSet>
          <AssociationSet Name="FK_WorkShift_Cashier" Association="gr672_pgvModel.FK_WorkShift_Cashier">
            <End Role="Cashier" EntitySet="Cashier" />
            <End Role="WorkShift" EntitySet="WorkShift" />
          </AssociationSet>
          <EntitySet Name="EmployeeInStore" EntityType="gr672_pgvModel.EmployeeInStore" />
          <AssociationSet Name="FK_EmployeeInStore_Employee" Association="gr672_pgvModel.FK_EmployeeInStore_Employee">
            <End Role="Employee" EntitySet="Employee" />
            <End Role="EmployeeInStore" EntitySet="EmployeeInStore" />
          </AssociationSet>
          <AssociationSet Name="FK_EmployeeInStore_Store" Association="gr672_pgvModel.FK_EmployeeInStore_Store">
            <End Role="Store" EntitySet="Store" />
            <End Role="EmployeeInStore" EntitySet="EmployeeInStore" />
          </AssociationSet>
          <AssociationSet Name="FK_WorkShift_EmployeeInStore" Association="gr672_pgvModel.FK_WorkShift_EmployeeInStore">
            <End Role="EmployeeInStore" EntitySet="EmployeeInStore" />
            <End Role="WorkShift" EntitySet="WorkShift" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="Cashier">
          <Key>
            <PropertyRef Name="CashierID" />
          </Key>
          <Property Name="CashierID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="IDStore" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Store" Relationship="gr672_pgvModel.FK_Cashier_Store" FromRole="Cashier" ToRole="Store" />
          <NavigationProperty Name="WorkShift" Relationship="gr672_pgvModel.FK_WorkShift_Cashier" FromRole="Cashier" ToRole="WorkShift" />
        </EntityType>
        <Association Name="FK_Cashier_Store">
          <End Type="gr672_pgvModel.Store" Role="Store" Multiplicity="1" />
          <End Type="gr672_pgvModel.Cashier" Role="Cashier" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Store">
              <PropertyRef Name="StoreID" />
            </Principal>
            <Dependent Role="Cashier">
              <PropertyRef Name="IDStore" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_WorkShift_Cashier">
          <End Type="gr672_pgvModel.Cashier" Role="Cashier" Multiplicity="1" />
          <End Type="gr672_pgvModel.WorkShift" Role="WorkShift" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Cashier">
              <PropertyRef Name="CashierID" />
            </Principal>
            <Dependent Role="WorkShift">
              <PropertyRef Name="IDCashier" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="EmployeeInStore">
          <Key>
            <PropertyRef Name="IDEmployeeInStore" />
          </Key>
          <Property Name="IDStore" Type="Int32" Nullable="false" />
          <Property Name="IDEmployee" Type="Int32" Nullable="false" />
          <Property Name="IDEmployeeInStore" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <NavigationProperty Name="Employee" Relationship="gr672_pgvModel.FK_EmployeeInStore_Employee" FromRole="EmployeeInStore" ToRole="Employee" />
          <NavigationProperty Name="Store" Relationship="gr672_pgvModel.FK_EmployeeInStore_Store" FromRole="EmployeeInStore" ToRole="Store" />
          <NavigationProperty Name="WorkShift" Relationship="gr672_pgvModel.FK_WorkShift_EmployeeInStore" FromRole="EmployeeInStore" ToRole="WorkShift" />
        </EntityType>
        <Association Name="FK_EmployeeInStore_Employee">
          <End Type="gr672_pgvModel.Employee" Role="Employee" Multiplicity="1" />
          <End Type="gr672_pgvModel.EmployeeInStore" Role="EmployeeInStore" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employee">
              <PropertyRef Name="EmployeeID" />
            </Principal>
            <Dependent Role="EmployeeInStore">
              <PropertyRef Name="IDEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EmployeeInStore_Store">
          <End Type="gr672_pgvModel.Store" Role="Store" Multiplicity="1" />
          <End Type="gr672_pgvModel.EmployeeInStore" Role="EmployeeInStore" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Store">
              <PropertyRef Name="StoreID" />
            </Principal>
            <Dependent Role="EmployeeInStore">
              <PropertyRef Name="IDStore" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_WorkShift_EmployeeInStore">
          <End Type="gr672_pgvModel.EmployeeInStore" Role="EmployeeInStore" Multiplicity="1" />
          <End Type="gr672_pgvModel.WorkShift" Role="WorkShift" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="EmployeeInStore">
              <PropertyRef Name="IDEmployeeInStore" />
            </Principal>
            <Dependent Role="WorkShift">
              <PropertyRef Name="IDEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="gr672_pgvModelStoreContainer" CdmEntityContainer="gr672_pgvEntities">
          <EntitySetMapping Name="Employee">
            <EntityTypeMapping TypeName="gr672_pgvModel.Employee">
              <MappingFragment StoreEntitySet="Employee">
                <ScalarProperty Name="EmployeeID" ColumnName="EmployeeID" />
                <ScalarProperty Name="LastName" ColumnName="LastName" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
                <ScalarProperty Name="Code" ColumnName="Code" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Order">
            <EntityTypeMapping TypeName="gr672_pgvModel.Order">
              <MappingFragment StoreEntitySet="Order">
                <ScalarProperty Name="OrderID" ColumnName="OrderID" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="IDWorkShift" ColumnName="IDWorkShift" />
                <ScalarProperty Name="State" ColumnName="State" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="PaymentMetod">
            <EntityTypeMapping TypeName="gr672_pgvModel.PaymentMetod">
              <MappingFragment StoreEntitySet="PaymentMetod">
                <ScalarProperty Name="PaymentMetodID" ColumnName="PaymentMetodID" />
                <ScalarProperty Name="PaymentMetodName" ColumnName="PaymentMetodName" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="PaymentOrder">
            <EntityTypeMapping TypeName="gr672_pgvModel.PaymentOrder">
              <MappingFragment StoreEntitySet="PaymentOrder">
                <ScalarProperty Name="PaymentID" ColumnName="PaymentID" />
                <ScalarProperty Name="IDPaymentMetod" ColumnName="IDPaymentMetod" />
                <ScalarProperty Name="IDOrder" ColumnName="IDOrder" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Product">
            <EntityTypeMapping TypeName="gr672_pgvModel.Product">
              <MappingFragment StoreEntitySet="Product">
                <ScalarProperty Name="ProductID" ColumnName="ProductID" />
                <ScalarProperty Name="NameProduct" ColumnName="NameProduct" />
                <ScalarProperty Name="Weight" ColumnName="Weight" />
                <ScalarProperty Name="Packaging" ColumnName="Packaging" />
                <ScalarProperty Name="PriceOfOne" ColumnName="PriceOfOne" />
                <ScalarProperty Name="BarCode" ColumnName="BarCode" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ProductInOrder">
            <EntityTypeMapping TypeName="gr672_pgvModel.ProductInOrder">
              <MappingFragment StoreEntitySet="ProductInOrder">
                <ScalarProperty Name="IDOrder" ColumnName="IDOrder" />
                <ScalarProperty Name="IDProduct" ColumnName="IDProduct" />
                <ScalarProperty Name="AmountProduct" ColumnName="AmountProduct" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ProductInStore">
            <EntityTypeMapping TypeName="gr672_pgvModel.ProductInStore">
              <MappingFragment StoreEntitySet="ProductInStore">
                <ScalarProperty Name="ProductInStoreID" ColumnName="ProductInStoreID" />
                <ScalarProperty Name="IDStore" ColumnName="IDStore" />
                <ScalarProperty Name="IDProduct" ColumnName="IDProduct" />
                <ScalarProperty Name="RemainsProduct" ColumnName="RemainsProduct" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Store">
            <EntityTypeMapping TypeName="gr672_pgvModel.Store">
              <MappingFragment StoreEntitySet="Store">
                <ScalarProperty Name="StoreID" ColumnName="StoreID" />
                <ScalarProperty Name="Address" ColumnName="Address" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="WorkShift">
            <EntityTypeMapping TypeName="gr672_pgvModel.WorkShift">
              <MappingFragment StoreEntitySet="WorkShift">
                <ScalarProperty Name="WorkShiftID" ColumnName="WorkShiftID" />
                <ScalarProperty Name="IDCashier" ColumnName="IDCashier" />
                <ScalarProperty Name="IDEmployee" ColumnName="IDEmployee" />
                <ScalarProperty Name="StartDateAndTimeWork" ColumnName="StartDateAndTimeWork" />
                <ScalarProperty Name="EndDateAndTimeWork" ColumnName="EndDateAndTimeWork" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Cashier">
            <EntityTypeMapping TypeName="gr672_pgvModel.Cashier">
              <MappingFragment StoreEntitySet="Cashier">
                <ScalarProperty Name="IDStore" ColumnName="IDStore" />
                <ScalarProperty Name="CashierID" ColumnName="CashierID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="EmployeeInStore">
            <EntityTypeMapping TypeName="gr672_pgvModel.EmployeeInStore">
              <MappingFragment StoreEntitySet="EmployeeInStore">
                <ScalarProperty Name="IDEmployeeInStore" ColumnName="IDEmployeeInStore" />
                <ScalarProperty Name="IDEmployee" ColumnName="IDEmployee" />
                <ScalarProperty Name="IDStore" ColumnName="IDStore" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="false" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
        <DesignerProperty Name="UseLegacyProvider" Value="false" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>