Kindergarten/Детский сад/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="Хранилище ModelKindergartenEntities" 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="Attendance">
          <Key>
            <PropertyRef Name="Id_visit" />
          </Key>
          <Property Name="Id_visit" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Date_visit" Type="date" Nullable="false" />
          <Property Name="Id_child" Type="int" Nullable="false" />
          <Property Name="Status_visit" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Children">
          <Key>
            <PropertyRef Name="Id_child" />
          </Key>
          <Property Name="Id_child" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Surname" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Names" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Patronymic" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Birthdate" Type="date" Nullable="false" />
          <Property Name="Id_gender" Type="int" Nullable="false" />
          <Property Name="Id_group" Type="int" Nullable="false" />
          <Property Name="Street" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Building" Type="nvarchar" MaxLength="10" Nullable="false" />
          <Property Name="Photo" Type="nvarchar" MaxLength="100" />
        </EntityType>
        <EntityType Name="Distributions">
          <Key>
            <PropertyRef Name="Id_distribution" />
          </Key>
          <Property Name="Id_distribution" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Id_employee" Type="int" Nullable="false" />
          <Property Name="Id_group" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Employees">
          <Key>
            <PropertyRef Name="Id_employee" />
          </Key>
          <Property Name="Id_employee" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Surname" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Names" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Patronymic" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Birthdate" Type="date" Nullable="false" />
          <Property Name="Id_gender" Type="int" Nullable="false" />
          <Property Name="Id_position" Type="int" Nullable="false" />
          <Property Name="Street" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Building" Type="nvarchar" MaxLength="10" Nullable="false" />
          <Property Name="Phone" Type="nvarchar" MaxLength="20" Nullable="false" />
          <Property Name="Login_user" Type="nvarchar" MaxLength="20" Nullable="false" />
          <Property Name="Password_user" Type="int" Nullable="false" />
          <Property Name="Id_role" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Genders">
          <Key>
            <PropertyRef Name="Id_gender" />
          </Key>
          <Property Name="Id_gender" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Gender" Type="nvarchar" MaxLength="10" Nullable="false" />
        </EntityType>
        <EntityType Name="Groups">
          <Key>
            <PropertyRef Name="Id_group" />
          </Key>
          <Property Name="Id_group" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Id_type" Type="int" Nullable="false" />
          <Property Name="Code" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Kinships">
          <Key>
            <PropertyRef Name="Id_kinship" />
          </Key>
          <Property Name="Id_kinship" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Id_parent" Type="int" Nullable="false" />
          <Property Name="Id_child" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Parents">
          <Key>
            <PropertyRef Name="Id_parent" />
          </Key>
          <Property Name="Id_parent" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Surname" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Names" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Patronymic" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Birthdate" Type="date" Nullable="false" />
          <Property Name="Id_gender" Type="int" Nullable="false" />
          <Property Name="Street" Type="nvarchar" MaxLength="50" Nullable="false" />
          <Property Name="Building" Type="nvarchar" MaxLength="10" Nullable="false" />
          <Property Name="Phone" Type="nvarchar" MaxLength="20" Nullable="false" />
        </EntityType>
        <EntityType Name="Photos">
          <Key>
            <PropertyRef Name="Id_photo" />
          </Key>
          <Property Name="Id_photo" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Id_employee" Type="int" />
          <Property Name="Byte_photo" Type="varbinary(max)" />
          <Property Name="Path_photo" Type="nvarchar" MaxLength="200" />
        </EntityType>
        <EntityType Name="Positions">
          <Key>
            <PropertyRef Name="Id_position" />
          </Key>
          <Property Name="Id_position" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Position" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <EntityType Name="Roles">
          <Key>
            <PropertyRef Name="Id_role" />
          </Key>
          <Property Name="Id_role" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Role_name" Type="nvarchar" MaxLength="20" Nullable="false" />
        </EntityType>
        <EntityType Name="Sertificates">
          <Key>
            <PropertyRef Name="Id_sertificate" />
          </Key>
          <Property Name="Id_sertificate" Type="int" Nullable="false" />
          <Property Name="Series" Type="nvarchar" MaxLength="10" Nullable="false" />
          <Property Name="Number" Type="int" Nullable="false" />
          <Property Name="Date_issue" Type="date" Nullable="false" />
          <Property Name="Iddued" Type="nvarchar" MaxLength="100" Nullable="false" />
        </EntityType>
        <EntityType Name="Types_group">
          <Key>
            <PropertyRef Name="Id_type" />
          </Key>
          <Property Name="Id_type" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Type_group" Type="nvarchar" MaxLength="50" Nullable="false" />
        </EntityType>
        <Association Name="FK__Attendanc__Id_ch__5F7E2DAC">
          <End Role="Children" Type="Self.Children" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Attendance" Type="Self.Attendance" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Children">
              <PropertyRef Name="Id_child" />
            </Principal>
            <Dependent Role="Attendance">
              <PropertyRef Name="Id_child" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Children__Id_gen__5BAD9CC8">
          <End Role="Genders" Type="Self.Genders" Multiplicity="1" />
          <End Role="Children" Type="Self.Children" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Genders">
              <PropertyRef Name="Id_gender" />
            </Principal>
            <Dependent Role="Children">
              <PropertyRef Name="Id_gender" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Children__Id_gro__5CA1C101">
          <End Role="Groups" Type="Self.Groups" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Children" Type="Self.Children" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groups">
              <PropertyRef Name="Id_group" />
            </Principal>
            <Dependent Role="Children">
              <PropertyRef Name="Id_group" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Distribut__Id_em__39237A9A">
          <End Role="Employees" Type="Self.Employees" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Distributions" Type="Self.Distributions" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="Id_employee" />
            </Principal>
            <Dependent Role="Distributions">
              <PropertyRef Name="Id_employee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Distribut__Id_gr__3A179ED3">
          <End Role="Groups" Type="Self.Groups" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Distributions" Type="Self.Distributions" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groups">
              <PropertyRef Name="Id_group" />
            </Principal>
            <Dependent Role="Distributions">
              <PropertyRef Name="Id_group" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Employees__Id_ge__1E6F845E">
          <End Role="Genders" Type="Self.Genders" Multiplicity="1" />
          <End Role="Employees" Type="Self.Employees" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Genders">
              <PropertyRef Name="Id_gender" />
            </Principal>
            <Dependent Role="Employees">
              <PropertyRef Name="Id_gender" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Employees__Id_po__1F63A897">
          <End Role="Positions" Type="Self.Positions" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Employees" Type="Self.Employees" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Positions">
              <PropertyRef Name="Id_position" />
            </Principal>
            <Dependent Role="Employees">
              <PropertyRef Name="Id_position" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Employees__Id_ro__2057CCD0">
          <End Role="Roles" Type="Self.Roles" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Employees" Type="Self.Employees" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Roles">
              <PropertyRef Name="Id_role" />
            </Principal>
            <Dependent Role="Employees">
              <PropertyRef Name="Id_role" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Groups__Id_type__4E53A1AA">
          <End Role="Types_group" Type="Self.Types_group" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Groups" Type="Self.Groups" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Types_group">
              <PropertyRef Name="Id_type" />
            </Principal>
            <Dependent Role="Groups">
              <PropertyRef Name="Id_type" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Kinships__Id_chi__6225902D">
          <End Role="Children" Type="Self.Children" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Kinships" Type="Self.Kinships" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Children">
              <PropertyRef Name="Id_child" />
            </Principal>
            <Dependent Role="Kinships">
              <PropertyRef Name="Id_child" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Parents__Id_gend__6CD828CA">
          <End Role="Genders" Type="Self.Genders" Multiplicity="1" />
          <End Role="Parents" Type="Self.Parents" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Genders">
              <PropertyRef Name="Id_gender" />
            </Principal>
            <Dependent Role="Parents">
              <PropertyRef Name="Id_gender" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Photos__Id_emplo__02925FBF">
          <End Role="Employees" Type="Self.Employees" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Photos" Type="Self.Photos" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="Id_employee" />
            </Principal>
            <Dependent Role="Photos">
              <PropertyRef Name="Id_employee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Kinships_Parents">
          <End Role="Parents" Type="Self.Parents" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Kinships" Type="Self.Kinships" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Parents">
              <PropertyRef Name="Id_parent" />
            </Principal>
            <Dependent Role="Kinships">
              <PropertyRef Name="Id_parent" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Sertificates_Children">
          <End Role="Children" Type="Self.Children" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Sertificates" Type="Self.Sertificates" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Children">
              <PropertyRef Name="Id_child" />
            </Principal>
            <Dependent Role="Sertificates">
              <PropertyRef Name="Id_sertificate" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Хранилище ModelKindergartenEntitiesContainer">
          <EntitySet Name="Attendance" EntityType="Self.Attendance" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Children" EntityType="Self.Children" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Distributions" EntityType="Self.Distributions" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Employees" EntityType="Self.Employees" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Genders" EntityType="Self.Genders" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Groups" EntityType="Self.Groups" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Kinships" EntityType="Self.Kinships" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Parents" EntityType="Self.Parents" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Photos" EntityType="Self.Photos" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Positions" EntityType="Self.Positions" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Roles" EntityType="Self.Roles" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Sertificates" EntityType="Self.Sertificates" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Types_group" EntityType="Self.Types_group" Schema="dbo" store:Type="Tables" />
          <AssociationSet Name="FK__Attendanc__Id_ch__5F7E2DAC" Association="Self.FK__Attendanc__Id_ch__5F7E2DAC">
            <End Role="Children" EntitySet="Children" />
            <End Role="Attendance" EntitySet="Attendance" />
          </AssociationSet>
          <AssociationSet Name="FK__Children__Id_gen__5BAD9CC8" Association="Self.FK__Children__Id_gen__5BAD9CC8">
            <End Role="Genders" EntitySet="Genders" />
            <End Role="Children" EntitySet="Children" />
          </AssociationSet>
          <AssociationSet Name="FK__Children__Id_gro__5CA1C101" Association="Self.FK__Children__Id_gro__5CA1C101">
            <End Role="Groups" EntitySet="Groups" />
            <End Role="Children" EntitySet="Children" />
          </AssociationSet>
          <AssociationSet Name="FK__Distribut__Id_em__39237A9A" Association="Self.FK__Distribut__Id_em__39237A9A">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="Distributions" EntitySet="Distributions" />
          </AssociationSet>
          <AssociationSet Name="FK__Distribut__Id_gr__3A179ED3" Association="Self.FK__Distribut__Id_gr__3A179ED3">
            <End Role="Groups" EntitySet="Groups" />
            <End Role="Distributions" EntitySet="Distributions" />
          </AssociationSet>
          <AssociationSet Name="FK__Employees__Id_ge__1E6F845E" Association="Self.FK__Employees__Id_ge__1E6F845E">
            <End Role="Genders" EntitySet="Genders" />
            <End Role="Employees" EntitySet="Employees" />
          </AssociationSet>
          <AssociationSet Name="FK__Employees__Id_po__1F63A897" Association="Self.FK__Employees__Id_po__1F63A897">
            <End Role="Positions" EntitySet="Positions" />
            <End Role="Employees" EntitySet="Employees" />
          </AssociationSet>
          <AssociationSet Name="FK__Employees__Id_ro__2057CCD0" Association="Self.FK__Employees__Id_ro__2057CCD0">
            <End Role="Roles" EntitySet="Roles" />
            <End Role="Employees" EntitySet="Employees" />
          </AssociationSet>
          <AssociationSet Name="FK__Groups__Id_type__4E53A1AA" Association="Self.FK__Groups__Id_type__4E53A1AA">
            <End Role="Types_group" EntitySet="Types_group" />
            <End Role="Groups" EntitySet="Groups" />
          </AssociationSet>
          <AssociationSet Name="FK__Kinships__Id_chi__6225902D" Association="Self.FK__Kinships__Id_chi__6225902D">
            <End Role="Children" EntitySet="Children" />
            <End Role="Kinships" EntitySet="Kinships" />
          </AssociationSet>
          <AssociationSet Name="FK__Parents__Id_gend__6CD828CA" Association="Self.FK__Parents__Id_gend__6CD828CA">
            <End Role="Genders" EntitySet="Genders" />
            <End Role="Parents" EntitySet="Parents" />
          </AssociationSet>
          <AssociationSet Name="FK__Photos__Id_emplo__02925FBF" Association="Self.FK__Photos__Id_emplo__02925FBF">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="Photos" EntitySet="Photos" />
          </AssociationSet>
          <AssociationSet Name="FK_Kinships_Parents" Association="Self.FK_Kinships_Parents">
            <End Role="Parents" EntitySet="Parents" />
            <End Role="Kinships" EntitySet="Kinships" />
          </AssociationSet>
          <AssociationSet Name="FK_Sertificates_Children" Association="Self.FK_Sertificates_Children">
            <End Role="Children" EntitySet="Children" />
            <End Role="Sertificates" EntitySet="Sertificates" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="ModelKindergartenEntities" 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="KindergartenEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Attendance" EntityType="ModelKindergartenEntities.Attendance" />
          <EntitySet Name="Children" EntityType="ModelKindergartenEntities.Children" />
          <EntitySet Name="Distributions" EntityType="ModelKindergartenEntities.Distributions" />
          <EntitySet Name="Employees" EntityType="ModelKindergartenEntities.Employees" />
          <EntitySet Name="Genders" EntityType="ModelKindergartenEntities.Genders" />
          <EntitySet Name="Groups" EntityType="ModelKindergartenEntities.Groups" />
          <EntitySet Name="Kinships" EntityType="ModelKindergartenEntities.Kinships" />
          <EntitySet Name="Parents" EntityType="ModelKindergartenEntities.Parents" />
          <EntitySet Name="Photos" EntityType="ModelKindergartenEntities.Photos" />
          <EntitySet Name="Positions" EntityType="ModelKindergartenEntities.Positions" />
          <EntitySet Name="Roles" EntityType="ModelKindergartenEntities.Roles" />
          <EntitySet Name="Sertificates" EntityType="ModelKindergartenEntities.Sertificates" />
          <EntitySet Name="Types_group" EntityType="ModelKindergartenEntities.Types_group" />
          <AssociationSet Name="FK__Attendanc__Id_ch__5F7E2DAC" Association="ModelKindergartenEntities.FK__Attendanc__Id_ch__5F7E2DAC">
            <End Role="Children" EntitySet="Children" />
            <End Role="Attendance" EntitySet="Attendance" />
          </AssociationSet>
          <AssociationSet Name="FK__Children__Id_gen__5BAD9CC8" Association="ModelKindergartenEntities.FK__Children__Id_gen__5BAD9CC8">
            <End Role="Genders" EntitySet="Genders" />
            <End Role="Children" EntitySet="Children" />
          </AssociationSet>
          <AssociationSet Name="FK__Children__Id_gro__5CA1C101" Association="ModelKindergartenEntities.FK__Children__Id_gro__5CA1C101">
            <End Role="Groups" EntitySet="Groups" />
            <End Role="Children" EntitySet="Children" />
          </AssociationSet>
          <AssociationSet Name="FK__Kinships__Id_chi__6225902D" Association="ModelKindergartenEntities.FK__Kinships__Id_chi__6225902D">
            <End Role="Children" EntitySet="Children" />
            <End Role="Kinships" EntitySet="Kinships" />
          </AssociationSet>
          <AssociationSet Name="FK_Sertificates_Children" Association="ModelKindergartenEntities.FK_Sertificates_Children">
            <End Role="Children" EntitySet="Children" />
            <End Role="Sertificates" EntitySet="Sertificates" />
          </AssociationSet>
          <AssociationSet Name="FK__Distribut__Id_em__39237A9A" Association="ModelKindergartenEntities.FK__Distribut__Id_em__39237A9A">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="Distributions" EntitySet="Distributions" />
          </AssociationSet>
          <AssociationSet Name="FK__Distribut__Id_gr__3A179ED3" Association="ModelKindergartenEntities.FK__Distribut__Id_gr__3A179ED3">
            <End Role="Groups" EntitySet="Groups" />
            <End Role="Distributions" EntitySet="Distributions" />
          </AssociationSet>
          <AssociationSet Name="FK__Employees__Id_ge__1E6F845E" Association="ModelKindergartenEntities.FK__Employees__Id_ge__1E6F845E">
            <End Role="Genders" EntitySet="Genders" />
            <End Role="Employees" EntitySet="Employees" />
          </AssociationSet>
          <AssociationSet Name="FK__Employees__Id_po__1F63A897" Association="ModelKindergartenEntities.FK__Employees__Id_po__1F63A897">
            <End Role="Positions" EntitySet="Positions" />
            <End Role="Employees" EntitySet="Employees" />
          </AssociationSet>
          <AssociationSet Name="FK__Employees__Id_ro__2057CCD0" Association="ModelKindergartenEntities.FK__Employees__Id_ro__2057CCD0">
            <End Role="Roles" EntitySet="Roles" />
            <End Role="Employees" EntitySet="Employees" />
          </AssociationSet>
          <AssociationSet Name="FK__Photos__Id_emplo__02925FBF" Association="ModelKindergartenEntities.FK__Photos__Id_emplo__02925FBF">
            <End Role="Employees" EntitySet="Employees" />
            <End Role="Photos" EntitySet="Photos" />
          </AssociationSet>
          <AssociationSet Name="FK__Parents__Id_gend__6CD828CA" Association="ModelKindergartenEntities.FK__Parents__Id_gend__6CD828CA">
            <End Role="Genders" EntitySet="Genders" />
            <End Role="Parents" EntitySet="Parents" />
          </AssociationSet>
          <AssociationSet Name="FK__Groups__Id_type__4E53A1AA" Association="ModelKindergartenEntities.FK__Groups__Id_type__4E53A1AA">
            <End Role="Types_group" EntitySet="Types_group" />
            <End Role="Groups" EntitySet="Groups" />
          </AssociationSet>
          <AssociationSet Name="FK_Kinships_Parents" Association="ModelKindergartenEntities.FK_Kinships_Parents">
            <End Role="Parents" EntitySet="Parents" />
            <End Role="Kinships" EntitySet="Kinships" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="Attendance">
          <Key>
            <PropertyRef Name="Id_visit" />
          </Key>
          <Property Name="Id_visit" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Date_visit" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Id_child" Type="Int32" Nullable="false" />
          <Property Name="Status_visit" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Children" Relationship="ModelKindergartenEntities.FK__Attendanc__Id_ch__5F7E2DAC" FromRole="Attendance" ToRole="Children" />
        </EntityType>
        <EntityType Name="Children">
          <Key>
            <PropertyRef Name="Id_child" />
          </Key>
          <Property Name="Id_child" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Surname" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Names" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Patronymic" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Birthdate" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Id_gender" Type="Int32" Nullable="false" />
          <Property Name="Id_group" Type="Int32" Nullable="false" />
          <Property Name="Street" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Building" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="Photo" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Attendance" Relationship="ModelKindergartenEntities.FK__Attendanc__Id_ch__5F7E2DAC" FromRole="Children" ToRole="Attendance" />
          <NavigationProperty Name="Genders" Relationship="ModelKindergartenEntities.FK__Children__Id_gen__5BAD9CC8" FromRole="Children" ToRole="Genders" />
          <NavigationProperty Name="Groups" Relationship="ModelKindergartenEntities.FK__Children__Id_gro__5CA1C101" FromRole="Children" ToRole="Groups" />
          <NavigationProperty Name="Kinships" Relationship="ModelKindergartenEntities.FK__Kinships__Id_chi__6225902D" FromRole="Children" ToRole="Kinships" />
          <NavigationProperty Name="Sertificates" Relationship="ModelKindergartenEntities.FK_Sertificates_Children" FromRole="Children" ToRole="Sertificates" />
        </EntityType>
        <EntityType Name="Distributions">
          <Key>
            <PropertyRef Name="Id_distribution" />
          </Key>
          <Property Name="Id_distribution" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Id_employee" Type="Int32" Nullable="false" />
          <Property Name="Id_group" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Employees" Relationship="ModelKindergartenEntities.FK__Distribut__Id_em__39237A9A" FromRole="Distributions" ToRole="Employees" />
          <NavigationProperty Name="Groups" Relationship="ModelKindergartenEntities.FK__Distribut__Id_gr__3A179ED3" FromRole="Distributions" ToRole="Groups" />
        </EntityType>
        <EntityType Name="Employees">
          <Key>
            <PropertyRef Name="Id_employee" />
          </Key>
          <Property Name="Id_employee" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Surname" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Names" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Patronymic" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Birthdate" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Id_gender" Type="Int32" Nullable="false" />
          <Property Name="Id_position" Type="Int32" Nullable="false" />
          <Property Name="Street" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Building" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="Phone" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Login_user" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Password_user" Type="Int32" Nullable="false" />
          <Property Name="Id_role" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Distributions" Relationship="ModelKindergartenEntities.FK__Distribut__Id_em__39237A9A" FromRole="Employees" ToRole="Distributions" />
          <NavigationProperty Name="Genders" Relationship="ModelKindergartenEntities.FK__Employees__Id_ge__1E6F845E" FromRole="Employees" ToRole="Genders" />
          <NavigationProperty Name="Positions" Relationship="ModelKindergartenEntities.FK__Employees__Id_po__1F63A897" FromRole="Employees" ToRole="Positions" />
          <NavigationProperty Name="Roles" Relationship="ModelKindergartenEntities.FK__Employees__Id_ro__2057CCD0" FromRole="Employees" ToRole="Roles" />
          <NavigationProperty Name="Photos" Relationship="ModelKindergartenEntities.FK__Photos__Id_emplo__02925FBF" FromRole="Employees" ToRole="Photos" />
        </EntityType>
        <EntityType Name="Genders">
          <Key>
            <PropertyRef Name="Id_gender" />
          </Key>
          <Property Name="Id_gender" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Gender" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Children" Relationship="ModelKindergartenEntities.FK__Children__Id_gen__5BAD9CC8" FromRole="Genders" ToRole="Children" />
          <NavigationProperty Name="Employees" Relationship="ModelKindergartenEntities.FK__Employees__Id_ge__1E6F845E" FromRole="Genders" ToRole="Employees" />
          <NavigationProperty Name="Parents" Relationship="ModelKindergartenEntities.FK__Parents__Id_gend__6CD828CA" FromRole="Genders" ToRole="Parents" />
        </EntityType>
        <EntityType Name="Groups">
          <Key>
            <PropertyRef Name="Id_group" />
          </Key>
          <Property Name="Id_group" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Id_type" Type="Int32" Nullable="false" />
          <Property Name="Code" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Children" Relationship="ModelKindergartenEntities.FK__Children__Id_gro__5CA1C101" FromRole="Groups" ToRole="Children" />
          <NavigationProperty Name="Distributions" Relationship="ModelKindergartenEntities.FK__Distribut__Id_gr__3A179ED3" FromRole="Groups" ToRole="Distributions" />
          <NavigationProperty Name="Types_group" Relationship="ModelKindergartenEntities.FK__Groups__Id_type__4E53A1AA" FromRole="Groups" ToRole="Types_group" />
        </EntityType>
        <EntityType Name="Kinships">
          <Key>
            <PropertyRef Name="Id_kinship" />
          </Key>
          <Property Name="Id_kinship" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Id_parent" Type="Int32" Nullable="false" />
          <Property Name="Id_child" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Children" Relationship="ModelKindergartenEntities.FK__Kinships__Id_chi__6225902D" FromRole="Kinships" ToRole="Children" />
          <NavigationProperty Name="Parents" Relationship="ModelKindergartenEntities.FK_Kinships_Parents" FromRole="Kinships" ToRole="Parents" />
        </EntityType>
        <EntityType Name="Parents">
          <Key>
            <PropertyRef Name="Id_parent" />
          </Key>
          <Property Name="Id_parent" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Surname" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Names" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Patronymic" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Birthdate" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Id_gender" Type="Int32" Nullable="false" />
          <Property Name="Street" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Building" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="Phone" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Genders" Relationship="ModelKindergartenEntities.FK__Parents__Id_gend__6CD828CA" FromRole="Parents" ToRole="Genders" />
          <NavigationProperty Name="Kinships" Relationship="ModelKindergartenEntities.FK_Kinships_Parents" FromRole="Parents" ToRole="Kinships" />
        </EntityType>
        <EntityType Name="Photos">
          <Key>
            <PropertyRef Name="Id_photo" />
          </Key>
          <Property Name="Id_photo" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Id_employee" Type="Int32" />
          <Property Name="Byte_photo" Type="Binary" MaxLength="Max" FixedLength="false" />
          <Property Name="Path_photo" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Employees" Relationship="ModelKindergartenEntities.FK__Photos__Id_emplo__02925FBF" FromRole="Photos" ToRole="Employees" />
        </EntityType>
        <EntityType Name="Positions">
          <Key>
            <PropertyRef Name="Id_position" />
          </Key>
          <Property Name="Id_position" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Position" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Employees" Relationship="ModelKindergartenEntities.FK__Employees__Id_po__1F63A897" FromRole="Positions" ToRole="Employees" />
        </EntityType>
        <EntityType Name="Roles">
          <Key>
            <PropertyRef Name="Id_role" />
          </Key>
          <Property Name="Id_role" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Role_name" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Employees" Relationship="ModelKindergartenEntities.FK__Employees__Id_ro__2057CCD0" FromRole="Roles" ToRole="Employees" />
        </EntityType>
        <EntityType Name="Sertificates">
          <Key>
            <PropertyRef Name="Id_sertificate" />
          </Key>
          <Property Name="Id_sertificate" Type="Int32" Nullable="false" />
          <Property Name="Series" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="Number" Type="Int32" Nullable="false" />
          <Property Name="Date_issue" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Iddued" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Children" Relationship="ModelKindergartenEntities.FK_Sertificates_Children" FromRole="Sertificates" ToRole="Children" />
        </EntityType>
        <EntityType Name="Types_group">
          <Key>
            <PropertyRef Name="Id_type" />
          </Key>
          <Property Name="Id_type" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Type_group" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="Groups" Relationship="ModelKindergartenEntities.FK__Groups__Id_type__4E53A1AA" FromRole="Types_group" ToRole="Groups" />
        </EntityType>
        <Association Name="FK__Attendanc__Id_ch__5F7E2DAC">
          <End Type="ModelKindergartenEntities.Children" Role="Children" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="ModelKindergartenEntities.Attendance" Role="Attendance" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Children">
              <PropertyRef Name="Id_child" />
            </Principal>
            <Dependent Role="Attendance">
              <PropertyRef Name="Id_child" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Children__Id_gen__5BAD9CC8">
          <End Type="ModelKindergartenEntities.Genders" Role="Genders" Multiplicity="1" />
          <End Type="ModelKindergartenEntities.Children" Role="Children" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Genders">
              <PropertyRef Name="Id_gender" />
            </Principal>
            <Dependent Role="Children">
              <PropertyRef Name="Id_gender" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Children__Id_gro__5CA1C101">
          <End Type="ModelKindergartenEntities.Groups" Role="Groups" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="ModelKindergartenEntities.Children" Role="Children" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groups">
              <PropertyRef Name="Id_group" />
            </Principal>
            <Dependent Role="Children">
              <PropertyRef Name="Id_group" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Kinships__Id_chi__6225902D">
          <End Type="ModelKindergartenEntities.Children" Role="Children" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="ModelKindergartenEntities.Kinships" Role="Kinships" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Children">
              <PropertyRef Name="Id_child" />
            </Principal>
            <Dependent Role="Kinships">
              <PropertyRef Name="Id_child" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Sertificates_Children">
          <End Type="ModelKindergartenEntities.Children" Role="Children" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="ModelKindergartenEntities.Sertificates" Role="Sertificates" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Children">
              <PropertyRef Name="Id_child" />
            </Principal>
            <Dependent Role="Sertificates">
              <PropertyRef Name="Id_sertificate" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Distribut__Id_em__39237A9A">
          <End Type="ModelKindergartenEntities.Employees" Role="Employees" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="ModelKindergartenEntities.Distributions" Role="Distributions" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="Id_employee" />
            </Principal>
            <Dependent Role="Distributions">
              <PropertyRef Name="Id_employee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Distribut__Id_gr__3A179ED3">
          <End Type="ModelKindergartenEntities.Groups" Role="Groups" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="ModelKindergartenEntities.Distributions" Role="Distributions" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groups">
              <PropertyRef Name="Id_group" />
            </Principal>
            <Dependent Role="Distributions">
              <PropertyRef Name="Id_group" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Employees__Id_ge__1E6F845E">
          <End Type="ModelKindergartenEntities.Genders" Role="Genders" Multiplicity="1" />
          <End Type="ModelKindergartenEntities.Employees" Role="Employees" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Genders">
              <PropertyRef Name="Id_gender" />
            </Principal>
            <Dependent Role="Employees">
              <PropertyRef Name="Id_gender" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Employees__Id_po__1F63A897">
          <End Type="ModelKindergartenEntities.Positions" Role="Positions" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="ModelKindergartenEntities.Employees" Role="Employees" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Positions">
              <PropertyRef Name="Id_position" />
            </Principal>
            <Dependent Role="Employees">
              <PropertyRef Name="Id_position" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Employees__Id_ro__2057CCD0">
          <End Type="ModelKindergartenEntities.Roles" Role="Roles" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="ModelKindergartenEntities.Employees" Role="Employees" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Roles">
              <PropertyRef Name="Id_role" />
            </Principal>
            <Dependent Role="Employees">
              <PropertyRef Name="Id_role" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Photos__Id_emplo__02925FBF">
          <End Type="ModelKindergartenEntities.Employees" Role="Employees" Multiplicity="0..1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="ModelKindergartenEntities.Photos" Role="Photos" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Employees">
              <PropertyRef Name="Id_employee" />
            </Principal>
            <Dependent Role="Photos">
              <PropertyRef Name="Id_employee" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Parents__Id_gend__6CD828CA">
          <End Type="ModelKindergartenEntities.Genders" Role="Genders" Multiplicity="1" />
          <End Type="ModelKindergartenEntities.Parents" Role="Parents" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Genders">
              <PropertyRef Name="Id_gender" />
            </Principal>
            <Dependent Role="Parents">
              <PropertyRef Name="Id_gender" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK__Groups__Id_type__4E53A1AA">
          <End Type="ModelKindergartenEntities.Types_group" Role="Types_group" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="ModelKindergartenEntities.Groups" Role="Groups" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Types_group">
              <PropertyRef Name="Id_type" />
            </Principal>
            <Dependent Role="Groups">
              <PropertyRef Name="Id_type" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Kinships_Parents">
          <End Type="ModelKindergartenEntities.Parents" Role="Parents" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Type="ModelKindergartenEntities.Kinships" Role="Kinships" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Parents">
              <PropertyRef Name="Id_parent" />
            </Principal>
            <Dependent Role="Kinships">
              <PropertyRef Name="Id_parent" />
            </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="Хранилище ModelKindergartenEntitiesContainer" CdmEntityContainer="KindergartenEntities">
          <EntitySetMapping Name="Attendance">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Attendance">
              <MappingFragment StoreEntitySet="Attendance">
                <ScalarProperty Name="Status_visit" ColumnName="Status_visit" />
                <ScalarProperty Name="Id_child" ColumnName="Id_child" />
                <ScalarProperty Name="Date_visit" ColumnName="Date_visit" />
                <ScalarProperty Name="Id_visit" ColumnName="Id_visit" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Children">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Children">
              <MappingFragment StoreEntitySet="Children">
                <ScalarProperty Name="Photo" ColumnName="Photo" />
                <ScalarProperty Name="Building" ColumnName="Building" />
                <ScalarProperty Name="Street" ColumnName="Street" />
                <ScalarProperty Name="Id_group" ColumnName="Id_group" />
                <ScalarProperty Name="Id_gender" ColumnName="Id_gender" />
                <ScalarProperty Name="Birthdate" ColumnName="Birthdate" />
                <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
                <ScalarProperty Name="Names" ColumnName="Names" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="Id_child" ColumnName="Id_child" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Distributions">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Distributions">
              <MappingFragment StoreEntitySet="Distributions">
                <ScalarProperty Name="Id_group" ColumnName="Id_group" />
                <ScalarProperty Name="Id_employee" ColumnName="Id_employee" />
                <ScalarProperty Name="Id_distribution" ColumnName="Id_distribution" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Employees">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Employees">
              <MappingFragment StoreEntitySet="Employees">
                <ScalarProperty Name="Id_role" ColumnName="Id_role" />
                <ScalarProperty Name="Password_user" ColumnName="Password_user" />
                <ScalarProperty Name="Login_user" ColumnName="Login_user" />
                <ScalarProperty Name="Phone" ColumnName="Phone" />
                <ScalarProperty Name="Building" ColumnName="Building" />
                <ScalarProperty Name="Street" ColumnName="Street" />
                <ScalarProperty Name="Id_position" ColumnName="Id_position" />
                <ScalarProperty Name="Id_gender" ColumnName="Id_gender" />
                <ScalarProperty Name="Birthdate" ColumnName="Birthdate" />
                <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
                <ScalarProperty Name="Names" ColumnName="Names" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="Id_employee" ColumnName="Id_employee" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Genders">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Genders">
              <MappingFragment StoreEntitySet="Genders">
                <ScalarProperty Name="Gender" ColumnName="Gender" />
                <ScalarProperty Name="Id_gender" ColumnName="Id_gender" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Groups">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Groups">
              <MappingFragment StoreEntitySet="Groups">
                <ScalarProperty Name="Code" ColumnName="Code" />
                <ScalarProperty Name="Id_type" ColumnName="Id_type" />
                <ScalarProperty Name="Id_group" ColumnName="Id_group" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Kinships">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Kinships">
              <MappingFragment StoreEntitySet="Kinships">
                <ScalarProperty Name="Id_child" ColumnName="Id_child" />
                <ScalarProperty Name="Id_parent" ColumnName="Id_parent" />
                <ScalarProperty Name="Id_kinship" ColumnName="Id_kinship" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Parents">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Parents">
              <MappingFragment StoreEntitySet="Parents">
                <ScalarProperty Name="Phone" ColumnName="Phone" />
                <ScalarProperty Name="Building" ColumnName="Building" />
                <ScalarProperty Name="Street" ColumnName="Street" />
                <ScalarProperty Name="Id_gender" ColumnName="Id_gender" />
                <ScalarProperty Name="Birthdate" ColumnName="Birthdate" />
                <ScalarProperty Name="Patronymic" ColumnName="Patronymic" />
                <ScalarProperty Name="Names" ColumnName="Names" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="Id_parent" ColumnName="Id_parent" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Photos">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Photos">
              <MappingFragment StoreEntitySet="Photos">
                <ScalarProperty Name="Path_photo" ColumnName="Path_photo" />
                <ScalarProperty Name="Byte_photo" ColumnName="Byte_photo" />
                <ScalarProperty Name="Id_employee" ColumnName="Id_employee" />
                <ScalarProperty Name="Id_photo" ColumnName="Id_photo" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Positions">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Positions">
              <MappingFragment StoreEntitySet="Positions">
                <ScalarProperty Name="Position" ColumnName="Position" />
                <ScalarProperty Name="Id_position" ColumnName="Id_position" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Roles">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Roles">
              <MappingFragment StoreEntitySet="Roles">
                <ScalarProperty Name="Role_name" ColumnName="Role_name" />
                <ScalarProperty Name="Id_role" ColumnName="Id_role" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Sertificates">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Sertificates">
              <MappingFragment StoreEntitySet="Sertificates">
                <ScalarProperty Name="Iddued" ColumnName="Iddued" />
                <ScalarProperty Name="Date_issue" ColumnName="Date_issue" />
                <ScalarProperty Name="Number" ColumnName="Number" />
                <ScalarProperty Name="Series" ColumnName="Series" />
                <ScalarProperty Name="Id_sertificate" ColumnName="Id_sertificate" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Types_group">
            <EntityTypeMapping TypeName="ModelKindergartenEntities.Types_group">
              <MappingFragment StoreEntitySet="Types_group">
                <ScalarProperty Name="Type_group" ColumnName="Type_group" />
                <ScalarProperty Name="Id_type" ColumnName="Id_type" />
              </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>