20221028054830_202210281348.Designer.cs 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369
  1. // <auto-generated />
  2. using System;
  3. using Microsoft.EntityFrameworkCore;
  4. using Microsoft.EntityFrameworkCore.Infrastructure;
  5. using Microsoft.EntityFrameworkCore.Migrations;
  6. using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
  7. using ProductionLineMonitor.EntityFramework;
  8. namespace ProductionLineMonitor.Web.Migrations
  9. {
  10. [DbContext(typeof(ProductionLineContext))]
  11. [Migration("20221028054830_202210281348")]
  12. partial class _202210281348
  13. {
  14. protected override void BuildTargetModel(ModelBuilder modelBuilder)
  15. {
  16. #pragma warning disable 612, 618
  17. modelBuilder
  18. .HasAnnotation("ProductVersion", "5.0.17");
  19. modelBuilder.Entity("ProductionLineMonitor.Core.Models.Cim", b =>
  20. {
  21. b.Property<string>("Id")
  22. .HasColumnType("TEXT");
  23. b.Property<DateTime?>("CreateTime")
  24. .HasColumnType("TEXT");
  25. b.Property<bool>("EAPIsConnected")
  26. .HasColumnType("INTEGER");
  27. b.Property<string>("IpAddress")
  28. .HasColumnType("TEXT");
  29. b.Property<bool>("IsConnected")
  30. .HasColumnType("INTEGER");
  31. b.Property<bool>("PLCIsConnected")
  32. .HasColumnType("INTEGER");
  33. b.Property<DateTime>("Time")
  34. .HasColumnType("TEXT");
  35. b.Property<string>("Topic")
  36. .HasColumnType("TEXT");
  37. b.Property<DateTime?>("UpdateTime")
  38. .HasColumnType("TEXT");
  39. b.Property<string>("User")
  40. .HasColumnType("TEXT");
  41. b.HasKey("Id");
  42. b.ToTable("Cims");
  43. });
  44. modelBuilder.Entity("ProductionLineMonitor.Core.Models.Machine", b =>
  45. {
  46. b.Property<string>("Id")
  47. .HasColumnType("TEXT");
  48. b.Property<DateTime?>("CreateTime")
  49. .HasColumnType("TEXT");
  50. b.Property<string>("FaultTopic")
  51. .HasColumnType("TEXT");
  52. b.Property<bool?>("IsInclusionLineStatistics")
  53. .HasColumnType("INTEGER");
  54. b.Property<string>("Name")
  55. .HasColumnType("TEXT");
  56. b.Property<string>("ProductionLineId")
  57. .HasColumnType("TEXT");
  58. b.Property<int?>("ProductionLineOrder")
  59. .HasColumnType("INTEGER");
  60. b.Property<string>("Topic")
  61. .HasColumnType("TEXT");
  62. b.Property<string>("Type")
  63. .HasColumnType("TEXT");
  64. b.Property<DateTime?>("UpdateTime")
  65. .HasColumnType("TEXT");
  66. b.HasKey("Id");
  67. b.ToTable("Machines");
  68. });
  69. modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachineFaultComparison", b =>
  70. {
  71. b.Property<string>("Id")
  72. .HasColumnType("TEXT");
  73. b.Property<DateTime?>("CreateTime")
  74. .HasColumnType("TEXT");
  75. b.Property<string>("FaultCategory")
  76. .HasColumnType("TEXT");
  77. b.Property<int?>("FaultCode")
  78. .HasColumnType("INTEGER");
  79. b.Property<string>("FaultInfo")
  80. .HasColumnType("TEXT");
  81. b.Property<int?>("FaultLevel")
  82. .HasColumnType("INTEGER");
  83. b.Property<string>("FaultTopic")
  84. .HasColumnType("TEXT");
  85. b.Property<DateTime?>("UpdateTime")
  86. .HasColumnType("TEXT");
  87. b.HasKey("Id");
  88. b.ToTable("MachineFaultComparisons");
  89. });
  90. modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachineFaultRecord", b =>
  91. {
  92. b.Property<string>("Id")
  93. .HasColumnType("TEXT");
  94. b.Property<DateTime?>("CreateTime")
  95. .HasColumnType("TEXT");
  96. b.Property<DateTime?>("EndTime")
  97. .HasColumnType("TEXT");
  98. b.Property<int?>("FaultCode")
  99. .HasColumnType("INTEGER");
  100. b.Property<string>("MachineId")
  101. .HasColumnType("TEXT");
  102. b.Property<int?>("MachineState")
  103. .HasColumnType("INTEGER");
  104. b.Property<DateTime?>("StartTime")
  105. .HasColumnType("TEXT");
  106. b.Property<int?>("State")
  107. .HasColumnType("INTEGER");
  108. b.Property<int?>("TriggerNumber")
  109. .HasColumnType("INTEGER");
  110. b.Property<DateTime?>("UpdateTime")
  111. .HasColumnType("TEXT");
  112. b.HasKey("Id");
  113. b.ToTable("MachineFaultRecords");
  114. });
  115. modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachineOutPutPerHour", b =>
  116. {
  117. b.Property<string>("Id")
  118. .HasColumnType("TEXT");
  119. b.Property<int?>("ActualTT")
  120. .HasColumnType("INTEGER");
  121. b.Property<int?>("AlarmSum")
  122. .HasColumnType("INTEGER");
  123. b.Property<int?>("AlarmTime")
  124. .HasColumnType("INTEGER");
  125. b.Property<int?>("AutoRunTime")
  126. .HasColumnType("INTEGER");
  127. b.Property<DateTime?>("CreateTime")
  128. .HasColumnType("TEXT");
  129. b.Property<DateTime?>("DataTime")
  130. .HasColumnType("TEXT");
  131. b.Property<int?>("IdleTime")
  132. .HasColumnType("INTEGER");
  133. b.Property<int?>("IdleTimeDownstream")
  134. .HasColumnType("INTEGER");
  135. b.Property<int?>("IdleTimeSelf")
  136. .HasColumnType("INTEGER");
  137. b.Property<int?>("IdleTimeUpstream")
  138. .HasColumnType("INTEGER");
  139. b.Property<int?>("LoadMATSum")
  140. .HasColumnType("INTEGER");
  141. b.Property<int?>("LoadMATTime")
  142. .HasColumnType("INTEGER");
  143. b.Property<string>("MachineId")
  144. .HasColumnType("TEXT");
  145. b.Property<string>("ModuleType")
  146. .HasColumnType("TEXT");
  147. b.Property<int?>("OutPut")
  148. .HasColumnType("INTEGER");
  149. b.Property<float?>("PowerConsumption")
  150. .HasColumnType("REAL");
  151. b.Property<int?>("TargetTT")
  152. .HasColumnType("INTEGER");
  153. b.Property<DateTime?>("UpdateTime")
  154. .HasColumnType("TEXT");
  155. b.HasKey("Id");
  156. b.ToTable("MachineOutPutPerHours");
  157. });
  158. modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachineStatistic", b =>
  159. {
  160. b.Property<string>("Id")
  161. .HasColumnType("TEXT");
  162. b.Property<double?>("Availability")
  163. .HasColumnType("REAL");
  164. b.Property<int?>("Capacity")
  165. .HasColumnType("INTEGER");
  166. b.Property<DateTime?>("CreateTime")
  167. .HasColumnType("TEXT");
  168. b.Property<DateTime>("Date")
  169. .HasColumnType("TEXT");
  170. b.Property<string>("MachineId")
  171. .HasColumnType("TEXT");
  172. b.Property<string>("ModuleType")
  173. .HasColumnType("TEXT");
  174. b.Property<double?>("OEE")
  175. .HasColumnType("REAL");
  176. b.Property<double?>("Performance")
  177. .HasColumnType("REAL");
  178. b.Property<double?>("Quality")
  179. .HasColumnType("REAL");
  180. b.Property<int?>("TT")
  181. .HasColumnType("INTEGER");
  182. b.Property<DateTime?>("UpdateTime")
  183. .HasColumnType("TEXT");
  184. b.HasKey("Id");
  185. b.ToTable("MachineStatistics");
  186. });
  187. modelBuilder.Entity("ProductionLineMonitor.Core.Models.ProductionLine", b =>
  188. {
  189. b.Property<string>("Id")
  190. .HasColumnType("TEXT");
  191. b.Property<DateTime?>("CreateTime")
  192. .HasColumnType("TEXT");
  193. b.Property<string>("Name")
  194. .HasColumnType("TEXT");
  195. b.Property<DateTime?>("UpdateTime")
  196. .HasColumnType("TEXT");
  197. b.HasKey("Id");
  198. b.ToTable("ProductionLines");
  199. });
  200. modelBuilder.Entity("ProductionLineMonitor.Core.Models.Recipe", b =>
  201. {
  202. b.Property<string>("Id")
  203. .HasColumnType("TEXT");
  204. b.Property<DateTime?>("CreateTime")
  205. .HasColumnType("TEXT");
  206. b.Property<string>("ModuleType")
  207. .HasColumnType("TEXT");
  208. b.Property<string>("ProductionLineId")
  209. .HasColumnType("TEXT");
  210. b.Property<int?>("TheoryCapacity")
  211. .HasColumnType("INTEGER");
  212. b.Property<float?>("TheoryTT")
  213. .HasColumnType("REAL");
  214. b.Property<DateTime?>("UpdateTime")
  215. .HasColumnType("TEXT");
  216. b.HasKey("Id");
  217. b.ToTable("Recipes");
  218. });
  219. modelBuilder.Entity("ProductionLineMonitor.Core.Models.Role", b =>
  220. {
  221. b.Property<string>("Id")
  222. .HasColumnType("TEXT");
  223. b.Property<DateTime?>("CreateTime")
  224. .HasColumnType("TEXT");
  225. b.Property<string>("Name")
  226. .HasColumnType("TEXT");
  227. b.Property<string>("Permissions")
  228. .HasColumnType("TEXT");
  229. b.Property<DateTime?>("UpdateTime")
  230. .HasColumnType("TEXT");
  231. b.HasKey("Id");
  232. b.ToTable("Roles");
  233. });
  234. modelBuilder.Entity("ProductionLineMonitor.Core.Models.User", b =>
  235. {
  236. b.Property<string>("Id")
  237. .HasColumnType("TEXT");
  238. b.Property<DateTime?>("CreateTime")
  239. .HasColumnType("TEXT");
  240. b.Property<string>("JobNo")
  241. .HasColumnType("TEXT");
  242. b.Property<string>("Name")
  243. .HasColumnType("TEXT");
  244. b.Property<string>("Password")
  245. .HasColumnType("TEXT");
  246. b.Property<string>("RoleId")
  247. .HasColumnType("TEXT");
  248. b.Property<DateTime?>("UpdateTime")
  249. .HasColumnType("TEXT");
  250. b.HasKey("Id");
  251. b.ToTable("Users");
  252. });
  253. #pragma warning restore 612, 618
  254. }
  255. }
  256. }