Model1.edmx 31 KB

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