Slice/CentralServer/obj/Debug/edmxResourcesToEmbed/StoreModel.csdl

<?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="gr672_pgvModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
  <EntityContainer Name="gr672_pgvEntities" annotation:LazyLoadingEnabled="true">
    <EntitySet Name="Employees" EntityType="gr672_pgvModel.Employee" />
    <EntitySet Name="Orders" EntityType="gr672_pgvModel.Order" />
    <EntitySet Name="PaymentMetods" EntityType="gr672_pgvModel.PaymentMetod" />
    <EntitySet Name="Products" EntityType="gr672_pgvModel.Product" />
    <EntitySet Name="ProductInOrders" EntityType="gr672_pgvModel.ProductInOrder" />
    <EntitySet Name="Stores" EntityType="gr672_pgvModel.Store" />
    <EntitySet Name="WorkShifts" EntityType="gr672_pgvModel.WorkShift" />
    <AssociationSet Name="FK_WorkShift_Employee" Association="gr672_pgvModel.FK_WorkShift_Employee">
      <End Role="Employee" EntitySet="Employees" />
      <End Role="WorkShift" EntitySet="WorkShifts" />
    </AssociationSet>
    <AssociationSet Name="FK_Order_PaymentMetod" Association="gr672_pgvModel.FK_Order_PaymentMetod">
      <End Role="PaymentMetod" EntitySet="PaymentMetods" />
      <End Role="Order" EntitySet="Orders" />
    </AssociationSet>
    <AssociationSet Name="FK_Order_WorkShift" Association="gr672_pgvModel.FK_Order_WorkShift">
      <End Role="WorkShift" EntitySet="WorkShifts" />
      <End Role="Order" EntitySet="Orders" />
    </AssociationSet>
    <AssociationSet Name="FK_ProductInOrder_Order" Association="gr672_pgvModel.FK_ProductInOrder_Order">
      <End Role="Order" EntitySet="Orders" />
      <End Role="ProductInOrder" EntitySet="ProductInOrders" />
    </AssociationSet>
    <AssociationSet Name="FK_ProductInOrder_Product" Association="gr672_pgvModel.FK_ProductInOrder_Product">
      <End Role="Product" EntitySet="Products" />
      <End Role="ProductInOrder" EntitySet="ProductInOrders" />
    </AssociationSet>
    <EntitySet Name="Cashiers" EntityType="gr672_pgvModel.Cashier" />
    <AssociationSet Name="FK_Cashier_Store" Association="gr672_pgvModel.FK_Cashier_Store">
      <End Role="Store" EntitySet="Stores" />
      <End Role="Cashier" EntitySet="Cashiers" />
    </AssociationSet>
    <AssociationSet Name="FK_WorkShift_Cashier" Association="gr672_pgvModel.FK_WorkShift_Cashier">
      <End Role="Cashier" EntitySet="Cashiers" />
      <End Role="WorkShift" EntitySet="WorkShifts" />
    </AssociationSet>
    <EntitySet Name="PaymentOrders" EntityType="gr672_pgvModel.PaymentOrder" />
    <EntitySet Name="ProductInStores" EntityType="gr672_pgvModel.ProductInStore" />
    <AssociationSet Name="FK_PaymentOrder_Order" Association="gr672_pgvModel.FK_PaymentOrder_Order">
      <End Role="Order" EntitySet="Orders" />
      <End Role="PaymentOrder" EntitySet="PaymentOrders" />
    </AssociationSet>
    <AssociationSet Name="FK_PaymentOrder_PaymentMetod" Association="gr672_pgvModel.FK_PaymentOrder_PaymentMetod">
      <End Role="PaymentMetod" EntitySet="PaymentMetods" />
      <End Role="PaymentOrder" EntitySet="PaymentOrders" />
    </AssociationSet>
    <AssociationSet Name="FK_ProductInStore_Product" Association="gr672_pgvModel.FK_ProductInStore_Product">
      <End Role="Product" EntitySet="Products" />
      <End Role="ProductInStore" EntitySet="ProductInStores" />
    </AssociationSet>
    <AssociationSet Name="FK_ProductInOrder_ProductInStore" Association="gr672_pgvModel.FK_ProductInOrder_ProductInStore">
      <End Role="ProductInStore" EntitySet="ProductInStores" />
      <End Role="ProductInOrder" EntitySet="ProductInOrders" />
    </AssociationSet>
    <AssociationSet Name="FK_ProductInStore_Store" Association="gr672_pgvModel.FK_ProductInStore_Store">
      <End Role="Store" EntitySet="Stores" />
      <End Role="ProductInStore" EntitySet="ProductInStores" />
    </AssociationSet>
  </EntityContainer>
  <EntityType Name="Employee">
    <Key>
      <PropertyRef Name="EmployeeID" />
    </Key>
    <Property Name="EmployeeID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="LastName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Name" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="MiddleName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Code" Type="String" Nullable="false" MaxLength="5" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="WorkShifts" Relationship="gr672_pgvModel.FK_WorkShift_Employee" FromRole="Employee" ToRole="WorkShift" />
  </EntityType>
  <EntityType Name="Order">
    <Key>
      <PropertyRef Name="OrderID" />
    </Key>
    <Property Name="OrderID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Date" Type="DateTime" Nullable="false" Precision="0" />
    <Property Name="IDWorkShift" Type="Int32" Nullable="false" />
    <Property Name="State" Type="Boolean" Nullable="false" />
    <Property Name="IDPaymentMetod" Type="Int32" />
    <NavigationProperty Name="PaymentMetod" Relationship="gr672_pgvModel.FK_Order_PaymentMetod" FromRole="Order" ToRole="PaymentMetod" />
    <NavigationProperty Name="WorkShift" Relationship="gr672_pgvModel.FK_Order_WorkShift" FromRole="Order" ToRole="WorkShift" />
    <NavigationProperty Name="ProductInOrders" Relationship="gr672_pgvModel.FK_ProductInOrder_Order" FromRole="Order" ToRole="ProductInOrder" />
    <NavigationProperty Name="PaymentOrders" Relationship="gr672_pgvModel.FK_PaymentOrder_Order" FromRole="Order" ToRole="PaymentOrder" />
  </EntityType>
  <EntityType Name="PaymentMetod">
    <Key>
      <PropertyRef Name="PaymentMetodID" />
    </Key>
    <Property Name="PaymentMetodID" Type="Int32" Nullable="false" />
    <Property Name="PaymentMetodName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Orders" Relationship="gr672_pgvModel.FK_Order_PaymentMetod" FromRole="PaymentMetod" ToRole="Order" />
    <NavigationProperty Name="PaymentOrders" Relationship="gr672_pgvModel.FK_PaymentOrder_PaymentMetod" FromRole="PaymentMetod" ToRole="PaymentOrder" />
  </EntityType>
  <EntityType Name="Product">
    <Key>
      <PropertyRef Name="ProductID" />
    </Key>
    <Property Name="ProductID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="NameProduct" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
    <Property Name="Weight" Type="Int32" Nullable="false" />
    <Property Name="Packaging" Type="Int32" Nullable="false" />
    <Property Name="PriceOfOne" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
    <Property Name="BarCode" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="ProductInOrders" Relationship="gr672_pgvModel.FK_ProductInOrder_Product" FromRole="Product" ToRole="ProductInOrder" />
    <NavigationProperty Name="ProductInStores" Relationship="gr672_pgvModel.FK_ProductInStore_Product" FromRole="Product" ToRole="ProductInStore" />
  </EntityType>
  <EntityType Name="ProductInOrder">
    <Key>
      <PropertyRef Name="IDOrder" />
      <PropertyRef Name="IDProduct" />
    </Key>
    <Property Name="IDOrder" Type="Int32" Nullable="false" />
    <Property Name="IDProduct" Type="Int32" Nullable="false" />
    <Property Name="AmountProduct" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Order" Relationship="gr672_pgvModel.FK_ProductInOrder_Order" FromRole="ProductInOrder" ToRole="Order" />
    <NavigationProperty Name="Product" Relationship="gr672_pgvModel.FK_ProductInOrder_Product" FromRole="ProductInOrder" ToRole="Product" />
    <NavigationProperty Name="ProductInStore" Relationship="gr672_pgvModel.FK_ProductInOrder_ProductInStore" FromRole="ProductInOrder" ToRole="ProductInStore" />
  </EntityType>
  <EntityType Name="Store">
    <Key>
      <PropertyRef Name="StoreID" />
    </Key>
    <Property Name="StoreID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Address" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Cashiers" Relationship="gr672_pgvModel.FK_Cashier_Store" FromRole="Store" ToRole="Cashier" />
    <NavigationProperty Name="ProductInStores" Relationship="gr672_pgvModel.FK_ProductInStore_Store" FromRole="Store" ToRole="ProductInStore" />
  </EntityType>
  <EntityType Name="WorkShift">
    <Key>
      <PropertyRef Name="WorkShiftID" />
    </Key>
    <Property Name="WorkShiftID" Type="Int32" Nullable="false" />
    <Property Name="IDCashier" Type="Int32" Nullable="false" />
    <Property Name="IDEmployee" Type="Int32" Nullable="false" />
    <Property Name="StartDateAndTimeWork" Type="DateTime" Nullable="false" Precision="3" />
    <Property Name="EndDateAndTimeWork" Type="DateTime" Precision="3" />
    <NavigationProperty Name="Employee" Relationship="gr672_pgvModel.FK_WorkShift_Employee" FromRole="WorkShift" ToRole="Employee" />
    <NavigationProperty Name="Orders" Relationship="gr672_pgvModel.FK_Order_WorkShift" FromRole="WorkShift" ToRole="Order" />
    <NavigationProperty Name="Cashier" Relationship="gr672_pgvModel.FK_WorkShift_Cashier" FromRole="WorkShift" ToRole="Cashier" />
  </EntityType>
  <Association Name="FK_WorkShift_Employee">
    <End Type="gr672_pgvModel.Employee" Role="Employee" Multiplicity="1" />
    <End Type="gr672_pgvModel.WorkShift" Role="WorkShift" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Employee">
        <PropertyRef Name="EmployeeID" />
      </Principal>
      <Dependent Role="WorkShift">
        <PropertyRef Name="IDEmployee" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Order_PaymentMetod">
    <End Type="gr672_pgvModel.PaymentMetod" Role="PaymentMetod" Multiplicity="0..1" />
    <End Type="gr672_pgvModel.Order" Role="Order" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="PaymentMetod">
        <PropertyRef Name="PaymentMetodID" />
      </Principal>
      <Dependent Role="Order">
        <PropertyRef Name="IDPaymentMetod" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Order_WorkShift">
    <End Type="gr672_pgvModel.WorkShift" Role="WorkShift" Multiplicity="1" />
    <End Type="gr672_pgvModel.Order" Role="Order" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="WorkShift">
        <PropertyRef Name="WorkShiftID" />
      </Principal>
      <Dependent Role="Order">
        <PropertyRef Name="IDWorkShift" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_ProductInOrder_Order">
    <End Type="gr672_pgvModel.Order" Role="Order" Multiplicity="1" />
    <End Type="gr672_pgvModel.ProductInOrder" Role="ProductInOrder" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Order">
        <PropertyRef Name="OrderID" />
      </Principal>
      <Dependent Role="ProductInOrder">
        <PropertyRef Name="IDOrder" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_ProductInOrder_Product">
    <End Type="gr672_pgvModel.Product" Role="Product" Multiplicity="1" />
    <End Type="gr672_pgvModel.ProductInOrder" Role="ProductInOrder" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Product">
        <PropertyRef Name="ProductID" />
      </Principal>
      <Dependent Role="ProductInOrder">
        <PropertyRef Name="IDProduct" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <EntityType Name="Cashier">
    <Key>
      <PropertyRef Name="CashierID" />
    </Key>
    <Property Name="CashierID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="IDStore" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Store" Relationship="gr672_pgvModel.FK_Cashier_Store" FromRole="Cashier" ToRole="Store" />
    <NavigationProperty Name="WorkShifts" Relationship="gr672_pgvModel.FK_WorkShift_Cashier" FromRole="Cashier" ToRole="WorkShift" />
  </EntityType>
  <Association Name="FK_Cashier_Store">
    <End Type="gr672_pgvModel.Store" Role="Store" Multiplicity="1" />
    <End Type="gr672_pgvModel.Cashier" Role="Cashier" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Store">
        <PropertyRef Name="StoreID" />
      </Principal>
      <Dependent Role="Cashier">
        <PropertyRef Name="IDStore" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_WorkShift_Cashier">
    <End Type="gr672_pgvModel.Cashier" Role="Cashier" Multiplicity="1" />
    <End Type="gr672_pgvModel.WorkShift" Role="WorkShift" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Cashier">
        <PropertyRef Name="CashierID" />
      </Principal>
      <Dependent Role="WorkShift">
        <PropertyRef Name="IDCashier" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <EntityType Name="PaymentOrder">
    <Key>
      <PropertyRef Name="PaymentID" />
    </Key>
    <Property Name="PaymentID" Type="Int32" Nullable="false" />
    <Property Name="IDPaymentMetod" Type="Int32" Nullable="false" />
    <Property Name="IDOrder" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Order" Relationship="gr672_pgvModel.FK_PaymentOrder_Order" FromRole="PaymentOrder" ToRole="Order" />
    <NavigationProperty Name="PaymentMetod" Relationship="gr672_pgvModel.FK_PaymentOrder_PaymentMetod" FromRole="PaymentOrder" ToRole="PaymentMetod" />
  </EntityType>
  <EntityType Name="ProductInStore">
    <Key>
      <PropertyRef Name="ProductInStoreID" />
    </Key>
    <Property Name="IDStore" Type="Int32" Nullable="false" />
    <Property Name="IDProduct" Type="Int32" Nullable="false" />
    <Property Name="RemainsProduct" Type="Int32" Nullable="false" />
    <Property Name="ProductInStoreID" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Product" Relationship="gr672_pgvModel.FK_ProductInStore_Product" FromRole="ProductInStore" ToRole="Product" />
    <NavigationProperty Name="ProductInOrders" Relationship="gr672_pgvModel.FK_ProductInOrder_ProductInStore" FromRole="ProductInStore" ToRole="ProductInOrder" />
    <NavigationProperty Name="Store" Relationship="gr672_pgvModel.FK_ProductInStore_Store" FromRole="ProductInStore" ToRole="Store" />
  </EntityType>
  <Association Name="FK_PaymentOrder_Order">
    <End Type="gr672_pgvModel.Order" Role="Order" Multiplicity="1" />
    <End Type="gr672_pgvModel.PaymentOrder" Role="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 Type="gr672_pgvModel.PaymentMetod" Role="PaymentMetod" Multiplicity="1" />
    <End Type="gr672_pgvModel.PaymentOrder" Role="PaymentOrder" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="PaymentMetod">
        <PropertyRef Name="PaymentMetodID" />
      </Principal>
      <Dependent Role="PaymentOrder">
        <PropertyRef Name="IDPaymentMetod" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_ProductInStore_Product">
    <End Type="gr672_pgvModel.Product" Role="Product" Multiplicity="1" />
    <End Type="gr672_pgvModel.ProductInStore" Role="ProductInStore" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Product">
        <PropertyRef Name="ProductID" />
      </Principal>
      <Dependent Role="ProductInStore">
        <PropertyRef Name="IDProduct" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_ProductInOrder_ProductInStore">
    <End Type="gr672_pgvModel.ProductInStore" Role="ProductInStore" Multiplicity="1" />
    <End Type="gr672_pgvModel.ProductInOrder" Role="ProductInOrder" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="ProductInStore">
        <PropertyRef Name="ProductInStoreID" />
      </Principal>
      <Dependent Role="ProductInOrder">
        <PropertyRef Name="IDProduct" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_ProductInStore_Store">
    <End Type="gr672_pgvModel.Store" Role="Store" Multiplicity="1" />
    <End Type="gr672_pgvModel.ProductInStore" Role="ProductInStore" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Store">
        <PropertyRef Name="StoreID" />
      </Principal>
      <Dependent Role="ProductInStore">
        <PropertyRef Name="IDStore" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
</Schema>