CatProejct/CatProject/Model1.edmx

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
    <Schema Namespace="Хранилище Mukhina2023Model" 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="BreedTable">
          <Key>
            <PropertyRef Name="idBreed" />
          </Key>
          <Property Name="idBreed" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Breed" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="CatTable">
          <Key>
            <PropertyRef Name="idCat" />
          </Key>
          <Property Name="idCat" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="CatName" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="idBreed" Type="int" Nullable="false" />
          <Property Name="Birthday" Type="date" Nullable="false" />
          <Property Name="idGender" Type="int" Nullable="false" />
          <Property Name="Photo" Type="nvarchar(max)" />
        </EntityType>
        <EntityType Name="feedCatTable">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idCat" Type="int" Nullable="false" />
          <Property Name="idFeed" Type="int" Nullable="false" />
          <Property Name="Count" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Feedtable">
          <Key>
            <PropertyRef Name="idFeed" />
          </Key>
          <Property Name="idFeed" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Feed" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Price" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="GenderTable">
          <Key>
            <PropertyRef Name="idGender" />
          </Key>
          <Property Name="idGender" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Gender" Type="nvarchar" MaxLength="10" Nullable="false" />
        </EntityType>
        <EntityType Name="PasssportTable">
          <Key>
            <PropertyRef Name="idCat" />
          </Key>
          <Property Name="idCat" Type="int" Nullable="false" />
          <Property Name="UniqueNumber" Type="nchar" MaxLength="10" Nullable="false" />
          <Property Name="Color" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="TraitCatTable">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idCat" Type="int" Nullable="false" />
          <Property Name="idTrait" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="TraitTable">
          <Key>
            <PropertyRef Name="idTrait" />
          </Key>
          <Property Name="idTrait" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Trait" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="User">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Surname" Type="nvarchar" MaxLength="100" Nullable="false" />
          <Property Name="DateBirthday" Type="date" Nullable="false" />
          <Property Name="Role" Type="int" Nullable="false" />
          <Property Name="Login" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Password" Type="int" Nullable="false" />
          <Property Name="Avatar" Type="int" />
        </EntityType>
        <EntityType Name="UserPhoto">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="idUser" Type="int" Nullable="false" />
          <Property Name="Photo" Type="varbinary(max)" Nullable="false" />
        </EntityType>
        <EntityType Name="UserRole">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Role" Type="nvarchar" MaxLength="100" Nullable="false" />
        </EntityType>
        <Association Name="FK_CatTable_BreedTable">
          <End Role="BreedTable" Type="Self.BreedTable" Multiplicity="1" />
          <End Role="CatTable" Type="Self.CatTable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="BreedTable">
              <PropertyRef Name="idBreed" />
            </Principal>
            <Dependent Role="CatTable">
              <PropertyRef Name="idBreed" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CatTable_GenderTable">
          <End Role="GenderTable" Type="Self.GenderTable" Multiplicity="1" />
          <End Role="CatTable" Type="Self.CatTable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="GenderTable">
              <PropertyRef Name="idGender" />
            </Principal>
            <Dependent Role="CatTable">
              <PropertyRef Name="idGender" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_feedCatTable_CatTable">
          <End Role="CatTable" Type="Self.CatTable" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="feedCatTable" Type="Self.feedCatTable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="CatTable">
              <PropertyRef Name="idCat" />
            </Principal>
            <Dependent Role="feedCatTable">
              <PropertyRef Name="idCat" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_feedCatTable_Feedtable">
          <End Role="Feedtable" Type="Self.Feedtable" Multiplicity="1" />
          <End Role="feedCatTable" Type="Self.feedCatTable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Feedtable">
              <PropertyRef Name="idFeed" />
            </Principal>
            <Dependent Role="feedCatTable">
              <PropertyRef Name="idFeed" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_PasssportTable_CatTable">
          <End Role="CatTable" Type="Self.CatTable" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="PasssportTable" Type="Self.PasssportTable" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="CatTable">
              <PropertyRef Name="idCat" />
            </Principal>
            <Dependent Role="PasssportTable">
              <PropertyRef Name="idCat" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_TraitCatTable_CatTable">
          <End Role="CatTable" Type="Self.CatTable" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="TraitCatTable" Type="Self.TraitCatTable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="CatTable">
              <PropertyRef Name="idCat" />
            </Principal>
            <Dependent Role="TraitCatTable">
              <PropertyRef Name="idCat" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_TraitCatTable_TraitTable">
          <End Role="TraitTable" Type="Self.TraitTable" Multiplicity="1" />
          <End Role="TraitCatTable" Type="Self.TraitCatTable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="TraitTable">
              <PropertyRef Name="idTrait" />
            </Principal>
            <Dependent Role="TraitCatTable">
              <PropertyRef Name="idTrait" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_User_UserRole">
          <End Role="UserRole" Type="Self.UserRole" Multiplicity="1" />
          <End Role="User" Type="Self.User" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="UserRole">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="User">
              <PropertyRef Name="Role" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserPhoto_User">
          <End Role="User" Type="Self.User" Multiplicity="1" />
          <End Role="UserPhoto" Type="Self.UserPhoto" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="User">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="UserPhoto">
              <PropertyRef Name="idUser" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Хранилище Mukhina2023ModelContainer">
          <EntitySet Name="BreedTable" EntityType="Self.BreedTable" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="CatTable" EntityType="Self.CatTable" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="feedCatTable" EntityType="Self.feedCatTable" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Feedtable" EntityType="Self.Feedtable" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="GenderTable" EntityType="Self.GenderTable" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="PasssportTable" EntityType="Self.PasssportTable" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="TraitCatTable" EntityType="Self.TraitCatTable" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="TraitTable" EntityType="Self.TraitTable" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="User" EntityType="Self.User" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="UserPhoto" EntityType="Self.UserPhoto" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="UserRole" EntityType="Self.UserRole" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK_CatTable_BreedTable" Association="Self.FK_CatTable_BreedTable">
            <End Role="BreedTable" EntitySet="BreedTable" />
            <End Role="CatTable" EntitySet="CatTable" />
          </AssociationSet>
          <AssociationSet Name="FK_CatTable_GenderTable" Association="Self.FK_CatTable_GenderTable">
            <End Role="GenderTable" EntitySet="GenderTable" />
            <End Role="CatTable" EntitySet="CatTable" />
          </AssociationSet>
          <AssociationSet Name="FK_feedCatTable_CatTable" Association="Self.FK_feedCatTable_CatTable">
            <End Role="CatTable" EntitySet="CatTable" />
            <End Role="feedCatTable" EntitySet="feedCatTable" />
          </AssociationSet>
          <AssociationSet Name="FK_feedCatTable_Feedtable" Association="Self.FK_feedCatTable_Feedtable">
            <End Role="Feedtable" EntitySet="Feedtable" />
            <End Role="feedCatTable" EntitySet="feedCatTable" />
          </AssociationSet>
          <AssociationSet Name="FK_PasssportTable_CatTable" Association="Self.FK_PasssportTable_CatTable">
            <End Role="CatTable" EntitySet="CatTable" />
            <End Role="PasssportTable" EntitySet="PasssportTable" />
          </AssociationSet>
          <AssociationSet Name="FK_TraitCatTable_CatTable" Association="Self.FK_TraitCatTable_CatTable">
            <End Role="CatTable" EntitySet="CatTable" />
            <End Role="TraitCatTable" EntitySet="TraitCatTable" />
          </AssociationSet>
          <AssociationSet Name="FK_TraitCatTable_TraitTable" Association="Self.FK_TraitCatTable_TraitTable">
            <End Role="TraitTable" EntitySet="TraitTable" />
            <End Role="TraitCatTable" EntitySet="TraitCatTable" />
          </AssociationSet>
          <AssociationSet Name="FK_User_UserRole" Association="Self.FK_User_UserRole">
            <End Role="UserRole" EntitySet="UserRole" />
            <End Role="User" EntitySet="User" />
          </AssociationSet>
          <AssociationSet Name="FK_UserPhoto_User" Association="Self.FK_UserPhoto_User">
            <End Role="User" EntitySet="User" />
            <End Role="UserPhoto" EntitySet="UserPhoto" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="Mukhina2023Model" 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="Mukhina2023Entities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="BreedTable" EntityType="Mukhina2023Model.BreedTable" />
          <EntitySet Name="CatTable" EntityType="Mukhina2023Model.CatTable" />
          <EntitySet Name="feedCatTable" EntityType="Mukhina2023Model.feedCatTable" />
          <EntitySet Name="Feedtable" EntityType="Mukhina2023Model.Feedtable" />
          <EntitySet Name="GenderTable" EntityType="Mukhina2023Model.GenderTable" />
          <EntitySet Name="PasssportTable" EntityType="Mukhina2023Model.PasssportTable" />
          <EntitySet Name="TraitCatTable" EntityType="Mukhina2023Model.TraitCatTable" />
          <EntitySet Name="TraitTable" EntityType="Mukhina2023Model.TraitTable" />
          <EntitySet Name="User" EntityType="Mukhina2023Model.User" />
          <EntitySet Name="UserPhoto" EntityType="Mukhina2023Model.UserPhoto" />
          <EntitySet Name="UserRole" EntityType="Mukhina2023Model.UserRole" />
          <AssociationSet Name="FK_CatTable_BreedTable" Association="Mukhina2023Model.FK_CatTable_BreedTable">
            <End Role="BreedTable" EntitySet="BreedTable" />
            <End Role="CatTable" EntitySet="CatTable" />
          </AssociationSet>
          <AssociationSet Name="FK_CatTable_GenderTable" Association="Mukhina2023Model.FK_CatTable_GenderTable">
            <End Role="GenderTable" EntitySet="GenderTable" />
            <End Role="CatTable" EntitySet="CatTable" />
          </AssociationSet>
          <AssociationSet Name="FK_feedCatTable_CatTable" Association="Mukhina2023Model.FK_feedCatTable_CatTable">
            <End Role="CatTable" EntitySet="CatTable" />
            <End Role="feedCatTable" EntitySet="feedCatTable" />
          </AssociationSet>
          <AssociationSet Name="FK_PasssportTable_CatTable" Association="Mukhina2023Model.FK_PasssportTable_CatTable">
            <End Role="CatTable" EntitySet="CatTable" />
            <End Role="PasssportTable" EntitySet="PasssportTable" />
          </AssociationSet>
          <AssociationSet Name="FK_TraitCatTable_CatTable" Association="Mukhina2023Model.FK_TraitCatTable_CatTable">
            <End Role="CatTable" EntitySet="CatTable" />
            <End Role="TraitCatTable" EntitySet="TraitCatTable" />
          </AssociationSet>
          <AssociationSet Name="FK_feedCatTable_Feedtable" Association="Mukhina2023Model.FK_feedCatTable_Feedtable">
            <End Role="Feedtable" EntitySet="Feedtable" />
            <End Role="feedCatTable" EntitySet="feedCatTable" />
          </AssociationSet>
          <AssociationSet Name="FK_TraitCatTable_TraitTable" Association="Mukhina2023Model.FK_TraitCatTable_TraitTable">
            <End Role="TraitTable" EntitySet="TraitTable" />
            <End Role="TraitCatTable" EntitySet="TraitCatTable" />
          </AssociationSet>
          <AssociationSet Name="FK_User_UserRole" Association="Mukhina2023Model.FK_User_UserRole">
            <End Role="UserRole" EntitySet="UserRole" />
            <End Role="User" EntitySet="User" />
          </AssociationSet>
          <AssociationSet Name="FK_UserPhoto_User" Association="Mukhina2023Model.FK_UserPhoto_User">
            <End Role="User" EntitySet="User" />
            <End Role="UserPhoto" EntitySet="UserPhoto" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="BreedTable">
          <Key>
            <PropertyRef Name="idBreed" />
          </Key>
          <Property Name="idBreed" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Breed" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="CatTable" Relationship="Mukhina2023Model.FK_CatTable_BreedTable" FromRole="BreedTable" ToRole="CatTable" />
        </EntityType>
        <EntityType Name="CatTable">
          <Key>
            <PropertyRef Name="idCat" />
          </Key>
          <Property Name="idCat" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="CatName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="idBreed" Type="Int32" Nullable="false" />
          <Property Name="Birthday" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="idGender" Type="Int32" Nullable="false" />
          <Property Name="Photo" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="BreedTable" Relationship="Mukhina2023Model.FK_CatTable_BreedTable" FromRole="CatTable" ToRole="BreedTable" />
          <NavigationProperty Name="GenderTable" Relationship="Mukhina2023Model.FK_CatTable_GenderTable" FromRole="CatTable" ToRole="GenderTable" />
          <NavigationProperty Name="feedCatTable" Relationship="Mukhina2023Model.FK_feedCatTable_CatTable" FromRole="CatTable" ToRole="feedCatTable" />
          <NavigationProperty Name="PasssportTable" Relationship="Mukhina2023Model.FK_PasssportTable_CatTable" FromRole="CatTable" ToRole="PasssportTable" />
          <NavigationProperty Name="TraitCatTable" Relationship="Mukhina2023Model.FK_TraitCatTable_CatTable" FromRole="CatTable" ToRole="TraitCatTable" />
        </EntityType>
        <EntityType Name="feedCatTable">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idCat" Type="Int32" Nullable="false" />
          <Property Name="idFeed" Type="Int32" Nullable="false" />
          <Property Name="Count" Type="Int32" Nullable="false" />
          <NavigationProperty Name="CatTable" Relationship="Mukhina2023Model.FK_feedCatTable_CatTable" FromRole="feedCatTable" ToRole="CatTable" />
          <NavigationProperty Name="Feedtable" Relationship="Mukhina2023Model.FK_feedCatTable_Feedtable" FromRole="feedCatTable" ToRole="Feedtable" />
        </EntityType>
        <EntityType Name="Feedtable">
          <Key>
            <PropertyRef Name="idFeed" />
          </Key>
          <Property Name="idFeed" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Feed" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Price" Type="Int32" Nullable="false" />
          <NavigationProperty Name="feedCatTable" Relationship="Mukhina2023Model.FK_feedCatTable_Feedtable" FromRole="Feedtable" ToRole="feedCatTable" />
        </EntityType>
        <EntityType Name="GenderTable">
          <Key>
            <PropertyRef Name="idGender" />
          </Key>
          <Property Name="idGender" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Gender" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="CatTable" Relationship="Mukhina2023Model.FK_CatTable_GenderTable" FromRole="GenderTable" ToRole="CatTable" />
        </EntityType>
        <EntityType Name="PasssportTable">
          <Key>
            <PropertyRef Name="idCat" />
          </Key>
          <Property Name="idCat" Type="Int32" Nullable="false" />
          <Property Name="UniqueNumber" Type="String" Nullable="false" MaxLength="10" FixedLength="true" Unicode="true" />
          <Property Name="Color" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="CatTable" Relationship="Mukhina2023Model.FK_PasssportTable_CatTable" FromRole="PasssportTable" ToRole="CatTable" />
        </EntityType>
        <EntityType Name="TraitCatTable">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idCat" Type="Int32" Nullable="false" />
          <Property Name="idTrait" Type="Int32" Nullable="false" />
          <NavigationProperty Name="CatTable" Relationship="Mukhina2023Model.FK_TraitCatTable_CatTable" FromRole="TraitCatTable" ToRole="CatTable" />
          <NavigationProperty Name="TraitTable" Relationship="Mukhina2023Model.FK_TraitCatTable_TraitTable" FromRole="TraitCatTable" ToRole="TraitTable" />
        </EntityType>
        <EntityType Name="TraitTable">
          <Key>
            <PropertyRef Name="idTrait" />
          </Key>
          <Property Name="idTrait" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Trait" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="TraitCatTable" Relationship="Mukhina2023Model.FK_TraitCatTable_TraitTable" FromRole="TraitTable" ToRole="TraitCatTable" />
        </EntityType>
        <EntityType Name="User">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Name" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Surname" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="DateBirthday" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Role" Type="Int32" Nullable="false" />
          <Property Name="Login" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Password" Type="Int32" Nullable="false" />
          <Property Name="Avatar" Type="Int32" />
          <NavigationProperty Name="UserRole" Relationship="Mukhina2023Model.FK_User_UserRole" FromRole="User" ToRole="UserRole" />
          <NavigationProperty Name="UserPhoto" Relationship="Mukhina2023Model.FK_UserPhoto_User" FromRole="User" ToRole="UserPhoto" />
        </EntityType>
        <EntityType Name="UserPhoto">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="idUser" Type="Int32" Nullable="false" />
          <Property Name="Photo" Type="Binary" Nullable="false" MaxLength="Max" FixedLength="false" />
          <NavigationProperty Name="User" Relationship="Mukhina2023Model.FK_UserPhoto_User" FromRole="UserPhoto" ToRole="User" />
        </EntityType>
        <EntityType Name="UserRole">
          <Key>
            <PropertyRef Name="id" />
          </Key>
          <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Role" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="User" Relationship="Mukhina2023Model.FK_User_UserRole" FromRole="UserRole" ToRole="User" />
        </EntityType>
        <Association Name="FK_CatTable_BreedTable">
          <End Type="Mukhina2023Model.BreedTable" Role="BreedTable" Multiplicity="1" />
          <End Type="Mukhina2023Model.CatTable" Role="CatTable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="BreedTable">
              <PropertyRef Name="idBreed" />
            </Principal>
            <Dependent Role="CatTable">
              <PropertyRef Name="idBreed" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_CatTable_GenderTable">
          <End Type="Mukhina2023Model.GenderTable" Role="GenderTable" Multiplicity="1" />
          <End Type="Mukhina2023Model.CatTable" Role="CatTable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="GenderTable">
              <PropertyRef Name="idGender" />
            </Principal>
            <Dependent Role="CatTable">
              <PropertyRef Name="idGender" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_feedCatTable_CatTable">
          <End Type="Mukhina2023Model.CatTable" Role="CatTable" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="Mukhina2023Model.feedCatTable" Role="feedCatTable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="CatTable">
              <PropertyRef Name="idCat" />
            </Principal>
            <Dependent Role="feedCatTable">
              <PropertyRef Name="idCat" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_PasssportTable_CatTable">
          <End Type="Mukhina2023Model.CatTable" Role="CatTable" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="Mukhina2023Model.PasssportTable" Role="PasssportTable" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="CatTable">
              <PropertyRef Name="idCat" />
            </Principal>
            <Dependent Role="PasssportTable">
              <PropertyRef Name="idCat" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_TraitCatTable_CatTable">
          <End Type="Mukhina2023Model.CatTable" Role="CatTable" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="Mukhina2023Model.TraitCatTable" Role="TraitCatTable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="CatTable">
              <PropertyRef Name="idCat" />
            </Principal>
            <Dependent Role="TraitCatTable">
              <PropertyRef Name="idCat" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_feedCatTable_Feedtable">
          <End Type="Mukhina2023Model.Feedtable" Role="Feedtable" Multiplicity="1" />
          <End Type="Mukhina2023Model.feedCatTable" Role="feedCatTable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Feedtable">
              <PropertyRef Name="idFeed" />
            </Principal>
            <Dependent Role="feedCatTable">
              <PropertyRef Name="idFeed" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_TraitCatTable_TraitTable">
          <End Type="Mukhina2023Model.TraitTable" Role="TraitTable" Multiplicity="1" />
          <End Type="Mukhina2023Model.TraitCatTable" Role="TraitCatTable" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="TraitTable">
              <PropertyRef Name="idTrait" />
            </Principal>
            <Dependent Role="TraitCatTable">
              <PropertyRef Name="idTrait" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_User_UserRole">
          <End Type="Mukhina2023Model.UserRole" Role="UserRole" Multiplicity="1" />
          <End Type="Mukhina2023Model.User" Role="User" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="UserRole">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="User">
              <PropertyRef Name="Role" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UserPhoto_User">
          <End Type="Mukhina2023Model.User" Role="User" Multiplicity="1" />
          <End Type="Mukhina2023Model.UserPhoto" Role="UserPhoto" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="User">
              <PropertyRef Name="id" />
            </Principal>
            <Dependent Role="UserPhoto">
              <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="Хранилище Mukhina2023ModelContainer" CdmEntityContainer="Mukhina2023Entities">
          <EntitySetMapping Name="BreedTable">
            <EntityTypeMapping TypeName="Mukhina2023Model.BreedTable">
              <MappingFragment StoreEntitySet="BreedTable">
                <ScalarProperty Name="Breed" ColumnName="Breed" />
                <ScalarProperty Name="idBreed" ColumnName="idBreed" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="CatTable">
            <EntityTypeMapping TypeName="Mukhina2023Model.CatTable">
              <MappingFragment StoreEntitySet="CatTable">
                <ScalarProperty Name="Photo" ColumnName="Photo" />
                <ScalarProperty Name="idGender" ColumnName="idGender" />
                <ScalarProperty Name="Birthday" ColumnName="Birthday" />
                <ScalarProperty Name="idBreed" ColumnName="idBreed" />
                <ScalarProperty Name="CatName" ColumnName="CatName" />
                <ScalarProperty Name="idCat" ColumnName="idCat" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="feedCatTable">
            <EntityTypeMapping TypeName="Mukhina2023Model.feedCatTable">
              <MappingFragment StoreEntitySet="feedCatTable">
                <ScalarProperty Name="Count" ColumnName="Count" />
                <ScalarProperty Name="idFeed" ColumnName="idFeed" />
                <ScalarProperty Name="idCat" ColumnName="idCat" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Feedtable">
            <EntityTypeMapping TypeName="Mukhina2023Model.Feedtable">
              <MappingFragment StoreEntitySet="Feedtable">
                <ScalarProperty Name="Price" ColumnName="Price" />
                <ScalarProperty Name="Feed" ColumnName="Feed" />
                <ScalarProperty Name="idFeed" ColumnName="idFeed" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="GenderTable">
            <EntityTypeMapping TypeName="Mukhina2023Model.GenderTable">
              <MappingFragment StoreEntitySet="GenderTable">
                <ScalarProperty Name="Gender" ColumnName="Gender" />
                <ScalarProperty Name="idGender" ColumnName="idGender" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="PasssportTable">
            <EntityTypeMapping TypeName="Mukhina2023Model.PasssportTable">
              <MappingFragment StoreEntitySet="PasssportTable">
                <ScalarProperty Name="Color" ColumnName="Color" />
                <ScalarProperty Name="UniqueNumber" ColumnName="UniqueNumber" />
                <ScalarProperty Name="idCat" ColumnName="idCat" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="TraitCatTable">
            <EntityTypeMapping TypeName="Mukhina2023Model.TraitCatTable">
              <MappingFragment StoreEntitySet="TraitCatTable">
                <ScalarProperty Name="idTrait" ColumnName="idTrait" />
                <ScalarProperty Name="idCat" ColumnName="idCat" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="TraitTable">
            <EntityTypeMapping TypeName="Mukhina2023Model.TraitTable">
              <MappingFragment StoreEntitySet="TraitTable">
                <ScalarProperty Name="Trait" ColumnName="Trait" />
                <ScalarProperty Name="idTrait" ColumnName="idTrait" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="User">
            <EntityTypeMapping TypeName="Mukhina2023Model.User">
              <MappingFragment StoreEntitySet="User">
                <ScalarProperty Name="Avatar" ColumnName="Avatar" />
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="Login" ColumnName="Login" />
                <ScalarProperty Name="Role" ColumnName="Role" />
                <ScalarProperty Name="DateBirthday" ColumnName="DateBirthday" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="UserPhoto">
            <EntityTypeMapping TypeName="Mukhina2023Model.UserPhoto">
              <MappingFragment StoreEntitySet="UserPhoto">
                <ScalarProperty Name="Photo" ColumnName="Photo" />
                <ScalarProperty Name="idUser" ColumnName="idUser" />
                <ScalarProperty Name="id" ColumnName="id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="UserRole">
            <EntityTypeMapping TypeName="Mukhina2023Model.UserRole">
              <MappingFragment StoreEntitySet="UserRole">
                <ScalarProperty Name="Role" ColumnName="Role" />
                <ScalarProperty Name="id" ColumnName="id" />
              </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>