Test_Kvalif/WpfApp1/obj/Debug/edmxResourcesToEmbed/ModelCafe.csdl

<?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="CafeModel" 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">
  <EntityType Name="Test_Dish">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Price" Type="Decimal" Precision="19" Scale="4" />
    <Property Name="CookingTime" Type="Int32" />
    <NavigationProperty Name="Test_DishList" Relationship="Self.FK_Test_DishList_Test_Dish" FromRole="Test_Dish" ToRole="Test_DishList" />
  </EntityType>
  <EntityType Name="Test_DishList">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="idDish" Type="Int32" Nullable="false" />
    <Property Name="idOrder" Type="Int32" Nullable="false" />
    <Property Name="CountDish" Type="Int32" />
    <NavigationProperty Name="Test_Dish" Relationship="Self.FK_Test_DishList_Test_Dish" FromRole="Test_DishList" ToRole="Test_Dish" />
    <NavigationProperty Name="Test_Order" Relationship="Self.FK_Test_DishList_Test_Order" FromRole="Test_DishList" ToRole="Test_Order" />
  </EntityType>
  <EntityType Name="Test_Order">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="NumberTable" Type="Int32" />
    <Property Name="CountClient" Type="Int32" />
    <Property Name="idStatus" Type="Int32" Nullable="false" />
    <Property Name="Date" Type="DateTime" Nullable="false" Precision="0" />
    <Property Name="idUser" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Test_DishList" Relationship="Self.FK_Test_DishList_Test_Order" FromRole="Test_Order" ToRole="Test_DishList" />
    <NavigationProperty Name="Test_Status" Relationship="Self.FK_Test_Order_Test_Status" FromRole="Test_Order" ToRole="Test_Status" />
    <NavigationProperty Name="Test_User" Relationship="Self.FK_Test_Order_Test_User" FromRole="Test_Order" ToRole="Test_User" />
  </EntityType>
  <EntityType Name="Test_Post">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Test_User" Relationship="Self.FK_Test_User_Test_Post" FromRole="Test_Post" ToRole="Test_User" />
  </EntityType>
  <EntityType Name="Test_Shift">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Date" Type="DateTime" Precision="0" />
    <NavigationProperty Name="Test_ShiftUser" Relationship="Self.FK_Test_ShiftUser_Test_Shift" FromRole="Test_Shift" ToRole="Test_ShiftUser" />
  </EntityType>
  <EntityType Name="Test_ShiftUser">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="idUser" Type="Int32" Nullable="false" />
    <Property Name="idShift" Type="Int32" Nullable="false" />
    <NavigationProperty Name="Test_Shift" Relationship="Self.FK_Test_ShiftUser_Test_Shift" FromRole="Test_ShiftUser" ToRole="Test_Shift" />
    <NavigationProperty Name="Test_User" Relationship="Self.FK_Test_ShiftUser_Test_User" FromRole="Test_ShiftUser" ToRole="Test_User" />
  </EntityType>
  <EntityType Name="Test_Status">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Test_Order" Relationship="Self.FK_Test_Order_Test_Status" FromRole="Test_Status" ToRole="Test_Order" />
  </EntityType>
  <EntityType Name="Test_User">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
    <Property Name="Login" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="Password" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="LastName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="FirstName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="MiddleName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <Property Name="idPost" Type="Int32" />
    <Property Name="Status" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
    <NavigationProperty Name="Test_Order" Relationship="Self.FK_Test_Order_Test_User" FromRole="Test_User" ToRole="Test_Order" />
    <NavigationProperty Name="Test_Post" Relationship="Self.FK_Test_User_Test_Post" FromRole="Test_User" ToRole="Test_Post" />
    <NavigationProperty Name="Test_ShiftUser" Relationship="Self.FK_Test_ShiftUser_Test_User" FromRole="Test_User" ToRole="Test_ShiftUser" />
  </EntityType>
  <Association Name="FK_Test_DishList_Test_Dish">
    <End Role="Test_Dish" Type="Self.Test_Dish" Multiplicity="1">
      <OnDelete Action="Cascade" />
    </End>
    <End Role="Test_DishList" Type="Self.Test_DishList" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Test_Dish">
        <PropertyRef Name="id" />
      </Principal>
      <Dependent Role="Test_DishList">
        <PropertyRef Name="idDish" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Test_DishList_Test_Order">
    <End Role="Test_Order" Type="Self.Test_Order" Multiplicity="1">
      <OnDelete Action="Cascade" />
    </End>
    <End Role="Test_DishList" Type="Self.Test_DishList" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Test_Order">
        <PropertyRef Name="id" />
      </Principal>
      <Dependent Role="Test_DishList">
        <PropertyRef Name="idOrder" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Test_Order_Test_Status">
    <End Role="Test_Status" Type="Self.Test_Status" Multiplicity="1">
      <OnDelete Action="Cascade" />
    </End>
    <End Role="Test_Order" Type="Self.Test_Order" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Test_Status">
        <PropertyRef Name="id" />
      </Principal>
      <Dependent Role="Test_Order">
        <PropertyRef Name="idStatus" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Test_Order_Test_User">
    <End Role="Test_User" Type="Self.Test_User" Multiplicity="1">
      <OnDelete Action="Cascade" />
    </End>
    <End Role="Test_Order" Type="Self.Test_Order" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Test_User">
        <PropertyRef Name="id" />
      </Principal>
      <Dependent Role="Test_Order">
        <PropertyRef Name="idUser" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Test_User_Test_Post">
    <End Role="Test_Post" Type="Self.Test_Post" Multiplicity="0..1">
      <OnDelete Action="Cascade" />
    </End>
    <End Role="Test_User" Type="Self.Test_User" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Test_Post">
        <PropertyRef Name="id" />
      </Principal>
      <Dependent Role="Test_User">
        <PropertyRef Name="idPost" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Test_ShiftUser_Test_Shift">
    <End Role="Test_Shift" Type="Self.Test_Shift" Multiplicity="1">
      <OnDelete Action="Cascade" />
    </End>
    <End Role="Test_ShiftUser" Type="Self.Test_ShiftUser" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Test_Shift">
        <PropertyRef Name="id" />
      </Principal>
      <Dependent Role="Test_ShiftUser">
        <PropertyRef Name="idShift" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <Association Name="FK_Test_ShiftUser_Test_User">
    <End Role="Test_User" Type="Self.Test_User" Multiplicity="1">
      <OnDelete Action="Cascade" />
    </End>
    <End Role="Test_ShiftUser" Type="Self.Test_ShiftUser" Multiplicity="*" />
    <ReferentialConstraint>
      <Principal Role="Test_User">
        <PropertyRef Name="id" />
      </Principal>
      <Dependent Role="Test_ShiftUser">
        <PropertyRef Name="idUser" />
      </Dependent>
    </ReferentialConstraint>
  </Association>
  <EntityContainer Name="CafeEntities" annotation:LazyLoadingEnabled="true">
    <EntitySet Name="Test_Dish" EntityType="Self.Test_Dish" />
    <EntitySet Name="Test_DishList" EntityType="Self.Test_DishList" />
    <EntitySet Name="Test_Order" EntityType="Self.Test_Order" />
    <EntitySet Name="Test_Post" EntityType="Self.Test_Post" />
    <EntitySet Name="Test_Shift" EntityType="Self.Test_Shift" />
    <EntitySet Name="Test_ShiftUser" EntityType="Self.Test_ShiftUser" />
    <EntitySet Name="Test_Status" EntityType="Self.Test_Status" />
    <EntitySet Name="Test_User" EntityType="Self.Test_User" />
    <AssociationSet Name="FK_Test_DishList_Test_Dish" Association="Self.FK_Test_DishList_Test_Dish">
      <End Role="Test_Dish" EntitySet="Test_Dish" />
      <End Role="Test_DishList" EntitySet="Test_DishList" />
    </AssociationSet>
    <AssociationSet Name="FK_Test_DishList_Test_Order" Association="Self.FK_Test_DishList_Test_Order">
      <End Role="Test_Order" EntitySet="Test_Order" />
      <End Role="Test_DishList" EntitySet="Test_DishList" />
    </AssociationSet>
    <AssociationSet Name="FK_Test_Order_Test_Status" Association="Self.FK_Test_Order_Test_Status">
      <End Role="Test_Status" EntitySet="Test_Status" />
      <End Role="Test_Order" EntitySet="Test_Order" />
    </AssociationSet>
    <AssociationSet Name="FK_Test_Order_Test_User" Association="Self.FK_Test_Order_Test_User">
      <End Role="Test_User" EntitySet="Test_User" />
      <End Role="Test_Order" EntitySet="Test_Order" />
    </AssociationSet>
    <AssociationSet Name="FK_Test_User_Test_Post" Association="Self.FK_Test_User_Test_Post">
      <End Role="Test_Post" EntitySet="Test_Post" />
      <End Role="Test_User" EntitySet="Test_User" />
    </AssociationSet>
    <AssociationSet Name="FK_Test_ShiftUser_Test_Shift" Association="Self.FK_Test_ShiftUser_Test_Shift">
      <End Role="Test_Shift" EntitySet="Test_Shift" />
      <End Role="Test_ShiftUser" EntitySet="Test_ShiftUser" />
    </AssociationSet>
    <AssociationSet Name="FK_Test_ShiftUser_Test_User" Association="Self.FK_Test_ShiftUser_Test_User">
      <End Role="Test_User" EntitySet="Test_User" />
      <End Role="Test_ShiftUser" EntitySet="Test_ShiftUser" />
    </AssociationSet>
  </EntityContainer>
</Schema>