UIFIS/OUP/obj/Debug/edmxResourcesToEmbed/Model1.ssdl

<?xml version="1.0" encoding="utf-8"?>
<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>