Kindergarten/Детский сад/obj/Release/edmxResourcesToEmbed/Model1.csdl

<?xml version="1.0" encoding="utf-8"?>
<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="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__70A8B9AE" Association="ModelKindergartenEntities.FK__Kinships__Id_chi__70A8B9AE">
      <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__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__Id_par__6FB49575" Association="ModelKindergartenEntities.FK__Kinships__Id_par__6FB49575">
      <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__70A8B9AE" 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" />
  </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__70A8B9AE" FromRole="Kinships" ToRole="Children" />
    <NavigationProperty Name="Parents" Relationship="ModelKindergartenEntities.FK__Kinships__Id_par__6FB49575" 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__Id_par__6FB49575" FromRole="Parents" ToRole="Kinships" />
  </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" />
    <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" />
    <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__70A8B9AE">
    <End Type="ModelKindergartenEntities.Children" Role="Children" Multiplicity="1" />
    <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" />
    <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" />
    <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" />
    <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" />
    <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" />
    <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__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" />
    <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__Id_par__6FB49575">
    <End Type="ModelKindergartenEntities.Parents" Role="Parents" Multiplicity="1" />
    <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>