<?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="Хранилище P_KolesovAD_ModuleEKZModel" 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="authors">
          <Key>
            <PropertyRef Name="id_author" />
          </Key>
          <Property Name="id_author" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="name_author" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="books">
          <Key>
            <PropertyRef Name="id_book" />
          </Key>
          <Property Name="id_book" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="title_book" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="id_genre" Type="int" Nullable="false" />
          <Property Name="id_author" Type="int" Nullable="false" />
          <Property Name="count_in_shop" Type="int" Nullable="false" />
          <Property Name="count_in_stock" Type="int" Nullable="false" />
          <Property Name="description" Type="varchar(max)" />
          <Property Name="cover" Type="varchar(max)" />
          <Property Name="price" Type="money" />
        </EntityType>
        <EntityType Name="genres">
          <Key>
            <PropertyRef Name="id_genre" />
          </Key>
          <Property Name="id_genre" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="title_genre" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="orders">
          <Key>
            <PropertyRef Name="id_zakaza" />
          </Key>
          <Property Name="id_zakaza" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="count_book" Type="int" Nullable="false" />
          <Property Name="sale" Type="int" Nullable="false" />
          <Property Name="total_price" Type="money" Nullable="false" />
          <Property Name="date_reserve" Type="date" Nullable="false" />
        </EntityType>
        <Association Name="FK_books_authors">
          <End Role="authors" Type="Self.authors" Multiplicity="1" />
          <End Role="books" Type="Self.books" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="authors">
              <PropertyRef Name="id_author" />
            </Principal>
            <Dependent Role="books">
              <PropertyRef Name="id_author" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_books_genres">
          <End Role="genres" Type="Self.genres" Multiplicity="1" />
          <End Role="books" Type="Self.books" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="genres">
              <PropertyRef Name="id_genre" />
            </Principal>
            <Dependent Role="books">
              <PropertyRef Name="id_genre" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Хранилище P_KolesovAD_ModuleEKZModelContainer">
          <EntitySet Name="authors" EntityType="Self.authors" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="books" EntityType="Self.books" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="genres" EntityType="Self.genres" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="orders" EntityType="Self.orders" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_books_authors" Association="Self.FK_books_authors">
            <End Role="authors" EntitySet="authors" />
            <End Role="books" EntitySet="books" />
          </AssociationSet>
          <AssociationSet Name="FK_books_genres" Association="Self.FK_books_genres">
            <End Role="genres" EntitySet="genres" />
            <End Role="books" EntitySet="books" />
          </AssociationSet>
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="P_KolesovAD_ModuleEKZModel" 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="authors">
          <Key>
            <PropertyRef Name="id_author" />
          </Key>
          <Property Name="id_author" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="name_author" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="books" Relationship="Self.FK_books_authors" FromRole="authors" ToRole="books" />
        </EntityType>
        <EntityType Name="books">
          <Key>
            <PropertyRef Name="id_book" />
          </Key>
          <Property Name="id_book" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="title_book" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="id_genre" Type="Int32" Nullable="false" />
          <Property Name="id_author" Type="Int32" Nullable="false" />
          <Property Name="count_in_shop" Type="Int32" Nullable="false" />
          <Property Name="count_in_stock" Type="Int32" Nullable="false" />
          <Property Name="description" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="cover" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="price" Type="Decimal" Precision="19" Scale="4" />
          <NavigationProperty Name="authors" Relationship="Self.FK_books_authors" FromRole="books" ToRole="authors" />
          <NavigationProperty Name="genres" Relationship="Self.FK_books_genres" FromRole="books" ToRole="genres" />
        </EntityType>
        <EntityType Name="genres">
          <Key>
            <PropertyRef Name="id_genre" />
          </Key>
          <Property Name="id_genre" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="title_genre" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="books" Relationship="Self.FK_books_genres" FromRole="genres" ToRole="books" />
        </EntityType>
        <EntityType Name="orders">
          <Key>
            <PropertyRef Name="id_zakaza" />
          </Key>
          <Property Name="id_zakaza" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="count_book" Type="Int32" Nullable="false" />
          <Property Name="sale" Type="Int32" Nullable="false" />
          <Property Name="total_price" Type="Decimal" Precision="19" Scale="4" Nullable="false" />
          <Property Name="date_reserve" Type="DateTime" Nullable="false" Precision="0" />
        </EntityType>
        <Association Name="FK_books_authors">
          <End Role="authors" Type="Self.authors" Multiplicity="1" />
          <End Role="books" Type="Self.books" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="authors">
              <PropertyRef Name="id_author" />
            </Principal>
            <Dependent Role="books">
              <PropertyRef Name="id_author" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_books_genres">
          <End Role="genres" Type="Self.genres" Multiplicity="1" />
          <End Role="books" Type="Self.books" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="genres">
              <PropertyRef Name="id_genre" />
            </Principal>
            <Dependent Role="books">
              <PropertyRef Name="id_genre" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="EntitiesDB" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="authors" EntityType="Self.authors" />
          <EntitySet Name="books" EntityType="Self.books" />
          <EntitySet Name="genres" EntityType="Self.genres" />
          <EntitySet Name="orders" EntityType="Self.orders" />
          <AssociationSet Name="FK_books_authors" Association="Self.FK_books_authors">
            <End Role="authors" EntitySet="authors" />
            <End Role="books" EntitySet="books" />
          </AssociationSet>
          <AssociationSet Name="FK_books_genres" Association="Self.FK_books_genres">
            <End Role="genres" EntitySet="genres" />
            <End Role="books" EntitySet="books" />
          </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="Хранилище P_KolesovAD_ModuleEKZModelContainer" CdmEntityContainer="EntitiesDB">
          <EntitySetMapping Name="authors">
            <EntityTypeMapping TypeName="P_KolesovAD_ModuleEKZModel.authors">
              <MappingFragment StoreEntitySet="authors">
                <ScalarProperty Name="id_author" ColumnName="id_author" />
                <ScalarProperty Name="name_author" ColumnName="name_author" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="books">
            <EntityTypeMapping TypeName="P_KolesovAD_ModuleEKZModel.books">
              <MappingFragment StoreEntitySet="books">
                <ScalarProperty Name="id_book" ColumnName="id_book" />
                <ScalarProperty Name="title_book" ColumnName="title_book" />
                <ScalarProperty Name="id_genre" ColumnName="id_genre" />
                <ScalarProperty Name="id_author" ColumnName="id_author" />
                <ScalarProperty Name="count_in_shop" ColumnName="count_in_shop" />
                <ScalarProperty Name="count_in_stock" ColumnName="count_in_stock" />
                <ScalarProperty Name="description" ColumnName="description" />
                <ScalarProperty Name="cover" ColumnName="cover" />
                <ScalarProperty Name="price" ColumnName="price" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="genres">
            <EntityTypeMapping TypeName="P_KolesovAD_ModuleEKZModel.genres">
              <MappingFragment StoreEntitySet="genres">
                <ScalarProperty Name="id_genre" ColumnName="id_genre" />
                <ScalarProperty Name="title_genre" ColumnName="title_genre" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="orders">
            <EntityTypeMapping TypeName="P_KolesovAD_ModuleEKZModel.orders">
              <MappingFragment StoreEntitySet="orders">
                <ScalarProperty Name="id_zakaza" ColumnName="id_zakaza" />
                <ScalarProperty Name="count_book" ColumnName="count_book" />
                <ScalarProperty Name="sale" ColumnName="sale" />
                <ScalarProperty Name="total_price" ColumnName="total_price" />
                <ScalarProperty Name="date_reserve" ColumnName="date_reserve" />
              </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>