RDK_Concert/PDK_Concert/ModelBD.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="Хранилище sm_RDKModel" 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="Concert">
          <Key>
            <PropertyRef Name="IDConcert" />
          </Key>
          <Property Name="IDConcert" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="ConcertDate" Type="date" Nullable="false" />
          <Property Name="Titlee" Type="nvarchar(max)" Nullable="false" />
          <Property Name="NumderOfRooms" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="ConcertProgram">
          <Key>
            <PropertyRef Name="IDConcertProgram" />
          </Key>
          <Property Name="IDConcertProgram" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="IDConcert" Type="int" />
          <Property Name="IDNumber" Type="int" />
          <Property Name="IndexNumber" Type="int" />
        </EntityType>
        <EntityType Name="Logined">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Login" Type="nvarchar(max)" Nullable="false" />
          <Property Name="Password" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Numbers">
          <Key>
            <PropertyRef Name="IDNumber" />
          </Key>
          <Property Name="IDNumber" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="IDUser" Type="int" Nullable="false" />
          <Property Name="Title" Type="nvarchar(max)" Nullable="false" />
          <Property Name="Description" Type="nvarchar(max)" />
        </EntityType>
        <EntityType Name="Post">
          <Key>
            <PropertyRef Name="IDPost" />
          </Key>
          <Property Name="IDPost" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Title" Type="nvarchar(max)" Nullable="false" />
        </EntityType>
        <EntityType Name="Power">
          <Key>
            <PropertyRef Name="IDPower" />
          </Key>
          <Property Name="IDPower" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Title" Type="nchar" MaxLength="10" Nullable="false" />
        </EntityType>
        <EntityType Name="RehearsalDate">
          <Key>
            <PropertyRef Name="IDData" />
          </Key>
          <Property Name="IDData" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="RehearsalDate" Type="date" Nullable="false" />
        </EntityType>
        <EntityType Name="RehearsalSchedule">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="IDSchedule" Type="int" Nullable="false" />
          <Property Name="IDUser" Type="int" Nullable="false" />
          <Property Name="RehearsalTime" Type="nvarchar" MaxLength="11" Nullable="false" />
        </EntityType>
        <EntityType Name="Users">
          <Key>
            <PropertyRef Name="IDUser" />
          </Key>
          <Property Name="IDUser" Type="int" Nullable="false" />
          <Property Name="Name" Type="nvarchar(max)" Nullable="false" />
          <Property Name="Surname" Type="nvarchar(max)" Nullable="false" />
          <Property Name="Patronymic" Type="nvarchar(max)" />
          <Property Name="Number" Type="nvarchar" MaxLength="11" />
          <Property Name="IDPower" Type="int" Nullable="false" />
          <Property Name="IDPost" Type="int" Nullable="false" />
        </EntityType>
        <Association Name="FK_ConcertProgram_Concert">
          <End Role="Concert" Type="Self.Concert" Multiplicity="0..1" />
          <End Role="ConcertProgram" Type="Self.ConcertProgram" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Concert">
              <PropertyRef Name="IDConcert" />
            </Principal>
            <Dependent Role="ConcertProgram">
              <PropertyRef Name="IDConcert" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ConcertProgram_Numbers">
          <End Role="Numbers" Type="Self.Numbers" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="ConcertProgram" Type="Self.ConcertProgram" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Numbers">
              <PropertyRef Name="IDNumber" />
            </Principal>
            <Dependent Role="ConcertProgram">
              <PropertyRef Name="IDNumber" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Numbers_Users">
          <End Role="Users" Type="Self.Users" Multiplicity="1" />
          <End Role="Numbers" Type="Self.Numbers" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Users">
              <PropertyRef Name="IDUser" />
            </Principal>
            <Dependent Role="Numbers">
              <PropertyRef Name="IDUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RehearsalSchedule_RehearsalDate">
          <End Role="RehearsalDate" Type="Self.RehearsalDate" Multiplicity="1" />
          <End Role="RehearsalSchedule" Type="Self.RehearsalSchedule" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="RehearsalDate">
              <PropertyRef Name="IDData" />
            </Principal>
            <Dependent Role="RehearsalSchedule">
              <PropertyRef Name="IDSchedule" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RehearsalSchedule_Users">
          <End Role="Users" Type="Self.Users" Multiplicity="1" />
          <End Role="RehearsalSchedule" Type="Self.RehearsalSchedule" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Users">
              <PropertyRef Name="IDUser" />
            </Principal>
            <Dependent Role="RehearsalSchedule">
              <PropertyRef Name="IDUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Users_Logined">
          <End Role="Logined" Type="Self.Logined" Multiplicity="1" />
          <End Role="Users" Type="Self.Users" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Logined">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="Users">
              <PropertyRef Name="IDUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Users_Post">
          <End Role="Post" Type="Self.Post" Multiplicity="1" />
          <End Role="Users" Type="Self.Users" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Post">
              <PropertyRef Name="IDPost" />
            </Principal>
            <Dependent Role="Users">
              <PropertyRef Name="IDPost" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Users_Power">
          <End Role="Power" Type="Self.Power" Multiplicity="1" />
          <End Role="Users" Type="Self.Users" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Power">
              <PropertyRef Name="IDPower" />
            </Principal>
            <Dependent Role="Users">
              <PropertyRef Name="IDPower" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Хранилище sm_RDKModelContainer">
          <EntitySet Name="Concert" EntityType="Self.Concert" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="ConcertProgram" EntityType="Self.ConcertProgram" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Logined" EntityType="Self.Logined" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Numbers" EntityType="Self.Numbers" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Post" EntityType="Self.Post" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Power" EntityType="Self.Power" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="RehearsalDate" EntityType="Self.RehearsalDate" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="RehearsalSchedule" EntityType="Self.RehearsalSchedule" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Users" EntityType="Self.Users" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_ConcertProgram_Concert" Association="Self.FK_ConcertProgram_Concert">
            <End Role="Concert" EntitySet="Concert" />
            <End Role="ConcertProgram" EntitySet="ConcertProgram" />
          </AssociationSet>
          <AssociationSet Name="FK_ConcertProgram_Numbers" Association="Self.FK_ConcertProgram_Numbers">
            <End Role="Numbers" EntitySet="Numbers" />
            <End Role="ConcertProgram" EntitySet="ConcertProgram" />
          </AssociationSet>
          <AssociationSet Name="FK_Numbers_Users" Association="Self.FK_Numbers_Users">
            <End Role="Users" EntitySet="Users" />
            <End Role="Numbers" EntitySet="Numbers" />
          </AssociationSet>
          <AssociationSet Name="FK_RehearsalSchedule_RehearsalDate" Association="Self.FK_RehearsalSchedule_RehearsalDate">
            <End Role="RehearsalDate" EntitySet="RehearsalDate" />
            <End Role="RehearsalSchedule" EntitySet="RehearsalSchedule" />
          </AssociationSet>
          <AssociationSet Name="FK_RehearsalSchedule_Users" Association="Self.FK_RehearsalSchedule_Users">
            <End Role="Users" EntitySet="Users" />
            <End Role="RehearsalSchedule" EntitySet="RehearsalSchedule" />
          </AssociationSet>
          <AssociationSet Name="FK_Users_Logined" Association="Self.FK_Users_Logined">
            <End Role="Logined" EntitySet="Logined" />
            <End Role="Users" EntitySet="Users" />
          </AssociationSet>
          <AssociationSet Name="FK_Users_Post" Association="Self.FK_Users_Post">
            <End Role="Post" EntitySet="Post" />
            <End Role="Users" EntitySet="Users" />
          </AssociationSet>
          <AssociationSet Name="FK_Users_Power" Association="Self.FK_Users_Power">
            <End Role="Power" EntitySet="Power" />
            <End Role="Users" EntitySet="Users" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="sm_RDKModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityContainer Name="sm_RDKEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Concert" EntityType="sm_RDKModel.Concert" />
          <EntitySet Name="ConcertProgram" EntityType="sm_RDKModel.ConcertProgram" />
          <EntitySet Name="Logined" EntityType="sm_RDKModel.Logined" />
          <EntitySet Name="Numbers" EntityType="sm_RDKModel.Numbers" />
          <EntitySet Name="Post" EntityType="sm_RDKModel.Post" />
          <EntitySet Name="Power" EntityType="sm_RDKModel.Power" />
          <EntitySet Name="RehearsalDate" EntityType="sm_RDKModel.RehearsalDate" />
          <EntitySet Name="RehearsalSchedule" EntityType="sm_RDKModel.RehearsalSchedule" />
          <EntitySet Name="Users" EntityType="sm_RDKModel.Users" />
          <AssociationSet Name="FK_ConcertProgram_Concert" Association="sm_RDKModel.FK_ConcertProgram_Concert">
            <End Role="Concert" EntitySet="Concert" />
            <End Role="ConcertProgram" EntitySet="ConcertProgram" />
          </AssociationSet>
          <AssociationSet Name="FK_ConcertProgram_Numbers" Association="sm_RDKModel.FK_ConcertProgram_Numbers">
            <End Role="Numbers" EntitySet="Numbers" />
            <End Role="ConcertProgram" EntitySet="ConcertProgram" />
          </AssociationSet>
          <AssociationSet Name="FK_Users_Logined" Association="sm_RDKModel.FK_Users_Logined">
            <End Role="Logined" EntitySet="Logined" />
            <End Role="Users" EntitySet="Users" />
          </AssociationSet>
          <AssociationSet Name="FK_Numbers_Users" Association="sm_RDKModel.FK_Numbers_Users">
            <End Role="Users" EntitySet="Users" />
            <End Role="Numbers" EntitySet="Numbers" />
          </AssociationSet>
          <AssociationSet Name="FK_Users_Post" Association="sm_RDKModel.FK_Users_Post">
            <End Role="Post" EntitySet="Post" />
            <End Role="Users" EntitySet="Users" />
          </AssociationSet>
          <AssociationSet Name="FK_Users_Power" Association="sm_RDKModel.FK_Users_Power">
            <End Role="Power" EntitySet="Power" />
            <End Role="Users" EntitySet="Users" />
          </AssociationSet>
          <AssociationSet Name="FK_RehearsalSchedule_RehearsalDate" Association="sm_RDKModel.FK_RehearsalSchedule_RehearsalDate">
            <End Role="RehearsalDate" EntitySet="RehearsalDate" />
            <End Role="RehearsalSchedule" EntitySet="RehearsalSchedule" />
          </AssociationSet>
          <AssociationSet Name="FK_RehearsalSchedule_Users" Association="sm_RDKModel.FK_RehearsalSchedule_Users">
            <End Role="Users" EntitySet="Users" />
            <End Role="RehearsalSchedule" EntitySet="RehearsalSchedule" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="Concert">
          <Key>
            <PropertyRef Name="IDConcert" />
          </Key>
          <Property Name="IDConcert" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="ConcertDate" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Titlee" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="NumderOfRooms" Type="Int32" Nullable="false" />
          <NavigationProperty Name="ConcertProgram" Relationship="sm_RDKModel.FK_ConcertProgram_Concert" FromRole="Concert" ToRole="ConcertProgram" />
        </EntityType>
        <EntityType Name="ConcertProgram">
          <Key>
            <PropertyRef Name="IDConcertProgram" />
          </Key>
          <Property Name="IDConcertProgram" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="IDConcert" Type="Int32" />
          <Property Name="IDNumber" Type="Int32" />
          <Property Name="IndexNumber" Type="Int32" />
          <NavigationProperty Name="Concert" Relationship="sm_RDKModel.FK_ConcertProgram_Concert" FromRole="ConcertProgram" ToRole="Concert" />
          <NavigationProperty Name="Numbers" Relationship="sm_RDKModel.FK_ConcertProgram_Numbers" FromRole="ConcertProgram" ToRole="Numbers" />
        </EntityType>
        <EntityType Name="Logined">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Login" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="Password" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Users" Relationship="sm_RDKModel.FK_Users_Logined" FromRole="Logined" ToRole="Users" />
        </EntityType>
        <EntityType Name="Numbers">
          <Key>
            <PropertyRef Name="IDNumber" />
          </Key>
          <Property Name="IDNumber" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="IDUser" Type="Int32" Nullable="false" />
          <Property Name="Title" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="Description" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="ConcertProgram" Relationship="sm_RDKModel.FK_ConcertProgram_Numbers" FromRole="Numbers" ToRole="ConcertProgram" />
          <NavigationProperty Name="Users" Relationship="sm_RDKModel.FK_Numbers_Users" FromRole="Numbers" ToRole="Users" />
        </EntityType>
        <EntityType Name="Post">
          <Key>
            <PropertyRef Name="IDPost" />
          </Key>
          <Property Name="IDPost" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Title" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Users" Relationship="sm_RDKModel.FK_Users_Post" FromRole="Post" ToRole="Users" />
        </EntityType>
        <EntityType Name="Power">
          <Key>
            <PropertyRef Name="IDPower" />
          </Key>
          <Property Name="IDPower" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Title" Type="String" Nullable="false" MaxLength="10" FixedLength="true" Unicode="true" />
          <NavigationProperty Name="Users" Relationship="sm_RDKModel.FK_Users_Power" FromRole="Power" ToRole="Users" />
        </EntityType>
        <EntityType Name="RehearsalDate">
          <Key>
            <PropertyRef Name="IDData" />
          </Key>
          <Property Name="IDData" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="RehearsalDate1" Type="DateTime" Nullable="false" Precision="0" />
          <NavigationProperty Name="RehearsalSchedule" Relationship="sm_RDKModel.FK_RehearsalSchedule_RehearsalDate" FromRole="RehearsalDate" ToRole="RehearsalSchedule" />
        </EntityType>
        <EntityType Name="RehearsalSchedule">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="IDSchedule" Type="Int32" Nullable="false" />
          <Property Name="IDUser" Type="Int32" Nullable="false" />
          <Property Name="RehearsalTime" Type="String" Nullable="false" MaxLength="11" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="RehearsalDate" Relationship="sm_RDKModel.FK_RehearsalSchedule_RehearsalDate" FromRole="RehearsalSchedule" ToRole="RehearsalDate" />
          <NavigationProperty Name="Users" Relationship="sm_RDKModel.FK_RehearsalSchedule_Users" FromRole="RehearsalSchedule" ToRole="Users" />
        </EntityType>
        <EntityType Name="Users">
          <Key>
            <PropertyRef Name="IDUser" />
          </Key>
          <Property Name="IDUser" Type="Int32" Nullable="false" />
          <Property Name="Name" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="Surname" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="Patronymic" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="Number" Type="String" MaxLength="11" FixedLength="false" Unicode="true" />
          <Property Name="IDPower" Type="Int32" Nullable="false" />
          <Property Name="IDPost" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Logined" Relationship="sm_RDKModel.FK_Users_Logined" FromRole="Users" ToRole="Logined" />
          <NavigationProperty Name="Numbers" Relationship="sm_RDKModel.FK_Numbers_Users" FromRole="Users" ToRole="Numbers" />
          <NavigationProperty Name="Post" Relationship="sm_RDKModel.FK_Users_Post" FromRole="Users" ToRole="Post" />
          <NavigationProperty Name="Power" Relationship="sm_RDKModel.FK_Users_Power" FromRole="Users" ToRole="Power" />
          <NavigationProperty Name="RehearsalSchedule" Relationship="sm_RDKModel.FK_RehearsalSchedule_Users" FromRole="Users" ToRole="RehearsalSchedule" />
        </EntityType>
        <Association Name="FK_ConcertProgram_Concert">
          <End Type="sm_RDKModel.Concert" Role="Concert" Multiplicity="0..1" />
          <End Type="sm_RDKModel.ConcertProgram" Role="ConcertProgram" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Concert">
              <PropertyRef Name="IDConcert" />
            </Principal>
            <Dependent Role="ConcertProgram">
              <PropertyRef Name="IDConcert" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ConcertProgram_Numbers">
          <End Type="sm_RDKModel.Numbers" Role="Numbers" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="sm_RDKModel.ConcertProgram" Role="ConcertProgram" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Numbers">
              <PropertyRef Name="IDNumber" />
            </Principal>
            <Dependent Role="ConcertProgram">
              <PropertyRef Name="IDNumber" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Users_Logined">
          <End Type="sm_RDKModel.Logined" Role="Logined" Multiplicity="1" />
          <End Type="sm_RDKModel.Users" Role="Users" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Logined">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="Users">
              <PropertyRef Name="IDUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Numbers_Users">
          <End Type="sm_RDKModel.Users" Role="Users" Multiplicity="1" />
          <End Type="sm_RDKModel.Numbers" Role="Numbers" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Users">
              <PropertyRef Name="IDUser" />
            </Principal>
            <Dependent Role="Numbers">
              <PropertyRef Name="IDUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Users_Post">
          <End Type="sm_RDKModel.Post" Role="Post" Multiplicity="1" />
          <End Type="sm_RDKModel.Users" Role="Users" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Post">
              <PropertyRef Name="IDPost" />
            </Principal>
            <Dependent Role="Users">
              <PropertyRef Name="IDPost" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Users_Power">
          <End Type="sm_RDKModel.Power" Role="Power" Multiplicity="1" />
          <End Type="sm_RDKModel.Users" Role="Users" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Power">
              <PropertyRef Name="IDPower" />
            </Principal>
            <Dependent Role="Users">
              <PropertyRef Name="IDPower" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RehearsalSchedule_RehearsalDate">
          <End Type="sm_RDKModel.RehearsalDate" Role="RehearsalDate" Multiplicity="1" />
          <End Type="sm_RDKModel.RehearsalSchedule" Role="RehearsalSchedule" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="RehearsalDate">
              <PropertyRef Name="IDData" />
            </Principal>
            <Dependent Role="RehearsalSchedule">
              <PropertyRef Name="IDSchedule" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RehearsalSchedule_Users">
          <End Type="sm_RDKModel.Users" Role="Users" Multiplicity="1" />
          <End Type="sm_RDKModel.RehearsalSchedule" Role="RehearsalSchedule" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Users">
              <PropertyRef Name="IDUser" />
            </Principal>
            <Dependent Role="RehearsalSchedule">
              <PropertyRef Name="IDUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        </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="Хранилище sm_RDKModelContainer" CdmEntityContainer="sm_RDKEntities">
          <EntitySetMapping Name="Concert">
            <EntityTypeMapping TypeName="sm_RDKModel.Concert">
              <MappingFragment StoreEntitySet="Concert">
                <ScalarProperty Name="NumderOfRooms" ColumnName="NumderOfRooms" />
                <ScalarProperty Name="Titlee" ColumnName="Titlee" />
                <ScalarProperty Name="ConcertDate" ColumnName="ConcertDate" />
                <ScalarProperty Name="IDConcert" ColumnName="IDConcert" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ConcertProgram">
            <EntityTypeMapping TypeName="sm_RDKModel.ConcertProgram">
              <MappingFragment StoreEntitySet="ConcertProgram">
                <ScalarProperty Name="IndexNumber" ColumnName="IndexNumber" />
                <ScalarProperty Name="IDNumber" ColumnName="IDNumber" />
                <ScalarProperty Name="IDConcert" ColumnName="IDConcert" />
                <ScalarProperty Name="IDConcertProgram" ColumnName="IDConcertProgram" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Logined">
            <EntityTypeMapping TypeName="sm_RDKModel.Logined">
              <MappingFragment StoreEntitySet="Logined">
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="Login" ColumnName="Login" />
                <ScalarProperty Name="ID" ColumnName="ID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Numbers">
            <EntityTypeMapping TypeName="sm_RDKModel.Numbers">
              <MappingFragment StoreEntitySet="Numbers">
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="IDUser" ColumnName="IDUser" />
                <ScalarProperty Name="IDNumber" ColumnName="IDNumber" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Post">
            <EntityTypeMapping TypeName="sm_RDKModel.Post">
              <MappingFragment StoreEntitySet="Post">
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="IDPost" ColumnName="IDPost" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Power">
            <EntityTypeMapping TypeName="sm_RDKModel.Power">
              <MappingFragment StoreEntitySet="Power">
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="IDPower" ColumnName="IDPower" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="RehearsalDate">
            <EntityTypeMapping TypeName="sm_RDKModel.RehearsalDate">
              <MappingFragment StoreEntitySet="RehearsalDate">
                <ScalarProperty Name="RehearsalDate1" ColumnName="RehearsalDate" />
                <ScalarProperty Name="IDData" ColumnName="IDData" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="RehearsalSchedule">
            <EntityTypeMapping TypeName="sm_RDKModel.RehearsalSchedule">
              <MappingFragment StoreEntitySet="RehearsalSchedule">
                <ScalarProperty Name="RehearsalTime" ColumnName="RehearsalTime" />
                <ScalarProperty Name="IDUser" ColumnName="IDUser" />
                <ScalarProperty Name="IDSchedule" ColumnName="IDSchedule" />
                <ScalarProperty Name="ID" ColumnName="ID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Users">
            <EntityTypeMapping TypeName="sm_RDKModel.Users">
              <MappingFragment StoreEntitySet="Users">
                <ScalarProperty Name="IDPost" ColumnName="IDPost" />
                <ScalarProperty Name="IDPower" ColumnName="IDPower" />
                <ScalarProperty Name="Number" ColumnName="Number" />
                <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="IDUser" ColumnName="IDUser" />
              </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>