UIFIS/OUP/Model1.edmx

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
      <Schema Namespace="Хранилище gr606_sosanModel" Provider="System.Data.SqlClient" ProviderManifestToken="2008" 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/02/edm/ssdl">
        <EntityType Name="Address">
          <Key>
            <PropertyRef Name="IdAddress" />
          </Key>
          <Property Name="IdAddress" Type="int" Nullable="false" />
          <Property Name="Street" Type="nvarchar" MaxLength="100" Nullable="false" />
          <Property Name="Number" Type="int" Nullable="false" />
          <Property Name="HouseNumber" Type="int" Nullable="false" />
          <Property Name="Flat" Type="int" Nullable="false" />
          <Property Name="IdEmployee" Type="int" />
        </EntityType>
        <EntityType Name="CardAmount">
          <Key>
            <PropertyRef Name="IdCard" />
          </Key>
          <Property Name="IdCard" Type="int" Nullable="false" />
          <Property Name="Sum" Type="money" />
          <Property Name="PaymentName" Type="nvarchar" MaxLength="50" />
          <Property Name="IdPay" Type="int" />
        </EntityType>
        <EntityType Name="Cash">
          <Key>
            <PropertyRef Name="IdCash" />
          </Key>
          <Property Name="IdCash" Type="int" Nullable="false" />
          <Property Name="Sum" Type="money" />
          <Property Name="PaymentName" Type="nvarchar" MaxLength="50" />
          <Property Name="IdPay" Type="int" />
        </EntityType>
        <EntityType Name="CashRegister">
          <Key>
            <PropertyRef Name="IdCashRegistre" />
          </Key>
          <Property Name="IdCashRegistre" Type="int" Nullable="false" />
          <Property Name="IdEmployee" Type="int" />
          <Property Name="IdProduct" Type="int" />
          <Property Name="IdSurrender" Type="int" />
          <Property Name="IdDate" Type="int" />
          <Property Name="IdPay" Type="int" />
        </EntityType>
        <EntityType Name="Dates">
          <Key>
            <PropertyRef Name="IdDate" />
          </Key>
          <Property Name="IdDate" Type="int" Nullable="false" />
          <Property Name="Date" Type="date" />
        </EntityType>
        <EntityType Name="Employees">
          <Key>
            <PropertyRef Name="IdEmployee" />
          </Key>
          <Property Name="IdEmployee" Type="int" Nullable="false" />
          <Property Name="Surname" Type="nvarchar" MaxLength="100" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="100" Nullable="false" />
          <Property Name="Patronymic" Type="nvarchar" MaxLength="100" Nullable="false" />
          <Property Name="TelephoneNumber" Type="nvarchar" MaxLength="20" Nullable="false" />
          <Property Name="Email" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Login" Type="nvarchar" MaxLength="20" Nullable="false" />
          <Property Name="Password" Type="nvarchar" MaxLength="20" Nullable="false" />
        </EntityType>
        <EntityType Name="PasportDetails">
          <Key>
            <PropertyRef Name="IdDetail" />
          </Key>
          <Property Name="IdDetail" Type="int" Nullable="false" />
          <Property Name="Number" Type="int" Nullable="false" />
          <Property Name="Series" Type="int" Nullable="false" />
          <Property Name="IssuedBy" Type="nvarchar" MaxLength="150" Nullable="false" />
          <Property Name="IdEmployee" Type="int" />
        </EntityType>
        <EntityType Name="Payment">
          <Key>
            <PropertyRef Name="IdPay" />
          </Key>
          <Property Name="IdPay" Type="int" Nullable="false" />
          <Property Name="HistoryAboutPayment" Type="nvarchar" MaxLength="255" />
        </EntityType>
        <EntityType Name="Product">
          <Key>
            <PropertyRef Name="IdProduct" />
          </Key>
          <Property Name="IdProduct" Type="int" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="100" Nullable="false" />
          <Property Name="Manufacture" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="ProductGroup" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="Cost" Type="money" Nullable="false" />
          <Property Name="TypeOfProduct" Type="nvarchar" MaxLength="100" Nullable="false" />
          <Property Name="Bardcode" Type="int" Nullable="false" />
          <Property Name="Margin" Type="money" Nullable="false" />
          <Property Name="Quantity" Type="int" Nullable="false" />
          <Property Name="Discount" Type="money" Nullable="false" />
          <Property Name="Unit" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="VAT" Type="money" />
        </EntityType>
        <EntityType Name="Revenue">
          <Key>
            <PropertyRef Name="IdRevenue" />
          </Key>
          <Property Name="IdRevenue" Type="int" Nullable="false" />
          <Property Name="SumRevenue" Type="money" />
          <Property Name="IdEmployee" Type="int" />
        </EntityType>
        <EntityType Name="SuppliersProduct">
          <Key>
            <PropertyRef Name="IdSupplier" />
          </Key>
          <Property Name="IdSupplier" Type="int" Nullable="false" />
          <Property Name="CompanyName" Type="nvarchar" MaxLength="255" Nullable="false" />
          <Property Name="IdSupply" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="SupplyProduct">
          <Key>
            <PropertyRef Name="IdSupply" />
          </Key>
          <Property Name="IdSupply" Type="int" Nullable="false" />
          <Property Name="QuantityDeliveredProduct" Type="int" Nullable="false" />
          <Property Name="CostDeliveredProduct" Type="money" Nullable="false" />
          <Property Name="IdProduct" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="SurrenderOfMoney">
          <Key>
            <PropertyRef Name="IdSurrender" />
          </Key>
          <Property Name="IdSurrender" Type="int" Nullable="false" />
          <Property Name="Sum" Type="money" />
          <Property Name="NumberOfChecks" Type="int" />
        </EntityType>
        <EntityType Name="WorkingShift">
          <Key>
            <PropertyRef Name="IdShift" />
          </Key>
          <Property Name="IdShift" Type="int" Nullable="false" />
          <Property Name="NameShift" Type="nvarchar" MaxLength="100" Nullable="false" />
          <Property Name="IdEmployee" Type="int" />
        </EntityType>
        <Association Name="FK_Address_Employees">
          <End Role="Employees" Type="Self.Employees" Multiplicity="0..1" />
          <End Role="Address" Type="Self.Address" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="IdEmployee" />
            </Principal>
            <Dependent Role="Address">
              <PropertyRef Name="IdEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CardAmount_Payment">
          <End Role="Payment" Type="Self.Payment" Multiplicity="0..1" />
          <End Role="CardAmount" Type="Self.CardAmount" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Payment">
              <PropertyRef Name="IdPay" />
            </Principal>
            <Dependent Role="CardAmount">
              <PropertyRef Name="IdPay" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Cash_Payment">
          <End Role="Payment" Type="Self.Payment" Multiplicity="0..1" />
          <End Role="Cash" Type="Self.Cash" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Payment">
              <PropertyRef Name="IdPay" />
            </Principal>
            <Dependent Role="Cash">
              <PropertyRef Name="IdPay" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CashRegister_Dates">
          <End Role="Dates" Type="Self.Dates" Multiplicity="0..1" />
          <End Role="CashRegister" Type="Self.CashRegister" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Dates">
              <PropertyRef Name="IdDate" />
            </Principal>
            <Dependent Role="CashRegister">
              <PropertyRef Name="IdDate" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CashRegister_Employees">
          <End Role="Employees" Type="Self.Employees" Multiplicity="0..1" />
          <End Role="CashRegister" Type="Self.CashRegister" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="IdEmployee" />
            </Principal>
            <Dependent Role="CashRegister">
              <PropertyRef Name="IdEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CashRegister_Payment">
          <End Role="Payment" Type="Self.Payment" Multiplicity="0..1" />
          <End Role="CashRegister" Type="Self.CashRegister" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Payment">
              <PropertyRef Name="IdPay" />
            </Principal>
            <Dependent Role="CashRegister">
              <PropertyRef Name="IdPay" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CashRegister_Product">
          <End Role="Product" Type="Self.Product" Multiplicity="0..1" />
          <End Role="CashRegister" Type="Self.CashRegister" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Product">
              <PropertyRef Name="IdProduct" />
            </Principal>
            <Dependent Role="CashRegister">
              <PropertyRef Name="IdProduct" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CashRegister_SurrenderOfMoney">
          <End Role="SurrenderOfMoney" Type="Self.SurrenderOfMoney" Multiplicity="0..1" />
          <End Role="CashRegister" Type="Self.CashRegister" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="SurrenderOfMoney">
              <PropertyRef Name="IdSurrender" />
            </Principal>
            <Dependent Role="CashRegister">
              <PropertyRef Name="IdSurrender" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_PasportDetails_Employees">
          <End Role="Employees" Type="Self.Employees" Multiplicity="0..1" />
          <End Role="PasportDetails" Type="Self.PasportDetails" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="IdEmployee" />
            </Principal>
            <Dependent Role="PasportDetails">
              <PropertyRef Name="IdEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Revenue_Employees">
          <End Role="Employees" Type="Self.Employees" Multiplicity="0..1" />
          <End Role="Revenue" Type="Self.Revenue" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="IdEmployee" />
            </Principal>
            <Dependent Role="Revenue">
              <PropertyRef Name="IdEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_SuppliersProduct_SupplyProduct">
          <End Role="SupplyProduct" Type="Self.SupplyProduct" Multiplicity="1" />
          <End Role="SuppliersProduct" Type="Self.SuppliersProduct" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="SupplyProduct">
              <PropertyRef Name="IdSupply" />
            </Principal>
            <Dependent Role="SuppliersProduct">
              <PropertyRef Name="IdSupply" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_SupplyProduct_Product">
          <End Role="Product" Type="Self.Product" Multiplicity="1" />
          <End Role="SupplyProduct" Type="Self.SupplyProduct" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Product">
              <PropertyRef Name="IdProduct" />
            </Principal>
            <Dependent Role="SupplyProduct">
              <PropertyRef Name="IdProduct" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_WorkingShift_Employees">
          <End Role="Employees" Type="Self.Employees" Multiplicity="0..1" />
          <End Role="WorkingShift" Type="Self.WorkingShift" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="IdEmployee" />
            </Principal>
            <Dependent Role="WorkingShift">
              <PropertyRef Name="IdEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Хранилище gr606_sosanModelContainer">
          <EntitySet Name="Address" EntityType="Self.Address" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="CardAmount" EntityType="Self.CardAmount" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Cash" EntityType="Self.Cash" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="CashRegister" EntityType="Self.CashRegister" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Dates" EntityType="Self.Dates" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Employees" EntityType="Self.Employees" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="PasportDetails" EntityType="Self.PasportDetails" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Payment" EntityType="Self.Payment" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Product" EntityType="Self.Product" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Revenue" EntityType="Self.Revenue" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="SuppliersProduct" EntityType="Self.SuppliersProduct" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="SupplyProduct" EntityType="Self.SupplyProduct" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="SurrenderOfMoney" EntityType="Self.SurrenderOfMoney" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="WorkingShift" EntityType="Self.WorkingShift" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_Address_Employees" Association="Self.FK_Address_Employees">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="Address" EntitySet="Address" />
          </AssociationSet>
          <AssociationSet Name="FK_CardAmount_Payment" Association="Self.FK_CardAmount_Payment">
            <End Role="Payment" EntitySet="Payment" />
            <End Role="CardAmount" EntitySet="CardAmount" />
          </AssociationSet>
          <AssociationSet Name="FK_Cash_Payment" Association="Self.FK_Cash_Payment">
            <End Role="Payment" EntitySet="Payment" />
            <End Role="Cash" EntitySet="Cash" />
          </AssociationSet>
          <AssociationSet Name="FK_CashRegister_Dates" Association="Self.FK_CashRegister_Dates">
            <End Role="Dates" EntitySet="Dates" />
            <End Role="CashRegister" EntitySet="CashRegister" />
          </AssociationSet>
          <AssociationSet Name="FK_CashRegister_Employees" Association="Self.FK_CashRegister_Employees">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="CashRegister" EntitySet="CashRegister" />
          </AssociationSet>
          <AssociationSet Name="FK_CashRegister_Payment" Association="Self.FK_CashRegister_Payment">
            <End Role="Payment" EntitySet="Payment" />
            <End Role="CashRegister" EntitySet="CashRegister" />
          </AssociationSet>
          <AssociationSet Name="FK_CashRegister_Product" Association="Self.FK_CashRegister_Product">
            <End Role="Product" EntitySet="Product" />
            <End Role="CashRegister" EntitySet="CashRegister" />
          </AssociationSet>
          <AssociationSet Name="FK_CashRegister_SurrenderOfMoney" Association="Self.FK_CashRegister_SurrenderOfMoney">
            <End Role="SurrenderOfMoney" EntitySet="SurrenderOfMoney" />
            <End Role="CashRegister" EntitySet="CashRegister" />
          </AssociationSet>
          <AssociationSet Name="FK_PasportDetails_Employees" Association="Self.FK_PasportDetails_Employees">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="PasportDetails" EntitySet="PasportDetails" />
          </AssociationSet>
          <AssociationSet Name="FK_Revenue_Employees" Association="Self.FK_Revenue_Employees">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="Revenue" EntitySet="Revenue" />
          </AssociationSet>
          <AssociationSet Name="FK_SuppliersProduct_SupplyProduct" Association="Self.FK_SuppliersProduct_SupplyProduct">
            <End Role="SupplyProduct" EntitySet="SupplyProduct" />
            <End Role="SuppliersProduct" EntitySet="SuppliersProduct" />
          </AssociationSet>
          <AssociationSet Name="FK_SupplyProduct_Product" Association="Self.FK_SupplyProduct_Product">
            <End Role="Product" EntitySet="Product" />
            <End Role="SupplyProduct" EntitySet="SupplyProduct" />
          </AssociationSet>
          <AssociationSet Name="FK_WorkingShift_Employees" Association="Self.FK_WorkingShift_Employees">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="WorkingShift" EntitySet="WorkingShift" />
          </AssociationSet>
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="gr606_sosanModel" Alias="Self" 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/2008/09/edm">
        <EntityType Name="Address">
          <Key>
            <PropertyRef Name="IdAddress" />
          </Key>
          <Property Name="IdAddress" Type="Int32" Nullable="false" />
          <Property Name="Street" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Number" Type="Int32" Nullable="false" />
          <Property Name="HouseNumber" Type="Int32" Nullable="false" />
          <Property Name="Flat" Type="Int32" Nullable="false" />
          <Property Name="IdEmployee" Type="Int32" />
          <NavigationProperty Name="Employees" Relationship="Self.FK_Address_Employees" FromRole="Address" ToRole="Employees" />
        </EntityType>
        <EntityType Name="CardAmount">
          <Key>
            <PropertyRef Name="IdCard" />
          </Key>
          <Property Name="IdCard" Type="Int32" Nullable="false" />
          <Property Name="Sum" Type="Decimal" Precision="19" Scale="4" />
          <Property Name="PaymentName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="IdPay" Type="Int32" />
          <NavigationProperty Name="Payment" Relationship="Self.FK_CardAmount_Payment" FromRole="CardAmount" ToRole="Payment" />
        </EntityType>
        <EntityType Name="Cash">
          <Key>
            <PropertyRef Name="IdCash" />
          </Key>
          <Property Name="IdCash" Type="Int32" Nullable="false" />
          <Property Name="Sum" Type="Decimal" Precision="19" Scale="4" />
          <Property Name="PaymentName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="IdPay" Type="Int32" />
          <NavigationProperty Name="Payment" Relationship="Self.FK_Cash_Payment" FromRole="Cash" ToRole="Payment" />
        </EntityType>
        <EntityType Name="CashRegister">
          <Key>
            <PropertyRef Name="IdCashRegistre" />
          </Key>
          <Property Name="IdCashRegistre" Type="Int32" Nullable="false" />
          <Property Name="IdEmployee" Type="Int32" />
          <Property Name="IdProduct" Type="Int32" />
          <Property Name="IdSurrender" Type="Int32" />
          <Property Name="IdDate" Type="Int32" />
          <Property Name="IdPay" Type="Int32" />
          <NavigationProperty Name="Dates" Relationship="Self.FK_CashRegister_Dates" FromRole="CashRegister" ToRole="Dates" />
          <NavigationProperty Name="Employees" Relationship="Self.FK_CashRegister_Employees" FromRole="CashRegister" ToRole="Employees" />
          <NavigationProperty Name="Payment" Relationship="Self.FK_CashRegister_Payment" FromRole="CashRegister" ToRole="Payment" />
          <NavigationProperty Name="Product" Relationship="Self.FK_CashRegister_Product" FromRole="CashRegister" ToRole="Product" />
          <NavigationProperty Name="SurrenderOfMoney" Relationship="Self.FK_CashRegister_SurrenderOfMoney" FromRole="CashRegister" ToRole="SurrenderOfMoney" />
        </EntityType>
        <EntityType Name="Dates">
          <Key>
            <PropertyRef Name="IdDate" />
          </Key>
          <Property Name="IdDate" Type="Int32" Nullable="false" />
          <Property Name="Date" Type="DateTime" Precision="0" />
          <NavigationProperty Name="CashRegister" Relationship="Self.FK_CashRegister_Dates" FromRole="Dates" ToRole="CashRegister" />
        </EntityType>
        <EntityType Name="Employees">
          <Key>
            <PropertyRef Name="IdEmployee" />
          </Key>
          <Property Name="IdEmployee" Type="Int32" Nullable="false" />
          <Property Name="Surname" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Patronymic" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="TelephoneNumber" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Email" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Login" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Password" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="Address" Relationship="Self.FK_Address_Employees" FromRole="Employees" ToRole="Address" />
          <NavigationProperty Name="CashRegister" Relationship="Self.FK_CashRegister_Employees" FromRole="Employees" ToRole="CashRegister" />
          <NavigationProperty Name="PasportDetails" Relationship="Self.FK_PasportDetails_Employees" FromRole="Employees" ToRole="PasportDetails" />
          <NavigationProperty Name="Revenue" Relationship="Self.FK_Revenue_Employees" FromRole="Employees" ToRole="Revenue" />
          <NavigationProperty Name="WorkingShift" Relationship="Self.FK_WorkingShift_Employees" FromRole="Employees" ToRole="WorkingShift" />
        </EntityType>
        <EntityType Name="PasportDetails">
          <Key>
            <PropertyRef Name="IdDetail" />
          </Key>
          <Property Name="IdDetail" Type="Int32" Nullable="false" />
          <Property Name="Number" Type="Int32" Nullable="false" />
          <Property Name="Series" Type="Int32" Nullable="false" />
          <Property Name="IssuedBy" Type="String" MaxLength="150" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="IdEmployee" Type="Int32" />
          <NavigationProperty Name="Employees" Relationship="Self.FK_PasportDetails_Employees" FromRole="PasportDetails" ToRole="Employees" />
        </EntityType>
        <EntityType Name="Payment">
          <Key>
            <PropertyRef Name="IdPay" />
          </Key>
          <Property Name="IdPay" Type="Int32" Nullable="false" />
          <Property Name="HistoryAboutPayment" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="CardAmount" Relationship="Self.FK_CardAmount_Payment" FromRole="Payment" ToRole="CardAmount" />
          <NavigationProperty Name="Cash" Relationship="Self.FK_Cash_Payment" FromRole="Payment" ToRole="Cash" />
          <NavigationProperty Name="CashRegister" Relationship="Self.FK_CashRegister_Payment" FromRole="Payment" ToRole="CashRegister" />
        </EntityType>
        <EntityType Name="Product">
          <Key>
            <PropertyRef Name="IdProduct" />
          </Key>
          <Property Name="IdProduct" Type="Int32" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Manufacture" Type="String" MaxLength="255" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="ProductGroup" Type="String" MaxLength="255" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Cost" Type="Decimal" Precision="19" Scale="4" Nullable="false" />
          <Property Name="TypeOfProduct" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Bardcode" Type="Int32" Nullable="false" />
          <Property Name="Margin" Type="Decimal" Precision="19" Scale="4" Nullable="false" />
          <Property Name="Quantity" Type="Int32" Nullable="false" />
          <Property Name="Discount" Type="Decimal" Precision="19" Scale="4" Nullable="false" />
          <Property Name="Unit" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="VAT" Type="Decimal" Precision="19" Scale="4" />
          <NavigationProperty Name="CashRegister" Relationship="Self.FK_CashRegister_Product" FromRole="Product" ToRole="CashRegister" />
          <NavigationProperty Name="SupplyProduct" Relationship="Self.FK_SupplyProduct_Product" FromRole="Product" ToRole="SupplyProduct" />
        </EntityType>
        <EntityType Name="Revenue">
          <Key>
            <PropertyRef Name="IdRevenue" />
          </Key>
          <Property Name="IdRevenue" Type="Int32" Nullable="false" />
          <Property Name="SumRevenue" Type="Decimal" Precision="19" Scale="4" />
          <Property Name="IdEmployee" Type="Int32" />
          <NavigationProperty Name="Employees" Relationship="Self.FK_Revenue_Employees" FromRole="Revenue" ToRole="Employees" />
        </EntityType>
        <EntityType Name="SuppliersProduct">
          <Key>
            <PropertyRef Name="IdSupplier" />
          </Key>
          <Property Name="IdSupplier" Type="Int32" Nullable="false" />
          <Property Name="CompanyName" Type="String" MaxLength="255" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="IdSupply" Type="Int32" Nullable="false" />
          <NavigationProperty Name="SupplyProduct" Relationship="Self.FK_SuppliersProduct_SupplyProduct" FromRole="SuppliersProduct" ToRole="SupplyProduct" />
        </EntityType>
        <EntityType Name="SupplyProduct">
          <Key>
            <PropertyRef Name="IdSupply" />
          </Key>
          <Property Name="IdSupply" Type="Int32" Nullable="false" />
          <Property Name="QuantityDeliveredProduct" Type="Int32" Nullable="false" />
          <Property Name="CostDeliveredProduct" Type="Decimal" Precision="19" Scale="4" Nullable="false" />
          <Property Name="IdProduct" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Product" Relationship="Self.FK_SupplyProduct_Product" FromRole="SupplyProduct" ToRole="Product" />
          <NavigationProperty Name="SuppliersProduct" Relationship="Self.FK_SuppliersProduct_SupplyProduct" FromRole="SupplyProduct" ToRole="SuppliersProduct" />
        </EntityType>
        <EntityType Name="SurrenderOfMoney">
          <Key>
            <PropertyRef Name="IdSurrender" />
          </Key>
          <Property Name="IdSurrender" Type="Int32" Nullable="false" />
          <Property Name="Sum" Type="Decimal" Precision="19" Scale="4" />
          <Property Name="NumberOfChecks" Type="Int32" />
          <NavigationProperty Name="CashRegister" Relationship="Self.FK_CashRegister_SurrenderOfMoney" FromRole="SurrenderOfMoney" ToRole="CashRegister" />
        </EntityType>
        <EntityType Name="WorkingShift">
          <Key>
            <PropertyRef Name="IdShift" />
          </Key>
          <Property Name="IdShift" Type="Int32" Nullable="false" />
          <Property Name="NameShift" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="IdEmployee" Type="Int32" />
          <NavigationProperty Name="Employees" Relationship="Self.FK_WorkingShift_Employees" FromRole="WorkingShift" ToRole="Employees" />
        </EntityType>
        <Association Name="FK_Address_Employees">
          <End Role="Employees" Type="Self.Employees" Multiplicity="0..1" />
          <End Role="Address" Type="Self.Address" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="IdEmployee" />
            </Principal>
            <Dependent Role="Address">
              <PropertyRef Name="IdEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CardAmount_Payment">
          <End Role="Payment" Type="Self.Payment" Multiplicity="0..1" />
          <End Role="CardAmount" Type="Self.CardAmount" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Payment">
              <PropertyRef Name="IdPay" />
            </Principal>
            <Dependent Role="CardAmount">
              <PropertyRef Name="IdPay" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Cash_Payment">
          <End Role="Payment" Type="Self.Payment" Multiplicity="0..1" />
          <End Role="Cash" Type="Self.Cash" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Payment">
              <PropertyRef Name="IdPay" />
            </Principal>
            <Dependent Role="Cash">
              <PropertyRef Name="IdPay" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CashRegister_Dates">
          <End Role="Dates" Type="Self.Dates" Multiplicity="0..1" />
          <End Role="CashRegister" Type="Self.CashRegister" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Dates">
              <PropertyRef Name="IdDate" />
            </Principal>
            <Dependent Role="CashRegister">
              <PropertyRef Name="IdDate" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CashRegister_Employees">
          <End Role="Employees" Type="Self.Employees" Multiplicity="0..1" />
          <End Role="CashRegister" Type="Self.CashRegister" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="IdEmployee" />
            </Principal>
            <Dependent Role="CashRegister">
              <PropertyRef Name="IdEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CashRegister_Payment">
          <End Role="Payment" Type="Self.Payment" Multiplicity="0..1" />
          <End Role="CashRegister" Type="Self.CashRegister" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Payment">
              <PropertyRef Name="IdPay" />
            </Principal>
            <Dependent Role="CashRegister">
              <PropertyRef Name="IdPay" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CashRegister_Product">
          <End Role="Product" Type="Self.Product" Multiplicity="0..1" />
          <End Role="CashRegister" Type="Self.CashRegister" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Product">
              <PropertyRef Name="IdProduct" />
            </Principal>
            <Dependent Role="CashRegister">
              <PropertyRef Name="IdProduct" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CashRegister_SurrenderOfMoney">
          <End Role="SurrenderOfMoney" Type="Self.SurrenderOfMoney" Multiplicity="0..1" />
          <End Role="CashRegister" Type="Self.CashRegister" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="SurrenderOfMoney">
              <PropertyRef Name="IdSurrender" />
            </Principal>
            <Dependent Role="CashRegister">
              <PropertyRef Name="IdSurrender" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_PasportDetails_Employees">
          <End Role="Employees" Type="Self.Employees" Multiplicity="0..1" />
          <End Role="PasportDetails" Type="Self.PasportDetails" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="IdEmployee" />
            </Principal>
            <Dependent Role="PasportDetails">
              <PropertyRef Name="IdEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Revenue_Employees">
          <End Role="Employees" Type="Self.Employees" Multiplicity="0..1" />
          <End Role="Revenue" Type="Self.Revenue" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="IdEmployee" />
            </Principal>
            <Dependent Role="Revenue">
              <PropertyRef Name="IdEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_WorkingShift_Employees">
          <End Role="Employees" Type="Self.Employees" Multiplicity="0..1" />
          <End Role="WorkingShift" Type="Self.WorkingShift" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="IdEmployee" />
            </Principal>
            <Dependent Role="WorkingShift">
              <PropertyRef Name="IdEmployee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_SupplyProduct_Product">
          <End Role="Product" Type="Self.Product" Multiplicity="1" />
          <End Role="SupplyProduct" Type="Self.SupplyProduct" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Product">
              <PropertyRef Name="IdProduct" />
            </Principal>
            <Dependent Role="SupplyProduct">
              <PropertyRef Name="IdProduct" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_SuppliersProduct_SupplyProduct">
          <End Role="SupplyProduct" Type="Self.SupplyProduct" Multiplicity="1" />
          <End Role="SuppliersProduct" Type="Self.SuppliersProduct" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="SupplyProduct">
              <PropertyRef Name="IdSupply" />
            </Principal>
            <Dependent Role="SuppliersProduct">
              <PropertyRef Name="IdSupply" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Address" EntityType="Self.Address" />
          <EntitySet Name="CardAmount" EntityType="Self.CardAmount" />
          <EntitySet Name="Cash" EntityType="Self.Cash" />
          <EntitySet Name="CashRegister" EntityType="Self.CashRegister" />
          <EntitySet Name="Dates" EntityType="Self.Dates" />
          <EntitySet Name="Employees" EntityType="Self.Employees" />
          <EntitySet Name="PasportDetails" EntityType="Self.PasportDetails" />
          <EntitySet Name="Payment" EntityType="Self.Payment" />
          <EntitySet Name="Product" EntityType="Self.Product" />
          <EntitySet Name="Revenue" EntityType="Self.Revenue" />
          <EntitySet Name="SuppliersProduct" EntityType="Self.SuppliersProduct" />
          <EntitySet Name="SupplyProduct" EntityType="Self.SupplyProduct" />
          <EntitySet Name="SurrenderOfMoney" EntityType="Self.SurrenderOfMoney" />
          <EntitySet Name="WorkingShift" EntityType="Self.WorkingShift" />
          <AssociationSet Name="FK_Address_Employees" Association="Self.FK_Address_Employees">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="Address" EntitySet="Address" />
          </AssociationSet>
          <AssociationSet Name="FK_CardAmount_Payment" Association="Self.FK_CardAmount_Payment">
            <End Role="Payment" EntitySet="Payment" />
            <End Role="CardAmount" EntitySet="CardAmount" />
          </AssociationSet>
          <AssociationSet Name="FK_Cash_Payment" Association="Self.FK_Cash_Payment">
            <End Role="Payment" EntitySet="Payment" />
            <End Role="Cash" EntitySet="Cash" />
          </AssociationSet>
          <AssociationSet Name="FK_CashRegister_Dates" Association="Self.FK_CashRegister_Dates">
            <End Role="Dates" EntitySet="Dates" />
            <End Role="CashRegister" EntitySet="CashRegister" />
          </AssociationSet>
          <AssociationSet Name="FK_CashRegister_Employees" Association="Self.FK_CashRegister_Employees">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="CashRegister" EntitySet="CashRegister" />
          </AssociationSet>
          <AssociationSet Name="FK_CashRegister_Payment" Association="Self.FK_CashRegister_Payment">
            <End Role="Payment" EntitySet="Payment" />
            <End Role="CashRegister" EntitySet="CashRegister" />
          </AssociationSet>
          <AssociationSet Name="FK_CashRegister_Product" Association="Self.FK_CashRegister_Product">
            <End Role="Product" EntitySet="Product" />
            <End Role="CashRegister" EntitySet="CashRegister" />
          </AssociationSet>
          <AssociationSet Name="FK_CashRegister_SurrenderOfMoney" Association="Self.FK_CashRegister_SurrenderOfMoney">
            <End Role="SurrenderOfMoney" EntitySet="SurrenderOfMoney" />
            <End Role="CashRegister" EntitySet="CashRegister" />
          </AssociationSet>
          <AssociationSet Name="FK_PasportDetails_Employees" Association="Self.FK_PasportDetails_Employees">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="PasportDetails" EntitySet="PasportDetails" />
          </AssociationSet>
          <AssociationSet Name="FK_Revenue_Employees" Association="Self.FK_Revenue_Employees">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="Revenue" EntitySet="Revenue" />
          </AssociationSet>
          <AssociationSet Name="FK_WorkingShift_Employees" Association="Self.FK_WorkingShift_Employees">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="WorkingShift" EntitySet="WorkingShift" />
          </AssociationSet>
          <AssociationSet Name="FK_SupplyProduct_Product" Association="Self.FK_SupplyProduct_Product">
            <End Role="Product" EntitySet="Product" />
            <End Role="SupplyProduct" EntitySet="SupplyProduct" />
          </AssociationSet>
          <AssociationSet Name="FK_SuppliersProduct_SupplyProduct" Association="Self.FK_SuppliersProduct_SupplyProduct">
            <End Role="SupplyProduct" EntitySet="SupplyProduct" />
            <End Role="SuppliersProduct" EntitySet="SuppliersProduct" />
          </AssociationSet>
        </EntityContainer>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="Хранилище gr606_sosanModelContainer" CdmEntityContainer="Entities">
          <EntitySetMapping Name="Address">
            <EntityTypeMapping TypeName="gr606_sosanModel.Address">
              <MappingFragment StoreEntitySet="Address">
                <ScalarProperty Name="IdAddress" ColumnName="IdAddress" />
                <ScalarProperty Name="Street" ColumnName="Street" />
                <ScalarProperty Name="Number" ColumnName="Number" />
                <ScalarProperty Name="HouseNumber" ColumnName="HouseNumber" />
                <ScalarProperty Name="Flat" ColumnName="Flat" />
                <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="CardAmount">
            <EntityTypeMapping TypeName="gr606_sosanModel.CardAmount">
              <MappingFragment StoreEntitySet="CardAmount">
                <ScalarProperty Name="IdCard" ColumnName="IdCard" />
                <ScalarProperty Name="Sum" ColumnName="Sum" />
                <ScalarProperty Name="PaymentName" ColumnName="PaymentName" />
                <ScalarProperty Name="IdPay" ColumnName="IdPay" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Cash">
            <EntityTypeMapping TypeName="gr606_sosanModel.Cash">
              <MappingFragment StoreEntitySet="Cash">
                <ScalarProperty Name="IdCash" ColumnName="IdCash" />
                <ScalarProperty Name="Sum" ColumnName="Sum" />
                <ScalarProperty Name="PaymentName" ColumnName="PaymentName" />
                <ScalarProperty Name="IdPay" ColumnName="IdPay" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="CashRegister">
            <EntityTypeMapping TypeName="gr606_sosanModel.CashRegister">
              <MappingFragment StoreEntitySet="CashRegister">
                <ScalarProperty Name="IdCashRegistre" ColumnName="IdCashRegistre" />
                <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
                <ScalarProperty Name="IdProduct" ColumnName="IdProduct" />
                <ScalarProperty Name="IdSurrender" ColumnName="IdSurrender" />
                <ScalarProperty Name="IdDate" ColumnName="IdDate" />
                <ScalarProperty Name="IdPay" ColumnName="IdPay" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Dates">
            <EntityTypeMapping TypeName="gr606_sosanModel.Dates">
              <MappingFragment StoreEntitySet="Dates">
                <ScalarProperty Name="IdDate" ColumnName="IdDate" />
                <ScalarProperty Name="Date" ColumnName="Date" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Employees">
            <EntityTypeMapping TypeName="gr606_sosanModel.Employees">
              <MappingFragment StoreEntitySet="Employees">
                <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
                <ScalarProperty Name="TelephoneNumber" ColumnName="TelephoneNumber" />
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="Login" ColumnName="Login" />
                <ScalarProperty Name="Password" ColumnName="Password" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="PasportDetails">
            <EntityTypeMapping TypeName="gr606_sosanModel.PasportDetails">
              <MappingFragment StoreEntitySet="PasportDetails">
                <ScalarProperty Name="IdDetail" ColumnName="IdDetail" />
                <ScalarProperty Name="Number" ColumnName="Number" />
                <ScalarProperty Name="Series" ColumnName="Series" />
                <ScalarProperty Name="IssuedBy" ColumnName="IssuedBy" />
                <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Payment">
            <EntityTypeMapping TypeName="gr606_sosanModel.Payment">
              <MappingFragment StoreEntitySet="Payment">
                <ScalarProperty Name="IdPay" ColumnName="IdPay" />
                <ScalarProperty Name="HistoryAboutPayment" ColumnName="HistoryAboutPayment" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Product">
            <EntityTypeMapping TypeName="gr606_sosanModel.Product">
              <MappingFragment StoreEntitySet="Product">
                <ScalarProperty Name="IdProduct" ColumnName="IdProduct" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="Manufacture" ColumnName="Manufacture" />
                <ScalarProperty Name="ProductGroup" ColumnName="ProductGroup" />
                <ScalarProperty Name="Cost" ColumnName="Cost" />
                <ScalarProperty Name="TypeOfProduct" ColumnName="TypeOfProduct" />
                <ScalarProperty Name="Bardcode" ColumnName="Bardcode" />
                <ScalarProperty Name="Margin" ColumnName="Margin" />
                <ScalarProperty Name="Quantity" ColumnName="Quantity" />
                <ScalarProperty Name="Discount" ColumnName="Discount" />
                <ScalarProperty Name="Unit" ColumnName="Unit" />
                <ScalarProperty Name="VAT" ColumnName="VAT" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Revenue">
            <EntityTypeMapping TypeName="gr606_sosanModel.Revenue">
              <MappingFragment StoreEntitySet="Revenue">
                <ScalarProperty Name="IdRevenue" ColumnName="IdRevenue" />
                <ScalarProperty Name="SumRevenue" ColumnName="SumRevenue" />
                <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="SuppliersProduct">
            <EntityTypeMapping TypeName="gr606_sosanModel.SuppliersProduct">
              <MappingFragment StoreEntitySet="SuppliersProduct">
                <ScalarProperty Name="IdSupplier" ColumnName="IdSupplier" />
                <ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
                <ScalarProperty Name="IdSupply" ColumnName="IdSupply" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="SupplyProduct">
            <EntityTypeMapping TypeName="gr606_sosanModel.SupplyProduct">
              <MappingFragment StoreEntitySet="SupplyProduct">
                <ScalarProperty Name="IdSupply" ColumnName="IdSupply" />
                <ScalarProperty Name="QuantityDeliveredProduct" ColumnName="QuantityDeliveredProduct" />
                <ScalarProperty Name="CostDeliveredProduct" ColumnName="CostDeliveredProduct" />
                <ScalarProperty Name="IdProduct" ColumnName="IdProduct" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="SurrenderOfMoney">
            <EntityTypeMapping TypeName="gr606_sosanModel.SurrenderOfMoney">
              <MappingFragment StoreEntitySet="SurrenderOfMoney">
                <ScalarProperty Name="IdSurrender" ColumnName="IdSurrender" />
                <ScalarProperty Name="Sum" ColumnName="Sum" />
                <ScalarProperty Name="NumberOfChecks" ColumnName="NumberOfChecks" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="WorkingShift">
            <EntityTypeMapping TypeName="gr606_sosanModel.WorkingShift">
              <MappingFragment StoreEntitySet="WorkingShift">
                <ScalarProperty Name="IdShift" ColumnName="IdShift" />
                <ScalarProperty Name="NameShift" ColumnName="NameShift" />
                <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
              </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/2008/10/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="true" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>