GasStationModel.edmx 49 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901
  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="Хранилище gr672_pgvModel" 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="Car">
  9. <Key>
  10. <PropertyRef Name="CarID" />
  11. </Key>
  12. <Property Name="CarID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  13. <Property Name="CarNumber" Type="nvarchar" MaxLength="9" Nullable="false" />
  14. <Property Name="VolumeTank" Type="int" />
  15. <Property Name="IDClient" Type="int" />
  16. </EntityType>
  17. <EntityType Name="Card">
  18. <Key>
  19. <PropertyRef Name="CardID" />
  20. </Key>
  21. <Property Name="CardID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  22. <Property Name="NumberCard" Type="nvarchar" MaxLength="20" Nullable="false" />
  23. <Property Name="CardExpDate" Type="nvarchar" MaxLength="10" Nullable="false" />
  24. <Property Name="Balance" Type="money" Nullable="false" />
  25. <Property Name="IDCardType" Type="int" Nullable="false" />
  26. <Property Name="IDCardIssuer" Type="int" />
  27. <Property Name="IDHolder" Type="int" Nullable="false" />
  28. </EntityType>
  29. <EntityType Name="CardIssuer">
  30. <Key>
  31. <PropertyRef Name="CardIssuerID" />
  32. </Key>
  33. <Property Name="CardIssuerID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  34. <Property Name="NameCardIssuer" Type="nvarchar" MaxLength="50" Nullable="false" />
  35. </EntityType>
  36. <EntityType Name="CardType">
  37. <Key>
  38. <PropertyRef Name="CardTypeID" />
  39. </Key>
  40. <Property Name="CardTypeID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  41. <Property Name="NameType" Type="nvarchar" MaxLength="50" Nullable="false" />
  42. </EntityType>
  43. <EntityType Name="Client">
  44. <Key>
  45. <PropertyRef Name="ClientID" />
  46. </Key>
  47. <Property Name="ClientID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  48. <Property Name="LastName" Type="nvarchar" MaxLength="50" Nullable="false" />
  49. <Property Name="Name" Type="nvarchar" MaxLength="50" Nullable="false" />
  50. </EntityType>
  51. <EntityType Name="DataOfCamera">
  52. <Key>
  53. <PropertyRef Name="DataOfCameraID" />
  54. </Key>
  55. <Property Name="DataOfCameraID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  56. <Property Name="Date" Type="datetime" Nullable="false" />
  57. <Property Name="Status" Type="bit" Nullable="false" />
  58. <Property Name="CarNumber" Type="nvarchar" MaxLength="9" />
  59. <Property Name="NameImage" Type="nvarchar(max)" Nullable="false" />
  60. </EntityType>
  61. <EntityType Name="FuelType">
  62. <Key>
  63. <PropertyRef Name="FuelTypeID" />
  64. </Key>
  65. <Property Name="FuelTypeID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  66. <Property Name="NameFuelType" Type="nvarchar" MaxLength="2" Nullable="false" />
  67. </EntityType>
  68. <EntityType Name="FuelTypeOnGasStation">
  69. <Key>
  70. <PropertyRef Name="IDGasStation" />
  71. <PropertyRef Name="IDFuelType" />
  72. </Key>
  73. <Property Name="IDGasStation" Type="int" Nullable="false" />
  74. <Property Name="IDFuelType" Type="int" Nullable="false" />
  75. <Property Name="Price" Type="float" Nullable="false" />
  76. <Property Name="AmountOfFuel" Type="int" Nullable="false" />
  77. </EntityType>
  78. <EntityType Name="GasStation">
  79. <Key>
  80. <PropertyRef Name="GasStationID" />
  81. </Key>
  82. <Property Name="GasStationID" Type="int" Nullable="false" />
  83. <Property Name="Address" Type="nvarchar(max)" Nullable="false" />
  84. </EntityType>
  85. <EntityType Name="Payment">
  86. <Key>
  87. <PropertyRef Name="PaymentID" />
  88. </Key>
  89. <Property Name="PaymentID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  90. <Property Name="IDRefueling" Type="int" Nullable="false" />
  91. <Property Name="PriceRefueling" Type="money" Nullable="false" />
  92. <Property Name="Status" Type="bit" Nullable="false" />
  93. <Property Name="TransactionCode" Type="nvarchar" MaxLength="17" Nullable="false" />
  94. <Property Name="IDCard" Type="int" Nullable="false" />
  95. </EntityType>
  96. <EntityType Name="Refueling">
  97. <Key>
  98. <PropertyRef Name="RefuelingID" />
  99. </Key>
  100. <Property Name="RefuelingID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  101. <Property Name="IDCar" Type="int" />
  102. <Property Name="VolumeFuel" Type="int" Nullable="false" />
  103. <Property Name="IDDataOfCamera" Type="int" />
  104. <Property Name="KeySession" Type="nvarchar" MaxLength="12" Nullable="false" />
  105. <Property Name="IDRefulingGun" Type="int" Nullable="false" />
  106. </EntityType>
  107. <EntityType Name="RefuelingColumn">
  108. <Key>
  109. <PropertyRef Name="RefuelingColumnID" />
  110. </Key>
  111. <Property Name="RefuelingColumnID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  112. <Property Name="IDGasStation" Type="int" Nullable="false" />
  113. </EntityType>
  114. <EntityType Name="RefuelingGun">
  115. <Key>
  116. <PropertyRef Name="RefuelingGunID" />
  117. </Key>
  118. <Property Name="RefuelingGunID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  119. <Property Name="IDRefuelingColumn" Type="int" Nullable="false" />
  120. <Property Name="IDFuelType" Type="int" Nullable="false" />
  121. </EntityType>
  122. <Association Name="FK_Car_Client">
  123. <End Role="Client" Type="Self.Client" Multiplicity="0..1" />
  124. <End Role="Car" Type="Self.Car" Multiplicity="*" />
  125. <ReferentialConstraint>
  126. <Principal Role="Client">
  127. <PropertyRef Name="ClientID" />
  128. </Principal>
  129. <Dependent Role="Car">
  130. <PropertyRef Name="IDClient" />
  131. </Dependent>
  132. </ReferentialConstraint>
  133. </Association>
  134. <Association Name="FK_Card_CardIssuer">
  135. <End Role="CardIssuer" Type="Self.CardIssuer" Multiplicity="0..1" />
  136. <End Role="Card" Type="Self.Card" Multiplicity="*" />
  137. <ReferentialConstraint>
  138. <Principal Role="CardIssuer">
  139. <PropertyRef Name="CardIssuerID" />
  140. </Principal>
  141. <Dependent Role="Card">
  142. <PropertyRef Name="IDCardIssuer" />
  143. </Dependent>
  144. </ReferentialConstraint>
  145. </Association>
  146. <Association Name="FK_Card_CardType">
  147. <End Role="CardType" Type="Self.CardType" Multiplicity="1" />
  148. <End Role="Card" Type="Self.Card" Multiplicity="*" />
  149. <ReferentialConstraint>
  150. <Principal Role="CardType">
  151. <PropertyRef Name="CardTypeID" />
  152. </Principal>
  153. <Dependent Role="Card">
  154. <PropertyRef Name="IDCardType" />
  155. </Dependent>
  156. </ReferentialConstraint>
  157. </Association>
  158. <Association Name="FK_Card_Client">
  159. <End Role="Client" Type="Self.Client" Multiplicity="1" />
  160. <End Role="Card" Type="Self.Card" Multiplicity="*" />
  161. <ReferentialConstraint>
  162. <Principal Role="Client">
  163. <PropertyRef Name="ClientID" />
  164. </Principal>
  165. <Dependent Role="Card">
  166. <PropertyRef Name="IDHolder" />
  167. </Dependent>
  168. </ReferentialConstraint>
  169. </Association>
  170. <Association Name="FK_FuelInGasStation_GasStation">
  171. <End Role="GasStation" Type="Self.GasStation" Multiplicity="1" />
  172. <End Role="FuelTypeOnGasStation" Type="Self.FuelTypeOnGasStation" Multiplicity="*" />
  173. <ReferentialConstraint>
  174. <Principal Role="GasStation">
  175. <PropertyRef Name="GasStationID" />
  176. </Principal>
  177. <Dependent Role="FuelTypeOnGasStation">
  178. <PropertyRef Name="IDGasStation" />
  179. </Dependent>
  180. </ReferentialConstraint>
  181. </Association>
  182. <Association Name="FK_FuelInGasStation_TypeOfFuel">
  183. <End Role="FuelType" Type="Self.FuelType" Multiplicity="1" />
  184. <End Role="FuelTypeOnGasStation" Type="Self.FuelTypeOnGasStation" Multiplicity="*" />
  185. <ReferentialConstraint>
  186. <Principal Role="FuelType">
  187. <PropertyRef Name="FuelTypeID" />
  188. </Principal>
  189. <Dependent Role="FuelTypeOnGasStation">
  190. <PropertyRef Name="IDFuelType" />
  191. </Dependent>
  192. </ReferentialConstraint>
  193. </Association>
  194. <Association Name="FK_Payment_Card">
  195. <End Role="Card" Type="Self.Card" Multiplicity="1" />
  196. <End Role="Payment" Type="Self.Payment" Multiplicity="*" />
  197. <ReferentialConstraint>
  198. <Principal Role="Card">
  199. <PropertyRef Name="CardID" />
  200. </Principal>
  201. <Dependent Role="Payment">
  202. <PropertyRef Name="IDCard" />
  203. </Dependent>
  204. </ReferentialConstraint>
  205. </Association>
  206. <Association Name="FK_Payment_Refueling">
  207. <End Role="Refueling" Type="Self.Refueling" Multiplicity="1" />
  208. <End Role="Payment" Type="Self.Payment" Multiplicity="*" />
  209. <ReferentialConstraint>
  210. <Principal Role="Refueling">
  211. <PropertyRef Name="RefuelingID" />
  212. </Principal>
  213. <Dependent Role="Payment">
  214. <PropertyRef Name="IDRefueling" />
  215. </Dependent>
  216. </ReferentialConstraint>
  217. </Association>
  218. <Association Name="FK_Refueling_Car">
  219. <End Role="Car" Type="Self.Car" Multiplicity="0..1" />
  220. <End Role="Refueling" Type="Self.Refueling" Multiplicity="*" />
  221. <ReferentialConstraint>
  222. <Principal Role="Car">
  223. <PropertyRef Name="CarID" />
  224. </Principal>
  225. <Dependent Role="Refueling">
  226. <PropertyRef Name="IDCar" />
  227. </Dependent>
  228. </ReferentialConstraint>
  229. </Association>
  230. <Association Name="FK_Refueling_DataOfCamera">
  231. <End Role="DataOfCamera" Type="Self.DataOfCamera" Multiplicity="0..1" />
  232. <End Role="Refueling" Type="Self.Refueling" Multiplicity="*" />
  233. <ReferentialConstraint>
  234. <Principal Role="DataOfCamera">
  235. <PropertyRef Name="DataOfCameraID" />
  236. </Principal>
  237. <Dependent Role="Refueling">
  238. <PropertyRef Name="IDDataOfCamera" />
  239. </Dependent>
  240. </ReferentialConstraint>
  241. </Association>
  242. <Association Name="FK_Refueling_RefuelingGun">
  243. <End Role="RefuelingGun" Type="Self.RefuelingGun" Multiplicity="1" />
  244. <End Role="Refueling" Type="Self.Refueling" Multiplicity="*" />
  245. <ReferentialConstraint>
  246. <Principal Role="RefuelingGun">
  247. <PropertyRef Name="RefuelingGunID" />
  248. </Principal>
  249. <Dependent Role="Refueling">
  250. <PropertyRef Name="IDRefulingGun" />
  251. </Dependent>
  252. </ReferentialConstraint>
  253. </Association>
  254. <Association Name="FK_RefuelingColumn_GasStation">
  255. <End Role="GasStation" Type="Self.GasStation" Multiplicity="1" />
  256. <End Role="RefuelingColumn" Type="Self.RefuelingColumn" Multiplicity="*" />
  257. <ReferentialConstraint>
  258. <Principal Role="GasStation">
  259. <PropertyRef Name="GasStationID" />
  260. </Principal>
  261. <Dependent Role="RefuelingColumn">
  262. <PropertyRef Name="IDGasStation" />
  263. </Dependent>
  264. </ReferentialConstraint>
  265. </Association>
  266. <Association Name="FK_RefuelingGun_FuelType">
  267. <End Role="FuelType" Type="Self.FuelType" Multiplicity="1" />
  268. <End Role="RefuelingGun" Type="Self.RefuelingGun" Multiplicity="*" />
  269. <ReferentialConstraint>
  270. <Principal Role="FuelType">
  271. <PropertyRef Name="FuelTypeID" />
  272. </Principal>
  273. <Dependent Role="RefuelingGun">
  274. <PropertyRef Name="IDFuelType" />
  275. </Dependent>
  276. </ReferentialConstraint>
  277. </Association>
  278. <Association Name="FK_RefuelingGun_RefuelingColumn">
  279. <End Role="RefuelingColumn" Type="Self.RefuelingColumn" Multiplicity="1" />
  280. <End Role="RefuelingGun" Type="Self.RefuelingGun" Multiplicity="*" />
  281. <ReferentialConstraint>
  282. <Principal Role="RefuelingColumn">
  283. <PropertyRef Name="RefuelingColumnID" />
  284. </Principal>
  285. <Dependent Role="RefuelingGun">
  286. <PropertyRef Name="IDRefuelingColumn" />
  287. </Dependent>
  288. </ReferentialConstraint>
  289. </Association>
  290. <EntityContainer Name="Хранилище gr672_pgvModelContainer">
  291. <EntitySet Name="Car" EntityType="Self.Car" Schema="dbo" store:Type="Tables" />
  292. <EntitySet Name="Card" EntityType="Self.Card" Schema="dbo" store:Type="Tables" />
  293. <EntitySet Name="CardIssuer" EntityType="Self.CardIssuer" Schema="dbo" store:Type="Tables" />
  294. <EntitySet Name="CardType" EntityType="Self.CardType" Schema="dbo" store:Type="Tables" />
  295. <EntitySet Name="Client" EntityType="Self.Client" Schema="dbo" store:Type="Tables" />
  296. <EntitySet Name="DataOfCamera" EntityType="Self.DataOfCamera" Schema="dbo" store:Type="Tables" />
  297. <EntitySet Name="FuelType" EntityType="Self.FuelType" Schema="dbo" store:Type="Tables" />
  298. <EntitySet Name="FuelTypeOnGasStation" EntityType="Self.FuelTypeOnGasStation" Schema="dbo" store:Type="Tables" />
  299. <EntitySet Name="GasStation" EntityType="Self.GasStation" Schema="dbo" store:Type="Tables" />
  300. <EntitySet Name="Payment" EntityType="Self.Payment" Schema="dbo" store:Type="Tables" />
  301. <EntitySet Name="Refueling" EntityType="Self.Refueling" Schema="dbo" store:Type="Tables" />
  302. <EntitySet Name="RefuelingColumn" EntityType="Self.RefuelingColumn" Schema="dbo" store:Type="Tables" />
  303. <EntitySet Name="RefuelingGun" EntityType="Self.RefuelingGun" Schema="dbo" store:Type="Tables" />
  304. <AssociationSet Name="FK_Car_Client" Association="Self.FK_Car_Client">
  305. <End Role="Client" EntitySet="Client" />
  306. <End Role="Car" EntitySet="Car" />
  307. </AssociationSet>
  308. <AssociationSet Name="FK_Card_CardIssuer" Association="Self.FK_Card_CardIssuer">
  309. <End Role="CardIssuer" EntitySet="CardIssuer" />
  310. <End Role="Card" EntitySet="Card" />
  311. </AssociationSet>
  312. <AssociationSet Name="FK_Card_CardType" Association="Self.FK_Card_CardType">
  313. <End Role="CardType" EntitySet="CardType" />
  314. <End Role="Card" EntitySet="Card" />
  315. </AssociationSet>
  316. <AssociationSet Name="FK_Card_Client" Association="Self.FK_Card_Client">
  317. <End Role="Client" EntitySet="Client" />
  318. <End Role="Card" EntitySet="Card" />
  319. </AssociationSet>
  320. <AssociationSet Name="FK_FuelInGasStation_GasStation" Association="Self.FK_FuelInGasStation_GasStation">
  321. <End Role="GasStation" EntitySet="GasStation" />
  322. <End Role="FuelTypeOnGasStation" EntitySet="FuelTypeOnGasStation" />
  323. </AssociationSet>
  324. <AssociationSet Name="FK_FuelInGasStation_TypeOfFuel" Association="Self.FK_FuelInGasStation_TypeOfFuel">
  325. <End Role="FuelType" EntitySet="FuelType" />
  326. <End Role="FuelTypeOnGasStation" EntitySet="FuelTypeOnGasStation" />
  327. </AssociationSet>
  328. <AssociationSet Name="FK_Payment_Card" Association="Self.FK_Payment_Card">
  329. <End Role="Card" EntitySet="Card" />
  330. <End Role="Payment" EntitySet="Payment" />
  331. </AssociationSet>
  332. <AssociationSet Name="FK_Payment_Refueling" Association="Self.FK_Payment_Refueling">
  333. <End Role="Refueling" EntitySet="Refueling" />
  334. <End Role="Payment" EntitySet="Payment" />
  335. </AssociationSet>
  336. <AssociationSet Name="FK_Refueling_Car" Association="Self.FK_Refueling_Car">
  337. <End Role="Car" EntitySet="Car" />
  338. <End Role="Refueling" EntitySet="Refueling" />
  339. </AssociationSet>
  340. <AssociationSet Name="FK_Refueling_DataOfCamera" Association="Self.FK_Refueling_DataOfCamera">
  341. <End Role="DataOfCamera" EntitySet="DataOfCamera" />
  342. <End Role="Refueling" EntitySet="Refueling" />
  343. </AssociationSet>
  344. <AssociationSet Name="FK_Refueling_RefuelingGun" Association="Self.FK_Refueling_RefuelingGun">
  345. <End Role="RefuelingGun" EntitySet="RefuelingGun" />
  346. <End Role="Refueling" EntitySet="Refueling" />
  347. </AssociationSet>
  348. <AssociationSet Name="FK_RefuelingColumn_GasStation" Association="Self.FK_RefuelingColumn_GasStation">
  349. <End Role="GasStation" EntitySet="GasStation" />
  350. <End Role="RefuelingColumn" EntitySet="RefuelingColumn" />
  351. </AssociationSet>
  352. <AssociationSet Name="FK_RefuelingGun_FuelType" Association="Self.FK_RefuelingGun_FuelType">
  353. <End Role="FuelType" EntitySet="FuelType" />
  354. <End Role="RefuelingGun" EntitySet="RefuelingGun" />
  355. </AssociationSet>
  356. <AssociationSet Name="FK_RefuelingGun_RefuelingColumn" Association="Self.FK_RefuelingGun_RefuelingColumn">
  357. <End Role="RefuelingColumn" EntitySet="RefuelingColumn" />
  358. <End Role="RefuelingGun" EntitySet="RefuelingGun" />
  359. </AssociationSet>
  360. </EntityContainer>
  361. </Schema></edmx:StorageModels>
  362. <!-- CSDL content -->
  363. <edmx:ConceptualModels>
  364. <Schema Namespace="gr672_pgvModel" 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">
  365. <EntityContainer Name="gr672_pgvEntities" annotation:LazyLoadingEnabled="true">
  366. <EntitySet Name="Car" EntityType="gr672_pgvModel.Car" />
  367. <EntitySet Name="Card" EntityType="gr672_pgvModel.Card" />
  368. <EntitySet Name="CardIssuer" EntityType="gr672_pgvModel.CardIssuer" />
  369. <EntitySet Name="CardType" EntityType="gr672_pgvModel.CardType" />
  370. <EntitySet Name="Client" EntityType="gr672_pgvModel.Client" />
  371. <EntitySet Name="DataOfCamera" EntityType="gr672_pgvModel.DataOfCamera" />
  372. <EntitySet Name="FuelType" EntityType="gr672_pgvModel.FuelType" />
  373. <EntitySet Name="FuelTypeOnGasStation" EntityType="gr672_pgvModel.FuelTypeOnGasStation" />
  374. <EntitySet Name="GasStation" EntityType="gr672_pgvModel.GasStation" />
  375. <EntitySet Name="Payment" EntityType="gr672_pgvModel.Payment" />
  376. <EntitySet Name="Refueling" EntityType="gr672_pgvModel.Refueling" />
  377. <EntitySet Name="RefuelingColumn" EntityType="gr672_pgvModel.RefuelingColumn" />
  378. <EntitySet Name="RefuelingGun" EntityType="gr672_pgvModel.RefuelingGun" />
  379. <AssociationSet Name="FK_Car_Client" Association="gr672_pgvModel.FK_Car_Client">
  380. <End Role="Client" EntitySet="Client" />
  381. <End Role="Car" EntitySet="Car" />
  382. </AssociationSet>
  383. <AssociationSet Name="FK_Refueling_Car" Association="gr672_pgvModel.FK_Refueling_Car">
  384. <End Role="Car" EntitySet="Car" />
  385. <End Role="Refueling" EntitySet="Refueling" />
  386. </AssociationSet>
  387. <AssociationSet Name="FK_Card_CardIssuer" Association="gr672_pgvModel.FK_Card_CardIssuer">
  388. <End Role="CardIssuer" EntitySet="CardIssuer" />
  389. <End Role="Card" EntitySet="Card" />
  390. </AssociationSet>
  391. <AssociationSet Name="FK_Card_CardType" Association="gr672_pgvModel.FK_Card_CardType">
  392. <End Role="CardType" EntitySet="CardType" />
  393. <End Role="Card" EntitySet="Card" />
  394. </AssociationSet>
  395. <AssociationSet Name="FK_Card_Client" Association="gr672_pgvModel.FK_Card_Client">
  396. <End Role="Client" EntitySet="Client" />
  397. <End Role="Card" EntitySet="Card" />
  398. </AssociationSet>
  399. <AssociationSet Name="FK_Payment_Card" Association="gr672_pgvModel.FK_Payment_Card">
  400. <End Role="Card" EntitySet="Card" />
  401. <End Role="Payment" EntitySet="Payment" />
  402. </AssociationSet>
  403. <AssociationSet Name="FK_Refueling_DataOfCamera" Association="gr672_pgvModel.FK_Refueling_DataOfCamera">
  404. <End Role="DataOfCamera" EntitySet="DataOfCamera" />
  405. <End Role="Refueling" EntitySet="Refueling" />
  406. </AssociationSet>
  407. <AssociationSet Name="FK_FuelInGasStation_TypeOfFuel" Association="gr672_pgvModel.FK_FuelInGasStation_TypeOfFuel">
  408. <End Role="FuelType" EntitySet="FuelType" />
  409. <End Role="FuelTypeOnGasStation" EntitySet="FuelTypeOnGasStation" />
  410. </AssociationSet>
  411. <AssociationSet Name="FK_RefuelingGun_FuelType" Association="gr672_pgvModel.FK_RefuelingGun_FuelType">
  412. <End Role="FuelType" EntitySet="FuelType" />
  413. <End Role="RefuelingGun" EntitySet="RefuelingGun" />
  414. </AssociationSet>
  415. <AssociationSet Name="FK_FuelInGasStation_GasStation" Association="gr672_pgvModel.FK_FuelInGasStation_GasStation">
  416. <End Role="GasStation" EntitySet="GasStation" />
  417. <End Role="FuelTypeOnGasStation" EntitySet="FuelTypeOnGasStation" />
  418. </AssociationSet>
  419. <AssociationSet Name="FK_RefuelingColumn_GasStation" Association="gr672_pgvModel.FK_RefuelingColumn_GasStation">
  420. <End Role="GasStation" EntitySet="GasStation" />
  421. <End Role="RefuelingColumn" EntitySet="RefuelingColumn" />
  422. </AssociationSet>
  423. <AssociationSet Name="FK_Payment_Refueling" Association="gr672_pgvModel.FK_Payment_Refueling">
  424. <End Role="Refueling" EntitySet="Refueling" />
  425. <End Role="Payment" EntitySet="Payment" />
  426. </AssociationSet>
  427. <AssociationSet Name="FK_Refueling_RefuelingGun" Association="gr672_pgvModel.FK_Refueling_RefuelingGun">
  428. <End Role="RefuelingGun" EntitySet="RefuelingGun" />
  429. <End Role="Refueling" EntitySet="Refueling" />
  430. </AssociationSet>
  431. <AssociationSet Name="FK_RefuelingGun_RefuelingColumn" Association="gr672_pgvModel.FK_RefuelingGun_RefuelingColumn">
  432. <End Role="RefuelingColumn" EntitySet="RefuelingColumn" />
  433. <End Role="RefuelingGun" EntitySet="RefuelingGun" />
  434. </AssociationSet>
  435. </EntityContainer>
  436. <EntityType Name="Car">
  437. <Key>
  438. <PropertyRef Name="CarID" />
  439. </Key>
  440. <Property Name="CarID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  441. <Property Name="CarNumber" Type="String" Nullable="false" MaxLength="9" FixedLength="false" Unicode="true" />
  442. <Property Name="VolumeTank" Type="Int32" />
  443. <Property Name="IDClient" Type="Int32" />
  444. <NavigationProperty Name="Client" Relationship="gr672_pgvModel.FK_Car_Client" FromRole="Car" ToRole="Client" />
  445. <NavigationProperty Name="Refueling" Relationship="gr672_pgvModel.FK_Refueling_Car" FromRole="Car" ToRole="Refueling" />
  446. </EntityType>
  447. <EntityType Name="Card">
  448. <Key>
  449. <PropertyRef Name="CardID" />
  450. </Key>
  451. <Property Name="CardID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  452. <Property Name="NumberCard" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true" />
  453. <Property Name="CardExpDate" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" />
  454. <Property Name="Balance" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
  455. <Property Name="IDCardType" Type="Int32" Nullable="false" />
  456. <Property Name="IDCardIssuer" Type="Int32" />
  457. <Property Name="IDHolder" Type="Int32" Nullable="false" />
  458. <NavigationProperty Name="CardIssuer" Relationship="gr672_pgvModel.FK_Card_CardIssuer" FromRole="Card" ToRole="CardIssuer" />
  459. <NavigationProperty Name="CardType" Relationship="gr672_pgvModel.FK_Card_CardType" FromRole="Card" ToRole="CardType" />
  460. <NavigationProperty Name="Client" Relationship="gr672_pgvModel.FK_Card_Client" FromRole="Card" ToRole="Client" />
  461. <NavigationProperty Name="Payment" Relationship="gr672_pgvModel.FK_Payment_Card" FromRole="Card" ToRole="Payment" />
  462. </EntityType>
  463. <EntityType Name="CardIssuer">
  464. <Key>
  465. <PropertyRef Name="CardIssuerID" />
  466. </Key>
  467. <Property Name="CardIssuerID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  468. <Property Name="NameCardIssuer" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
  469. <NavigationProperty Name="Card" Relationship="gr672_pgvModel.FK_Card_CardIssuer" FromRole="CardIssuer" ToRole="Card" />
  470. </EntityType>
  471. <EntityType Name="CardType">
  472. <Key>
  473. <PropertyRef Name="CardTypeID" />
  474. </Key>
  475. <Property Name="CardTypeID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  476. <Property Name="NameType" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
  477. <NavigationProperty Name="Card" Relationship="gr672_pgvModel.FK_Card_CardType" FromRole="CardType" ToRole="Card" />
  478. </EntityType>
  479. <EntityType Name="Client">
  480. <Key>
  481. <PropertyRef Name="ClientID" />
  482. </Key>
  483. <Property Name="ClientID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  484. <Property Name="LastName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
  485. <Property Name="Name" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
  486. <NavigationProperty Name="Car" Relationship="gr672_pgvModel.FK_Car_Client" FromRole="Client" ToRole="Car" />
  487. <NavigationProperty Name="Card" Relationship="gr672_pgvModel.FK_Card_Client" FromRole="Client" ToRole="Card" />
  488. </EntityType>
  489. <EntityType Name="DataOfCamera">
  490. <Key>
  491. <PropertyRef Name="DataOfCameraID" />
  492. </Key>
  493. <Property Name="DataOfCameraID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  494. <Property Name="Date" Type="DateTime" Nullable="false" Precision="3" />
  495. <Property Name="Status" Type="Boolean" Nullable="false" />
  496. <Property Name="CarNumber" Type="String" MaxLength="9" FixedLength="false" Unicode="true" />
  497. <Property Name="NameImage" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
  498. <NavigationProperty Name="Refueling" Relationship="gr672_pgvModel.FK_Refueling_DataOfCamera" FromRole="DataOfCamera" ToRole="Refueling" />
  499. </EntityType>
  500. <EntityType Name="FuelType">
  501. <Key>
  502. <PropertyRef Name="FuelTypeID" />
  503. </Key>
  504. <Property Name="FuelTypeID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  505. <Property Name="NameFuelType" Type="String" Nullable="false" MaxLength="2" FixedLength="false" Unicode="true" />
  506. <NavigationProperty Name="FuelTypeOnGasStation" Relationship="gr672_pgvModel.FK_FuelInGasStation_TypeOfFuel" FromRole="FuelType" ToRole="FuelTypeOnGasStation" />
  507. <NavigationProperty Name="RefuelingGun" Relationship="gr672_pgvModel.FK_RefuelingGun_FuelType" FromRole="FuelType" ToRole="RefuelingGun" />
  508. </EntityType>
  509. <EntityType Name="FuelTypeOnGasStation">
  510. <Key>
  511. <PropertyRef Name="IDGasStation" />
  512. <PropertyRef Name="IDFuelType" />
  513. </Key>
  514. <Property Name="IDGasStation" Type="Int32" Nullable="false" />
  515. <Property Name="IDFuelType" Type="Int32" Nullable="false" />
  516. <Property Name="Price" Type="Double" Nullable="false" />
  517. <Property Name="AmountOfFuel" Type="Int32" Nullable="false" />
  518. <NavigationProperty Name="FuelType" Relationship="gr672_pgvModel.FK_FuelInGasStation_TypeOfFuel" FromRole="FuelTypeOnGasStation" ToRole="FuelType" />
  519. <NavigationProperty Name="GasStation" Relationship="gr672_pgvModel.FK_FuelInGasStation_GasStation" FromRole="FuelTypeOnGasStation" ToRole="GasStation" />
  520. </EntityType>
  521. <EntityType Name="GasStation">
  522. <Key>
  523. <PropertyRef Name="GasStationID" />
  524. </Key>
  525. <Property Name="GasStationID" Type="Int32" Nullable="false" />
  526. <Property Name="Address" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
  527. <NavigationProperty Name="FuelTypeOnGasStation" Relationship="gr672_pgvModel.FK_FuelInGasStation_GasStation" FromRole="GasStation" ToRole="FuelTypeOnGasStation" />
  528. <NavigationProperty Name="RefuelingColumn" Relationship="gr672_pgvModel.FK_RefuelingColumn_GasStation" FromRole="GasStation" ToRole="RefuelingColumn" />
  529. </EntityType>
  530. <EntityType Name="Payment">
  531. <Key>
  532. <PropertyRef Name="PaymentID" />
  533. </Key>
  534. <Property Name="PaymentID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  535. <Property Name="IDRefueling" Type="Int32" Nullable="false" />
  536. <Property Name="PriceRefueling" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
  537. <Property Name="Status" Type="Boolean" Nullable="false" />
  538. <Property Name="TransactionCode" Type="String" Nullable="false" MaxLength="17" FixedLength="false" Unicode="true" />
  539. <Property Name="IDCard" Type="Int32" Nullable="false" />
  540. <NavigationProperty Name="Card" Relationship="gr672_pgvModel.FK_Payment_Card" FromRole="Payment" ToRole="Card" />
  541. <NavigationProperty Name="Refueling" Relationship="gr672_pgvModel.FK_Payment_Refueling" FromRole="Payment" ToRole="Refueling" />
  542. </EntityType>
  543. <EntityType Name="Refueling">
  544. <Key>
  545. <PropertyRef Name="RefuelingID" />
  546. </Key>
  547. <Property Name="RefuelingID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  548. <Property Name="IDCar" Type="Int32" />
  549. <Property Name="VolumeFuel" Type="Int32" Nullable="false" />
  550. <Property Name="IDDataOfCamera" Type="Int32" />
  551. <Property Name="KeySession" Type="String" Nullable="false" MaxLength="12" FixedLength="false" Unicode="true" />
  552. <Property Name="IDRefulingGun" Type="Int32" Nullable="false" />
  553. <NavigationProperty Name="Car" Relationship="gr672_pgvModel.FK_Refueling_Car" FromRole="Refueling" ToRole="Car" />
  554. <NavigationProperty Name="DataOfCamera" Relationship="gr672_pgvModel.FK_Refueling_DataOfCamera" FromRole="Refueling" ToRole="DataOfCamera" />
  555. <NavigationProperty Name="Payment" Relationship="gr672_pgvModel.FK_Payment_Refueling" FromRole="Refueling" ToRole="Payment" />
  556. <NavigationProperty Name="RefuelingGun" Relationship="gr672_pgvModel.FK_Refueling_RefuelingGun" FromRole="Refueling" ToRole="RefuelingGun" />
  557. </EntityType>
  558. <EntityType Name="RefuelingColumn">
  559. <Key>
  560. <PropertyRef Name="RefuelingColumnID" />
  561. </Key>
  562. <Property Name="RefuelingColumnID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  563. <Property Name="IDGasStation" Type="Int32" Nullable="false" />
  564. <NavigationProperty Name="GasStation" Relationship="gr672_pgvModel.FK_RefuelingColumn_GasStation" FromRole="RefuelingColumn" ToRole="GasStation" />
  565. <NavigationProperty Name="RefuelingGun" Relationship="gr672_pgvModel.FK_RefuelingGun_RefuelingColumn" FromRole="RefuelingColumn" ToRole="RefuelingGun" />
  566. </EntityType>
  567. <EntityType Name="RefuelingGun">
  568. <Key>
  569. <PropertyRef Name="RefuelingGunID" />
  570. </Key>
  571. <Property Name="RefuelingGunID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  572. <Property Name="IDRefuelingColumn" Type="Int32" Nullable="false" />
  573. <Property Name="IDFuelType" Type="Int32" Nullable="false" />
  574. <NavigationProperty Name="FuelType" Relationship="gr672_pgvModel.FK_RefuelingGun_FuelType" FromRole="RefuelingGun" ToRole="FuelType" />
  575. <NavigationProperty Name="Refueling" Relationship="gr672_pgvModel.FK_Refueling_RefuelingGun" FromRole="RefuelingGun" ToRole="Refueling" />
  576. <NavigationProperty Name="RefuelingColumn" Relationship="gr672_pgvModel.FK_RefuelingGun_RefuelingColumn" FromRole="RefuelingGun" ToRole="RefuelingColumn" />
  577. </EntityType>
  578. <Association Name="FK_Car_Client">
  579. <End Type="gr672_pgvModel.Client" Role="Client" Multiplicity="0..1" />
  580. <End Type="gr672_pgvModel.Car" Role="Car" Multiplicity="*" />
  581. <ReferentialConstraint>
  582. <Principal Role="Client">
  583. <PropertyRef Name="ClientID" />
  584. </Principal>
  585. <Dependent Role="Car">
  586. <PropertyRef Name="IDClient" />
  587. </Dependent>
  588. </ReferentialConstraint>
  589. </Association>
  590. <Association Name="FK_Refueling_Car">
  591. <End Type="gr672_pgvModel.Car" Role="Car" Multiplicity="0..1" />
  592. <End Type="gr672_pgvModel.Refueling" Role="Refueling" Multiplicity="*" />
  593. <ReferentialConstraint>
  594. <Principal Role="Car">
  595. <PropertyRef Name="CarID" />
  596. </Principal>
  597. <Dependent Role="Refueling">
  598. <PropertyRef Name="IDCar" />
  599. </Dependent>
  600. </ReferentialConstraint>
  601. </Association>
  602. <Association Name="FK_Card_CardIssuer">
  603. <End Type="gr672_pgvModel.CardIssuer" Role="CardIssuer" Multiplicity="0..1" />
  604. <End Type="gr672_pgvModel.Card" Role="Card" Multiplicity="*" />
  605. <ReferentialConstraint>
  606. <Principal Role="CardIssuer">
  607. <PropertyRef Name="CardIssuerID" />
  608. </Principal>
  609. <Dependent Role="Card">
  610. <PropertyRef Name="IDCardIssuer" />
  611. </Dependent>
  612. </ReferentialConstraint>
  613. </Association>
  614. <Association Name="FK_Card_CardType">
  615. <End Type="gr672_pgvModel.CardType" Role="CardType" Multiplicity="1" />
  616. <End Type="gr672_pgvModel.Card" Role="Card" Multiplicity="*" />
  617. <ReferentialConstraint>
  618. <Principal Role="CardType">
  619. <PropertyRef Name="CardTypeID" />
  620. </Principal>
  621. <Dependent Role="Card">
  622. <PropertyRef Name="IDCardType" />
  623. </Dependent>
  624. </ReferentialConstraint>
  625. </Association>
  626. <Association Name="FK_Card_Client">
  627. <End Type="gr672_pgvModel.Client" Role="Client" Multiplicity="1" />
  628. <End Type="gr672_pgvModel.Card" Role="Card" Multiplicity="*" />
  629. <ReferentialConstraint>
  630. <Principal Role="Client">
  631. <PropertyRef Name="ClientID" />
  632. </Principal>
  633. <Dependent Role="Card">
  634. <PropertyRef Name="IDHolder" />
  635. </Dependent>
  636. </ReferentialConstraint>
  637. </Association>
  638. <Association Name="FK_Payment_Card">
  639. <End Type="gr672_pgvModel.Card" Role="Card" Multiplicity="1" />
  640. <End Type="gr672_pgvModel.Payment" Role="Payment" Multiplicity="*" />
  641. <ReferentialConstraint>
  642. <Principal Role="Card">
  643. <PropertyRef Name="CardID" />
  644. </Principal>
  645. <Dependent Role="Payment">
  646. <PropertyRef Name="IDCard" />
  647. </Dependent>
  648. </ReferentialConstraint>
  649. </Association>
  650. <Association Name="FK_Refueling_DataOfCamera">
  651. <End Type="gr672_pgvModel.DataOfCamera" Role="DataOfCamera" Multiplicity="0..1" />
  652. <End Type="gr672_pgvModel.Refueling" Role="Refueling" Multiplicity="*" />
  653. <ReferentialConstraint>
  654. <Principal Role="DataOfCamera">
  655. <PropertyRef Name="DataOfCameraID" />
  656. </Principal>
  657. <Dependent Role="Refueling">
  658. <PropertyRef Name="IDDataOfCamera" />
  659. </Dependent>
  660. </ReferentialConstraint>
  661. </Association>
  662. <Association Name="FK_FuelInGasStation_TypeOfFuel">
  663. <End Type="gr672_pgvModel.FuelType" Role="FuelType" Multiplicity="1" />
  664. <End Type="gr672_pgvModel.FuelTypeOnGasStation" Role="FuelTypeOnGasStation" Multiplicity="*" />
  665. <ReferentialConstraint>
  666. <Principal Role="FuelType">
  667. <PropertyRef Name="FuelTypeID" />
  668. </Principal>
  669. <Dependent Role="FuelTypeOnGasStation">
  670. <PropertyRef Name="IDFuelType" />
  671. </Dependent>
  672. </ReferentialConstraint>
  673. </Association>
  674. <Association Name="FK_RefuelingGun_FuelType">
  675. <End Type="gr672_pgvModel.FuelType" Role="FuelType" Multiplicity="1" />
  676. <End Type="gr672_pgvModel.RefuelingGun" Role="RefuelingGun" Multiplicity="*" />
  677. <ReferentialConstraint>
  678. <Principal Role="FuelType">
  679. <PropertyRef Name="FuelTypeID" />
  680. </Principal>
  681. <Dependent Role="RefuelingGun">
  682. <PropertyRef Name="IDFuelType" />
  683. </Dependent>
  684. </ReferentialConstraint>
  685. </Association>
  686. <Association Name="FK_FuelInGasStation_GasStation">
  687. <End Type="gr672_pgvModel.GasStation" Role="GasStation" Multiplicity="1" />
  688. <End Type="gr672_pgvModel.FuelTypeOnGasStation" Role="FuelTypeOnGasStation" Multiplicity="*" />
  689. <ReferentialConstraint>
  690. <Principal Role="GasStation">
  691. <PropertyRef Name="GasStationID" />
  692. </Principal>
  693. <Dependent Role="FuelTypeOnGasStation">
  694. <PropertyRef Name="IDGasStation" />
  695. </Dependent>
  696. </ReferentialConstraint>
  697. </Association>
  698. <Association Name="FK_RefuelingColumn_GasStation">
  699. <End Type="gr672_pgvModel.GasStation" Role="GasStation" Multiplicity="1" />
  700. <End Type="gr672_pgvModel.RefuelingColumn" Role="RefuelingColumn" Multiplicity="*" />
  701. <ReferentialConstraint>
  702. <Principal Role="GasStation">
  703. <PropertyRef Name="GasStationID" />
  704. </Principal>
  705. <Dependent Role="RefuelingColumn">
  706. <PropertyRef Name="IDGasStation" />
  707. </Dependent>
  708. </ReferentialConstraint>
  709. </Association>
  710. <Association Name="FK_Payment_Refueling">
  711. <End Type="gr672_pgvModel.Refueling" Role="Refueling" Multiplicity="1" />
  712. <End Type="gr672_pgvModel.Payment" Role="Payment" Multiplicity="*" />
  713. <ReferentialConstraint>
  714. <Principal Role="Refueling">
  715. <PropertyRef Name="RefuelingID" />
  716. </Principal>
  717. <Dependent Role="Payment">
  718. <PropertyRef Name="IDRefueling" />
  719. </Dependent>
  720. </ReferentialConstraint>
  721. </Association>
  722. <Association Name="FK_Refueling_RefuelingGun">
  723. <End Type="gr672_pgvModel.RefuelingGun" Role="RefuelingGun" Multiplicity="1" />
  724. <End Type="gr672_pgvModel.Refueling" Role="Refueling" Multiplicity="*" />
  725. <ReferentialConstraint>
  726. <Principal Role="RefuelingGun">
  727. <PropertyRef Name="RefuelingGunID" />
  728. </Principal>
  729. <Dependent Role="Refueling">
  730. <PropertyRef Name="IDRefulingGun" />
  731. </Dependent>
  732. </ReferentialConstraint>
  733. </Association>
  734. <Association Name="FK_RefuelingGun_RefuelingColumn">
  735. <End Type="gr672_pgvModel.RefuelingColumn" Role="RefuelingColumn" Multiplicity="1" />
  736. <End Type="gr672_pgvModel.RefuelingGun" Role="RefuelingGun" Multiplicity="*" />
  737. <ReferentialConstraint>
  738. <Principal Role="RefuelingColumn">
  739. <PropertyRef Name="RefuelingColumnID" />
  740. </Principal>
  741. <Dependent Role="RefuelingGun">
  742. <PropertyRef Name="IDRefuelingColumn" />
  743. </Dependent>
  744. </ReferentialConstraint>
  745. </Association>
  746. </Schema>
  747. </edmx:ConceptualModels>
  748. <!-- C-S mapping content -->
  749. <edmx:Mappings>
  750. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  751. <EntityContainerMapping StorageEntityContainer="Хранилище gr672_pgvModelContainer" CdmEntityContainer="gr672_pgvEntities">
  752. <EntitySetMapping Name="Car">
  753. <EntityTypeMapping TypeName="gr672_pgvModel.Car">
  754. <MappingFragment StoreEntitySet="Car">
  755. <ScalarProperty Name="IDClient" ColumnName="IDClient" />
  756. <ScalarProperty Name="VolumeTank" ColumnName="VolumeTank" />
  757. <ScalarProperty Name="CarNumber" ColumnName="CarNumber" />
  758. <ScalarProperty Name="CarID" ColumnName="CarID" />
  759. </MappingFragment>
  760. </EntityTypeMapping>
  761. </EntitySetMapping>
  762. <EntitySetMapping Name="Card">
  763. <EntityTypeMapping TypeName="gr672_pgvModel.Card">
  764. <MappingFragment StoreEntitySet="Card">
  765. <ScalarProperty Name="IDHolder" ColumnName="IDHolder" />
  766. <ScalarProperty Name="IDCardIssuer" ColumnName="IDCardIssuer" />
  767. <ScalarProperty Name="IDCardType" ColumnName="IDCardType" />
  768. <ScalarProperty Name="Balance" ColumnName="Balance" />
  769. <ScalarProperty Name="CardExpDate" ColumnName="CardExpDate" />
  770. <ScalarProperty Name="NumberCard" ColumnName="NumberCard" />
  771. <ScalarProperty Name="CardID" ColumnName="CardID" />
  772. </MappingFragment>
  773. </EntityTypeMapping>
  774. </EntitySetMapping>
  775. <EntitySetMapping Name="CardIssuer">
  776. <EntityTypeMapping TypeName="gr672_pgvModel.CardIssuer">
  777. <MappingFragment StoreEntitySet="CardIssuer">
  778. <ScalarProperty Name="NameCardIssuer" ColumnName="NameCardIssuer" />
  779. <ScalarProperty Name="CardIssuerID" ColumnName="CardIssuerID" />
  780. </MappingFragment>
  781. </EntityTypeMapping>
  782. </EntitySetMapping>
  783. <EntitySetMapping Name="CardType">
  784. <EntityTypeMapping TypeName="gr672_pgvModel.CardType">
  785. <MappingFragment StoreEntitySet="CardType">
  786. <ScalarProperty Name="NameType" ColumnName="NameType" />
  787. <ScalarProperty Name="CardTypeID" ColumnName="CardTypeID" />
  788. </MappingFragment>
  789. </EntityTypeMapping>
  790. </EntitySetMapping>
  791. <EntitySetMapping Name="Client">
  792. <EntityTypeMapping TypeName="gr672_pgvModel.Client">
  793. <MappingFragment StoreEntitySet="Client">
  794. <ScalarProperty Name="Name" ColumnName="Name" />
  795. <ScalarProperty Name="LastName" ColumnName="LastName" />
  796. <ScalarProperty Name="ClientID" ColumnName="ClientID" />
  797. </MappingFragment>
  798. </EntityTypeMapping>
  799. </EntitySetMapping>
  800. <EntitySetMapping Name="DataOfCamera">
  801. <EntityTypeMapping TypeName="gr672_pgvModel.DataOfCamera">
  802. <MappingFragment StoreEntitySet="DataOfCamera">
  803. <ScalarProperty Name="NameImage" ColumnName="NameImage" />
  804. <ScalarProperty Name="CarNumber" ColumnName="CarNumber" />
  805. <ScalarProperty Name="Status" ColumnName="Status" />
  806. <ScalarProperty Name="Date" ColumnName="Date" />
  807. <ScalarProperty Name="DataOfCameraID" ColumnName="DataOfCameraID" />
  808. </MappingFragment>
  809. </EntityTypeMapping>
  810. </EntitySetMapping>
  811. <EntitySetMapping Name="FuelType">
  812. <EntityTypeMapping TypeName="gr672_pgvModel.FuelType">
  813. <MappingFragment StoreEntitySet="FuelType">
  814. <ScalarProperty Name="NameFuelType" ColumnName="NameFuelType" />
  815. <ScalarProperty Name="FuelTypeID" ColumnName="FuelTypeID" />
  816. </MappingFragment>
  817. </EntityTypeMapping>
  818. </EntitySetMapping>
  819. <EntitySetMapping Name="FuelTypeOnGasStation">
  820. <EntityTypeMapping TypeName="gr672_pgvModel.FuelTypeOnGasStation">
  821. <MappingFragment StoreEntitySet="FuelTypeOnGasStation">
  822. <ScalarProperty Name="AmountOfFuel" ColumnName="AmountOfFuel" />
  823. <ScalarProperty Name="Price" ColumnName="Price" />
  824. <ScalarProperty Name="IDFuelType" ColumnName="IDFuelType" />
  825. <ScalarProperty Name="IDGasStation" ColumnName="IDGasStation" />
  826. </MappingFragment>
  827. </EntityTypeMapping>
  828. </EntitySetMapping>
  829. <EntitySetMapping Name="GasStation">
  830. <EntityTypeMapping TypeName="gr672_pgvModel.GasStation">
  831. <MappingFragment StoreEntitySet="GasStation">
  832. <ScalarProperty Name="Address" ColumnName="Address" />
  833. <ScalarProperty Name="GasStationID" ColumnName="GasStationID" />
  834. </MappingFragment>
  835. </EntityTypeMapping>
  836. </EntitySetMapping>
  837. <EntitySetMapping Name="Payment">
  838. <EntityTypeMapping TypeName="gr672_pgvModel.Payment">
  839. <MappingFragment StoreEntitySet="Payment">
  840. <ScalarProperty Name="IDCard" ColumnName="IDCard" />
  841. <ScalarProperty Name="TransactionCode" ColumnName="TransactionCode" />
  842. <ScalarProperty Name="Status" ColumnName="Status" />
  843. <ScalarProperty Name="PriceRefueling" ColumnName="PriceRefueling" />
  844. <ScalarProperty Name="IDRefueling" ColumnName="IDRefueling" />
  845. <ScalarProperty Name="PaymentID" ColumnName="PaymentID" />
  846. </MappingFragment>
  847. </EntityTypeMapping>
  848. </EntitySetMapping>
  849. <EntitySetMapping Name="Refueling">
  850. <EntityTypeMapping TypeName="gr672_pgvModel.Refueling">
  851. <MappingFragment StoreEntitySet="Refueling">
  852. <ScalarProperty Name="IDRefulingGun" ColumnName="IDRefulingGun" />
  853. <ScalarProperty Name="KeySession" ColumnName="KeySession" />
  854. <ScalarProperty Name="IDDataOfCamera" ColumnName="IDDataOfCamera" />
  855. <ScalarProperty Name="VolumeFuel" ColumnName="VolumeFuel" />
  856. <ScalarProperty Name="IDCar" ColumnName="IDCar" />
  857. <ScalarProperty Name="RefuelingID" ColumnName="RefuelingID" />
  858. </MappingFragment>
  859. </EntityTypeMapping>
  860. </EntitySetMapping>
  861. <EntitySetMapping Name="RefuelingColumn">
  862. <EntityTypeMapping TypeName="gr672_pgvModel.RefuelingColumn">
  863. <MappingFragment StoreEntitySet="RefuelingColumn">
  864. <ScalarProperty Name="IDGasStation" ColumnName="IDGasStation" />
  865. <ScalarProperty Name="RefuelingColumnID" ColumnName="RefuelingColumnID" />
  866. </MappingFragment>
  867. </EntityTypeMapping>
  868. </EntitySetMapping>
  869. <EntitySetMapping Name="RefuelingGun">
  870. <EntityTypeMapping TypeName="gr672_pgvModel.RefuelingGun">
  871. <MappingFragment StoreEntitySet="RefuelingGun">
  872. <ScalarProperty Name="IDFuelType" ColumnName="IDFuelType" />
  873. <ScalarProperty Name="IDRefuelingColumn" ColumnName="IDRefuelingColumn" />
  874. <ScalarProperty Name="RefuelingGunID" ColumnName="RefuelingGunID" />
  875. </MappingFragment>
  876. </EntityTypeMapping>
  877. </EntitySetMapping>
  878. </EntityContainerMapping>
  879. </Mapping>
  880. </edmx:Mappings>
  881. </edmx:Runtime>
  882. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  883. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  884. <Connection>
  885. <DesignerInfoPropertySet>
  886. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  887. </DesignerInfoPropertySet>
  888. </Connection>
  889. <Options>
  890. <DesignerInfoPropertySet>
  891. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  892. <DesignerProperty Name="EnablePluralization" Value="false" />
  893. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  894. <DesignerProperty Name="UseLegacyProvider" Value="false" />
  895. <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
  896. </DesignerInfoPropertySet>
  897. </Options>
  898. <!-- Diagram content (shape and connector positions) -->
  899. <Diagrams></Diagrams>
  900. </Designer>
  901. </edmx:Edmx>