CourseProject/Course_Project/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="Хранилище courseModel" 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="Branches">
          <Key>
            <PropertyRef Name="BranchID" />
          </Key>
          <Property Name="BranchID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Title" Type="varchar" MaxLength="100" Nullable="false" />
          <Property Name="Chief" Type="varchar" MaxLength="100" Nullable="false" />
        </EntityType>
        <EntityType Name="Companies">
          <Key>
            <PropertyRef Name="CompanyID" />
          </Key>
          <Property Name="CompanyID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Title" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="Address" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="TelNumber" Type="varchar" MaxLength="15" Nullable="false" />
          <Property Name="Requisites" Type="varchar" MaxLength="150" Nullable="false" />
          <Property Name="ResponsiblePerson" Type="varchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="Groups">
          <Key>
            <PropertyRef Name="GroupID" />
          </Key>
          <Property Name="GroupID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Title" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="Curator" Type="varchar" MaxLength="30" Nullable="false" />
          <Property Name="SpecialtyID" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Practices">
          <Key>
            <PropertyRef Name="PracticeID" />
          </Key>
          <Property Name="PracticeID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="CompanyID" Type="int" Nullable="false" />
          <Property Name="SudentID" Type="int" Nullable="false" />
          <Property Name="TicketID" Type="int" />
          <Property Name="ProModuleID" Type="int" Nullable="false" />
          <Property Name="StartDate" Type="date" Nullable="false" />
          <Property Name="EndDate" Type="date" Nullable="false" />
        </EntityType>
        <EntityType Name="PracticleTickets">
          <Key>
            <PropertyRef Name="TicketID" />
          </Key>
          <Property Name="TicketID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="StudentID" Type="int" Nullable="false" />
          <Property Name="DateOfIssue" Type="date" Nullable="false" />
          <Property Name="Returned" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="ProModules">
          <Key>
            <PropertyRef Name="ProModuleID" />
          </Key>
          <Property Name="ProModuleID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Title" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="SpecialityID" Type="int" />
        </EntityType>
        <EntityType Name="Specialities">
          <Key>
            <PropertyRef Name="SpecialityID" />
          </Key>
          <Property Name="SpecialityID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="BranchID" Type="int" Nullable="false" />
          <Property Name="SpecialtyGovID" Type="varchar" MaxLength="10" />
          <Property Name="Title" Type="varchar" MaxLength="100" Nullable="false" />
          <Property Name="StudyingPeriod" Type="varchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="Students">
          <Key>
            <PropertyRef Name="StidentID" />
          </Key>
          <Property Name="StidentID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Surname" Type="varchar" MaxLength="15" Nullable="false" />
          <Property Name="FirstName" Type="varchar" MaxLength="15" Nullable="false" />
          <Property Name="LastName" Type="varchar" MaxLength="15" Nullable="false" />
          <Property Name="BrithDate" Type="date" Nullable="false" />
          <Property Name="Address" Type="varchar" MaxLength="100" Nullable="false" />
          <Property Name="TelNumber" Type="varchar" MaxLength="15" Nullable="false" />
          <Property Name="StudentCardID" Type="int" Nullable="false" />
          <Property Name="GradeBookID" Type="int" Nullable="false" />
          <Property Name="GroupID" 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="Users">
          <Key>
            <PropertyRef Name="UserID" />
          </Key>
          <Property Name="UserID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Login" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="Password" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="UserGroup" Type="varchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <Association Name="FK_Groups_Specialities">
          <End Role="Specialities" Type="Self.Specialities" Multiplicity="1" />
          <End Role="Groups" Type="Self.Groups" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Specialities">
              <PropertyRef Name="SpecialityID" />
            </Principal>
            <Dependent Role="Groups">
              <PropertyRef Name="SpecialtyID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Practices_Companies">
          <End Role="Companies" Type="Self.Companies" Multiplicity="1" />
          <End Role="Practices" Type="Self.Practices" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Companies">
              <PropertyRef Name="CompanyID" />
            </Principal>
            <Dependent Role="Practices">
              <PropertyRef Name="CompanyID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Practices_PracticleTickets">
          <End Role="PracticleTickets" Type="Self.PracticleTickets" Multiplicity="0..1" />
          <End Role="Practices" Type="Self.Practices" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="PracticleTickets">
              <PropertyRef Name="TicketID" />
            </Principal>
            <Dependent Role="Practices">
              <PropertyRef Name="TicketID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Practices_ProModules">
          <End Role="ProModules" Type="Self.ProModules" Multiplicity="1" />
          <End Role="Practices" Type="Self.Practices" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ProModules">
              <PropertyRef Name="ProModuleID" />
            </Principal>
            <Dependent Role="Practices">
              <PropertyRef Name="ProModuleID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Practices_Students">
          <End Role="Students" Type="Self.Students" Multiplicity="1" />
          <End Role="Practices" Type="Self.Practices" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Students">
              <PropertyRef Name="StidentID" />
            </Principal>
            <Dependent Role="Practices">
              <PropertyRef Name="SudentID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Specialities_Branches">
          <End Role="Branches" Type="Self.Branches" Multiplicity="1" />
          <End Role="Specialities" Type="Self.Specialities" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Branches">
              <PropertyRef Name="BranchID" />
            </Principal>
            <Dependent Role="Specialities">
              <PropertyRef Name="BranchID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Students_Groups">
          <End Role="Groups" Type="Self.Groups" Multiplicity="1" />
          <End Role="Students" Type="Self.Students" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groups">
              <PropertyRef Name="GroupID" />
            </Principal>
            <Dependent Role="Students">
              <PropertyRef Name="GroupID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Хранилище courseModelContainer">
          <EntitySet Name="Branches" EntityType="Self.Branches" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Companies" EntityType="Self.Companies" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Groups" EntityType="Self.Groups" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Practices" EntityType="Self.Practices" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="PracticleTickets" EntityType="Self.PracticleTickets" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ProModules" EntityType="Self.ProModules" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Specialities" EntityType="Self.Specialities" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Students" EntityType="Self.Students" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Users" EntityType="Self.Users" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_Groups_Specialities" Association="Self.FK_Groups_Specialities">
            <End Role="Specialities" EntitySet="Specialities" />
            <End Role="Groups" EntitySet="Groups" />
          </AssociationSet>
          <AssociationSet Name="FK_Practices_Companies" Association="Self.FK_Practices_Companies">
            <End Role="Companies" EntitySet="Companies" />
            <End Role="Practices" EntitySet="Practices" />
          </AssociationSet>
          <AssociationSet Name="FK_Practices_PracticleTickets" Association="Self.FK_Practices_PracticleTickets">
            <End Role="PracticleTickets" EntitySet="PracticleTickets" />
            <End Role="Practices" EntitySet="Practices" />
          </AssociationSet>
          <AssociationSet Name="FK_Practices_ProModules" Association="Self.FK_Practices_ProModules">
            <End Role="ProModules" EntitySet="ProModules" />
            <End Role="Practices" EntitySet="Practices" />
          </AssociationSet>
          <AssociationSet Name="FK_Practices_Students" Association="Self.FK_Practices_Students">
            <End Role="Students" EntitySet="Students" />
            <End Role="Practices" EntitySet="Practices" />
          </AssociationSet>
          <AssociationSet Name="FK_Specialities_Branches" Association="Self.FK_Specialities_Branches">
            <End Role="Branches" EntitySet="Branches" />
            <End Role="Specialities" EntitySet="Specialities" />
          </AssociationSet>
          <AssociationSet Name="FK_Students_Groups" Association="Self.FK_Students_Groups">
            <End Role="Groups" EntitySet="Groups" />
            <End Role="Students" EntitySet="Students" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="courseModel" 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="Branches">
          <Key>
            <PropertyRef Name="BranchID" />
          </Key>
          <Property Name="BranchID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Title" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="Chief" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
          <NavigationProperty Name="Specialities" Relationship="Self.FK_Specialities_Branches" FromRole="Branches" ToRole="Specialities" />
        </EntityType>
        <EntityType Name="Companies">
          <Key>
            <PropertyRef Name="CompanyID" />
          </Key>
          <Property Name="CompanyID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Title" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="Address" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="TelNumber" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="Requisites" Type="String" MaxLength="150" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="ResponsiblePerson" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <NavigationProperty Name="Practices" Relationship="Self.FK_Practices_Companies" FromRole="Companies" ToRole="Practices" />
        </EntityType>
        <EntityType Name="Groups">
          <Key>
            <PropertyRef Name="GroupID" />
          </Key>
          <Property Name="GroupID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Title" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="Curator" Type="String" MaxLength="30" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="SpecialtyID" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Specialities" Relationship="Self.FK_Groups_Specialities" FromRole="Groups" ToRole="Specialities" />
          <NavigationProperty Name="Students" Relationship="Self.FK_Students_Groups" FromRole="Groups" ToRole="Students" />
        </EntityType>
        <EntityType Name="Practices">
          <Key>
            <PropertyRef Name="PracticeID" />
          </Key>
          <Property Name="PracticeID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="CompanyID" Type="Int32" Nullable="false" />
          <Property Name="SudentID" Type="Int32" Nullable="false" />
          <Property Name="TicketID" Type="Int32" />
          <Property Name="ProModuleID" Type="Int32" Nullable="false" />
          <Property Name="StartDate" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="EndDate" Type="DateTime" Nullable="false" Precision="0" />
          <NavigationProperty Name="Companies" Relationship="Self.FK_Practices_Companies" FromRole="Practices" ToRole="Companies" />
          <NavigationProperty Name="PracticleTickets" Relationship="Self.FK_Practices_PracticleTickets" FromRole="Practices" ToRole="PracticleTickets" />
          <NavigationProperty Name="ProModules" Relationship="Self.FK_Practices_ProModules" FromRole="Practices" ToRole="ProModules" />
          <NavigationProperty Name="Students" Relationship="Self.FK_Practices_Students" FromRole="Practices" ToRole="Students" />
        </EntityType>
        <EntityType Name="PracticleTickets">
          <Key>
            <PropertyRef Name="TicketID" />
          </Key>
          <Property Name="TicketID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="StudentID" Type="Int32" Nullable="false" />
          <Property Name="DateOfIssue" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Returned" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="Practices" Relationship="Self.FK_Practices_PracticleTickets" FromRole="PracticleTickets" ToRole="Practices" />
        </EntityType>
        <EntityType Name="ProModules">
          <Key>
            <PropertyRef Name="ProModuleID" />
          </Key>
          <Property Name="ProModuleID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Title" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="SpecialityID" Type="Int32" />
          <NavigationProperty Name="Practices" Relationship="Self.FK_Practices_ProModules" FromRole="ProModules" ToRole="Practices" />
        </EntityType>
        <EntityType Name="Specialities">
          <Key>
            <PropertyRef Name="SpecialityID" />
          </Key>
          <Property Name="SpecialityID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="BranchID" Type="Int32" Nullable="false" />
          <Property Name="SpecialtyGovID" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
          <Property Name="Title" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="StudyingPeriod" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <NavigationProperty Name="Branches" Relationship="Self.FK_Specialities_Branches" FromRole="Specialities" ToRole="Branches" />
          <NavigationProperty Name="Groups" Relationship="Self.FK_Groups_Specialities" FromRole="Specialities" ToRole="Groups" />
        </EntityType>
        <EntityType Name="Students">
          <Key>
            <PropertyRef Name="StidentID" />
          </Key>
          <Property Name="StidentID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Surname" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="FirstName" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="LastName" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="BrithDate" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Address" Type="String" MaxLength="100" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="TelNumber" Type="String" MaxLength="15" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="StudentCardID" Type="Int32" Nullable="false" />
          <Property Name="GradeBookID" Type="Int32" Nullable="false" />
          <Property Name="GroupID" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Groups" Relationship="Self.FK_Students_Groups" FromRole="Students" ToRole="Groups" />
          <NavigationProperty Name="Practices" Relationship="Self.FK_Practices_Students" FromRole="Students" ToRole="Practices" />
        </EntityType>
        <EntityType Name="sysdiagrams">
          <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="Users">
          <Key>
            <PropertyRef Name="UserID" />
          </Key>
          <Property Name="UserID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Login" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="Password" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="UserGroup" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
        </EntityType>
        <Association Name="FK_Specialities_Branches">
          <End Role="Branches" Type="Self.Branches" Multiplicity="1" />
          <End Role="Specialities" Type="Self.Specialities" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Branches">
              <PropertyRef Name="BranchID" />
            </Principal>
            <Dependent Role="Specialities">
              <PropertyRef Name="BranchID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Practices_Companies">
          <End Role="Companies" Type="Self.Companies" Multiplicity="1" />
          <End Role="Practices" Type="Self.Practices" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Companies">
              <PropertyRef Name="CompanyID" />
            </Principal>
            <Dependent Role="Practices">
              <PropertyRef Name="CompanyID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Groups_Specialities">
          <End Role="Specialities" Type="Self.Specialities" Multiplicity="1" />
          <End Role="Groups" Type="Self.Groups" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Specialities">
              <PropertyRef Name="SpecialityID" />
            </Principal>
            <Dependent Role="Groups">
              <PropertyRef Name="SpecialtyID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Students_Groups">
          <End Role="Groups" Type="Self.Groups" Multiplicity="1" />
          <End Role="Students" Type="Self.Students" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groups">
              <PropertyRef Name="GroupID" />
            </Principal>
            <Dependent Role="Students">
              <PropertyRef Name="GroupID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Practices_PracticleTickets">
          <End Role="PracticleTickets" Type="Self.PracticleTickets" Multiplicity="0..1" />
          <End Role="Practices" Type="Self.Practices" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="PracticleTickets">
              <PropertyRef Name="TicketID" />
            </Principal>
            <Dependent Role="Practices">
              <PropertyRef Name="TicketID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Practices_ProModules">
          <End Role="ProModules" Type="Self.ProModules" Multiplicity="1" />
          <End Role="Practices" Type="Self.Practices" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ProModules">
              <PropertyRef Name="ProModuleID" />
            </Principal>
            <Dependent Role="Practices">
              <PropertyRef Name="ProModuleID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Practices_Students">
          <End Role="Students" Type="Self.Students" Multiplicity="1" />
          <End Role="Practices" Type="Self.Practices" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Students">
              <PropertyRef Name="StidentID" />
            </Principal>
            <Dependent Role="Practices">
              <PropertyRef Name="SudentID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Database" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Branches" EntityType="Self.Branches" />
          <EntitySet Name="Companies" EntityType="Self.Companies" />
          <EntitySet Name="Groups" EntityType="Self.Groups" />
          <EntitySet Name="Practices" EntityType="Self.Practices" />
          <EntitySet Name="PracticleTickets" EntityType="Self.PracticleTickets" />
          <EntitySet Name="ProModules" EntityType="Self.ProModules" />
          <EntitySet Name="Specialities" EntityType="Self.Specialities" />
          <EntitySet Name="Students" EntityType="Self.Students" />
          <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" />
          <EntitySet Name="Users" EntityType="Self.Users" />
          <AssociationSet Name="FK_Specialities_Branches" Association="Self.FK_Specialities_Branches">
            <End Role="Branches" EntitySet="Branches" />
            <End Role="Specialities" EntitySet="Specialities" />
          </AssociationSet>
          <AssociationSet Name="FK_Practices_Companies" Association="Self.FK_Practices_Companies">
            <End Role="Companies" EntitySet="Companies" />
            <End Role="Practices" EntitySet="Practices" />
          </AssociationSet>
          <AssociationSet Name="FK_Groups_Specialities" Association="Self.FK_Groups_Specialities">
            <End Role="Specialities" EntitySet="Specialities" />
            <End Role="Groups" EntitySet="Groups" />
          </AssociationSet>
          <AssociationSet Name="FK_Students_Groups" Association="Self.FK_Students_Groups">
            <End Role="Groups" EntitySet="Groups" />
            <End Role="Students" EntitySet="Students" />
          </AssociationSet>
          <AssociationSet Name="FK_Practices_PracticleTickets" Association="Self.FK_Practices_PracticleTickets">
            <End Role="PracticleTickets" EntitySet="PracticleTickets" />
            <End Role="Practices" EntitySet="Practices" />
          </AssociationSet>
          <AssociationSet Name="FK_Practices_ProModules" Association="Self.FK_Practices_ProModules">
            <End Role="ProModules" EntitySet="ProModules" />
            <End Role="Practices" EntitySet="Practices" />
          </AssociationSet>
          <AssociationSet Name="FK_Practices_Students" Association="Self.FK_Practices_Students">
            <End Role="Students" EntitySet="Students" />
            <End Role="Practices" EntitySet="Practices" />
          </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="Хранилище courseModelContainer" CdmEntityContainer="Database">
          <EntitySetMapping Name="Branches">
            <EntityTypeMapping TypeName="courseModel.Branches">
              <MappingFragment StoreEntitySet="Branches">
                <ScalarProperty Name="BranchID" ColumnName="BranchID" />
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="Chief" ColumnName="Chief" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Companies">
            <EntityTypeMapping TypeName="courseModel.Companies">
              <MappingFragment StoreEntitySet="Companies">
                <ScalarProperty Name="CompanyID" ColumnName="CompanyID" />
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="Address" ColumnName="Address" />
                <ScalarProperty Name="TelNumber" ColumnName="TelNumber" />
                <ScalarProperty Name="Requisites" ColumnName="Requisites" />
                <ScalarProperty Name="ResponsiblePerson" ColumnName="ResponsiblePerson" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Groups">
            <EntityTypeMapping TypeName="courseModel.Groups">
              <MappingFragment StoreEntitySet="Groups">
                <ScalarProperty Name="GroupID" ColumnName="GroupID" />
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="Curator" ColumnName="Curator" />
                <ScalarProperty Name="SpecialtyID" ColumnName="SpecialtyID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Practices">
            <EntityTypeMapping TypeName="courseModel.Practices">
              <MappingFragment StoreEntitySet="Practices">
                <ScalarProperty Name="PracticeID" ColumnName="PracticeID" />
                <ScalarProperty Name="CompanyID" ColumnName="CompanyID" />
                <ScalarProperty Name="SudentID" ColumnName="SudentID" />
                <ScalarProperty Name="TicketID" ColumnName="TicketID" />
                <ScalarProperty Name="ProModuleID" ColumnName="ProModuleID" />
                <ScalarProperty Name="StartDate" ColumnName="StartDate" />
                <ScalarProperty Name="EndDate" ColumnName="EndDate" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="PracticleTickets">
            <EntityTypeMapping TypeName="courseModel.PracticleTickets">
              <MappingFragment StoreEntitySet="PracticleTickets">
                <ScalarProperty Name="TicketID" ColumnName="TicketID" />
                <ScalarProperty Name="StudentID" ColumnName="StudentID" />
                <ScalarProperty Name="DateOfIssue" ColumnName="DateOfIssue" />
                <ScalarProperty Name="Returned" ColumnName="Returned" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ProModules">
            <EntityTypeMapping TypeName="courseModel.ProModules">
              <MappingFragment StoreEntitySet="ProModules">
                <ScalarProperty Name="ProModuleID" ColumnName="ProModuleID" />
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="SpecialityID" ColumnName="SpecialityID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Specialities">
            <EntityTypeMapping TypeName="courseModel.Specialities">
              <MappingFragment StoreEntitySet="Specialities">
                <ScalarProperty Name="SpecialityID" ColumnName="SpecialityID" />
                <ScalarProperty Name="BranchID" ColumnName="BranchID" />
                <ScalarProperty Name="SpecialtyGovID" ColumnName="SpecialtyGovID" />
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="StudyingPeriod" ColumnName="StudyingPeriod" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Students">
            <EntityTypeMapping TypeName="courseModel.Students">
              <MappingFragment StoreEntitySet="Students">
                <ScalarProperty Name="StidentID" ColumnName="StidentID" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="FirstName" ColumnName="FirstName" />
                <ScalarProperty Name="LastName" ColumnName="LastName" />
                <ScalarProperty Name="BrithDate" ColumnName="BrithDate" />
                <ScalarProperty Name="Address" ColumnName="Address" />
                <ScalarProperty Name="TelNumber" ColumnName="TelNumber" />
                <ScalarProperty Name="StudentCardID" ColumnName="StudentCardID" />
                <ScalarProperty Name="GradeBookID" ColumnName="GradeBookID" />
                <ScalarProperty Name="GroupID" ColumnName="GroupID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="sysdiagrams">
            <EntityTypeMapping TypeName="courseModel.sysdiagrams">
              <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="Users">
            <EntityTypeMapping TypeName="courseModel.Users">
              <MappingFragment StoreEntitySet="Users">
                <ScalarProperty Name="UserID" ColumnName="UserID" />
                <ScalarProperty Name="Login" ColumnName="Login" />
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="UserGroup" ColumnName="UserGroup" />
              </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="false" />
        <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>