Slice/StoreServer/obj/Debug/edmxResourcesToEmbed/ModelStore.ssdl

<?xml version="1.0" encoding="utf-8"?>
<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" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="IDCashier" Type="int" Nullable="false" />
    <Property Name="IDEmployee" Type="int" Nullable="false" />
    <Property Name="StartDateAndTimeWork" Type="datetime" />
    <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>