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

<?xml version="1.0" encoding="utf-8"?>
<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="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" />
    <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" />
    <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" />
    <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" />
    <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" />
    <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" />
    <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" />
    <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__70A8B9AE">
    <End Role="Children" Type="Self.Children" Multiplicity="1" />
    <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__Kinships__Id_par__6FB49575">
    <End Role="Parents" Type="Self.Parents" Multiplicity="1" />
    <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__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_Sertificates_Children">
    <End Role="Children" Type="Self.Children" Multiplicity="1" />
    <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="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__70A8B9AE" Association="Self.FK__Kinships__Id_chi__70A8B9AE">
      <End Role="Children" EntitySet="Children" />
      <End Role="Kinships" EntitySet="Kinships" />
    </AssociationSet>
    <AssociationSet Name="FK__Kinships__Id_par__6FB49575" Association="Self.FK__Kinships__Id_par__6FB49575">
      <End Role="Parents" EntitySet="Parents" />
      <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_Sertificates_Children" Association="Self.FK_Sertificates_Children">
      <End Role="Children" EntitySet="Children" />
      <End Role="Sertificates" EntitySet="Sertificates" />
    </AssociationSet>
  </EntityContainer>
</Schema>