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

<?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="Хранилище CafeModel" 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="Test_Dish">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Name" Type="nvarchar" MaxLength="50" />
    <Property Name="Price" Type="money" />
    <Property Name="CookingTime" Type="int" />
  </EntityType>
  <EntityType Name="Test_DishList">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="idDish" Type="int" Nullable="false" />
    <Property Name="idOrder" Type="int" Nullable="false" />
    <Property Name="CountDish" Type="int" />
  </EntityType>
  <EntityType Name="Test_Order">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="NumberTable" Type="int" />
    <Property Name="CountClient" Type="int" />
    <Property Name="idStatus" Type="int" Nullable="false" />
    <Property Name="Date" Type="date" Nullable="false" />
    <Property Name="idUser" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="Test_Post">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Name" Type="nvarchar" MaxLength="50" />
  </EntityType>
  <EntityType Name="Test_Shift">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Date" Type="date" />
  </EntityType>
  <EntityType Name="Test_ShiftUser">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="idUser" Type="int" Nullable="false" />
    <Property Name="idShift" Type="int" Nullable="false" />
  </EntityType>
  <EntityType Name="Test_Status">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Name" Type="nvarchar" MaxLength="50" />
  </EntityType>
  <EntityType Name="Test_User">
    <Key>
      <PropertyRef Name="id" />
    </Key>
    <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
    <Property Name="Login" Type="nvarchar" MaxLength="50" />
    <Property Name="Password" Type="nvarchar" MaxLength="50" />
    <Property Name="LastName" Type="nvarchar" MaxLength="50" />
    <Property Name="FirstName" Type="nvarchar" MaxLength="50" />
    <Property Name="MiddleName" Type="nvarchar" MaxLength="50" />
    <Property Name="idPost" Type="int" />
    <Property Name="Status" Type="nvarchar" MaxLength="50" />
  </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_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>
  <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>
  <EntityContainer Name="Хранилище CafeModelContainer">
    <EntitySet Name="Test_Dish" EntityType="Self.Test_Dish" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="Test_DishList" EntityType="Self.Test_DishList" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="Test_Order" EntityType="Self.Test_Order" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="Test_Post" EntityType="Self.Test_Post" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="Test_Shift" EntityType="Self.Test_Shift" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="Test_ShiftUser" EntityType="Self.Test_ShiftUser" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="Test_Status" EntityType="Self.Test_Status" Schema="dbo" store:Type="Tables" />
    <EntitySet Name="Test_User" EntityType="Self.Test_User" Schema="dbo" store:Type="Tables" />
    <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_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>
    <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>
  </EntityContainer>
</Schema>