ModelBD.edmx 30 KB

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