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

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