Model1.edmx 28 KB

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