BaseModel.edmx 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  3. <!-- EF Runtime content -->
  4. <edmx:Runtime>
  5. <!-- SSDL content -->
  6. <edmx:StorageModels>
  7. <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">
  8. <EntityType Name="BlogTable">
  9. <Key>
  10. <PropertyRef Name="ID" />
  11. </Key>
  12. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  13. <Property Name="Date" Type="date" Nullable="false" />
  14. <Property Name="Entry" Type="nvarchar(max)" Nullable="false" />
  15. <Property Name="IdUser" Type="int" Nullable="false" />
  16. </EntityType>
  17. <EntityType Name="DiseaseQuestionTable">
  18. <Key>
  19. <PropertyRef Name="ID" />
  20. </Key>
  21. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  22. <Property Name="IdDisease" Type="int" Nullable="false" />
  23. <Property Name="IdQuestion" Type="int" Nullable="false" />
  24. </EntityType>
  25. <EntityType Name="DiseaseTable">
  26. <Key>
  27. <PropertyRef Name="ID" />
  28. </Key>
  29. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  30. <Property Name="Name" Type="nvarchar(max)" Nullable="false" />
  31. <Property Name="Description" Type="nvarchar(max)" />
  32. <Property Name="Medication" Type="nvarchar(max)" />
  33. </EntityType>
  34. <EntityType Name="LoginedTable">
  35. <Key>
  36. <PropertyRef Name="ID" />
  37. </Key>
  38. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  39. <Property Name="Login" Type="nvarchar(max)" Nullable="false" />
  40. <Property Name="Password" Type="int" Nullable="false" />
  41. </EntityType>
  42. <EntityType Name="QuestionTable">
  43. <Key>
  44. <PropertyRef Name="ID" />
  45. </Key>
  46. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  47. <Property Name="Name" Type="nvarchar(max)" Nullable="false" />
  48. </EntityType>
  49. <EntityType Name="SessionDiseaseTable">
  50. <Key>
  51. <PropertyRef Name="ID" />
  52. </Key>
  53. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  54. <Property Name="IdSession" Type="int" Nullable="false" />
  55. <Property Name="IdDisease" Type="int" Nullable="false" />
  56. </EntityType>
  57. <EntityType Name="SessionTestTable">
  58. <Key>
  59. <PropertyRef Name="ID" />
  60. </Key>
  61. <Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  62. <Property Name="IdUser" Type="int" Nullable="false" />
  63. <Property Name="Date" Type="date" Nullable="false" />
  64. </EntityType>
  65. <EntityType Name="UserTable">
  66. <Key>
  67. <PropertyRef Name="ID" />
  68. </Key>
  69. <Property Name="ID" Type="int" Nullable="false" />
  70. <Property Name="Surname" Type="nvarchar(max)" Nullable="false" />
  71. <Property Name="Name" Type="nvarchar(max)" Nullable="false" />
  72. </EntityType>
  73. <Association Name="FK__BlogTable__IdUse__3C69FB99">
  74. <End Role="UserTable" Type="Self.UserTable" Multiplicity="1" />
  75. <End Role="BlogTable" Type="Self.BlogTable" Multiplicity="*" />
  76. <ReferentialConstraint>
  77. <Principal Role="UserTable">
  78. <PropertyRef Name="ID" />
  79. </Principal>
  80. <Dependent Role="BlogTable">
  81. <PropertyRef Name="IdUser" />
  82. </Dependent>
  83. </ReferentialConstraint>
  84. </Association>
  85. <Association Name="FK__SessionTe__IdUse__46E78A0C">
  86. <End Role="UserTable" Type="Self.UserTable" Multiplicity="1" />
  87. <End Role="SessionTestTable" Type="Self.SessionTestTable" Multiplicity="*" />
  88. <ReferentialConstraint>
  89. <Principal Role="UserTable">
  90. <PropertyRef Name="ID" />
  91. </Principal>
  92. <Dependent Role="SessionTestTable">
  93. <PropertyRef Name="IdUser" />
  94. </Dependent>
  95. </ReferentialConstraint>
  96. </Association>
  97. <Association Name="FK__UserTable__ID__398D8EEE">
  98. <End Role="LoginedTable" Type="Self.LoginedTable" Multiplicity="1" />
  99. <End Role="UserTable" Type="Self.UserTable" Multiplicity="0..1" />
  100. <ReferentialConstraint>
  101. <Principal Role="LoginedTable">
  102. <PropertyRef Name="ID" />
  103. </Principal>
  104. <Dependent Role="UserTable">
  105. <PropertyRef Name="ID" />
  106. </Dependent>
  107. </ReferentialConstraint>
  108. </Association>
  109. <Association Name="FK_DiseaseQuestionTable_DiseaseTable">
  110. <End Role="DiseaseTable" Type="Self.DiseaseTable" Multiplicity="1" />
  111. <End Role="DiseaseQuestionTable" Type="Self.DiseaseQuestionTable" Multiplicity="*" />
  112. <ReferentialConstraint>
  113. <Principal Role="DiseaseTable">
  114. <PropertyRef Name="ID" />
  115. </Principal>
  116. <Dependent Role="DiseaseQuestionTable">
  117. <PropertyRef Name="IdDisease" />
  118. </Dependent>
  119. </ReferentialConstraint>
  120. </Association>
  121. <Association Name="FK_DiseaseQuestionTable_QuestionTable">
  122. <End Role="QuestionTable" Type="Self.QuestionTable" Multiplicity="1" />
  123. <End Role="DiseaseQuestionTable" Type="Self.DiseaseQuestionTable" Multiplicity="*" />
  124. <ReferentialConstraint>
  125. <Principal Role="QuestionTable">
  126. <PropertyRef Name="ID" />
  127. </Principal>
  128. <Dependent Role="DiseaseQuestionTable">
  129. <PropertyRef Name="IdQuestion" />
  130. </Dependent>
  131. </ReferentialConstraint>
  132. </Association>
  133. <Association Name="FK_SessionDiseaseTable_DiseaseTable">
  134. <End Role="DiseaseTable" Type="Self.DiseaseTable" Multiplicity="1" />
  135. <End Role="SessionDiseaseTable" Type="Self.SessionDiseaseTable" Multiplicity="*" />
  136. <ReferentialConstraint>
  137. <Principal Role="DiseaseTable">
  138. <PropertyRef Name="ID" />
  139. </Principal>
  140. <Dependent Role="SessionDiseaseTable">
  141. <PropertyRef Name="IdDisease" />
  142. </Dependent>
  143. </ReferentialConstraint>
  144. </Association>
  145. <Association Name="FK_SessionDiseaseTable_SessionTestTable">
  146. <End Role="SessionTestTable" Type="Self.SessionTestTable" Multiplicity="1" />
  147. <End Role="SessionDiseaseTable" Type="Self.SessionDiseaseTable" Multiplicity="*" />
  148. <ReferentialConstraint>
  149. <Principal Role="SessionTestTable">
  150. <PropertyRef Name="ID" />
  151. </Principal>
  152. <Dependent Role="SessionDiseaseTable">
  153. <PropertyRef Name="IdSession" />
  154. </Dependent>
  155. </ReferentialConstraint>
  156. </Association>
  157. <EntityContainer Name="Хранилище Knyazeva_Kochnev_Smerdova_UPModelContainer">
  158. <EntitySet Name="BlogTable" EntityType="Self.BlogTable" Schema="dbo" store:Type="Tables" />
  159. <EntitySet Name="DiseaseQuestionTable" EntityType="Self.DiseaseQuestionTable" Schema="dbo" store:Type="Tables" />
  160. <EntitySet Name="DiseaseTable" EntityType="Self.DiseaseTable" Schema="dbo" store:Type="Tables" />
  161. <EntitySet Name="LoginedTable" EntityType="Self.LoginedTable" Schema="dbo" store:Type="Tables" />
  162. <EntitySet Name="QuestionTable" EntityType="Self.QuestionTable" Schema="dbo" store:Type="Tables" />
  163. <EntitySet Name="SessionDiseaseTable" EntityType="Self.SessionDiseaseTable" Schema="dbo" store:Type="Tables" />
  164. <EntitySet Name="SessionTestTable" EntityType="Self.SessionTestTable" Schema="dbo" store:Type="Tables" />
  165. <EntitySet Name="UserTable" EntityType="Self.UserTable" Schema="dbo" store:Type="Tables" />
  166. <AssociationSet Name="FK__BlogTable__IdUse__3C69FB99" Association="Self.FK__BlogTable__IdUse__3C69FB99">
  167. <End Role="UserTable" EntitySet="UserTable" />
  168. <End Role="BlogTable" EntitySet="BlogTable" />
  169. </AssociationSet>
  170. <AssociationSet Name="FK__SessionTe__IdUse__46E78A0C" Association="Self.FK__SessionTe__IdUse__46E78A0C">
  171. <End Role="UserTable" EntitySet="UserTable" />
  172. <End Role="SessionTestTable" EntitySet="SessionTestTable" />
  173. </AssociationSet>
  174. <AssociationSet Name="FK__UserTable__ID__398D8EEE" Association="Self.FK__UserTable__ID__398D8EEE">
  175. <End Role="LoginedTable" EntitySet="LoginedTable" />
  176. <End Role="UserTable" EntitySet="UserTable" />
  177. </AssociationSet>
  178. <AssociationSet Name="FK_DiseaseQuestionTable_DiseaseTable" Association="Self.FK_DiseaseQuestionTable_DiseaseTable">
  179. <End Role="DiseaseTable" EntitySet="DiseaseTable" />
  180. <End Role="DiseaseQuestionTable" EntitySet="DiseaseQuestionTable" />
  181. </AssociationSet>
  182. <AssociationSet Name="FK_DiseaseQuestionTable_QuestionTable" Association="Self.FK_DiseaseQuestionTable_QuestionTable">
  183. <End Role="QuestionTable" EntitySet="QuestionTable" />
  184. <End Role="DiseaseQuestionTable" EntitySet="DiseaseQuestionTable" />
  185. </AssociationSet>
  186. <AssociationSet Name="FK_SessionDiseaseTable_DiseaseTable" Association="Self.FK_SessionDiseaseTable_DiseaseTable">
  187. <End Role="DiseaseTable" EntitySet="DiseaseTable" />
  188. <End Role="SessionDiseaseTable" EntitySet="SessionDiseaseTable" />
  189. </AssociationSet>
  190. <AssociationSet Name="FK_SessionDiseaseTable_SessionTestTable" Association="Self.FK_SessionDiseaseTable_SessionTestTable">
  191. <End Role="SessionTestTable" EntitySet="SessionTestTable" />
  192. <End Role="SessionDiseaseTable" EntitySet="SessionDiseaseTable" />
  193. </AssociationSet>
  194. </EntityContainer>
  195. </Schema></edmx:StorageModels>
  196. <!-- CSDL content -->
  197. <edmx:ConceptualModels>
  198. <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">
  199. <EntityContainer Name="Knyazeva_Kochnev_Smerdova_UPEntities" annotation:LazyLoadingEnabled="true">
  200. <EntitySet Name="BlogTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.BlogTable" />
  201. <EntitySet Name="DiseaseQuestionTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseQuestionTable" />
  202. <EntitySet Name="DiseaseTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseTable" />
  203. <EntitySet Name="LoginedTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.LoginedTable" />
  204. <EntitySet Name="QuestionTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.QuestionTable" />
  205. <EntitySet Name="SessionDiseaseTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.SessionDiseaseTable" />
  206. <EntitySet Name="SessionTestTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.SessionTestTable" />
  207. <EntitySet Name="UserTable" EntityType="Knyazeva_Kochnev_Smerdova_UPModel.UserTable" />
  208. <AssociationSet Name="FK__BlogTable__IdUse__3C69FB99" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK__BlogTable__IdUse__3C69FB99">
  209. <End Role="UserTable" EntitySet="UserTable" />
  210. <End Role="BlogTable" EntitySet="BlogTable" />
  211. </AssociationSet>
  212. <AssociationSet Name="FK_DiseaseQuestionTable_DiseaseTable" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK_DiseaseQuestionTable_DiseaseTable">
  213. <End Role="DiseaseTable" EntitySet="DiseaseTable" />
  214. <End Role="DiseaseQuestionTable" EntitySet="DiseaseQuestionTable" />
  215. </AssociationSet>
  216. <AssociationSet Name="FK_DiseaseQuestionTable_QuestionTable" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK_DiseaseQuestionTable_QuestionTable">
  217. <End Role="QuestionTable" EntitySet="QuestionTable" />
  218. <End Role="DiseaseQuestionTable" EntitySet="DiseaseQuestionTable" />
  219. </AssociationSet>
  220. <AssociationSet Name="FK_SessionDiseaseTable_DiseaseTable" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK_SessionDiseaseTable_DiseaseTable">
  221. <End Role="DiseaseTable" EntitySet="DiseaseTable" />
  222. <End Role="SessionDiseaseTable" EntitySet="SessionDiseaseTable" />
  223. </AssociationSet>
  224. <AssociationSet Name="FK__UserTable__ID__398D8EEE" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK__UserTable__ID__398D8EEE">
  225. <End Role="LoginedTable" EntitySet="LoginedTable" />
  226. <End Role="UserTable" EntitySet="UserTable" />
  227. </AssociationSet>
  228. <AssociationSet Name="FK_SessionDiseaseTable_SessionTestTable" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK_SessionDiseaseTable_SessionTestTable">
  229. <End Role="SessionTestTable" EntitySet="SessionTestTable" />
  230. <End Role="SessionDiseaseTable" EntitySet="SessionDiseaseTable" />
  231. </AssociationSet>
  232. <AssociationSet Name="FK__SessionTe__IdUse__46E78A0C" Association="Knyazeva_Kochnev_Smerdova_UPModel.FK__SessionTe__IdUse__46E78A0C">
  233. <End Role="UserTable" EntitySet="UserTable" />
  234. <End Role="SessionTestTable" EntitySet="SessionTestTable" />
  235. </AssociationSet>
  236. </EntityContainer>
  237. <EntityType Name="BlogTable">
  238. <Key>
  239. <PropertyRef Name="ID" />
  240. </Key>
  241. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  242. <Property Name="Date" Type="DateTime" Nullable="false" Precision="0" />
  243. <Property Name="Entry" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
  244. <Property Name="IdUser" Type="Int32" Nullable="false" />
  245. <NavigationProperty Name="UserTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK__BlogTable__IdUse__3C69FB99" FromRole="BlogTable" ToRole="UserTable" />
  246. </EntityType>
  247. <EntityType Name="DiseaseQuestionTable">
  248. <Key>
  249. <PropertyRef Name="ID" />
  250. </Key>
  251. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  252. <Property Name="IdDisease" Type="Int32" Nullable="false" />
  253. <Property Name="IdQuestion" Type="Int32" Nullable="false" />
  254. <NavigationProperty Name="DiseaseTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_DiseaseQuestionTable_DiseaseTable" FromRole="DiseaseQuestionTable" ToRole="DiseaseTable" />
  255. <NavigationProperty Name="QuestionTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_DiseaseQuestionTable_QuestionTable" FromRole="DiseaseQuestionTable" ToRole="QuestionTable" />
  256. </EntityType>
  257. <EntityType Name="DiseaseTable">
  258. <Key>
  259. <PropertyRef Name="ID" />
  260. </Key>
  261. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  262. <Property Name="Name" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
  263. <Property Name="Description" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
  264. <Property Name="Medication" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
  265. <NavigationProperty Name="DiseaseQuestionTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_DiseaseQuestionTable_DiseaseTable" FromRole="DiseaseTable" ToRole="DiseaseQuestionTable" />
  266. <NavigationProperty Name="SessionDiseaseTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_SessionDiseaseTable_DiseaseTable" FromRole="DiseaseTable" ToRole="SessionDiseaseTable" />
  267. </EntityType>
  268. <EntityType Name="LoginedTable">
  269. <Key>
  270. <PropertyRef Name="ID" />
  271. </Key>
  272. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  273. <Property Name="Login" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
  274. <Property Name="Password" Type="Int32" Nullable="false" />
  275. <NavigationProperty Name="UserTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK__UserTable__ID__398D8EEE" FromRole="LoginedTable" ToRole="UserTable" />
  276. </EntityType>
  277. <EntityType Name="QuestionTable">
  278. <Key>
  279. <PropertyRef Name="ID" />
  280. </Key>
  281. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  282. <Property Name="Name" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
  283. <NavigationProperty Name="DiseaseQuestionTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_DiseaseQuestionTable_QuestionTable" FromRole="QuestionTable" ToRole="DiseaseQuestionTable" />
  284. </EntityType>
  285. <EntityType Name="SessionDiseaseTable">
  286. <Key>
  287. <PropertyRef Name="ID" />
  288. </Key>
  289. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  290. <Property Name="IdSession" Type="Int32" Nullable="false" />
  291. <Property Name="IdDisease" Type="Int32" Nullable="false" />
  292. <NavigationProperty Name="DiseaseTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_SessionDiseaseTable_DiseaseTable" FromRole="SessionDiseaseTable" ToRole="DiseaseTable" />
  293. <NavigationProperty Name="SessionTestTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_SessionDiseaseTable_SessionTestTable" FromRole="SessionDiseaseTable" ToRole="SessionTestTable" />
  294. </EntityType>
  295. <EntityType Name="SessionTestTable">
  296. <Key>
  297. <PropertyRef Name="ID" />
  298. </Key>
  299. <Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  300. <Property Name="IdUser" Type="Int32" Nullable="false" />
  301. <Property Name="Date" Type="DateTime" Nullable="false" Precision="0" />
  302. <NavigationProperty Name="SessionDiseaseTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK_SessionDiseaseTable_SessionTestTable" FromRole="SessionTestTable" ToRole="SessionDiseaseTable" />
  303. <NavigationProperty Name="UserTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK__SessionTe__IdUse__46E78A0C" FromRole="SessionTestTable" ToRole="UserTable" />
  304. </EntityType>
  305. <EntityType Name="UserTable">
  306. <Key>
  307. <PropertyRef Name="ID" />
  308. </Key>
  309. <Property Name="ID" Type="Int32" Nullable="false" />
  310. <Property Name="Surname" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
  311. <Property Name="Name" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
  312. <NavigationProperty Name="BlogTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK__BlogTable__IdUse__3C69FB99" FromRole="UserTable" ToRole="BlogTable" />
  313. <NavigationProperty Name="LoginedTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK__UserTable__ID__398D8EEE" FromRole="UserTable" ToRole="LoginedTable" />
  314. <NavigationProperty Name="SessionTestTable" Relationship="Knyazeva_Kochnev_Smerdova_UPModel.FK__SessionTe__IdUse__46E78A0C" FromRole="UserTable" ToRole="SessionTestTable" />
  315. </EntityType>
  316. <Association Name="FK__BlogTable__IdUse__3C69FB99">
  317. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.UserTable" Role="UserTable" Multiplicity="1" />
  318. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.BlogTable" Role="BlogTable" Multiplicity="*" />
  319. <ReferentialConstraint>
  320. <Principal Role="UserTable">
  321. <PropertyRef Name="ID" />
  322. </Principal>
  323. <Dependent Role="BlogTable">
  324. <PropertyRef Name="IdUser" />
  325. </Dependent>
  326. </ReferentialConstraint>
  327. </Association>
  328. <Association Name="FK_DiseaseQuestionTable_DiseaseTable">
  329. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseTable" Role="DiseaseTable" Multiplicity="1" />
  330. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseQuestionTable" Role="DiseaseQuestionTable" Multiplicity="*" />
  331. <ReferentialConstraint>
  332. <Principal Role="DiseaseTable">
  333. <PropertyRef Name="ID" />
  334. </Principal>
  335. <Dependent Role="DiseaseQuestionTable">
  336. <PropertyRef Name="IdDisease" />
  337. </Dependent>
  338. </ReferentialConstraint>
  339. </Association>
  340. <Association Name="FK_DiseaseQuestionTable_QuestionTable">
  341. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.QuestionTable" Role="QuestionTable" Multiplicity="1" />
  342. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseQuestionTable" Role="DiseaseQuestionTable" Multiplicity="*" />
  343. <ReferentialConstraint>
  344. <Principal Role="QuestionTable">
  345. <PropertyRef Name="ID" />
  346. </Principal>
  347. <Dependent Role="DiseaseQuestionTable">
  348. <PropertyRef Name="IdQuestion" />
  349. </Dependent>
  350. </ReferentialConstraint>
  351. </Association>
  352. <Association Name="FK_SessionDiseaseTable_DiseaseTable">
  353. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseTable" Role="DiseaseTable" Multiplicity="1" />
  354. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.SessionDiseaseTable" Role="SessionDiseaseTable" Multiplicity="*" />
  355. <ReferentialConstraint>
  356. <Principal Role="DiseaseTable">
  357. <PropertyRef Name="ID" />
  358. </Principal>
  359. <Dependent Role="SessionDiseaseTable">
  360. <PropertyRef Name="IdDisease" />
  361. </Dependent>
  362. </ReferentialConstraint>
  363. </Association>
  364. <Association Name="FK__UserTable__ID__398D8EEE">
  365. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.LoginedTable" Role="LoginedTable" Multiplicity="1" />
  366. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.UserTable" Role="UserTable" Multiplicity="0..1" />
  367. <ReferentialConstraint>
  368. <Principal Role="LoginedTable">
  369. <PropertyRef Name="ID" />
  370. </Principal>
  371. <Dependent Role="UserTable">
  372. <PropertyRef Name="ID" />
  373. </Dependent>
  374. </ReferentialConstraint>
  375. </Association>
  376. <Association Name="FK_SessionDiseaseTable_SessionTestTable">
  377. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.SessionTestTable" Role="SessionTestTable" Multiplicity="1" />
  378. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.SessionDiseaseTable" Role="SessionDiseaseTable" Multiplicity="*" />
  379. <ReferentialConstraint>
  380. <Principal Role="SessionTestTable">
  381. <PropertyRef Name="ID" />
  382. </Principal>
  383. <Dependent Role="SessionDiseaseTable">
  384. <PropertyRef Name="IdSession" />
  385. </Dependent>
  386. </ReferentialConstraint>
  387. </Association>
  388. <Association Name="FK__SessionTe__IdUse__46E78A0C">
  389. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.UserTable" Role="UserTable" Multiplicity="1" />
  390. <End Type="Knyazeva_Kochnev_Smerdova_UPModel.SessionTestTable" Role="SessionTestTable" Multiplicity="*" />
  391. <ReferentialConstraint>
  392. <Principal Role="UserTable">
  393. <PropertyRef Name="ID" />
  394. </Principal>
  395. <Dependent Role="SessionTestTable">
  396. <PropertyRef Name="IdUser" />
  397. </Dependent>
  398. </ReferentialConstraint>
  399. </Association>
  400. </Schema>
  401. </edmx:ConceptualModels>
  402. <!-- C-S mapping content -->
  403. <edmx:Mappings>
  404. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  405. <EntityContainerMapping StorageEntityContainer="Хранилище Knyazeva_Kochnev_Smerdova_UPModelContainer" CdmEntityContainer="Knyazeva_Kochnev_Smerdova_UPEntities">
  406. <EntitySetMapping Name="BlogTable">
  407. <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.BlogTable">
  408. <MappingFragment StoreEntitySet="BlogTable">
  409. <ScalarProperty Name="IdUser" ColumnName="IdUser" />
  410. <ScalarProperty Name="Entry" ColumnName="Entry" />
  411. <ScalarProperty Name="Date" ColumnName="Date" />
  412. <ScalarProperty Name="ID" ColumnName="ID" />
  413. </MappingFragment>
  414. </EntityTypeMapping>
  415. </EntitySetMapping>
  416. <EntitySetMapping Name="DiseaseQuestionTable">
  417. <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseQuestionTable">
  418. <MappingFragment StoreEntitySet="DiseaseQuestionTable">
  419. <ScalarProperty Name="IdQuestion" ColumnName="IdQuestion" />
  420. <ScalarProperty Name="IdDisease" ColumnName="IdDisease" />
  421. <ScalarProperty Name="ID" ColumnName="ID" />
  422. </MappingFragment>
  423. </EntityTypeMapping>
  424. </EntitySetMapping>
  425. <EntitySetMapping Name="DiseaseTable">
  426. <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.DiseaseTable">
  427. <MappingFragment StoreEntitySet="DiseaseTable">
  428. <ScalarProperty Name="Medication" ColumnName="Medication" />
  429. <ScalarProperty Name="Description" ColumnName="Description" />
  430. <ScalarProperty Name="Name" ColumnName="Name" />
  431. <ScalarProperty Name="ID" ColumnName="ID" />
  432. </MappingFragment>
  433. </EntityTypeMapping>
  434. </EntitySetMapping>
  435. <EntitySetMapping Name="LoginedTable">
  436. <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.LoginedTable">
  437. <MappingFragment StoreEntitySet="LoginedTable">
  438. <ScalarProperty Name="Password" ColumnName="Password" />
  439. <ScalarProperty Name="Login" ColumnName="Login" />
  440. <ScalarProperty Name="ID" ColumnName="ID" />
  441. </MappingFragment>
  442. </EntityTypeMapping>
  443. </EntitySetMapping>
  444. <EntitySetMapping Name="QuestionTable">
  445. <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.QuestionTable">
  446. <MappingFragment StoreEntitySet="QuestionTable">
  447. <ScalarProperty Name="Name" ColumnName="Name" />
  448. <ScalarProperty Name="ID" ColumnName="ID" />
  449. </MappingFragment>
  450. </EntityTypeMapping>
  451. </EntitySetMapping>
  452. <EntitySetMapping Name="SessionDiseaseTable">
  453. <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.SessionDiseaseTable">
  454. <MappingFragment StoreEntitySet="SessionDiseaseTable">
  455. <ScalarProperty Name="IdDisease" ColumnName="IdDisease" />
  456. <ScalarProperty Name="IdSession" ColumnName="IdSession" />
  457. <ScalarProperty Name="ID" ColumnName="ID" />
  458. </MappingFragment>
  459. </EntityTypeMapping>
  460. </EntitySetMapping>
  461. <EntitySetMapping Name="SessionTestTable">
  462. <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.SessionTestTable">
  463. <MappingFragment StoreEntitySet="SessionTestTable">
  464. <ScalarProperty Name="Date" ColumnName="Date" />
  465. <ScalarProperty Name="IdUser" ColumnName="IdUser" />
  466. <ScalarProperty Name="ID" ColumnName="ID" />
  467. </MappingFragment>
  468. </EntityTypeMapping>
  469. </EntitySetMapping>
  470. <EntitySetMapping Name="UserTable">
  471. <EntityTypeMapping TypeName="Knyazeva_Kochnev_Smerdova_UPModel.UserTable">
  472. <MappingFragment StoreEntitySet="UserTable">
  473. <ScalarProperty Name="Name" ColumnName="Name" />
  474. <ScalarProperty Name="Surname" ColumnName="Surname" />
  475. <ScalarProperty Name="ID" ColumnName="ID" />
  476. </MappingFragment>
  477. </EntityTypeMapping>
  478. </EntitySetMapping>
  479. </EntityContainerMapping>
  480. </Mapping>
  481. </edmx:Mappings>
  482. </edmx:Runtime>
  483. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  484. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  485. <Connection>
  486. <DesignerInfoPropertySet>
  487. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  488. </DesignerInfoPropertySet>
  489. </Connection>
  490. <Options>
  491. <DesignerInfoPropertySet>
  492. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  493. <DesignerProperty Name="EnablePluralization" Value="false" />
  494. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  495. <DesignerProperty Name="UseLegacyProvider" Value="false" />
  496. <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
  497. </DesignerInfoPropertySet>
  498. </Options>
  499. <!-- Diagram content (shape and connector positions) -->
  500. <Diagrams></Diagrams>
  501. </Designer>
  502. </edmx:Edmx>