mdk-01-01-N5/Практическая №5/DataBase.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="Хранилище Model" 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="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="tbBasket">
          <Key>
            <PropertyRef Name="idBaslet" />
          </Key>
          <Property Name="idBaslet" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idUser" Type="int" Nullable="false" />
          <Property Name="basketSum" Type="float" Nullable="false" />
        </EntityType>
        <EntityType Name="tbBasketItems">
          <Key>
            <PropertyRef Name="idItem" />
          </Key>
          <Property Name="idItem" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idBasket" Type="int" Nullable="false" />
          <Property Name="idJewelry" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="tbBatchMaterial">
          <Key>
            <PropertyRef Name="idBatch" />
          </Key>
          <Property Name="idBatch" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idMaterial" Type="int" Nullable="false" />
          <Property Name="price" Type="float" Nullable="false" />
          <Property Name="dateTime" Type="datetime" />
        </EntityType>
        <EntityType Name="tbCategoryMaterial">
          <Key>
            <PropertyRef Name="idCategory" />
          </Key>
          <Property Name="idCategory" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nameCategory" Type="varchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="tbCompositionJewelry">
          <Key>
            <PropertyRef Name="idComposition" />
          </Key>
          <Property Name="idComposition" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idJewelry" Type="int" Nullable="false" />
          <Property Name="idBatch" Type="int" Nullable="false" />
          <Property Name="count" Type="float" Nullable="false" />
        </EntityType>
        <EntityType Name="tbGender">
          <Key>
            <PropertyRef Name="idGender" />
          </Key>
          <Property Name="idGender" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nameGender" Type="varchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="tbImageUser">
          <Key>
            <PropertyRef Name="idImage" />
          </Key>
          <Property Name="idImage" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idUser" Type="int" Nullable="false" />
          <Property Name="image" Type="varbinary(max)" Nullable="false" />
        </EntityType>
        <EntityType Name="tbJewelry">
          <Key>
            <PropertyRef Name="idJewelry" />
          </Key>
          <Property Name="idJewelry" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idType" Type="int" Nullable="false" />
          <Property Name="name" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="description" Type="varchar" MaxLength="5000" />
          <Property Name="price" Type="float" Nullable="false" />
          <Property Name="image" Type="varbinary(max)" />
        </EntityType>
        <EntityType Name="tbMaterial">
          <Key>
            <PropertyRef Name="idMaterial" />
          </Key>
          <Property Name="idMaterial" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nameMaterial" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="idCategory" Type="int" />
        </EntityType>
        <EntityType Name="tbOrder">
          <Key>
            <PropertyRef Name="idOrder" />
          </Key>
          <Property Name="idOrder" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idUser" Type="int" Nullable="false" />
          <Property Name="orderSum" Type="float" Nullable="false" />
        </EntityType>
        <EntityType Name="tbOrderItems">
          <Key>
            <PropertyRef Name="idItem" />
          </Key>
          <Property Name="idItem" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idOrder" Type="int" Nullable="false" />
          <Property Name="idJewelry" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="tbRole">
          <Key>
            <PropertyRef Name="idRole" />
          </Key>
          <Property Name="idRole" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nameRole" Type="varchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="tbTypeJewelry">
          <Key>
            <PropertyRef Name="idType" />
          </Key>
          <Property Name="idType" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="nameType" Type="varchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="tbUsers">
          <Key>
            <PropertyRef Name="idUser" />
          </Key>
          <Property Name="idUser" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="lastName" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="firstName" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="middleName" Type="varchar" MaxLength="50" />
          <Property Name="idGender" Type="int" Nullable="false" />
          <Property Name="dateBirthday" Type="date" Nullable="false" />
          <Property Name="login" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="password" Type="int" Nullable="false" />
          <Property Name="idRole" Type="int" Nullable="false" />
          <Property Name="idImage" Type="int" />
        </EntityType>
        <Association Name="FK_tbBasket_tbUsers">
          <End Role="tbUsers" Type="Self.tbUsers" Multiplicity="1" />
          <End Role="tbBasket" Type="Self.tbBasket" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbUsers">
              <PropertyRef Name="idUser" />
            </Principal>
            <Dependent Role="tbBasket">
              <PropertyRef Name="idUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbBasketItems_tbBasket">
          <End Role="tbBasket" Type="Self.tbBasket" Multiplicity="1" />
          <End Role="tbBasketItems" Type="Self.tbBasketItems" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbBasket">
              <PropertyRef Name="idBaslet" />
            </Principal>
            <Dependent Role="tbBasketItems">
              <PropertyRef Name="idBasket" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbBasketItems_tbJewelry">
          <End Role="tbJewelry" Type="Self.tbJewelry" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="tbBasketItems" Type="Self.tbBasketItems" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbJewelry">
              <PropertyRef Name="idJewelry" />
            </Principal>
            <Dependent Role="tbBasketItems">
              <PropertyRef Name="idJewelry" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbBatchMaterial_tbMaterial">
          <End Role="tbMaterial" Type="Self.tbMaterial" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="tbBatchMaterial" Type="Self.tbBatchMaterial" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbMaterial">
              <PropertyRef Name="idMaterial" />
            </Principal>
            <Dependent Role="tbBatchMaterial">
              <PropertyRef Name="idMaterial" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbCompositionJewelry_tbBatchMaterial">
          <End Role="tbBatchMaterial" Type="Self.tbBatchMaterial" Multiplicity="1" />
          <End Role="tbCompositionJewelry" Type="Self.tbCompositionJewelry" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbBatchMaterial">
              <PropertyRef Name="idBatch" />
            </Principal>
            <Dependent Role="tbCompositionJewelry">
              <PropertyRef Name="idBatch" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbCompositionJewelry_tbJewelry">
          <End Role="tbJewelry" Type="Self.tbJewelry" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="tbCompositionJewelry" Type="Self.tbCompositionJewelry" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbJewelry">
              <PropertyRef Name="idJewelry" />
            </Principal>
            <Dependent Role="tbCompositionJewelry">
              <PropertyRef Name="idJewelry" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbImageUser_tbUsers">
          <End Role="tbUsers" Type="Self.tbUsers" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="tbImageUser" Type="Self.tbImageUser" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbUsers">
              <PropertyRef Name="idUser" />
            </Principal>
            <Dependent Role="tbImageUser">
              <PropertyRef Name="idUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbJewelry_tbTypeJewelry">
          <End Role="tbTypeJewelry" Type="Self.tbTypeJewelry" Multiplicity="1" />
          <End Role="tbJewelry" Type="Self.tbJewelry" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbTypeJewelry">
              <PropertyRef Name="idType" />
            </Principal>
            <Dependent Role="tbJewelry">
              <PropertyRef Name="idType" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbMaterial_tbCategoryMaterial">
          <End Role="tbCategoryMaterial" Type="Self.tbCategoryMaterial" Multiplicity="0..1" />
          <End Role="tbMaterial" Type="Self.tbMaterial" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbCategoryMaterial">
              <PropertyRef Name="idCategory" />
            </Principal>
            <Dependent Role="tbMaterial">
              <PropertyRef Name="idCategory" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbOrder_tbUsers">
          <End Role="tbUsers" Type="Self.tbUsers" Multiplicity="1" />
          <End Role="tbOrder" Type="Self.tbOrder" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbUsers">
              <PropertyRef Name="idUser" />
            </Principal>
            <Dependent Role="tbOrder">
              <PropertyRef Name="idUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbOrderItems_tbJewelry">
          <End Role="tbJewelry" Type="Self.tbJewelry" Multiplicity="1" />
          <End Role="tbOrderItems" Type="Self.tbOrderItems" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbJewelry">
              <PropertyRef Name="idJewelry" />
            </Principal>
            <Dependent Role="tbOrderItems">
              <PropertyRef Name="idJewelry" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbOrderItems_tbOrder">
          <End Role="tbOrder" Type="Self.tbOrder" Multiplicity="1" />
          <End Role="tbOrderItems" Type="Self.tbOrderItems" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbOrder">
              <PropertyRef Name="idOrder" />
            </Principal>
            <Dependent Role="tbOrderItems">
              <PropertyRef Name="idOrder" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbUsers_tbGender">
          <End Role="tbGender" Type="Self.tbGender" Multiplicity="1" />
          <End Role="tbUsers" Type="Self.tbUsers" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbGender">
              <PropertyRef Name="idGender" />
            </Principal>
            <Dependent Role="tbUsers">
              <PropertyRef Name="idGender" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbUsers_tbImageUser">
          <End Role="tbImageUser" Type="Self.tbImageUser" Multiplicity="0..1" />
          <End Role="tbUsers" Type="Self.tbUsers" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbImageUser">
              <PropertyRef Name="idImage" />
            </Principal>
            <Dependent Role="tbUsers">
              <PropertyRef Name="idImage" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbUsers_tbRole">
          <End Role="tbRole" Type="Self.tbRole" Multiplicity="1" />
          <End Role="tbUsers" Type="Self.tbUsers" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbRole">
              <PropertyRef Name="idRole" />
            </Principal>
            <Dependent Role="tbUsers">
              <PropertyRef Name="idRole" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Хранилище ModelContainer">
          <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbBasket" EntityType="Self.tbBasket" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbBasketItems" EntityType="Self.tbBasketItems" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbBatchMaterial" EntityType="Self.tbBatchMaterial" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbCategoryMaterial" EntityType="Self.tbCategoryMaterial" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbCompositionJewelry" EntityType="Self.tbCompositionJewelry" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbGender" EntityType="Self.tbGender" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbImageUser" EntityType="Self.tbImageUser" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbJewelry" EntityType="Self.tbJewelry" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbMaterial" EntityType="Self.tbMaterial" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbOrder" EntityType="Self.tbOrder" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbOrderItems" EntityType="Self.tbOrderItems" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbRole" EntityType="Self.tbRole" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbTypeJewelry" EntityType="Self.tbTypeJewelry" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="tbUsers" EntityType="Self.tbUsers" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_tbBasket_tbUsers" Association="Self.FK_tbBasket_tbUsers">
            <End Role="tbUsers" EntitySet="tbUsers" />
            <End Role="tbBasket" EntitySet="tbBasket" />
          </AssociationSet>
          <AssociationSet Name="FK_tbBasketItems_tbBasket" Association="Self.FK_tbBasketItems_tbBasket">
            <End Role="tbBasket" EntitySet="tbBasket" />
            <End Role="tbBasketItems" EntitySet="tbBasketItems" />
          </AssociationSet>
          <AssociationSet Name="FK_tbBasketItems_tbJewelry" Association="Self.FK_tbBasketItems_tbJewelry">
            <End Role="tbJewelry" EntitySet="tbJewelry" />
            <End Role="tbBasketItems" EntitySet="tbBasketItems" />
          </AssociationSet>
          <AssociationSet Name="FK_tbBatchMaterial_tbMaterial" Association="Self.FK_tbBatchMaterial_tbMaterial">
            <End Role="tbMaterial" EntitySet="tbMaterial" />
            <End Role="tbBatchMaterial" EntitySet="tbBatchMaterial" />
          </AssociationSet>
          <AssociationSet Name="FK_tbCompositionJewelry_tbBatchMaterial" Association="Self.FK_tbCompositionJewelry_tbBatchMaterial">
            <End Role="tbBatchMaterial" EntitySet="tbBatchMaterial" />
            <End Role="tbCompositionJewelry" EntitySet="tbCompositionJewelry" />
          </AssociationSet>
          <AssociationSet Name="FK_tbCompositionJewelry_tbJewelry" Association="Self.FK_tbCompositionJewelry_tbJewelry">
            <End Role="tbJewelry" EntitySet="tbJewelry" />
            <End Role="tbCompositionJewelry" EntitySet="tbCompositionJewelry" />
          </AssociationSet>
          <AssociationSet Name="FK_tbImageUser_tbUsers" Association="Self.FK_tbImageUser_tbUsers">
            <End Role="tbUsers" EntitySet="tbUsers" />
            <End Role="tbImageUser" EntitySet="tbImageUser" />
          </AssociationSet>
          <AssociationSet Name="FK_tbJewelry_tbTypeJewelry" Association="Self.FK_tbJewelry_tbTypeJewelry">
            <End Role="tbTypeJewelry" EntitySet="tbTypeJewelry" />
            <End Role="tbJewelry" EntitySet="tbJewelry" />
          </AssociationSet>
          <AssociationSet Name="FK_tbMaterial_tbCategoryMaterial" Association="Self.FK_tbMaterial_tbCategoryMaterial">
            <End Role="tbCategoryMaterial" EntitySet="tbCategoryMaterial" />
            <End Role="tbMaterial" EntitySet="tbMaterial" />
          </AssociationSet>
          <AssociationSet Name="FK_tbOrder_tbUsers" Association="Self.FK_tbOrder_tbUsers">
            <End Role="tbUsers" EntitySet="tbUsers" />
            <End Role="tbOrder" EntitySet="tbOrder" />
          </AssociationSet>
          <AssociationSet Name="FK_tbOrderItems_tbJewelry" Association="Self.FK_tbOrderItems_tbJewelry">
            <End Role="tbJewelry" EntitySet="tbJewelry" />
            <End Role="tbOrderItems" EntitySet="tbOrderItems" />
          </AssociationSet>
          <AssociationSet Name="FK_tbOrderItems_tbOrder" Association="Self.FK_tbOrderItems_tbOrder">
            <End Role="tbOrder" EntitySet="tbOrder" />
            <End Role="tbOrderItems" EntitySet="tbOrderItems" />
          </AssociationSet>
          <AssociationSet Name="FK_tbUsers_tbGender" Association="Self.FK_tbUsers_tbGender">
            <End Role="tbGender" EntitySet="tbGender" />
            <End Role="tbUsers" EntitySet="tbUsers" />
          </AssociationSet>
          <AssociationSet Name="FK_tbUsers_tbImageUser" Association="Self.FK_tbUsers_tbImageUser">
            <End Role="tbImageUser" EntitySet="tbImageUser" />
            <End Role="tbUsers" EntitySet="tbUsers" />
          </AssociationSet>
          <AssociationSet Name="FK_tbUsers_tbRole" Association="Self.FK_tbUsers_tbRole">
            <End Role="tbRole" EntitySet="tbRole" />
            <End Role="tbUsers" EntitySet="tbUsers" />
          </AssociationSet>
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="Model" 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="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="tbBasket">
          <Key>
            <PropertyRef Name="idBaslet" />
          </Key>
          <Property Name="idBaslet" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idUser" Type="Int32" Nullable="false" />
          <Property Name="basketSum" Type="Double" Nullable="false" />
          <NavigationProperty Name="tbUsers" Relationship="Self.FK_tbBasket_tbUsers" FromRole="tbBasket" ToRole="tbUsers" />
          <NavigationProperty Name="tbBasketItems" Relationship="Self.FK_tbBasketItems_tbBasket" FromRole="tbBasket" ToRole="tbBasketItems" />
        </EntityType>
        <EntityType Name="tbBasketItems">
          <Key>
            <PropertyRef Name="idItem" />
          </Key>
          <Property Name="idItem" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idBasket" Type="Int32" Nullable="false" />
          <Property Name="idJewelry" Type="Int32" Nullable="false" />
          <NavigationProperty Name="tbBasket" Relationship="Self.FK_tbBasketItems_tbBasket" FromRole="tbBasketItems" ToRole="tbBasket" />
          <NavigationProperty Name="tbJewelry" Relationship="Self.FK_tbBasketItems_tbJewelry" FromRole="tbBasketItems" ToRole="tbJewelry" />
        </EntityType>
        <EntityType Name="tbBatchMaterial">
          <Key>
            <PropertyRef Name="idBatch" />
          </Key>
          <Property Name="idBatch" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idMaterial" Type="Int32" Nullable="false" />
          <Property Name="price" Type="Double" Nullable="false" />
          <Property Name="dateTime" Type="DateTime" Precision="3" />
          <NavigationProperty Name="tbMaterial" Relationship="Self.FK_tbBatchMaterial_tbMaterial" FromRole="tbBatchMaterial" ToRole="tbMaterial" />
          <NavigationProperty Name="tbCompositionJewelry" Relationship="Self.FK_tbCompositionJewelry_tbBatchMaterial" FromRole="tbBatchMaterial" ToRole="tbCompositionJewelry" />
        </EntityType>
        <EntityType Name="tbCategoryMaterial">
          <Key>
            <PropertyRef Name="idCategory" />
          </Key>
          <Property Name="idCategory" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nameCategory" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <NavigationProperty Name="tbMaterial" Relationship="Self.FK_tbMaterial_tbCategoryMaterial" FromRole="tbCategoryMaterial" ToRole="tbMaterial" />
        </EntityType>
        <EntityType Name="tbCompositionJewelry">
          <Key>
            <PropertyRef Name="idComposition" />
          </Key>
          <Property Name="idComposition" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idJewelry" Type="Int32" Nullable="false" />
          <Property Name="idBatch" Type="Int32" Nullable="false" />
          <Property Name="count" Type="Double" Nullable="false" />
          <NavigationProperty Name="tbBatchMaterial" Relationship="Self.FK_tbCompositionJewelry_tbBatchMaterial" FromRole="tbCompositionJewelry" ToRole="tbBatchMaterial" />
          <NavigationProperty Name="tbJewelry" Relationship="Self.FK_tbCompositionJewelry_tbJewelry" FromRole="tbCompositionJewelry" ToRole="tbJewelry" />
        </EntityType>
        <EntityType Name="tbGender">
          <Key>
            <PropertyRef Name="idGender" />
          </Key>
          <Property Name="idGender" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nameGender" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <NavigationProperty Name="tbUsers" Relationship="Self.FK_tbUsers_tbGender" FromRole="tbGender" ToRole="tbUsers" />
        </EntityType>
        <EntityType Name="tbImageUser">
          <Key>
            <PropertyRef Name="idImage" />
          </Key>
          <Property Name="idImage" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idUser" Type="Int32" Nullable="false" />
          <Property Name="image" Type="Binary" MaxLength="Max" FixedLength="false" Nullable="false" />
          <NavigationProperty Name="tbUsers" Relationship="Self.FK_tbImageUser_tbUsers" FromRole="tbImageUser" ToRole="tbUsers" />
          <NavigationProperty Name="tbUsers1" Relationship="Self.FK_tbUsers_tbImageUser" FromRole="tbImageUser" ToRole="tbUsers" />
        </EntityType>
        <EntityType Name="tbJewelry">
          <Key>
            <PropertyRef Name="idJewelry" />
          </Key>
          <Property Name="idJewelry" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idType" Type="Int32" Nullable="false" />
          <Property Name="name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="description" Type="String" MaxLength="5000" FixedLength="false" Unicode="false" />
          <Property Name="price" Type="Double" Nullable="false" />
          <Property Name="image" Type="Binary" MaxLength="Max" FixedLength="false" />
          <NavigationProperty Name="tbBasketItems" Relationship="Self.FK_tbBasketItems_tbJewelry" FromRole="tbJewelry" ToRole="tbBasketItems" />
          <NavigationProperty Name="tbCompositionJewelry" Relationship="Self.FK_tbCompositionJewelry_tbJewelry" FromRole="tbJewelry" ToRole="tbCompositionJewelry" />
          <NavigationProperty Name="tbTypeJewelry" Relationship="Self.FK_tbJewelry_tbTypeJewelry" FromRole="tbJewelry" ToRole="tbTypeJewelry" />
          <NavigationProperty Name="tbOrderItems" Relationship="Self.FK_tbOrderItems_tbJewelry" FromRole="tbJewelry" ToRole="tbOrderItems" />
        </EntityType>
        <EntityType Name="tbMaterial">
          <Key>
            <PropertyRef Name="idMaterial" />
          </Key>
          <Property Name="idMaterial" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nameMaterial" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="idCategory" Type="Int32" />
          <NavigationProperty Name="tbBatchMaterial" Relationship="Self.FK_tbBatchMaterial_tbMaterial" FromRole="tbMaterial" ToRole="tbBatchMaterial" />
          <NavigationProperty Name="tbCategoryMaterial" Relationship="Self.FK_tbMaterial_tbCategoryMaterial" FromRole="tbMaterial" ToRole="tbCategoryMaterial" />
        </EntityType>
        <EntityType Name="tbOrder">
          <Key>
            <PropertyRef Name="idOrder" />
          </Key>
          <Property Name="idOrder" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idUser" Type="Int32" Nullable="false" />
          <Property Name="orderSum" Type="Double" Nullable="false" />
          <NavigationProperty Name="tbUsers" Relationship="Self.FK_tbOrder_tbUsers" FromRole="tbOrder" ToRole="tbUsers" />
          <NavigationProperty Name="tbOrderItems" Relationship="Self.FK_tbOrderItems_tbOrder" FromRole="tbOrder" ToRole="tbOrderItems" />
        </EntityType>
        <EntityType Name="tbOrderItems">
          <Key>
            <PropertyRef Name="idItem" />
          </Key>
          <Property Name="idItem" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idOrder" Type="Int32" Nullable="false" />
          <Property Name="idJewelry" Type="Int32" Nullable="false" />
          <NavigationProperty Name="tbJewelry" Relationship="Self.FK_tbOrderItems_tbJewelry" FromRole="tbOrderItems" ToRole="tbJewelry" />
          <NavigationProperty Name="tbOrder" Relationship="Self.FK_tbOrderItems_tbOrder" FromRole="tbOrderItems" ToRole="tbOrder" />
        </EntityType>
        <EntityType Name="tbRole">
          <Key>
            <PropertyRef Name="idRole" />
          </Key>
          <Property Name="idRole" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nameRole" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <NavigationProperty Name="tbUsers" Relationship="Self.FK_tbUsers_tbRole" FromRole="tbRole" ToRole="tbUsers" />
        </EntityType>
        <EntityType Name="tbTypeJewelry">
          <Key>
            <PropertyRef Name="idType" />
          </Key>
          <Property Name="idType" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="nameType" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <NavigationProperty Name="tbJewelry" Relationship="Self.FK_tbJewelry_tbTypeJewelry" FromRole="tbTypeJewelry" ToRole="tbJewelry" />
        </EntityType>
        <EntityType Name="tbUsers">
          <Key>
            <PropertyRef Name="idUser" />
          </Key>
          <Property Name="idUser" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="lastName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="firstName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="middleName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="idGender" Type="Int32" Nullable="false" />
          <Property Name="dateBirthday" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="login" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
          <Property Name="password" Type="Int32" Nullable="false" />
          <Property Name="idRole" Type="Int32" Nullable="false" />
          <Property Name="idImage" Type="Int32" />
          <NavigationProperty Name="tbBasket" Relationship="Self.FK_tbBasket_tbUsers" FromRole="tbUsers" ToRole="tbBasket" />
          <NavigationProperty Name="tbGender" Relationship="Self.FK_tbUsers_tbGender" FromRole="tbUsers" ToRole="tbGender" />
          <NavigationProperty Name="tbImageUser" Relationship="Self.FK_tbImageUser_tbUsers" FromRole="tbUsers" ToRole="tbImageUser" />
          <NavigationProperty Name="tbImageUser1" Relationship="Self.FK_tbUsers_tbImageUser" FromRole="tbUsers" ToRole="tbImageUser" />
          <NavigationProperty Name="tbOrder" Relationship="Self.FK_tbOrder_tbUsers" FromRole="tbUsers" ToRole="tbOrder" />
          <NavigationProperty Name="tbRole" Relationship="Self.FK_tbUsers_tbRole" FromRole="tbUsers" ToRole="tbRole" />
        </EntityType>
        <Association Name="FK_tbBasket_tbUsers">
          <End Role="tbUsers" Type="Self.tbUsers" Multiplicity="1" />
          <End Role="tbBasket" Type="Self.tbBasket" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbUsers">
              <PropertyRef Name="idUser" />
            </Principal>
            <Dependent Role="tbBasket">
              <PropertyRef Name="idUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbBasketItems_tbBasket">
          <End Role="tbBasket" Type="Self.tbBasket" Multiplicity="1" />
          <End Role="tbBasketItems" Type="Self.tbBasketItems" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbBasket">
              <PropertyRef Name="idBaslet" />
            </Principal>
            <Dependent Role="tbBasketItems">
              <PropertyRef Name="idBasket" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbBasketItems_tbJewelry">
          <End Role="tbJewelry" Type="Self.tbJewelry" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="tbBasketItems" Type="Self.tbBasketItems" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbJewelry">
              <PropertyRef Name="idJewelry" />
            </Principal>
            <Dependent Role="tbBasketItems">
              <PropertyRef Name="idJewelry" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbBatchMaterial_tbMaterial">
          <End Role="tbMaterial" Type="Self.tbMaterial" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="tbBatchMaterial" Type="Self.tbBatchMaterial" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbMaterial">
              <PropertyRef Name="idMaterial" />
            </Principal>
            <Dependent Role="tbBatchMaterial">
              <PropertyRef Name="idMaterial" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbCompositionJewelry_tbBatchMaterial">
          <End Role="tbBatchMaterial" Type="Self.tbBatchMaterial" Multiplicity="1" />
          <End Role="tbCompositionJewelry" Type="Self.tbCompositionJewelry" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbBatchMaterial">
              <PropertyRef Name="idBatch" />
            </Principal>
            <Dependent Role="tbCompositionJewelry">
              <PropertyRef Name="idBatch" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbMaterial_tbCategoryMaterial">
          <End Role="tbCategoryMaterial" Type="Self.tbCategoryMaterial" Multiplicity="0..1" />
          <End Role="tbMaterial" Type="Self.tbMaterial" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbCategoryMaterial">
              <PropertyRef Name="idCategory" />
            </Principal>
            <Dependent Role="tbMaterial">
              <PropertyRef Name="idCategory" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbCompositionJewelry_tbJewelry">
          <End Role="tbJewelry" Type="Self.tbJewelry" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="tbCompositionJewelry" Type="Self.tbCompositionJewelry" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbJewelry">
              <PropertyRef Name="idJewelry" />
            </Principal>
            <Dependent Role="tbCompositionJewelry">
              <PropertyRef Name="idJewelry" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbUsers_tbGender">
          <End Role="tbGender" Type="Self.tbGender" Multiplicity="1" />
          <End Role="tbUsers" Type="Self.tbUsers" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbGender">
              <PropertyRef Name="idGender" />
            </Principal>
            <Dependent Role="tbUsers">
              <PropertyRef Name="idGender" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbImageUser_tbUsers">
          <End Role="tbUsers" Type="Self.tbUsers" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="tbImageUser" Type="Self.tbImageUser" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbUsers">
              <PropertyRef Name="idUser" />
            </Principal>
            <Dependent Role="tbImageUser">
              <PropertyRef Name="idUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbUsers_tbImageUser">
          <End Role="tbImageUser" Type="Self.tbImageUser" Multiplicity="0..1" />
          <End Role="tbUsers" Type="Self.tbUsers" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbImageUser">
              <PropertyRef Name="idImage" />
            </Principal>
            <Dependent Role="tbUsers">
              <PropertyRef Name="idImage" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbJewelry_tbTypeJewelry">
          <End Role="tbTypeJewelry" Type="Self.tbTypeJewelry" Multiplicity="1" />
          <End Role="tbJewelry" Type="Self.tbJewelry" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbTypeJewelry">
              <PropertyRef Name="idType" />
            </Principal>
            <Dependent Role="tbJewelry">
              <PropertyRef Name="idType" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbOrderItems_tbJewelry">
          <End Role="tbJewelry" Type="Self.tbJewelry" Multiplicity="1" />
          <End Role="tbOrderItems" Type="Self.tbOrderItems" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbJewelry">
              <PropertyRef Name="idJewelry" />
            </Principal>
            <Dependent Role="tbOrderItems">
              <PropertyRef Name="idJewelry" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbOrder_tbUsers">
          <End Role="tbUsers" Type="Self.tbUsers" Multiplicity="1" />
          <End Role="tbOrder" Type="Self.tbOrder" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbUsers">
              <PropertyRef Name="idUser" />
            </Principal>
            <Dependent Role="tbOrder">
              <PropertyRef Name="idUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbOrderItems_tbOrder">
          <End Role="tbOrder" Type="Self.tbOrder" Multiplicity="1" />
          <End Role="tbOrderItems" Type="Self.tbOrderItems" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbOrder">
              <PropertyRef Name="idOrder" />
            </Principal>
            <Dependent Role="tbOrderItems">
              <PropertyRef Name="idOrder" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_tbUsers_tbRole">
          <End Role="tbRole" Type="Self.tbRole" Multiplicity="1" />
          <End Role="tbUsers" Type="Self.tbUsers" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="tbRole">
              <PropertyRef Name="idRole" />
            </Principal>
            <Dependent Role="tbUsers">
              <PropertyRef Name="idRole" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="kotBase" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" />
          <EntitySet Name="tbBasket" EntityType="Self.tbBasket" />
          <EntitySet Name="tbBasketItems" EntityType="Self.tbBasketItems" />
          <EntitySet Name="tbBatchMaterial" EntityType="Self.tbBatchMaterial" />
          <EntitySet Name="tbCategoryMaterial" EntityType="Self.tbCategoryMaterial" />
          <EntitySet Name="tbCompositionJewelry" EntityType="Self.tbCompositionJewelry" />
          <EntitySet Name="tbGender" EntityType="Self.tbGender" />
          <EntitySet Name="tbImageUser" EntityType="Self.tbImageUser" />
          <EntitySet Name="tbJewelry" EntityType="Self.tbJewelry" />
          <EntitySet Name="tbMaterial" EntityType="Self.tbMaterial" />
          <EntitySet Name="tbOrder" EntityType="Self.tbOrder" />
          <EntitySet Name="tbOrderItems" EntityType="Self.tbOrderItems" />
          <EntitySet Name="tbRole" EntityType="Self.tbRole" />
          <EntitySet Name="tbTypeJewelry" EntityType="Self.tbTypeJewelry" />
          <EntitySet Name="tbUsers" EntityType="Self.tbUsers" />
          <AssociationSet Name="FK_tbBasket_tbUsers" Association="Self.FK_tbBasket_tbUsers">
            <End Role="tbUsers" EntitySet="tbUsers" />
            <End Role="tbBasket" EntitySet="tbBasket" />
          </AssociationSet>
          <AssociationSet Name="FK_tbBasketItems_tbBasket" Association="Self.FK_tbBasketItems_tbBasket">
            <End Role="tbBasket" EntitySet="tbBasket" />
            <End Role="tbBasketItems" EntitySet="tbBasketItems" />
          </AssociationSet>
          <AssociationSet Name="FK_tbBasketItems_tbJewelry" Association="Self.FK_tbBasketItems_tbJewelry">
            <End Role="tbJewelry" EntitySet="tbJewelry" />
            <End Role="tbBasketItems" EntitySet="tbBasketItems" />
          </AssociationSet>
          <AssociationSet Name="FK_tbBatchMaterial_tbMaterial" Association="Self.FK_tbBatchMaterial_tbMaterial">
            <End Role="tbMaterial" EntitySet="tbMaterial" />
            <End Role="tbBatchMaterial" EntitySet="tbBatchMaterial" />
          </AssociationSet>
          <AssociationSet Name="FK_tbCompositionJewelry_tbBatchMaterial" Association="Self.FK_tbCompositionJewelry_tbBatchMaterial">
            <End Role="tbBatchMaterial" EntitySet="tbBatchMaterial" />
            <End Role="tbCompositionJewelry" EntitySet="tbCompositionJewelry" />
          </AssociationSet>
          <AssociationSet Name="FK_tbMaterial_tbCategoryMaterial" Association="Self.FK_tbMaterial_tbCategoryMaterial">
            <End Role="tbCategoryMaterial" EntitySet="tbCategoryMaterial" />
            <End Role="tbMaterial" EntitySet="tbMaterial" />
          </AssociationSet>
          <AssociationSet Name="FK_tbCompositionJewelry_tbJewelry" Association="Self.FK_tbCompositionJewelry_tbJewelry">
            <End Role="tbJewelry" EntitySet="tbJewelry" />
            <End Role="tbCompositionJewelry" EntitySet="tbCompositionJewelry" />
          </AssociationSet>
          <AssociationSet Name="FK_tbUsers_tbGender" Association="Self.FK_tbUsers_tbGender">
            <End Role="tbGender" EntitySet="tbGender" />
            <End Role="tbUsers" EntitySet="tbUsers" />
          </AssociationSet>
          <AssociationSet Name="FK_tbImageUser_tbUsers" Association="Self.FK_tbImageUser_tbUsers">
            <End Role="tbUsers" EntitySet="tbUsers" />
            <End Role="tbImageUser" EntitySet="tbImageUser" />
          </AssociationSet>
          <AssociationSet Name="FK_tbUsers_tbImageUser" Association="Self.FK_tbUsers_tbImageUser">
            <End Role="tbImageUser" EntitySet="tbImageUser" />
            <End Role="tbUsers" EntitySet="tbUsers" />
          </AssociationSet>
          <AssociationSet Name="FK_tbJewelry_tbTypeJewelry" Association="Self.FK_tbJewelry_tbTypeJewelry">
            <End Role="tbTypeJewelry" EntitySet="tbTypeJewelry" />
            <End Role="tbJewelry" EntitySet="tbJewelry" />
          </AssociationSet>
          <AssociationSet Name="FK_tbOrderItems_tbJewelry" Association="Self.FK_tbOrderItems_tbJewelry">
            <End Role="tbJewelry" EntitySet="tbJewelry" />
            <End Role="tbOrderItems" EntitySet="tbOrderItems" />
          </AssociationSet>
          <AssociationSet Name="FK_tbOrder_tbUsers" Association="Self.FK_tbOrder_tbUsers">
            <End Role="tbUsers" EntitySet="tbUsers" />
            <End Role="tbOrder" EntitySet="tbOrder" />
          </AssociationSet>
          <AssociationSet Name="FK_tbOrderItems_tbOrder" Association="Self.FK_tbOrderItems_tbOrder">
            <End Role="tbOrder" EntitySet="tbOrder" />
            <End Role="tbOrderItems" EntitySet="tbOrderItems" />
          </AssociationSet>
          <AssociationSet Name="FK_tbUsers_tbRole" Association="Self.FK_tbUsers_tbRole">
            <End Role="tbRole" EntitySet="tbRole" />
            <End Role="tbUsers" EntitySet="tbUsers" />
          </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="Хранилище ModelContainer" CdmEntityContainer="kotBase">
          <EntitySetMapping Name="sysdiagrams">
            <EntityTypeMapping TypeName="Model.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="tbBasket">
            <EntityTypeMapping TypeName="Model.tbBasket">
              <MappingFragment StoreEntitySet="tbBasket">
                <ScalarProperty Name="idBaslet" ColumnName="idBaslet" />
                <ScalarProperty Name="idUser" ColumnName="idUser" />
                <ScalarProperty Name="basketSum" ColumnName="basketSum" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbBasketItems">
            <EntityTypeMapping TypeName="Model.tbBasketItems">
              <MappingFragment StoreEntitySet="tbBasketItems">
                <ScalarProperty Name="idItem" ColumnName="idItem" />
                <ScalarProperty Name="idBasket" ColumnName="idBasket" />
                <ScalarProperty Name="idJewelry" ColumnName="idJewelry" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbBatchMaterial">
            <EntityTypeMapping TypeName="Model.tbBatchMaterial">
              <MappingFragment StoreEntitySet="tbBatchMaterial">
                <ScalarProperty Name="idBatch" ColumnName="idBatch" />
                <ScalarProperty Name="idMaterial" ColumnName="idMaterial" />
                <ScalarProperty Name="price" ColumnName="price" />
                <ScalarProperty Name="dateTime" ColumnName="dateTime" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbCategoryMaterial">
            <EntityTypeMapping TypeName="Model.tbCategoryMaterial">
              <MappingFragment StoreEntitySet="tbCategoryMaterial">
                <ScalarProperty Name="idCategory" ColumnName="idCategory" />
                <ScalarProperty Name="nameCategory" ColumnName="nameCategory" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbCompositionJewelry">
            <EntityTypeMapping TypeName="Model.tbCompositionJewelry">
              <MappingFragment StoreEntitySet="tbCompositionJewelry">
                <ScalarProperty Name="idComposition" ColumnName="idComposition" />
                <ScalarProperty Name="idJewelry" ColumnName="idJewelry" />
                <ScalarProperty Name="idBatch" ColumnName="idBatch" />
                <ScalarProperty Name="count" ColumnName="count" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbGender">
            <EntityTypeMapping TypeName="Model.tbGender">
              <MappingFragment StoreEntitySet="tbGender">
                <ScalarProperty Name="idGender" ColumnName="idGender" />
                <ScalarProperty Name="nameGender" ColumnName="nameGender" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbImageUser">
            <EntityTypeMapping TypeName="Model.tbImageUser">
              <MappingFragment StoreEntitySet="tbImageUser">
                <ScalarProperty Name="idImage" ColumnName="idImage" />
                <ScalarProperty Name="idUser" ColumnName="idUser" />
                <ScalarProperty Name="image" ColumnName="image" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbJewelry">
            <EntityTypeMapping TypeName="Model.tbJewelry">
              <MappingFragment StoreEntitySet="tbJewelry">
                <ScalarProperty Name="idJewelry" ColumnName="idJewelry" />
                <ScalarProperty Name="idType" ColumnName="idType" />
                <ScalarProperty Name="name" ColumnName="name" />
                <ScalarProperty Name="description" ColumnName="description" />
                <ScalarProperty Name="price" ColumnName="price" />
                <ScalarProperty Name="image" ColumnName="image" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbMaterial">
            <EntityTypeMapping TypeName="Model.tbMaterial">
              <MappingFragment StoreEntitySet="tbMaterial">
                <ScalarProperty Name="idMaterial" ColumnName="idMaterial" />
                <ScalarProperty Name="nameMaterial" ColumnName="nameMaterial" />
                <ScalarProperty Name="idCategory" ColumnName="idCategory" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbOrder">
            <EntityTypeMapping TypeName="Model.tbOrder">
              <MappingFragment StoreEntitySet="tbOrder">
                <ScalarProperty Name="idOrder" ColumnName="idOrder" />
                <ScalarProperty Name="idUser" ColumnName="idUser" />
                <ScalarProperty Name="orderSum" ColumnName="orderSum" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbOrderItems">
            <EntityTypeMapping TypeName="Model.tbOrderItems">
              <MappingFragment StoreEntitySet="tbOrderItems">
                <ScalarProperty Name="idItem" ColumnName="idItem" />
                <ScalarProperty Name="idOrder" ColumnName="idOrder" />
                <ScalarProperty Name="idJewelry" ColumnName="idJewelry" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbRole">
            <EntityTypeMapping TypeName="Model.tbRole">
              <MappingFragment StoreEntitySet="tbRole">
                <ScalarProperty Name="idRole" ColumnName="idRole" />
                <ScalarProperty Name="nameRole" ColumnName="nameRole" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbTypeJewelry">
            <EntityTypeMapping TypeName="Model.tbTypeJewelry">
              <MappingFragment StoreEntitySet="tbTypeJewelry">
                <ScalarProperty Name="idType" ColumnName="idType" />
                <ScalarProperty Name="nameType" ColumnName="nameType" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="tbUsers">
            <EntityTypeMapping TypeName="Model.tbUsers">
              <MappingFragment StoreEntitySet="tbUsers">
                <ScalarProperty Name="idUser" ColumnName="idUser" />
                <ScalarProperty Name="lastName" ColumnName="lastName" />
                <ScalarProperty Name="firstName" ColumnName="firstName" />
                <ScalarProperty Name="middleName" ColumnName="middleName" />
                <ScalarProperty Name="idGender" ColumnName="idGender" />
                <ScalarProperty Name="dateBirthday" ColumnName="dateBirthday" />
                <ScalarProperty Name="login" ColumnName="login" />
                <ScalarProperty Name="password" ColumnName="password" />
                <ScalarProperty Name="idRole" ColumnName="idRole" />
                <ScalarProperty Name="idImage" ColumnName="idImage" />
              </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>