Model1.edmx 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454
  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_bdaModel" 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="Eating">
  9. <Key>
  10. <PropertyRef Name="IdEating" />
  11. </Key>
  12. <Property Name="IdEating" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  13. <Property Name="NameEating" Type="nvarchar" MaxLength="50" Nullable="false" />
  14. <Property Name="Price" Type="money" Nullable="false" />
  15. <Property Name="TimeCooking" Type="int" Nullable="false" />
  16. </EntityType>
  17. <EntityType Name="EmployeeCafe">
  18. <Key>
  19. <PropertyRef Name="IdEmployee" />
  20. </Key>
  21. <Property Name="IdEmployee" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  22. <Property Name="Login" Type="nvarchar" MaxLength="50" Nullable="false" />
  23. <Property Name="Password" Type="nvarchar" MaxLength="50" Nullable="false" />
  24. <Property Name="LastName" Type="nvarchar" MaxLength="50" Nullable="false" />
  25. <Property Name="FirstName" Type="nvarchar" MaxLength="50" Nullable="false" />
  26. <Property Name="MiddleName" Type="nvarchar" MaxLength="50" />
  27. <Property Name="StatusEmployeeId" Type="int" />
  28. <Property Name="RoleEmployeeId" Type="int" Nullable="false" />
  29. </EntityType>
  30. <EntityType Name="Order">
  31. <Key>
  32. <PropertyRef Name="IdOrder" />
  33. </Key>
  34. <Property Name="IdOrder" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  35. <Property Name="StatusOrderId" Type="int" Nullable="false" />
  36. <Property Name="DateOrder" Type="datetime" Nullable="false" />
  37. <Property Name="TableId" Type="int" Nullable="false" />
  38. <Property Name="EmployeeId" Type="int" Nullable="false" />
  39. </EntityType>
  40. <EntityType Name="RoleEmployee">
  41. <Key>
  42. <PropertyRef Name="IdRole" />
  43. </Key>
  44. <Property Name="IdRole" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  45. <Property Name="RoleName" Type="nvarchar" MaxLength="50" Nullable="false" />
  46. </EntityType>
  47. <EntityType Name="StatusEmployee">
  48. <Key>
  49. <PropertyRef Name="IdStatusEmployee" />
  50. </Key>
  51. <Property Name="IdStatusEmployee" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  52. <Property Name="NameStatusE" Type="nvarchar" MaxLength="50" Nullable="false" />
  53. </EntityType>
  54. <EntityType Name="StatusOrder">
  55. <Key>
  56. <PropertyRef Name="IdStatusOrder" />
  57. </Key>
  58. <Property Name="IdStatusOrder" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  59. <Property Name="NameStatusO" Type="nvarchar" MaxLength="50" Nullable="false" />
  60. </EntityType>
  61. <EntityType Name="Table">
  62. <Key>
  63. <PropertyRef Name="IdTable" />
  64. </Key>
  65. <Property Name="IdTable" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  66. <Property Name="EatingId" Type="int" Nullable="false" />
  67. <Property Name="NumberTable" Type="int" Nullable="false" />
  68. </EntityType>
  69. <Association Name="FK__EmployeeC__RoleE__0FB750B3">
  70. <End Role="RoleEmployee" Type="Self.RoleEmployee" Multiplicity="1" />
  71. <End Role="EmployeeCafe" Type="Self.EmployeeCafe" Multiplicity="*" />
  72. <ReferentialConstraint>
  73. <Principal Role="RoleEmployee">
  74. <PropertyRef Name="IdRole" />
  75. </Principal>
  76. <Dependent Role="EmployeeCafe">
  77. <PropertyRef Name="RoleEmployeeId" />
  78. </Dependent>
  79. </ReferentialConstraint>
  80. </Association>
  81. <Association Name="FK__EmployeeC__Statu__0EC32C7A">
  82. <End Role="StatusEmployee" Type="Self.StatusEmployee" Multiplicity="0..1" />
  83. <End Role="EmployeeCafe" Type="Self.EmployeeCafe" Multiplicity="*" />
  84. <ReferentialConstraint>
  85. <Principal Role="StatusEmployee">
  86. <PropertyRef Name="IdStatusEmployee" />
  87. </Principal>
  88. <Dependent Role="EmployeeCafe">
  89. <PropertyRef Name="StatusEmployeeId" />
  90. </Dependent>
  91. </ReferentialConstraint>
  92. </Association>
  93. <Association Name="FK__Order__EmployeeI__1EF99443">
  94. <End Role="EmployeeCafe" Type="Self.EmployeeCafe" Multiplicity="1" />
  95. <End Role="Order" Type="Self.Order" Multiplicity="*" />
  96. <ReferentialConstraint>
  97. <Principal Role="EmployeeCafe">
  98. <PropertyRef Name="IdEmployee" />
  99. </Principal>
  100. <Dependent Role="Order">
  101. <PropertyRef Name="EmployeeId" />
  102. </Dependent>
  103. </ReferentialConstraint>
  104. </Association>
  105. <Association Name="FK__Order__StatusOrd__1D114BD1">
  106. <End Role="StatusOrder" Type="Self.StatusOrder" Multiplicity="1" />
  107. <End Role="Order" Type="Self.Order" Multiplicity="*" />
  108. <ReferentialConstraint>
  109. <Principal Role="StatusOrder">
  110. <PropertyRef Name="IdStatusOrder" />
  111. </Principal>
  112. <Dependent Role="Order">
  113. <PropertyRef Name="StatusOrderId" />
  114. </Dependent>
  115. </ReferentialConstraint>
  116. </Association>
  117. <Association Name="FK__Order__TableId__1E05700A">
  118. <End Role="Table" Type="Self.Table" Multiplicity="1" />
  119. <End Role="Order" Type="Self.Order" Multiplicity="*" />
  120. <ReferentialConstraint>
  121. <Principal Role="Table">
  122. <PropertyRef Name="IdTable" />
  123. </Principal>
  124. <Dependent Role="Order">
  125. <PropertyRef Name="TableId" />
  126. </Dependent>
  127. </ReferentialConstraint>
  128. </Association>
  129. <Association Name="FK__Table__EatingId__147C05D0">
  130. <End Role="Eating" Type="Self.Eating" Multiplicity="1" />
  131. <End Role="Table" Type="Self.Table" Multiplicity="*" />
  132. <ReferentialConstraint>
  133. <Principal Role="Eating">
  134. <PropertyRef Name="IdEating" />
  135. </Principal>
  136. <Dependent Role="Table">
  137. <PropertyRef Name="EatingId" />
  138. </Dependent>
  139. </ReferentialConstraint>
  140. </Association>
  141. <EntityContainer Name="Хранилище gr672_bdaModelContainer">
  142. <EntitySet Name="Eating" EntityType="Self.Eating" Schema="dbo" store:Type="Tables" />
  143. <EntitySet Name="EmployeeCafe" EntityType="Self.EmployeeCafe" Schema="dbo" store:Type="Tables" />
  144. <EntitySet Name="Order" EntityType="Self.Order" Schema="dbo" store:Type="Tables" />
  145. <EntitySet Name="RoleEmployee" EntityType="Self.RoleEmployee" Schema="dbo" store:Type="Tables" />
  146. <EntitySet Name="StatusEmployee" EntityType="Self.StatusEmployee" Schema="dbo" store:Type="Tables" />
  147. <EntitySet Name="StatusOrder" EntityType="Self.StatusOrder" Schema="dbo" store:Type="Tables" />
  148. <EntitySet Name="Table" EntityType="Self.Table" Schema="dbo" store:Type="Tables" />
  149. <AssociationSet Name="FK__EmployeeC__RoleE__0FB750B3" Association="Self.FK__EmployeeC__RoleE__0FB750B3">
  150. <End Role="RoleEmployee" EntitySet="RoleEmployee" />
  151. <End Role="EmployeeCafe" EntitySet="EmployeeCafe" />
  152. </AssociationSet>
  153. <AssociationSet Name="FK__EmployeeC__Statu__0EC32C7A" Association="Self.FK__EmployeeC__Statu__0EC32C7A">
  154. <End Role="StatusEmployee" EntitySet="StatusEmployee" />
  155. <End Role="EmployeeCafe" EntitySet="EmployeeCafe" />
  156. </AssociationSet>
  157. <AssociationSet Name="FK__Order__EmployeeI__1EF99443" Association="Self.FK__Order__EmployeeI__1EF99443">
  158. <End Role="EmployeeCafe" EntitySet="EmployeeCafe" />
  159. <End Role="Order" EntitySet="Order" />
  160. </AssociationSet>
  161. <AssociationSet Name="FK__Order__StatusOrd__1D114BD1" Association="Self.FK__Order__StatusOrd__1D114BD1">
  162. <End Role="StatusOrder" EntitySet="StatusOrder" />
  163. <End Role="Order" EntitySet="Order" />
  164. </AssociationSet>
  165. <AssociationSet Name="FK__Order__TableId__1E05700A" Association="Self.FK__Order__TableId__1E05700A">
  166. <End Role="Table" EntitySet="Table" />
  167. <End Role="Order" EntitySet="Order" />
  168. </AssociationSet>
  169. <AssociationSet Name="FK__Table__EatingId__147C05D0" Association="Self.FK__Table__EatingId__147C05D0">
  170. <End Role="Eating" EntitySet="Eating" />
  171. <End Role="Table" EntitySet="Table" />
  172. </AssociationSet>
  173. </EntityContainer>
  174. </Schema>
  175. </edmx:StorageModels>
  176. <!-- CSDL content -->
  177. <edmx:ConceptualModels>
  178. <Schema Namespace="gr672_bdaModel" 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">
  179. <EntityType Name="Eating">
  180. <Key>
  181. <PropertyRef Name="IdEating" />
  182. </Key>
  183. <Property Name="IdEating" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  184. <Property Name="NameEating" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
  185. <Property Name="Price" Type="Decimal" Precision="19" Scale="4" Nullable="false" />
  186. <Property Name="TimeCooking" Type="Int32" Nullable="false" />
  187. <NavigationProperty Name="Table" Relationship="Self.FK__Table__EatingId__147C05D0" FromRole="Eating" ToRole="Table" />
  188. </EntityType>
  189. <EntityType Name="EmployeeCafe">
  190. <Key>
  191. <PropertyRef Name="IdEmployee" />
  192. </Key>
  193. <Property Name="IdEmployee" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  194. <Property Name="Login" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
  195. <Property Name="Password" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
  196. <Property Name="LastName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
  197. <Property Name="FirstName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
  198. <Property Name="MiddleName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
  199. <Property Name="StatusEmployeeId" Type="Int32" />
  200. <Property Name="RoleEmployeeId" Type="Int32" Nullable="false" />
  201. <NavigationProperty Name="RoleEmployee" Relationship="Self.FK__EmployeeC__RoleE__0FB750B3" FromRole="EmployeeCafe" ToRole="RoleEmployee" />
  202. <NavigationProperty Name="StatusEmployee" Relationship="Self.FK__EmployeeC__Statu__0EC32C7A" FromRole="EmployeeCafe" ToRole="StatusEmployee" />
  203. <NavigationProperty Name="Order" Relationship="Self.FK__Order__EmployeeI__1EF99443" FromRole="EmployeeCafe" ToRole="Order" />
  204. </EntityType>
  205. <EntityType Name="Order">
  206. <Key>
  207. <PropertyRef Name="IdOrder" />
  208. </Key>
  209. <Property Name="IdOrder" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  210. <Property Name="StatusOrderId" Type="Int32" Nullable="false" />
  211. <Property Name="DateOrder" Type="DateTime" Nullable="false" Precision="3" />
  212. <Property Name="TableId" Type="Int32" Nullable="false" />
  213. <Property Name="EmployeeId" Type="Int32" Nullable="false" />
  214. <NavigationProperty Name="EmployeeCafe" Relationship="Self.FK__Order__EmployeeI__1EF99443" FromRole="Order" ToRole="EmployeeCafe" />
  215. <NavigationProperty Name="StatusOrder" Relationship="Self.FK__Order__StatusOrd__1D114BD1" FromRole="Order" ToRole="StatusOrder" />
  216. <NavigationProperty Name="Table" Relationship="Self.FK__Order__TableId__1E05700A" FromRole="Order" ToRole="Table" />
  217. </EntityType>
  218. <EntityType Name="RoleEmployee">
  219. <Key>
  220. <PropertyRef Name="IdRole" />
  221. </Key>
  222. <Property Name="IdRole" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  223. <Property Name="RoleName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
  224. <NavigationProperty Name="EmployeeCafe" Relationship="Self.FK__EmployeeC__RoleE__0FB750B3" FromRole="RoleEmployee" ToRole="EmployeeCafe" />
  225. </EntityType>
  226. <EntityType Name="StatusEmployee">
  227. <Key>
  228. <PropertyRef Name="IdStatusEmployee" />
  229. </Key>
  230. <Property Name="IdStatusEmployee" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  231. <Property Name="NameStatusE" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
  232. <NavigationProperty Name="EmployeeCafe" Relationship="Self.FK__EmployeeC__Statu__0EC32C7A" FromRole="StatusEmployee" ToRole="EmployeeCafe" />
  233. </EntityType>
  234. <EntityType Name="StatusOrder">
  235. <Key>
  236. <PropertyRef Name="IdStatusOrder" />
  237. </Key>
  238. <Property Name="IdStatusOrder" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  239. <Property Name="NameStatusO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
  240. <NavigationProperty Name="Order" Relationship="Self.FK__Order__StatusOrd__1D114BD1" FromRole="StatusOrder" ToRole="Order" />
  241. </EntityType>
  242. <EntityType Name="Table">
  243. <Key>
  244. <PropertyRef Name="IdTable" />
  245. </Key>
  246. <Property Name="IdTable" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
  247. <Property Name="EatingId" Type="Int32" Nullable="false" />
  248. <Property Name="NumberTable" Type="Int32" Nullable="false" />
  249. <NavigationProperty Name="Eating" Relationship="Self.FK__Table__EatingId__147C05D0" FromRole="Table" ToRole="Eating" />
  250. <NavigationProperty Name="Order" Relationship="Self.FK__Order__TableId__1E05700A" FromRole="Table" ToRole="Order" />
  251. </EntityType>
  252. <Association Name="FK__Table__EatingId__147C05D0">
  253. <End Role="Eating" Type="Self.Eating" Multiplicity="1" />
  254. <End Role="Table" Type="Self.Table" Multiplicity="*" />
  255. <ReferentialConstraint>
  256. <Principal Role="Eating">
  257. <PropertyRef Name="IdEating" />
  258. </Principal>
  259. <Dependent Role="Table">
  260. <PropertyRef Name="EatingId" />
  261. </Dependent>
  262. </ReferentialConstraint>
  263. </Association>
  264. <Association Name="FK__EmployeeC__RoleE__0FB750B3">
  265. <End Role="RoleEmployee" Type="Self.RoleEmployee" Multiplicity="1" />
  266. <End Role="EmployeeCafe" Type="Self.EmployeeCafe" Multiplicity="*" />
  267. <ReferentialConstraint>
  268. <Principal Role="RoleEmployee">
  269. <PropertyRef Name="IdRole" />
  270. </Principal>
  271. <Dependent Role="EmployeeCafe">
  272. <PropertyRef Name="RoleEmployeeId" />
  273. </Dependent>
  274. </ReferentialConstraint>
  275. </Association>
  276. <Association Name="FK__EmployeeC__Statu__0EC32C7A">
  277. <End Role="StatusEmployee" Type="Self.StatusEmployee" Multiplicity="0..1" />
  278. <End Role="EmployeeCafe" Type="Self.EmployeeCafe" Multiplicity="*" />
  279. <ReferentialConstraint>
  280. <Principal Role="StatusEmployee">
  281. <PropertyRef Name="IdStatusEmployee" />
  282. </Principal>
  283. <Dependent Role="EmployeeCafe">
  284. <PropertyRef Name="StatusEmployeeId" />
  285. </Dependent>
  286. </ReferentialConstraint>
  287. </Association>
  288. <Association Name="FK__Order__EmployeeI__1EF99443">
  289. <End Role="EmployeeCafe" Type="Self.EmployeeCafe" Multiplicity="1" />
  290. <End Role="Order" Type="Self.Order" Multiplicity="*" />
  291. <ReferentialConstraint>
  292. <Principal Role="EmployeeCafe">
  293. <PropertyRef Name="IdEmployee" />
  294. </Principal>
  295. <Dependent Role="Order">
  296. <PropertyRef Name="EmployeeId" />
  297. </Dependent>
  298. </ReferentialConstraint>
  299. </Association>
  300. <Association Name="FK__Order__StatusOrd__1D114BD1">
  301. <End Role="StatusOrder" Type="Self.StatusOrder" Multiplicity="1" />
  302. <End Role="Order" Type="Self.Order" Multiplicity="*" />
  303. <ReferentialConstraint>
  304. <Principal Role="StatusOrder">
  305. <PropertyRef Name="IdStatusOrder" />
  306. </Principal>
  307. <Dependent Role="Order">
  308. <PropertyRef Name="StatusOrderId" />
  309. </Dependent>
  310. </ReferentialConstraint>
  311. </Association>
  312. <Association Name="FK__Order__TableId__1E05700A">
  313. <End Role="Table" Type="Self.Table" Multiplicity="1" />
  314. <End Role="Order" Type="Self.Order" Multiplicity="*" />
  315. <ReferentialConstraint>
  316. <Principal Role="Table">
  317. <PropertyRef Name="IdTable" />
  318. </Principal>
  319. <Dependent Role="Order">
  320. <PropertyRef Name="TableId" />
  321. </Dependent>
  322. </ReferentialConstraint>
  323. </Association>
  324. <EntityContainer Name="gr672_bdaEntities" annotation:LazyLoadingEnabled="true">
  325. <EntitySet Name="Eating" EntityType="Self.Eating" />
  326. <EntitySet Name="EmployeeCafe" EntityType="Self.EmployeeCafe" />
  327. <EntitySet Name="Order" EntityType="Self.Order" />
  328. <EntitySet Name="RoleEmployee" EntityType="Self.RoleEmployee" />
  329. <EntitySet Name="StatusEmployee" EntityType="Self.StatusEmployee" />
  330. <EntitySet Name="StatusOrder" EntityType="Self.StatusOrder" />
  331. <EntitySet Name="Table" EntityType="Self.Table" />
  332. <AssociationSet Name="FK__Table__EatingId__147C05D0" Association="Self.FK__Table__EatingId__147C05D0">
  333. <End Role="Eating" EntitySet="Eating" />
  334. <End Role="Table" EntitySet="Table" />
  335. </AssociationSet>
  336. <AssociationSet Name="FK__EmployeeC__RoleE__0FB750B3" Association="Self.FK__EmployeeC__RoleE__0FB750B3">
  337. <End Role="RoleEmployee" EntitySet="RoleEmployee" />
  338. <End Role="EmployeeCafe" EntitySet="EmployeeCafe" />
  339. </AssociationSet>
  340. <AssociationSet Name="FK__EmployeeC__Statu__0EC32C7A" Association="Self.FK__EmployeeC__Statu__0EC32C7A">
  341. <End Role="StatusEmployee" EntitySet="StatusEmployee" />
  342. <End Role="EmployeeCafe" EntitySet="EmployeeCafe" />
  343. </AssociationSet>
  344. <AssociationSet Name="FK__Order__EmployeeI__1EF99443" Association="Self.FK__Order__EmployeeI__1EF99443">
  345. <End Role="EmployeeCafe" EntitySet="EmployeeCafe" />
  346. <End Role="Order" EntitySet="Order" />
  347. </AssociationSet>
  348. <AssociationSet Name="FK__Order__StatusOrd__1D114BD1" Association="Self.FK__Order__StatusOrd__1D114BD1">
  349. <End Role="StatusOrder" EntitySet="StatusOrder" />
  350. <End Role="Order" EntitySet="Order" />
  351. </AssociationSet>
  352. <AssociationSet Name="FK__Order__TableId__1E05700A" Association="Self.FK__Order__TableId__1E05700A">
  353. <End Role="Table" EntitySet="Table" />
  354. <End Role="Order" EntitySet="Order" />
  355. </AssociationSet>
  356. </EntityContainer>
  357. </Schema>
  358. </edmx:ConceptualModels>
  359. <!-- C-S mapping content -->
  360. <edmx:Mappings>
  361. <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
  362. <EntityContainerMapping StorageEntityContainer="Хранилище gr672_bdaModelContainer" CdmEntityContainer="gr672_bdaEntities">
  363. <EntitySetMapping Name="Eating">
  364. <EntityTypeMapping TypeName="gr672_bdaModel.Eating">
  365. <MappingFragment StoreEntitySet="Eating">
  366. <ScalarProperty Name="IdEating" ColumnName="IdEating" />
  367. <ScalarProperty Name="NameEating" ColumnName="NameEating" />
  368. <ScalarProperty Name="Price" ColumnName="Price" />
  369. <ScalarProperty Name="TimeCooking" ColumnName="TimeCooking" />
  370. </MappingFragment>
  371. </EntityTypeMapping>
  372. </EntitySetMapping>
  373. <EntitySetMapping Name="EmployeeCafe">
  374. <EntityTypeMapping TypeName="gr672_bdaModel.EmployeeCafe">
  375. <MappingFragment StoreEntitySet="EmployeeCafe">
  376. <ScalarProperty Name="IdEmployee" ColumnName="IdEmployee" />
  377. <ScalarProperty Name="Login" ColumnName="Login" />
  378. <ScalarProperty Name="Password" ColumnName="Password" />
  379. <ScalarProperty Name="LastName" ColumnName="LastName" />
  380. <ScalarProperty Name="FirstName" ColumnName="FirstName" />
  381. <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
  382. <ScalarProperty Name="StatusEmployeeId" ColumnName="StatusEmployeeId" />
  383. <ScalarProperty Name="RoleEmployeeId" ColumnName="RoleEmployeeId" />
  384. </MappingFragment>
  385. </EntityTypeMapping>
  386. </EntitySetMapping>
  387. <EntitySetMapping Name="Order">
  388. <EntityTypeMapping TypeName="gr672_bdaModel.Order">
  389. <MappingFragment StoreEntitySet="Order">
  390. <ScalarProperty Name="IdOrder" ColumnName="IdOrder" />
  391. <ScalarProperty Name="StatusOrderId" ColumnName="StatusOrderId" />
  392. <ScalarProperty Name="DateOrder" ColumnName="DateOrder" />
  393. <ScalarProperty Name="TableId" ColumnName="TableId" />
  394. <ScalarProperty Name="EmployeeId" ColumnName="EmployeeId" />
  395. </MappingFragment>
  396. </EntityTypeMapping>
  397. </EntitySetMapping>
  398. <EntitySetMapping Name="RoleEmployee">
  399. <EntityTypeMapping TypeName="gr672_bdaModel.RoleEmployee">
  400. <MappingFragment StoreEntitySet="RoleEmployee">
  401. <ScalarProperty Name="IdRole" ColumnName="IdRole" />
  402. <ScalarProperty Name="RoleName" ColumnName="RoleName" />
  403. </MappingFragment>
  404. </EntityTypeMapping>
  405. </EntitySetMapping>
  406. <EntitySetMapping Name="StatusEmployee">
  407. <EntityTypeMapping TypeName="gr672_bdaModel.StatusEmployee">
  408. <MappingFragment StoreEntitySet="StatusEmployee">
  409. <ScalarProperty Name="IdStatusEmployee" ColumnName="IdStatusEmployee" />
  410. <ScalarProperty Name="NameStatusE" ColumnName="NameStatusE" />
  411. </MappingFragment>
  412. </EntityTypeMapping>
  413. </EntitySetMapping>
  414. <EntitySetMapping Name="StatusOrder">
  415. <EntityTypeMapping TypeName="gr672_bdaModel.StatusOrder">
  416. <MappingFragment StoreEntitySet="StatusOrder">
  417. <ScalarProperty Name="IdStatusOrder" ColumnName="IdStatusOrder" />
  418. <ScalarProperty Name="NameStatusO" ColumnName="NameStatusO" />
  419. </MappingFragment>
  420. </EntityTypeMapping>
  421. </EntitySetMapping>
  422. <EntitySetMapping Name="Table">
  423. <EntityTypeMapping TypeName="gr672_bdaModel.Table">
  424. <MappingFragment StoreEntitySet="Table">
  425. <ScalarProperty Name="IdTable" ColumnName="IdTable" />
  426. <ScalarProperty Name="EatingId" ColumnName="EatingId" />
  427. <ScalarProperty Name="NumberTable" ColumnName="NumberTable" />
  428. </MappingFragment>
  429. </EntityTypeMapping>
  430. </EntitySetMapping>
  431. </EntityContainerMapping>
  432. </Mapping>
  433. </edmx:Mappings>
  434. </edmx:Runtime>
  435. <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  436. <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
  437. <Connection>
  438. <DesignerInfoPropertySet>
  439. <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
  440. </DesignerInfoPropertySet>
  441. </Connection>
  442. <Options>
  443. <DesignerInfoPropertySet>
  444. <DesignerProperty Name="ValidateOnBuild" Value="true" />
  445. <DesignerProperty Name="EnablePluralization" Value="false" />
  446. <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
  447. <DesignerProperty Name="UseLegacyProvider" Value="false" />
  448. <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
  449. </DesignerInfoPropertySet>
  450. </Options>
  451. <!-- Diagram content (shape and connector positions) -->
  452. <Diagrams></Diagrams>
  453. </Designer>
  454. </edmx:Edmx>