123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502 |
- <?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="Хранилище Knyazeva_Kochnev_Smerdova_UPModel" 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="BlogTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Date" Type="date" Nullable="false" />
- <Property Name="Entry" Type="nvarchar(max)" Nullable="false" />
- <Property Name="IdUser" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="DiseaseQuestionTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="IdDisease" Type="int" Nullable="false" />
- <Property Name="IdQuestion" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="DiseaseTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Name" Type="nvarchar(max)" Nullable="false" />
- <Property Name="Description" Type="nvarchar(max)" />
- <Property Name="Medication" Type="nvarchar(max)" />
- </EntityType>
- <EntityType Name="LoginedTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Login" Type="nvarchar(max)" Nullable="false" />
- <Property Name="Password" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="QuestionTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="Name" Type="nvarchar(max)" Nullable="false" />
- </EntityType>
- <EntityType Name="SessionDiseaseTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="IdSession" Type="int" Nullable="false" />
- <Property Name="IdDisease" Type="int" Nullable="false" />
- </EntityType>
- <EntityType Name="SessionTestTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
- <Property Name="IdUser" Type="int" Nullable="false" />
- <Property Name="Date" Type="date" Nullable="false" />
- </EntityType>
- <EntityType Name="UserTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="int" Nullable="false" />
- <Property Name="Surname" Type="nvarchar(max)" Nullable="false" />
- <Property Name="Name" Type="nvarchar(max)" Nullable="false" />
- </EntityType>
- <Association Name="FK__BlogTable__IdUse__3C69FB99">
- <End Role="UserTable" Type="Self.UserTable" Multiplicity="1" />
- <End Role="BlogTable" Type="Self.BlogTable" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="UserTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="BlogTable">
- <PropertyRef Name="IdUser" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__SessionTe__IdUse__46E78A0C">
- <End Role="UserTable" Type="Self.UserTable" Multiplicity="1" />
- <End Role="SessionTestTable" Type="Self.SessionTestTable" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="UserTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SessionTestTable">
- <PropertyRef Name="IdUser" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__UserTable__ID__398D8EEE">
- <End Role="LoginedTable" Type="Self.LoginedTable" Multiplicity="1" />
- <End Role="UserTable" Type="Self.UserTable" Multiplicity="0..1" />
- <ReferentialConstraint>
- <Principal Role="LoginedTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="UserTable">
- <PropertyRef Name="ID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_DiseaseQuestionTable_DiseaseTable">
- <End Role="DiseaseTable" Type="Self.DiseaseTable" Multiplicity="1" />
- <End Role="DiseaseQuestionTable" Type="Self.DiseaseQuestionTable" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="DiseaseTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="DiseaseQuestionTable">
- <PropertyRef Name="IdDisease" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_DiseaseQuestionTable_QuestionTable">
- <End Role="QuestionTable" Type="Self.QuestionTable" Multiplicity="1" />
- <End Role="DiseaseQuestionTable" Type="Self.DiseaseQuestionTable" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="QuestionTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="DiseaseQuestionTable">
- <PropertyRef Name="IdQuestion" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SessionDiseaseTable_DiseaseTable">
- <End Role="DiseaseTable" Type="Self.DiseaseTable" Multiplicity="1" />
- <End Role="SessionDiseaseTable" Type="Self.SessionDiseaseTable" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="DiseaseTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SessionDiseaseTable">
- <PropertyRef Name="IdDisease" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SessionDiseaseTable_SessionTestTable">
- <End Role="SessionTestTable" Type="Self.SessionTestTable" Multiplicity="1" />
- <End Role="SessionDiseaseTable" Type="Self.SessionDiseaseTable" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SessionTestTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SessionDiseaseTable">
- <PropertyRef Name="IdSession" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <EntityContainer Name="Хранилище Knyazeva_Kochnev_Smerdova_UPModelContainer">
- <EntitySet Name="BlogTable" EntityType="Self.BlogTable" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="DiseaseQuestionTable" EntityType="Self.DiseaseQuestionTable" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="DiseaseTable" EntityType="Self.DiseaseTable" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="LoginedTable" EntityType="Self.LoginedTable" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="QuestionTable" EntityType="Self.QuestionTable" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SessionDiseaseTable" EntityType="Self.SessionDiseaseTable" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="SessionTestTable" EntityType="Self.SessionTestTable" Schema="dbo" store:Type="Tables" />
- <EntitySet Name="UserTable" EntityType="Self.UserTable" Schema="dbo" store:Type="Tables" />
- <AssociationSet Name="FK__BlogTable__IdUse__3C69FB99" Association="Self.FK__BlogTable__IdUse__3C69FB99">
- <End Role="UserTable" EntitySet="UserTable" />
- <End Role="BlogTable" EntitySet="BlogTable" />
- </AssociationSet>
- <AssociationSet Name="FK__SessionTe__IdUse__46E78A0C" Association="Self.FK__SessionTe__IdUse__46E78A0C">
- <End Role="UserTable" EntitySet="UserTable" />
- <End Role="SessionTestTable" EntitySet="SessionTestTable" />
- </AssociationSet>
- <AssociationSet Name="FK__UserTable__ID__398D8EEE" Association="Self.FK__UserTable__ID__398D8EEE">
- <End Role="LoginedTable" EntitySet="LoginedTable" />
- <End Role="UserTable" EntitySet="UserTable" />
- </AssociationSet>
- <AssociationSet Name="FK_DiseaseQuestionTable_DiseaseTable" Association="Self.FK_DiseaseQuestionTable_DiseaseTable">
- <End Role="DiseaseTable" EntitySet="DiseaseTable" />
- <End Role="DiseaseQuestionTable" EntitySet="DiseaseQuestionTable" />
- </AssociationSet>
- <AssociationSet Name="FK_DiseaseQuestionTable_QuestionTable" Association="Self.FK_DiseaseQuestionTable_QuestionTable">
- <End Role="QuestionTable" EntitySet="QuestionTable" />
- <End Role="DiseaseQuestionTable" EntitySet="DiseaseQuestionTable" />
- </AssociationSet>
- <AssociationSet Name="FK_SessionDiseaseTable_DiseaseTable" Association="Self.FK_SessionDiseaseTable_DiseaseTable">
- <End Role="DiseaseTable" EntitySet="DiseaseTable" />
- <End Role="SessionDiseaseTable" EntitySet="SessionDiseaseTable" />
- </AssociationSet>
- <AssociationSet Name="FK_SessionDiseaseTable_SessionTestTable" Association="Self.FK_SessionDiseaseTable_SessionTestTable">
- <End Role="SessionTestTable" EntitySet="SessionTestTable" />
- <End Role="SessionDiseaseTable" EntitySet="SessionDiseaseTable" />
- </AssociationSet>
- </EntityContainer>
- </Schema></edmx:StorageModels>
- <!-- CSDL content -->
- <edmx:ConceptualModels>
- <Schema Namespace="Knyazeva_Kochnev_Smerdova_UPModel" 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="Knyazeva_Kochnev_Smerdova_UPEntities" annotation:LazyLoadingEnabled="true">
- <EntitySet Name="BlogTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.BlogTable" />
- <EntitySet Name="DiseaseQuestionTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseQuestionTable" />
- <EntitySet Name="DiseaseTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseTable" />
- <EntitySet Name="LoginedTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.LoginedTable" />
- <EntitySet Name="QuestionTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.QuestionTable" />
- <EntitySet Name="SessionDiseaseTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.SessionDiseaseTable" />
- <EntitySet Name="SessionTestTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.SessionTestTable" />
- <EntitySet Name="UserTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.UserTable" />
- <AssociationSet Name="FK__BlogTable__IdUse__3C69FB99" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK__BlogTable__IdUse__3C69FB99">
- <End Role="UserTable" EntitySet="UserTable" />
- <End Role="BlogTable" EntitySet="BlogTable" />
- </AssociationSet>
- <AssociationSet Name="FK_DiseaseQuestionTable_DiseaseTable" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK_DiseaseQuestionTable_DiseaseTable">
- <End Role="DiseaseTable" EntitySet="DiseaseTable" />
- <End Role="DiseaseQuestionTable" EntitySet="DiseaseQuestionTable" />
- </AssociationSet>
- <AssociationSet Name="FK_DiseaseQuestionTable_QuestionTable" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK_DiseaseQuestionTable_QuestionTable">
- <End Role="QuestionTable" EntitySet="QuestionTable" />
- <End Role="DiseaseQuestionTable" EntitySet="DiseaseQuestionTable" />
- </AssociationSet>
- <AssociationSet Name="FK_SessionDiseaseTable_DiseaseTable" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK_SessionDiseaseTable_DiseaseTable">
- <End Role="DiseaseTable" EntitySet="DiseaseTable" />
- <End Role="SessionDiseaseTable" EntitySet="SessionDiseaseTable" />
- </AssociationSet>
- <AssociationSet Name="FK__UserTable__ID__398D8EEE" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK__UserTable__ID__398D8EEE">
- <End Role="LoginedTable" EntitySet="LoginedTable" />
- <End Role="UserTable" EntitySet="UserTable" />
- </AssociationSet>
- <AssociationSet Name="FK_SessionDiseaseTable_SessionTestTable" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK_SessionDiseaseTable_SessionTestTable">
- <End Role="SessionTestTable" EntitySet="SessionTestTable" />
- <End Role="SessionDiseaseTable" EntitySet="SessionDiseaseTable" />
- </AssociationSet>
- <AssociationSet Name="FK__SessionTe__IdUse__46E78A0C" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK__SessionTe__IdUse__46E78A0C">
- <End Role="UserTable" EntitySet="UserTable" />
- <End Role="SessionTestTable" EntitySet="SessionTestTable" />
- </AssociationSet>
- </EntityContainer>
- <EntityType Name="BlogTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Date" Type="DateTime" Nullable="false" Precision="0" />
- <Property Name="Entry" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
- <Property Name="IdUser" Type="Int32" Nullable="false" />
- <NavigationProperty Name="UserTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK__BlogTable__IdUse__3C69FB99" FromRole="BlogTable" ToRole="UserTable" />
- </EntityType>
- <EntityType Name="DiseaseQuestionTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="IdDisease" Type="Int32" Nullable="false" />
- <Property Name="IdQuestion" Type="Int32" Nullable="false" />
- <NavigationProperty Name="DiseaseTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_DiseaseQuestionTable_DiseaseTable" FromRole="DiseaseQuestionTable" ToRole="DiseaseTable" />
- <NavigationProperty Name="QuestionTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_DiseaseQuestionTable_QuestionTable" FromRole="DiseaseQuestionTable" ToRole="QuestionTable" />
- </EntityType>
- <EntityType Name="DiseaseTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Name" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
- <Property Name="Description" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
- <Property Name="Medication" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="DiseaseQuestionTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_DiseaseQuestionTable_DiseaseTable" FromRole="DiseaseTable" ToRole="DiseaseQuestionTable" />
- <NavigationProperty Name="SessionDiseaseTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_SessionDiseaseTable_DiseaseTable" FromRole="DiseaseTable" ToRole="SessionDiseaseTable" />
- </EntityType>
- <EntityType Name="LoginedTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Login" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
- <Property Name="Password" Type="Int32" Nullable="false" />
- <NavigationProperty Name="UserTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK__UserTable__ID__398D8EEE" FromRole="LoginedTable" ToRole="UserTable" />
- </EntityType>
- <EntityType Name="QuestionTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="Name" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="DiseaseQuestionTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_DiseaseQuestionTable_QuestionTable" FromRole="QuestionTable" ToRole="DiseaseQuestionTable" />
- </EntityType>
- <EntityType Name="SessionDiseaseTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="IdSession" Type="Int32" Nullable="false" />
- <Property Name="IdDisease" Type="Int32" Nullable="false" />
- <NavigationProperty Name="DiseaseTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_SessionDiseaseTable_DiseaseTable" FromRole="SessionDiseaseTable" ToRole="DiseaseTable" />
- <NavigationProperty Name="SessionTestTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_SessionDiseaseTable_SessionTestTable" FromRole="SessionDiseaseTable" ToRole="SessionTestTable" />
- </EntityType>
- <EntityType Name="SessionTestTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
- <Property Name="IdUser" Type="Int32" Nullable="false" />
- <Property Name="Date" Type="DateTime" Nullable="false" Precision="0" />
- <NavigationProperty Name="SessionDiseaseTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_SessionDiseaseTable_SessionTestTable" FromRole="SessionTestTable" ToRole="SessionDiseaseTable" />
- <NavigationProperty Name="UserTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK__SessionTe__IdUse__46E78A0C" FromRole="SessionTestTable" ToRole="UserTable" />
- </EntityType>
- <EntityType Name="UserTable">
- <Key>
- <PropertyRef Name="ID" />
- </Key>
- <Property Name="ID" Type="Int32" Nullable="false" />
- <Property Name="Surname" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
- <Property Name="Name" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
- <NavigationProperty Name="BlogTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK__BlogTable__IdUse__3C69FB99" FromRole="UserTable" ToRole="BlogTable" />
- <NavigationProperty Name="LoginedTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK__UserTable__ID__398D8EEE" FromRole="UserTable" ToRole="LoginedTable" />
- <NavigationProperty Name="SessionTestTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK__SessionTe__IdUse__46E78A0C" FromRole="UserTable" ToRole="SessionTestTable" />
- </EntityType>
- <Association Name="FK__BlogTable__IdUse__3C69FB99">
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.UserTable" Role="UserTable" Multiplicity="1" />
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.BlogTable" Role="BlogTable" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="UserTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="BlogTable">
- <PropertyRef Name="IdUser" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_DiseaseQuestionTable_DiseaseTable">
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseTable" Role="DiseaseTable" Multiplicity="1" />
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseQuestionTable" Role="DiseaseQuestionTable" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="DiseaseTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="DiseaseQuestionTable">
- <PropertyRef Name="IdDisease" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_DiseaseQuestionTable_QuestionTable">
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.QuestionTable" Role="QuestionTable" Multiplicity="1" />
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseQuestionTable" Role="DiseaseQuestionTable" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="QuestionTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="DiseaseQuestionTable">
- <PropertyRef Name="IdQuestion" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SessionDiseaseTable_DiseaseTable">
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseTable" Role="DiseaseTable" Multiplicity="1" />
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.SessionDiseaseTable" Role="SessionDiseaseTable" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="DiseaseTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SessionDiseaseTable">
- <PropertyRef Name="IdDisease" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__UserTable__ID__398D8EEE">
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.LoginedTable" Role="LoginedTable" Multiplicity="1" />
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.UserTable" Role="UserTable" Multiplicity="0..1" />
- <ReferentialConstraint>
- <Principal Role="LoginedTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="UserTable">
- <PropertyRef Name="ID" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK_SessionDiseaseTable_SessionTestTable">
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.SessionTestTable" Role="SessionTestTable" Multiplicity="1" />
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.SessionDiseaseTable" Role="SessionDiseaseTable" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="SessionTestTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SessionDiseaseTable">
- <PropertyRef Name="IdSession" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- <Association Name="FK__SessionTe__IdUse__46E78A0C">
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.UserTable" Role="UserTable" Multiplicity="1" />
- <End Type="Knyazeva_Kochnev_Smerdova_UPModel.SessionTestTable" Role="SessionTestTable" Multiplicity="*" />
- <ReferentialConstraint>
- <Principal Role="UserTable">
- <PropertyRef Name="ID" />
- </Principal>
- <Dependent Role="SessionTestTable">
- <PropertyRef Name="IdUser" />
- </Dependent>
- </ReferentialConstraint>
- </Association>
- </Schema>
- </edmx:ConceptualModels>
- <!-- C-S mapping content -->
- <edmx:Mappings>
- <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
- <EntityContainerMapping StorageEntityContainer="Хранилище Knyazeva_Kochnev_Smerdova_UPModelContainer" CdmEntityContainer="Knyazeva_Kochnev_Smerdova_UPEntities">
- <EntitySetMapping Name="BlogTable">
- <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.BlogTable">
- <MappingFragment StoreEntitySet="BlogTable">
- <ScalarProperty Name="IdUser" ColumnName="IdUser" />
- <ScalarProperty Name="Entry" ColumnName="Entry" />
- <ScalarProperty Name="Date" ColumnName="Date" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="DiseaseQuestionTable">
- <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseQuestionTable">
- <MappingFragment StoreEntitySet="DiseaseQuestionTable">
- <ScalarProperty Name="IdQuestion" ColumnName="IdQuestion" />
- <ScalarProperty Name="IdDisease" ColumnName="IdDisease" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="DiseaseTable">
- <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseTable">
- <MappingFragment StoreEntitySet="DiseaseTable">
- <ScalarProperty Name="Medication" ColumnName="Medication" />
- <ScalarProperty Name="Description" ColumnName="Description" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="LoginedTable">
- <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.LoginedTable">
- <MappingFragment StoreEntitySet="LoginedTable">
- <ScalarProperty Name="Password" ColumnName="Password" />
- <ScalarProperty Name="Login" ColumnName="Login" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="QuestionTable">
- <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.QuestionTable">
- <MappingFragment StoreEntitySet="QuestionTable">
- <ScalarProperty Name="Name" ColumnName="Name" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SessionDiseaseTable">
- <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.SessionDiseaseTable">
- <MappingFragment StoreEntitySet="SessionDiseaseTable">
- <ScalarProperty Name="IdDisease" ColumnName="IdDisease" />
- <ScalarProperty Name="IdSession" ColumnName="IdSession" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="SessionTestTable">
- <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.SessionTestTable">
- <MappingFragment StoreEntitySet="SessionTestTable">
- <ScalarProperty Name="Date" ColumnName="Date" />
- <ScalarProperty Name="IdUser" ColumnName="IdUser" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="UserTable">
- <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.UserTable">
- <MappingFragment StoreEntitySet="UserTable">
- <ScalarProperty Name="Name" ColumnName="Name" />
- <ScalarProperty Name="Surname" ColumnName="Surname" />
- <ScalarProperty Name="ID" ColumnName="ID" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- </EntityContainerMapping>
- </Mapping>
- </edmx:Mappings>
- </edmx:Runtime>
- <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
- <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
- <Connection>
- <DesignerInfoPropertySet>
- <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
- </DesignerInfoPropertySet>
- </Connection>
- <Options>
- <DesignerInfoPropertySet>
- <DesignerProperty Name="ValidateOnBuild" Value="true" />
- <DesignerProperty Name="EnablePluralization" Value="false" />
- <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
- <DesignerProperty Name="UseLegacyProvider" Value="false" />
- <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
- </DesignerInfoPropertySet>
- </Options>
- <!-- Diagram content (shape and connector positions) -->
- <Diagrams></Diagrams>
- </Designer>
- </edmx:Edmx>
|