KursachMukha/KursachMukha692gr/Model1.edmx

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
      <Schema Namespace="Хранилище KURSACH1Model" 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="Books">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Name" Type="nvarchar(max)" Nullable="false" />
          <Property Name="Price" Type="money" Nullable="false" />
          <Property Name="Category" Type="nvarchar(max)" Nullable="false" />
          <Property Name="Author" Type="nvarchar(max)" />
        </EntityType>
        <EntityType Name="corpus">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="corpus" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="den_nedeli">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="dennedeli" Type="nvarchar" MaxLength="20" Nullable="false" />
        </EntityType>
        <EntityType Name="disciplina">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="disciplina" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="gruppa">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" Nullable="false" />
          <Property Name="gruppa" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="infoadmin">
          <Key>
            <PropertyRef Name="idAdmin" />
          </Key>
          <Property Name="idAdmin" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="imyaAdmin" Type="nvarchar" MaxLength="200" Nullable="false" />
          <Property Name="familiyaAdmin" Type="nvarchar" MaxLength="200" Nullable="false" />
          <Property Name="dataAdmin" Type="date" Nullable="false" />
          <Property Name="otchestvoAdmin" Type="nvarchar" MaxLength="200" Nullable="false" />
          <Property Name="telephonenumAdmin" Type="nvarchar" MaxLength="200" Nullable="false" />
          <Property Name="emailAdmin" Type="nvarchar" MaxLength="200" />
          <Property Name="loginAdmin" Type="nvarchar" MaxLength="200" Nullable="false" />
          <Property Name="passAdmin" Type="nvarchar" MaxLength="200" Nullable="false" />
        </EntityType>
        <EntityType Name="infotrener">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="familiyaTrener" Type="nvarchar" MaxLength="200" Nullable="false" />
          <Property Name="imyaTrener" Type="nvarchar" MaxLength="200" Nullable="false" />
          <Property Name="otchestvoTrener" Type="nvarchar" MaxLength="200" Nullable="false" />
          <Property Name="dataTrener" Type="date" Nullable="false" />
          <Property Name="telephonenumTrener" Type="nvarchar" MaxLength="200" Nullable="false" />
          <Property Name="fk_disciplina_id" Type="int" Nullable="false" />
          <Property Name="categoryTrener" Type="nvarchar" MaxLength="200" Nullable="false" />
          <Property Name="fk_pol_id" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="infouchenik">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="familiya" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="imya" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="otchestvo" Type="nvarchar" MaxLength="50" />
          <Property Name="dataUchenik" Type="date" Nullable="false" />
          <Property Name="fk_disciplina_id" Type="int" Nullable="false" />
          <Property Name="fk_gruppa_id" Type="int" Nullable="false" />
          <Property Name="fk_pol_id" Type="int" Nullable="false" />
          <Property Name="telephonenumUchenik" Type="nvarchar" MaxLength="12" Nullable="false" />
        </EntityType>
        <EntityType Name="pol">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="pol_name" Type="nvarchar" MaxLength="10" />
        </EntityType>
        <EntityType Name="RASPISANIYE">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="fk_den_nedeli_id" Type="int" Nullable="false" />
          <Property Name="fk_vremya_zanyatiya_id" Type="int" Nullable="false" />
          <Property Name="fk_gruppi_id" Type="int" Nullable="false" />
          <Property Name="fk_disciplina_id" Type="int" Nullable="false" />
          <Property Name="fk_zal_trenirovki_id" Type="int" Nullable="false" />
          <Property Name="fk_trener_id" Type="int" Nullable="false" />
          <Property Name="fk_corpus_id" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="sorevnovaniya">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="name_tournment" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="mesto_provedeniya" Type="nvarchar" MaxLength="100" Nullable="false" />
          <Property Name="fk_disciplina_id" Type="int" Nullable="false" />
          <Property Name="fk_gruppa_id" Type="int" Nullable="false" />
          <Property Name="fk_infotrener_id" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="sysdiagrams">
          <Key>
            <PropertyRef Name="diagram_id" />
          </Key>
          <Property Name="name" Type="nvarchar" MaxLength="128" Nullable="false" />
          <Property Name="principal_id" Type="int" Nullable="false" />
          <Property Name="diagram_id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="version" Type="int" />
          <Property Name="definition" Type="varbinary(max)" />
        </EntityType>
        <EntityType Name="vremya_zanyatiya">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nomer" Type="int" Nullable="false" />
          <Property Name="nachalo" Type="time" Precision="0" Nullable="false" />
          <Property Name="konec" Type="time" Precision="0" Nullable="false" />
        </EntityType>
        <EntityType Name="zal_trenerovki">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="zal" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <Association Name="FK__infotrene__fk_di__3864608B">
          <End Role="disciplina" Type="Self.disciplina" Multiplicity="1" />
          <End Role="infotrener" Type="Self.infotrener" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="disciplina">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infotrener">
              <PropertyRef Name="fk_disciplina_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infotrene__fk_po__367C1819">
          <End Role="pol" Type="Self.pol" Multiplicity="1" />
          <End Role="infotrener" Type="Self.infotrener" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="pol">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infotrener">
              <PropertyRef Name="fk_pol_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infouchen__fk_di__2A164134">
          <End Role="disciplina" Type="Self.disciplina" Multiplicity="1" />
          <End Role="infouchenik" Type="Self.infouchenik" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="disciplina">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infouchenik">
              <PropertyRef Name="fk_disciplina_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infouchen__fk_gr__282DF8C2">
          <End Role="gruppa" Type="Self.gruppa" Multiplicity="1" />
          <End Role="infouchenik" Type="Self.infouchenik" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="gruppa">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infouchenik">
              <PropertyRef Name="fk_gruppa_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infouchen__fk_gr__2BFE89A6">
          <End Role="gruppa" Type="Self.gruppa" Multiplicity="1" />
          <End Role="infouchenik" Type="Self.infouchenik" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="gruppa">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infouchenik">
              <PropertyRef Name="fk_gruppa_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infouchen__fk_po__29221CFB">
          <End Role="pol" Type="Self.pol" Multiplicity="1" />
          <End Role="infouchenik" Type="Self.infouchenik" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="pol">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infouchenik">
              <PropertyRef Name="fk_pol_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infouchen__fk_po__2B0A656D">
          <End Role="pol" Type="Self.pol" Multiplicity="1" />
          <End Role="infouchenik" Type="Self.infouchenik" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="pol">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infouchenik">
              <PropertyRef Name="fk_pol_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_co__47A6A41B">
          <End Role="corpus" Type="Self.corpus" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="corpus">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_corpus_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_de__489AC854">
          <End Role="den_nedeli" Type="Self.den_nedeli" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="den_nedeli">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_den_nedeli_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_di__498EEC8D">
          <End Role="disciplina" Type="Self.disciplina" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="disciplina">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_disciplina_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_gr__4A8310C6">
          <End Role="gruppa" Type="Self.gruppa" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="gruppa">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_gruppi_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_tr__4D5F7D71">
          <End Role="infotrener" Type="Self.infotrener" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="infotrener">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_trener_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_vr__4B7734FF">
          <End Role="vremya_zanyatiya" Type="Self.vremya_zanyatiya" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="vremya_zanyatiya">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_vremya_zanyatiya_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_za__4C6B5938">
          <End Role="zal_trenerovki" Type="Self.zal_trenerovki" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="zal_trenerovki">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_zal_trenirovki_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__sorevnova__fk_di__51300E55">
          <End Role="disciplina" Type="Self.disciplina" Multiplicity="1" />
          <End Role="sorevnovaniya" Type="Self.sorevnovaniya" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="disciplina">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="sorevnovaniya">
              <PropertyRef Name="fk_disciplina_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__sorevnova__fk_gr__5224328E">
          <End Role="gruppa" Type="Self.gruppa" Multiplicity="1" />
          <End Role="sorevnovaniya" Type="Self.sorevnovaniya" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="gruppa">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="sorevnovaniya">
              <PropertyRef Name="fk_gruppa_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__sorevnova__fk_in__531856C7">
          <End Role="infotrener" Type="Self.infotrener" Multiplicity="1" />
          <End Role="sorevnovaniya" Type="Self.sorevnovaniya" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="infotrener">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="sorevnovaniya">
              <PropertyRef Name="fk_infotrener_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Хранилище KURSACH1ModelContainer">
          <EntitySet Name="Books" EntityType="Self.Books" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="corpus" EntityType="Self.corpus" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="den_nedeli" EntityType="Self.den_nedeli" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="disciplina" EntityType="Self.disciplina" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="gruppa" EntityType="Self.gruppa" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="infoadmin" EntityType="Self.infoadmin" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="infotrener" EntityType="Self.infotrener" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="infouchenik" EntityType="Self.infouchenik" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="pol" EntityType="Self.pol" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="RASPISANIYE" EntityType="Self.RASPISANIYE" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="sorevnovaniya" EntityType="Self.sorevnovaniya" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="vremya_zanyatiya" EntityType="Self.vremya_zanyatiya" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="zal_trenerovki" EntityType="Self.zal_trenerovki" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK__infotrene__fk_di__3864608B" Association="Self.FK__infotrene__fk_di__3864608B">
            <End Role="disciplina" EntitySet="disciplina" />
            <End Role="infotrener" EntitySet="infotrener" />
          </AssociationSet>
          <AssociationSet Name="FK__infotrene__fk_po__367C1819" Association="Self.FK__infotrene__fk_po__367C1819">
            <End Role="pol" EntitySet="pol" />
            <End Role="infotrener" EntitySet="infotrener" />
          </AssociationSet>
          <AssociationSet Name="FK__infouchen__fk_di__2A164134" Association="Self.FK__infouchen__fk_di__2A164134">
            <End Role="disciplina" EntitySet="disciplina" />
            <End Role="infouchenik" EntitySet="infouchenik" />
          </AssociationSet>
          <AssociationSet Name="FK__infouchen__fk_gr__282DF8C2" Association="Self.FK__infouchen__fk_gr__282DF8C2">
            <End Role="gruppa" EntitySet="gruppa" />
            <End Role="infouchenik" EntitySet="infouchenik" />
          </AssociationSet>
          <AssociationSet Name="FK__infouchen__fk_gr__2BFE89A6" Association="Self.FK__infouchen__fk_gr__2BFE89A6">
            <End Role="gruppa" EntitySet="gruppa" />
            <End Role="infouchenik" EntitySet="infouchenik" />
          </AssociationSet>
          <AssociationSet Name="FK__infouchen__fk_po__29221CFB" Association="Self.FK__infouchen__fk_po__29221CFB">
            <End Role="pol" EntitySet="pol" />
            <End Role="infouchenik" EntitySet="infouchenik" />
          </AssociationSet>
          <AssociationSet Name="FK__infouchen__fk_po__2B0A656D" Association="Self.FK__infouchen__fk_po__2B0A656D">
            <End Role="pol" EntitySet="pol" />
            <End Role="infouchenik" EntitySet="infouchenik" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_co__47A6A41B" Association="Self.FK__RASPISANI__fk_co__47A6A41B">
            <End Role="corpus" EntitySet="corpus" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYE" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_de__489AC854" Association="Self.FK__RASPISANI__fk_de__489AC854">
            <End Role="den_nedeli" EntitySet="den_nedeli" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYE" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_di__498EEC8D" Association="Self.FK__RASPISANI__fk_di__498EEC8D">
            <End Role="disciplina" EntitySet="disciplina" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYE" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_gr__4A8310C6" Association="Self.FK__RASPISANI__fk_gr__4A8310C6">
            <End Role="gruppa" EntitySet="gruppa" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYE" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_tr__4D5F7D71" Association="Self.FK__RASPISANI__fk_tr__4D5F7D71">
            <End Role="infotrener" EntitySet="infotrener" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYE" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_vr__4B7734FF" Association="Self.FK__RASPISANI__fk_vr__4B7734FF">
            <End Role="vremya_zanyatiya" EntitySet="vremya_zanyatiya" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYE" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_za__4C6B5938" Association="Self.FK__RASPISANI__fk_za__4C6B5938">
            <End Role="zal_trenerovki" EntitySet="zal_trenerovki" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYE" />
          </AssociationSet>
          <AssociationSet Name="FK__sorevnova__fk_di__51300E55" Association="Self.FK__sorevnova__fk_di__51300E55">
            <End Role="disciplina" EntitySet="disciplina" />
            <End Role="sorevnovaniya" EntitySet="sorevnovaniya" />
          </AssociationSet>
          <AssociationSet Name="FK__sorevnova__fk_gr__5224328E" Association="Self.FK__sorevnova__fk_gr__5224328E">
            <End Role="gruppa" EntitySet="gruppa" />
            <End Role="sorevnovaniya" EntitySet="sorevnovaniya" />
          </AssociationSet>
          <AssociationSet Name="FK__sorevnova__fk_in__531856C7" Association="Self.FK__sorevnova__fk_in__531856C7">
            <End Role="infotrener" EntitySet="infotrener" />
            <End Role="sorevnovaniya" EntitySet="sorevnovaniya" />
          </AssociationSet>
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="KURSACH1Model" 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="Book">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Name" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Price" Type="Decimal" Precision="19" Scale="4" Nullable="false" />
          <Property Name="Category" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Author" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="corpus">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="corpus1" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="RASPISANIYEs" Relationship="Self.FK__RASPISANI__fk_co__47A6A41B" FromRole="corpus" ToRole="RASPISANIYE" />
        </EntityType>
        <EntityType Name="den_nedeli">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="dennedeli" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="RASPISANIYEs" Relationship="Self.FK__RASPISANI__fk_de__489AC854" FromRole="den_nedeli" ToRole="RASPISANIYE" />
        </EntityType>
        <EntityType Name="disciplina">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="disciplina1" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="infotreners" Relationship="Self.FK__infotrene__fk_di__3864608B" FromRole="disciplina" ToRole="infotrener" />
          <NavigationProperty Name="infoucheniks" Relationship="Self.FK__infouchen__fk_di__2A164134" FromRole="disciplina" ToRole="infouchenik" />
          <NavigationProperty Name="RASPISANIYEs" Relationship="Self.FK__RASPISANI__fk_di__498EEC8D" FromRole="disciplina" ToRole="RASPISANIYE" />
          <NavigationProperty Name="sorevnovaniyas" Relationship="Self.FK__sorevnova__fk_di__51300E55" FromRole="disciplina" ToRole="sorevnovaniya" />
        </EntityType>
        <EntityType Name="gruppa">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" />
          <Property Name="gruppa1" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="infoucheniks" Relationship="Self.FK__infouchen__fk_gr__282DF8C2" FromRole="gruppa" ToRole="infouchenik" />
          <NavigationProperty Name="infoucheniks1" Relationship="Self.FK__infouchen__fk_gr__2BFE89A6" FromRole="gruppa" ToRole="infouchenik" />
          <NavigationProperty Name="RASPISANIYEs" Relationship="Self.FK__RASPISANI__fk_gr__4A8310C6" FromRole="gruppa" ToRole="RASPISANIYE" />
          <NavigationProperty Name="sorevnovaniyas" Relationship="Self.FK__sorevnova__fk_gr__5224328E" FromRole="gruppa" ToRole="sorevnovaniya" />
        </EntityType>
        <EntityType Name="infoadmin">
          <Key>
            <PropertyRef Name="idAdmin" />
          </Key>
          <Property Name="idAdmin" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="imyaAdmin" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="familiyaAdmin" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="dataAdmin" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="otchestvoAdmin" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="telephonenumAdmin" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="emailAdmin" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <Property Name="loginAdmin" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="passAdmin" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
        </EntityType>
        <EntityType Name="infotrener">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="familiyaTrener" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="imyaTrener" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="otchestvoTrener" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="dataTrener" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="telephonenumTrener" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="fk_disciplina_id" Type="Int32" Nullable="false" />
          <Property Name="categoryTrener" Type="String" MaxLength="200" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="fk_pol_id" Type="Int32" Nullable="false" />
          <NavigationProperty Name="disciplina" Relationship="Self.FK__infotrene__fk_di__3864608B" FromRole="infotrener" ToRole="disciplina" />
          <NavigationProperty Name="pol" Relationship="Self.FK__infotrene__fk_po__367C1819" FromRole="infotrener" ToRole="pol" />
          <NavigationProperty Name="RASPISANIYEs" Relationship="Self.FK__RASPISANI__fk_tr__4D5F7D71" FromRole="infotrener" ToRole="RASPISANIYE" />
          <NavigationProperty Name="sorevnovaniyas" Relationship="Self.FK__sorevnova__fk_in__531856C7" FromRole="infotrener" ToRole="sorevnovaniya" />
        </EntityType>
        <EntityType Name="infouchenik">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="familiya" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="imya" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="otchestvo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="dataUchenik" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="fk_disciplina_id" Type="Int32" Nullable="false" />
          <Property Name="fk_gruppa_id" Type="Int32" Nullable="false" />
          <Property Name="fk_pol_id" Type="Int32" Nullable="false" />
          <Property Name="telephonenumUchenik" Type="String" MaxLength="12" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="disciplina" Relationship="Self.FK__infouchen__fk_di__2A164134" FromRole="infouchenik" ToRole="disciplina" />
          <NavigationProperty Name="gruppa" Relationship="Self.FK__infouchen__fk_gr__282DF8C2" FromRole="infouchenik" ToRole="gruppa" />
          <NavigationProperty Name="gruppa1" Relationship="Self.FK__infouchen__fk_gr__2BFE89A6" FromRole="infouchenik" ToRole="gruppa" />
          <NavigationProperty Name="pol" Relationship="Self.FK__infouchen__fk_po__29221CFB" FromRole="infouchenik" ToRole="pol" />
          <NavigationProperty Name="pol1" Relationship="Self.FK__infouchen__fk_po__2B0A656D" FromRole="infouchenik" ToRole="pol" />
        </EntityType>
        <EntityType Name="pol">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="pol_name" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="infotreners" Relationship="Self.FK__infotrene__fk_po__367C1819" FromRole="pol" ToRole="infotrener" />
          <NavigationProperty Name="infoucheniks" Relationship="Self.FK__infouchen__fk_po__29221CFB" FromRole="pol" ToRole="infouchenik" />
          <NavigationProperty Name="infoucheniks1" Relationship="Self.FK__infouchen__fk_po__2B0A656D" FromRole="pol" ToRole="infouchenik" />
        </EntityType>
        <EntityType Name="RASPISANIYE">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="fk_den_nedeli_id" Type="Int32" Nullable="false" />
          <Property Name="fk_vremya_zanyatiya_id" Type="Int32" Nullable="false" />
          <Property Name="fk_gruppi_id" Type="Int32" Nullable="false" />
          <Property Name="fk_disciplina_id" Type="Int32" Nullable="false" />
          <Property Name="fk_zal_trenirovki_id" Type="Int32" Nullable="false" />
          <Property Name="fk_trener_id" Type="Int32" Nullable="false" />
          <Property Name="fk_corpus_id" Type="Int32" Nullable="false" />
          <NavigationProperty Name="corpus" Relationship="Self.FK__RASPISANI__fk_co__47A6A41B" FromRole="RASPISANIYE" ToRole="corpus" />
          <NavigationProperty Name="den_nedeli" Relationship="Self.FK__RASPISANI__fk_de__489AC854" FromRole="RASPISANIYE" ToRole="den_nedeli" />
          <NavigationProperty Name="disciplina" Relationship="Self.FK__RASPISANI__fk_di__498EEC8D" FromRole="RASPISANIYE" ToRole="disciplina" />
          <NavigationProperty Name="gruppa" Relationship="Self.FK__RASPISANI__fk_gr__4A8310C6" FromRole="RASPISANIYE" ToRole="gruppa" />
          <NavigationProperty Name="infotrener" Relationship="Self.FK__RASPISANI__fk_tr__4D5F7D71" FromRole="RASPISANIYE" ToRole="infotrener" />
          <NavigationProperty Name="vremya_zanyatiya" Relationship="Self.FK__RASPISANI__fk_vr__4B7734FF" FromRole="RASPISANIYE" ToRole="vremya_zanyatiya" />
          <NavigationProperty Name="zal_trenerovki" Relationship="Self.FK__RASPISANI__fk_za__4C6B5938" FromRole="RASPISANIYE" ToRole="zal_trenerovki" />
        </EntityType>
        <EntityType Name="sorevnovaniya">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="name_tournment" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="mesto_provedeniya" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="fk_disciplina_id" Type="Int32" Nullable="false" />
          <Property Name="fk_gruppa_id" Type="Int32" Nullable="false" />
          <Property Name="fk_infotrener_id" Type="Int32" Nullable="false" />
          <NavigationProperty Name="disciplina" Relationship="Self.FK__sorevnova__fk_di__51300E55" FromRole="sorevnovaniya" ToRole="disciplina" />
          <NavigationProperty Name="gruppa" Relationship="Self.FK__sorevnova__fk_gr__5224328E" FromRole="sorevnovaniya" ToRole="gruppa" />
          <NavigationProperty Name="infotrener" Relationship="Self.FK__sorevnova__fk_in__531856C7" FromRole="sorevnovaniya" ToRole="infotrener" />
        </EntityType>
        <EntityType Name="sysdiagram">
          <Key>
            <PropertyRef Name="diagram_id" />
          </Key>
          <Property Name="name" Type="String" MaxLength="128" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="principal_id" Type="Int32" Nullable="false" />
          <Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="version" Type="Int32" />
          <Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" />
        </EntityType>
        <EntityType Name="vremya_zanyatiya">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nomer" Type="Int32" Nullable="false" />
          <Property Name="nachalo" Type="Time" Nullable="false" Precision="0" />
          <Property Name="konec" Type="Time" Nullable="false" Precision="0" />
          <NavigationProperty Name="RASPISANIYEs" Relationship="Self.FK__RASPISANI__fk_vr__4B7734FF" FromRole="vremya_zanyatiya" ToRole="RASPISANIYE" />
        </EntityType>
        <EntityType Name="zal_trenerovki">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="zal" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="RASPISANIYEs" Relationship="Self.FK__RASPISANI__fk_za__4C6B5938" FromRole="zal_trenerovki" ToRole="RASPISANIYE" />
        </EntityType>
        <Association Name="FK__RASPISANI__fk_co__47A6A41B">
          <End Role="corpus" Type="Self.corpus" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="corpus">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_corpus_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_de__489AC854">
          <End Role="den_nedeli" Type="Self.den_nedeli" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="den_nedeli">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_den_nedeli_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infotrene__fk_di__3864608B">
          <End Role="disciplina" Type="Self.disciplina" Multiplicity="1" />
          <End Role="infotrener" Type="Self.infotrener" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="disciplina">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infotrener">
              <PropertyRef Name="fk_disciplina_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infouchen__fk_di__2A164134">
          <End Role="disciplina" Type="Self.disciplina" Multiplicity="1" />
          <End Role="infouchenik" Type="Self.infouchenik" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="disciplina">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infouchenik">
              <PropertyRef Name="fk_disciplina_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_di__498EEC8D">
          <End Role="disciplina" Type="Self.disciplina" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="disciplina">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_disciplina_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__sorevnova__fk_di__51300E55">
          <End Role="disciplina" Type="Self.disciplina" Multiplicity="1" />
          <End Role="sorevnovaniya" Type="Self.sorevnovaniya" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="disciplina">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="sorevnovaniya">
              <PropertyRef Name="fk_disciplina_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infouchen__fk_gr__282DF8C2">
          <End Role="gruppa" Type="Self.gruppa" Multiplicity="1" />
          <End Role="infouchenik" Type="Self.infouchenik" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="gruppa">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infouchenik">
              <PropertyRef Name="fk_gruppa_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infouchen__fk_gr__2BFE89A6">
          <End Role="gruppa" Type="Self.gruppa" Multiplicity="1" />
          <End Role="infouchenik" Type="Self.infouchenik" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="gruppa">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infouchenik">
              <PropertyRef Name="fk_gruppa_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_gr__4A8310C6">
          <End Role="gruppa" Type="Self.gruppa" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="gruppa">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_gruppi_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__sorevnova__fk_gr__5224328E">
          <End Role="gruppa" Type="Self.gruppa" Multiplicity="1" />
          <End Role="sorevnovaniya" Type="Self.sorevnovaniya" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="gruppa">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="sorevnovaniya">
              <PropertyRef Name="fk_gruppa_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infotrene__fk_po__367C1819">
          <End Role="pol" Type="Self.pol" Multiplicity="1" />
          <End Role="infotrener" Type="Self.infotrener" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="pol">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infotrener">
              <PropertyRef Name="fk_pol_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_tr__4D5F7D71">
          <End Role="infotrener" Type="Self.infotrener" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="infotrener">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_trener_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__sorevnova__fk_in__531856C7">
          <End Role="infotrener" Type="Self.infotrener" Multiplicity="1" />
          <End Role="sorevnovaniya" Type="Self.sorevnovaniya" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="infotrener">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="sorevnovaniya">
              <PropertyRef Name="fk_infotrener_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infouchen__fk_po__29221CFB">
          <End Role="pol" Type="Self.pol" Multiplicity="1" />
          <End Role="infouchenik" Type="Self.infouchenik" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="pol">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infouchenik">
              <PropertyRef Name="fk_pol_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__infouchen__fk_po__2B0A656D">
          <End Role="pol" Type="Self.pol" Multiplicity="1" />
          <End Role="infouchenik" Type="Self.infouchenik" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="pol">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="infouchenik">
              <PropertyRef Name="fk_pol_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_vr__4B7734FF">
          <End Role="vremya_zanyatiya" Type="Self.vremya_zanyatiya" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="vremya_zanyatiya">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_vremya_zanyatiya_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__RASPISANI__fk_za__4C6B5938">
          <End Role="zal_trenerovki" Type="Self.zal_trenerovki" Multiplicity="1" />
          <End Role="RASPISANIYE" Type="Self.RASPISANIYE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="zal_trenerovki">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="RASPISANIYE">
              <PropertyRef Name="fk_zal_trenirovki_id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="KURSACH1Entities2" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Books" EntityType="Self.Book" />
          <EntitySet Name="corpora" EntityType="Self.corpus" />
          <EntitySet Name="den_nedeli" EntityType="Self.den_nedeli" />
          <EntitySet Name="disciplinas" EntityType="Self.disciplina" />
          <EntitySet Name="gruppas" EntityType="Self.gruppa" />
          <EntitySet Name="infoadmins" EntityType="Self.infoadmin" />
          <EntitySet Name="infotreners" EntityType="Self.infotrener" />
          <EntitySet Name="infoucheniks" EntityType="Self.infouchenik" />
          <EntitySet Name="pols" EntityType="Self.pol" />
          <EntitySet Name="RASPISANIYEs" EntityType="Self.RASPISANIYE" />
          <EntitySet Name="sorevnovaniyas" EntityType="Self.sorevnovaniya" />
          <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagram" />
          <EntitySet Name="vremya_zanyatiya" EntityType="Self.vremya_zanyatiya" />
          <EntitySet Name="zal_trenerovki" EntityType="Self.zal_trenerovki" />
          <AssociationSet Name="FK__RASPISANI__fk_co__47A6A41B" Association="Self.FK__RASPISANI__fk_co__47A6A41B">
            <End Role="corpus" EntitySet="corpora" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYEs" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_de__489AC854" Association="Self.FK__RASPISANI__fk_de__489AC854">
            <End Role="den_nedeli" EntitySet="den_nedeli" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYEs" />
          </AssociationSet>
          <AssociationSet Name="FK__infotrene__fk_di__3864608B" Association="Self.FK__infotrene__fk_di__3864608B">
            <End Role="disciplina" EntitySet="disciplinas" />
            <End Role="infotrener" EntitySet="infotreners" />
          </AssociationSet>
          <AssociationSet Name="FK__infouchen__fk_di__2A164134" Association="Self.FK__infouchen__fk_di__2A164134">
            <End Role="disciplina" EntitySet="disciplinas" />
            <End Role="infouchenik" EntitySet="infoucheniks" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_di__498EEC8D" Association="Self.FK__RASPISANI__fk_di__498EEC8D">
            <End Role="disciplina" EntitySet="disciplinas" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYEs" />
          </AssociationSet>
          <AssociationSet Name="FK__sorevnova__fk_di__51300E55" Association="Self.FK__sorevnova__fk_di__51300E55">
            <End Role="disciplina" EntitySet="disciplinas" />
            <End Role="sorevnovaniya" EntitySet="sorevnovaniyas" />
          </AssociationSet>
          <AssociationSet Name="FK__infouchen__fk_gr__282DF8C2" Association="Self.FK__infouchen__fk_gr__282DF8C2">
            <End Role="gruppa" EntitySet="gruppas" />
            <End Role="infouchenik" EntitySet="infoucheniks" />
          </AssociationSet>
          <AssociationSet Name="FK__infouchen__fk_gr__2BFE89A6" Association="Self.FK__infouchen__fk_gr__2BFE89A6">
            <End Role="gruppa" EntitySet="gruppas" />
            <End Role="infouchenik" EntitySet="infoucheniks" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_gr__4A8310C6" Association="Self.FK__RASPISANI__fk_gr__4A8310C6">
            <End Role="gruppa" EntitySet="gruppas" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYEs" />
          </AssociationSet>
          <AssociationSet Name="FK__sorevnova__fk_gr__5224328E" Association="Self.FK__sorevnova__fk_gr__5224328E">
            <End Role="gruppa" EntitySet="gruppas" />
            <End Role="sorevnovaniya" EntitySet="sorevnovaniyas" />
          </AssociationSet>
          <AssociationSet Name="FK__infotrene__fk_po__367C1819" Association="Self.FK__infotrene__fk_po__367C1819">
            <End Role="pol" EntitySet="pols" />
            <End Role="infotrener" EntitySet="infotreners" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_tr__4D5F7D71" Association="Self.FK__RASPISANI__fk_tr__4D5F7D71">
            <End Role="infotrener" EntitySet="infotreners" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYEs" />
          </AssociationSet>
          <AssociationSet Name="FK__sorevnova__fk_in__531856C7" Association="Self.FK__sorevnova__fk_in__531856C7">
            <End Role="infotrener" EntitySet="infotreners" />
            <End Role="sorevnovaniya" EntitySet="sorevnovaniyas" />
          </AssociationSet>
          <AssociationSet Name="FK__infouchen__fk_po__29221CFB" Association="Self.FK__infouchen__fk_po__29221CFB">
            <End Role="pol" EntitySet="pols" />
            <End Role="infouchenik" EntitySet="infoucheniks" />
          </AssociationSet>
          <AssociationSet Name="FK__infouchen__fk_po__2B0A656D" Association="Self.FK__infouchen__fk_po__2B0A656D">
            <End Role="pol" EntitySet="pols" />
            <End Role="infouchenik" EntitySet="infoucheniks" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_vr__4B7734FF" Association="Self.FK__RASPISANI__fk_vr__4B7734FF">
            <End Role="vremya_zanyatiya" EntitySet="vremya_zanyatiya" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYEs" />
          </AssociationSet>
          <AssociationSet Name="FK__RASPISANI__fk_za__4C6B5938" Association="Self.FK__RASPISANI__fk_za__4C6B5938">
            <End Role="zal_trenerovki" EntitySet="zal_trenerovki" />
            <End Role="RASPISANIYE" EntitySet="RASPISANIYEs" />
          </AssociationSet>
        </EntityContainer>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="Хранилище KURSACH1ModelContainer" CdmEntityContainer="KURSACH1Entities2">
          <EntitySetMapping Name="Books">
            <EntityTypeMapping TypeName="KURSACH1Model.Book">
              <MappingFragment StoreEntitySet="Books">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="Price" ColumnName="Price" />
                <ScalarProperty Name="Category" ColumnName="Category" />
                <ScalarProperty Name="Author" ColumnName="Author" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="corpora">
            <EntityTypeMapping TypeName="KURSACH1Model.corpus">
              <MappingFragment StoreEntitySet="corpus">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="corpus1" ColumnName="corpus" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="den_nedeli">
            <EntityTypeMapping TypeName="KURSACH1Model.den_nedeli">
              <MappingFragment StoreEntitySet="den_nedeli">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="dennedeli" ColumnName="dennedeli" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="disciplinas">
            <EntityTypeMapping TypeName="KURSACH1Model.disciplina">
              <MappingFragment StoreEntitySet="disciplina">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="disciplina1" ColumnName="disciplina" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="gruppas">
            <EntityTypeMapping TypeName="KURSACH1Model.gruppa">
              <MappingFragment StoreEntitySet="gruppa">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="gruppa1" ColumnName="gruppa" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="infoadmins">
            <EntityTypeMapping TypeName="KURSACH1Model.infoadmin">
              <MappingFragment StoreEntitySet="infoadmin">
                <ScalarProperty Name="idAdmin" ColumnName="idAdmin" />
                <ScalarProperty Name="imyaAdmin" ColumnName="imyaAdmin" />
                <ScalarProperty Name="familiyaAdmin" ColumnName="familiyaAdmin" />
                <ScalarProperty Name="dataAdmin" ColumnName="dataAdmin" />
                <ScalarProperty Name="otchestvoAdmin" ColumnName="otchestvoAdmin" />
                <ScalarProperty Name="telephonenumAdmin" ColumnName="telephonenumAdmin" />
                <ScalarProperty Name="emailAdmin" ColumnName="emailAdmin" />
                <ScalarProperty Name="loginAdmin" ColumnName="loginAdmin" />
                <ScalarProperty Name="passAdmin" ColumnName="passAdmin" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="infotreners">
            <EntityTypeMapping TypeName="KURSACH1Model.infotrener">
              <MappingFragment StoreEntitySet="infotrener">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="familiyaTrener" ColumnName="familiyaTrener" />
                <ScalarProperty Name="imyaTrener" ColumnName="imyaTrener" />
                <ScalarProperty Name="otchestvoTrener" ColumnName="otchestvoTrener" />
                <ScalarProperty Name="dataTrener" ColumnName="dataTrener" />
                <ScalarProperty Name="telephonenumTrener" ColumnName="telephonenumTrener" />
                <ScalarProperty Name="fk_disciplina_id" ColumnName="fk_disciplina_id" />
                <ScalarProperty Name="categoryTrener" ColumnName="categoryTrener" />
                <ScalarProperty Name="fk_pol_id" ColumnName="fk_pol_id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="infoucheniks">
            <EntityTypeMapping TypeName="KURSACH1Model.infouchenik">
              <MappingFragment StoreEntitySet="infouchenik">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="familiya" ColumnName="familiya" />
                <ScalarProperty Name="imya" ColumnName="imya" />
                <ScalarProperty Name="otchestvo" ColumnName="otchestvo" />
                <ScalarProperty Name="dataUchenik" ColumnName="dataUchenik" />
                <ScalarProperty Name="fk_disciplina_id" ColumnName="fk_disciplina_id" />
                <ScalarProperty Name="fk_gruppa_id" ColumnName="fk_gruppa_id" />
                <ScalarProperty Name="fk_pol_id" ColumnName="fk_pol_id" />
                <ScalarProperty Name="telephonenumUchenik" ColumnName="telephonenumUchenik" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="pols">
            <EntityTypeMapping TypeName="KURSACH1Model.pol">
              <MappingFragment StoreEntitySet="pol">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="pol_name" ColumnName="pol_name" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="RASPISANIYEs">
            <EntityTypeMapping TypeName="KURSACH1Model.RASPISANIYE">
              <MappingFragment StoreEntitySet="RASPISANIYE">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="fk_den_nedeli_id" ColumnName="fk_den_nedeli_id" />
                <ScalarProperty Name="fk_vremya_zanyatiya_id" ColumnName="fk_vremya_zanyatiya_id" />
                <ScalarProperty Name="fk_gruppi_id" ColumnName="fk_gruppi_id" />
                <ScalarProperty Name="fk_disciplina_id" ColumnName="fk_disciplina_id" />
                <ScalarProperty Name="fk_zal_trenirovki_id" ColumnName="fk_zal_trenirovki_id" />
                <ScalarProperty Name="fk_trener_id" ColumnName="fk_trener_id" />
                <ScalarProperty Name="fk_corpus_id" ColumnName="fk_corpus_id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="sorevnovaniyas">
            <EntityTypeMapping TypeName="KURSACH1Model.sorevnovaniya">
              <MappingFragment StoreEntitySet="sorevnovaniya">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="name_tournment" ColumnName="name_tournment" />
                <ScalarProperty Name="mesto_provedeniya" ColumnName="mesto_provedeniya" />
                <ScalarProperty Name="fk_disciplina_id" ColumnName="fk_disciplina_id" />
                <ScalarProperty Name="fk_gruppa_id" ColumnName="fk_gruppa_id" />
                <ScalarProperty Name="fk_infotrener_id" ColumnName="fk_infotrener_id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="sysdiagrams">
            <EntityTypeMapping TypeName="KURSACH1Model.sysdiagram">
              <MappingFragment StoreEntitySet="sysdiagrams">
                <ScalarProperty Name="name" ColumnName="name" />
                <ScalarProperty Name="principal_id" ColumnName="principal_id" />
                <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
                <ScalarProperty Name="version" ColumnName="version" />
                <ScalarProperty Name="definition" ColumnName="definition" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="vremya_zanyatiya">
            <EntityTypeMapping TypeName="KURSACH1Model.vremya_zanyatiya">
              <MappingFragment StoreEntitySet="vremya_zanyatiya">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="nomer" ColumnName="nomer" />
                <ScalarProperty Name="nachalo" ColumnName="nachalo" />
                <ScalarProperty Name="konec" ColumnName="konec" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="zal_trenerovki">
            <EntityTypeMapping TypeName="KURSACH1Model.zal_trenerovki">
              <MappingFragment StoreEntitySet="zal_trenerovki">
                <ScalarProperty Name="id" ColumnName="id" />
                <ScalarProperty Name="zal" ColumnName="zal" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="true" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
        <DesignerProperty Name="UseLegacyProvider" Value="false" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>