DataBaseModel.edmx 29 KB

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