20231019090908_RemoveUpdatetest.Designer.cs 39 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074
  1. // <auto-generated />
  2. using System;
  3. using EVCB_OCPP.Domain;
  4. using Microsoft.EntityFrameworkCore;
  5. using Microsoft.EntityFrameworkCore.Infrastructure;
  6. using Microsoft.EntityFrameworkCore.Metadata;
  7. using Microsoft.EntityFrameworkCore.Migrations;
  8. using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
  9. #nullable disable
  10. namespace EVCB_OCPP.Domain.Migrations
  11. {
  12. [DbContext(typeof(MainDBContext))]
  13. [Migration("20231019090908_RemoveUpdatetest")]
  14. partial class RemoveUpdatetest
  15. {
  16. /// <inheritdoc />
  17. protected override void BuildTargetModel(ModelBuilder modelBuilder)
  18. {
  19. #pragma warning disable 612, 618
  20. modelBuilder
  21. .UseCollation("Chinese_Taiwan_Stroke_CI_AS")
  22. .HasAnnotation("ProductVersion", "7.0.12")
  23. .HasAnnotation("Relational:MaxIdentifierLength", 128);
  24. SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder);
  25. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.ConnectorMeterValueRecord", b =>
  26. {
  27. b.Property<long>("Id")
  28. .ValueGeneratedOnAdd()
  29. .HasColumnType("bigint");
  30. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  31. b.Property<string>("ChargeBoxId")
  32. .HasMaxLength(50)
  33. .HasColumnType("nvarchar(50)");
  34. b.Property<byte>("ConnectorId")
  35. .HasColumnType("tinyint");
  36. b.Property<int>("ContextId")
  37. .HasColumnType("int");
  38. b.Property<DateTime>("CreatedOn")
  39. .HasColumnType("datetime");
  40. b.Property<int>("FormatId")
  41. .HasColumnType("int");
  42. b.Property<int>("LocationId")
  43. .HasColumnType("int");
  44. b.Property<int>("MeasurandId")
  45. .HasColumnType("int");
  46. b.Property<int>("PhaseId")
  47. .HasColumnType("int");
  48. b.Property<int>("TransactionId")
  49. .HasColumnType("int");
  50. b.Property<int>("UnitId")
  51. .HasColumnType("int");
  52. b.Property<string>("Value")
  53. .HasMaxLength(10)
  54. .HasColumnType("nvarchar(10)");
  55. b.HasKey("Id")
  56. .HasName("PK_dbo.ConnectorMeterValueRecord");
  57. b.ToTable("ConnectorMeterValueRecord", (string)null);
  58. });
  59. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.ConnectorStatus", b =>
  60. {
  61. b.Property<string>("Id")
  62. .HasMaxLength(36)
  63. .HasColumnType("nvarchar(36)");
  64. b.Property<string>("ChargeBoxId")
  65. .HasMaxLength(50)
  66. .HasColumnType("nvarchar(50)");
  67. b.Property<int>("ChargePointErrorCodeId")
  68. .HasColumnType("int");
  69. b.Property<byte>("ConnectorId")
  70. .HasColumnType("tinyint");
  71. b.Property<DateTime>("CreatedOn")
  72. .HasColumnType("datetime");
  73. b.Property<string>("ErrorInfo")
  74. .HasMaxLength(50)
  75. .HasColumnType("nvarchar(50)");
  76. b.Property<int>("Status")
  77. .HasColumnType("int");
  78. b.Property<decimal>("TotalEnergy")
  79. .HasColumnType("decimal(10, 2)");
  80. b.Property<int>("Type")
  81. .HasColumnType("int");
  82. b.Property<string>("VendorErrorCode")
  83. .HasMaxLength(100)
  84. .HasColumnType("nvarchar(100)");
  85. b.Property<string>("VendorId")
  86. .HasMaxLength(255)
  87. .HasColumnType("nvarchar(255)");
  88. b.HasKey("Id")
  89. .HasName("PK_dbo.ConnectorStatus");
  90. b.HasIndex(new[] { "ChargeBoxId", "ConnectorId" }, "IX_ConnectorStatus")
  91. .IsUnique()
  92. .HasFilter("[ChargeBoxId] IS NOT NULL");
  93. b.ToTable("ConnectorStatus", (string)null);
  94. });
  95. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.Customer", b =>
  96. {
  97. b.Property<Guid>("Id")
  98. .HasColumnType("uniqueidentifier");
  99. b.Property<string>("ApiCustomerId")
  100. .HasMaxLength(36)
  101. .HasColumnType("nvarchar(36)");
  102. b.Property<string>("ApiKey")
  103. .HasMaxLength(128)
  104. .HasColumnType("nvarchar(128)");
  105. b.Property<DateTime?>("ApiKeyUpdatedOn")
  106. .HasColumnType("datetime");
  107. b.Property<string>("ApiUrl")
  108. .HasMaxLength(256)
  109. .HasColumnType("nvarchar(256)");
  110. b.Property<bool>("CallPartnerApiOnSchedule")
  111. .HasColumnType("bit");
  112. b.Property<string>("CreatedBy")
  113. .HasMaxLength(50)
  114. .HasColumnType("nvarchar(50)");
  115. b.Property<DateTime>("CreatedOn")
  116. .HasColumnType("datetime");
  117. b.Property<DateTime?>("Deadline")
  118. .HasColumnType("datetime");
  119. b.Property<bool>("EnableTtia")
  120. .HasColumnType("bit")
  121. .HasColumnName("EnableTTIA");
  122. b.Property<string>("Ftphost")
  123. .HasMaxLength(50)
  124. .HasColumnType("nvarchar(50)")
  125. .HasColumnName("FTPHost");
  126. b.Property<string>("Ftppassword")
  127. .HasMaxLength(20)
  128. .HasColumnType("nvarchar(20)")
  129. .HasColumnName("FTPPassword");
  130. b.Property<string>("Ftppath")
  131. .HasColumnType("nvarchar(max)")
  132. .HasColumnName("FTPPath");
  133. b.Property<string>("Ftpuser")
  134. .HasMaxLength(20)
  135. .HasColumnType("nvarchar(20)")
  136. .HasColumnName("FTPUser");
  137. b.Property<bool>("InstantStopTxReport")
  138. .HasColumnType("bit");
  139. b.Property<bool>("IsShow")
  140. .HasColumnType("bit");
  141. b.Property<string>("Name")
  142. .HasMaxLength(50)
  143. .HasColumnType("nvarchar(50)");
  144. b.Property<string>("PartnerId")
  145. .HasMaxLength(36)
  146. .HasColumnType("nvarchar(36)");
  147. b.Property<string>("TtiaApikey")
  148. .HasMaxLength(10)
  149. .HasColumnType("nvarchar(10)")
  150. .HasColumnName("TTIA_APIKey");
  151. b.Property<string>("TtiaApiurl")
  152. .HasMaxLength(100)
  153. .HasColumnType("nvarchar(100)")
  154. .HasColumnName("TTIA_APIUrl");
  155. b.Property<int>("TtiaCustomerId")
  156. .HasColumnType("int")
  157. .HasColumnName("TTIA_CustomerId");
  158. b.Property<string>("TtiaEquipmentProvider")
  159. .HasMaxLength(10)
  160. .HasColumnType("nvarchar(10)")
  161. .HasColumnName("TTIA_EquipmentProvider");
  162. b.Property<string>("UpdatedBy")
  163. .HasMaxLength(50)
  164. .HasColumnType("nvarchar(50)");
  165. b.Property<DateTime?>("UpdatedOn")
  166. .HasColumnType("datetime");
  167. b.HasKey("Id")
  168. .HasName("PK_dbo.Customer");
  169. b.ToTable("Customer", (string)null);
  170. });
  171. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.LoadingBalance", b =>
  172. {
  173. b.Property<long>("Id")
  174. .ValueGeneratedOnAdd()
  175. .HasColumnType("bigint");
  176. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  177. b.Property<DateTime>("CreatedOn")
  178. .HasColumnType("datetime");
  179. b.Property<DateTime>("FinishedOn")
  180. .HasColumnType("datetime");
  181. b.Property<string>("MachineId")
  182. .IsRequired()
  183. .HasMaxLength(36)
  184. .HasColumnType("nvarchar(36)");
  185. b.Property<decimal>("Power")
  186. .HasColumnType("decimal(10, 2)");
  187. b.Property<int>("StationId")
  188. .HasColumnType("int");
  189. b.HasKey("Id");
  190. b.ToTable("LoadingBalance", (string)null);
  191. });
  192. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.Machine", b =>
  193. {
  194. b.Property<string>("Id")
  195. .HasMaxLength(36)
  196. .HasColumnType("nvarchar(36)");
  197. b.Property<string>("BoardVersions")
  198. .HasColumnType("nvarchar(max)");
  199. b.Property<string>("ChargeBoxId")
  200. .HasMaxLength(50)
  201. .HasColumnType("nvarchar(50)");
  202. b.Property<string>("ChargeBoxSerialNumber")
  203. .HasMaxLength(25)
  204. .HasColumnType("nvarchar(25)");
  205. b.Property<string>("ChargePointModel")
  206. .HasMaxLength(20)
  207. .HasColumnType("nvarchar(20)");
  208. b.Property<string>("ChargePointSerialNumber")
  209. .HasMaxLength(25)
  210. .HasColumnType("nvarchar(25)");
  211. b.Property<string>("ChargePointVendor")
  212. .HasMaxLength(20)
  213. .HasColumnType("nvarchar(20)");
  214. b.Property<string>("Comment")
  215. .HasMaxLength(100)
  216. .HasColumnType("nvarchar(100)");
  217. b.Property<int>("ConnectionType")
  218. .HasColumnType("int");
  219. b.Property<string>("ConnectorPowerType")
  220. .HasMaxLength(50)
  221. .HasColumnType("nvarchar(50)");
  222. b.Property<string>("ConnectorType")
  223. .HasMaxLength(50)
  224. .HasColumnType("nvarchar(50)");
  225. b.Property<string>("CreatedBy")
  226. .HasMaxLength(50)
  227. .HasColumnType("nvarchar(50)");
  228. b.Property<DateTime>("CreatedOn")
  229. .HasColumnType("datetime");
  230. b.Property<Guid>("CustomerId")
  231. .HasColumnType("uniqueidentifier");
  232. b.Property<int?>("FwAssignedVersion")
  233. .HasColumnType("int")
  234. .HasColumnName("FW_AssignedVersion");
  235. b.Property<string>("FwCurrentVersion")
  236. .HasMaxLength(50)
  237. .HasColumnType("nvarchar(50)")
  238. .HasColumnName("FW_CurrentVersion");
  239. b.Property<int?>("FwVersionReport")
  240. .HasColumnType("int")
  241. .HasColumnName("FW_VersionReport");
  242. b.Property<int>("GunAmt")
  243. .HasColumnType("int");
  244. b.Property<DateTime>("HeartbeatUpdatedOn")
  245. .HasColumnType("datetime");
  246. b.Property<string>("Iccid")
  247. .HasMaxLength(20)
  248. .HasColumnType("nvarchar(20)");
  249. b.Property<string>("Imsi")
  250. .HasMaxLength(20)
  251. .HasColumnType("nvarchar(20)");
  252. b.Property<bool>("IsDelete")
  253. .HasColumnType("bit");
  254. b.Property<decimal>("Latitude")
  255. .HasColumnType("decimal(10, 6)");
  256. b.Property<decimal>("Longitude")
  257. .HasColumnType("decimal(10, 6)");
  258. b.Property<string>("MeterSerialNumber")
  259. .HasMaxLength(25)
  260. .HasColumnType("nvarchar(25)");
  261. b.Property<string>("MeterType")
  262. .HasMaxLength(25)
  263. .HasColumnType("nvarchar(25)");
  264. b.Property<string>("ModelName")
  265. .IsRequired()
  266. .ValueGeneratedOnAdd()
  267. .HasMaxLength(50)
  268. .HasColumnType("nvarchar(50)")
  269. .HasDefaultValueSql("('')");
  270. b.Property<DateTime?>("OfflineOn")
  271. .HasColumnType("datetime");
  272. b.Property<bool>("Online")
  273. .HasColumnType("bit");
  274. b.Property<decimal>("RatedPower")
  275. .HasColumnType("decimal(6, 2)");
  276. b.Property<int>("Ttiatag")
  277. .HasColumnType("int")
  278. .HasColumnName("TTIATag");
  279. b.Property<string>("VendorId")
  280. .ValueGeneratedOnAdd()
  281. .HasMaxLength(50)
  282. .HasColumnType("nvarchar(50)")
  283. .HasDefaultValueSql("('Zerova')");
  284. b.HasKey("Id")
  285. .HasName("PK_dbo.Machine");
  286. b.HasIndex(new[] { "CustomerId", "ChargeBoxId" }, "nci_wi_Machine_7CD4A9D1688F96F6967B2244A0666F62");
  287. b.ToTable("Machine", (string)null);
  288. });
  289. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.MachineConfiguration", b =>
  290. {
  291. b.Property<string>("ConfigureName")
  292. .HasMaxLength(50)
  293. .HasColumnType("nvarchar(50)");
  294. b.Property<string>("ChargeBoxId")
  295. .HasMaxLength(50)
  296. .HasColumnType("nvarchar(50)");
  297. b.Property<string>("ConfigureSetting")
  298. .HasMaxLength(500)
  299. .HasColumnType("nvarchar(500)");
  300. b.Property<bool>("Exists")
  301. .HasColumnType("bit");
  302. b.Property<int>("Id")
  303. .ValueGeneratedOnAdd()
  304. .HasColumnType("int");
  305. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  306. b.Property<bool>("ReadOnly")
  307. .HasColumnType("bit");
  308. b.HasKey("ConfigureName", "ChargeBoxId")
  309. .HasName("PK_dbo.MachineConfigurations");
  310. b.HasIndex(new[] { "ConfigureName", "ConfigureSetting" }, "nci_wi_MachineConfigurations_132E765C043BF95A2570D2EA019DD783");
  311. b.ToTable("MachineConfigurations");
  312. });
  313. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.MachineError", b =>
  314. {
  315. b.Property<int>("Id")
  316. .ValueGeneratedOnAdd()
  317. .HasColumnType("int");
  318. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  319. b.Property<string>("ChargeBoxId")
  320. .HasMaxLength(50)
  321. .HasColumnType("nvarchar(50)");
  322. b.Property<byte>("ConnectorId")
  323. .HasColumnType("tinyint");
  324. b.Property<DateTime>("CreatedOn")
  325. .HasColumnType("datetime");
  326. b.Property<int>("ErrorCodeId")
  327. .HasColumnType("int");
  328. b.Property<string>("ErrorInfo")
  329. .HasMaxLength(50)
  330. .HasColumnType("nvarchar(50)");
  331. b.Property<int>("PreStatus")
  332. .HasColumnType("int");
  333. b.Property<int>("Status")
  334. .HasColumnType("int");
  335. b.Property<string>("VendorErrorCode")
  336. .HasMaxLength(100)
  337. .HasColumnType("nvarchar(100)");
  338. b.Property<string>("VendorId")
  339. .HasMaxLength(255)
  340. .HasColumnType("nvarchar(255)");
  341. b.HasKey("Id")
  342. .HasName("PK_dbo.MachineError");
  343. b.ToTable("MachineError", (string)null);
  344. });
  345. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.MachineOperateRecord", b =>
  346. {
  347. b.Property<int>("Id")
  348. .ValueGeneratedOnAdd()
  349. .HasColumnType("int");
  350. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  351. b.Property<string>("Action")
  352. .HasMaxLength(30)
  353. .HasColumnType("nvarchar(30)");
  354. b.Property<string>("ChargeBoxId")
  355. .HasMaxLength(50)
  356. .HasColumnType("nvarchar(50)");
  357. b.Property<DateTime>("CreatedOn")
  358. .HasColumnType("datetime");
  359. b.Property<int>("EvseStatus")
  360. .HasColumnType("int")
  361. .HasColumnName("EVSE_Status");
  362. b.Property<string>("EvseValue")
  363. .HasColumnType("nvarchar(max)")
  364. .HasColumnName("EVSE_Value");
  365. b.Property<DateTime>("FinishedOn")
  366. .HasColumnType("datetime");
  367. b.Property<DateTime>("ReportedOn")
  368. .HasColumnType("datetime");
  369. b.Property<string>("RequestContent")
  370. .HasColumnType("nvarchar(max)");
  371. b.Property<int>("RequestType")
  372. .HasColumnType("int");
  373. b.Property<string>("SerialNo")
  374. .HasMaxLength(36)
  375. .HasColumnType("nvarchar(36)");
  376. b.Property<int>("Status")
  377. .HasColumnType("int");
  378. b.HasKey("Id")
  379. .HasName("PK_dbo.MachineOperateRecord");
  380. b.ToTable("MachineOperateRecord", (string)null);
  381. });
  382. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.MachineVersionFile", b =>
  383. {
  384. b.Property<int>("Id")
  385. .ValueGeneratedOnAdd()
  386. .HasColumnType("int");
  387. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  388. b.Property<string>("ChargeBoxId")
  389. .HasMaxLength(50)
  390. .HasColumnType("nvarchar(50)");
  391. b.Property<DateTime>("CreatedOn")
  392. .HasColumnType("datetime");
  393. b.Property<int>("Seq")
  394. .HasColumnType("int");
  395. b.Property<string>("UploadFileId")
  396. .IsRequired()
  397. .HasMaxLength(36)
  398. .HasColumnType("nvarchar(36)");
  399. b.HasKey("Id")
  400. .HasName("PK_dbo.MachineVersionFile");
  401. b.HasIndex("UploadFileId");
  402. b.ToTable("MachineVersionFile", (string)null);
  403. });
  404. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.MigrationHistory", b =>
  405. {
  406. b.Property<string>("MigrationId")
  407. .HasMaxLength(150)
  408. .HasColumnType("nvarchar(150)");
  409. b.Property<string>("ContextKey")
  410. .HasMaxLength(300)
  411. .HasColumnType("nvarchar(300)");
  412. b.Property<byte[]>("Model")
  413. .IsRequired()
  414. .HasColumnType("varbinary(max)");
  415. b.Property<string>("ProductVersion")
  416. .IsRequired()
  417. .HasMaxLength(32)
  418. .HasColumnType("nvarchar(32)");
  419. b.HasKey("MigrationId", "ContextKey")
  420. .HasName("PK_dbo.__MigrationHistory");
  421. b.ToTable("__MigrationHistory", (string)null);
  422. });
  423. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.Ocmf", b =>
  424. {
  425. b.Property<int>("Id")
  426. .ValueGeneratedOnAdd()
  427. .HasColumnType("int");
  428. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  429. b.Property<string>("DataString")
  430. .HasMaxLength(2048)
  431. .HasColumnType("nvarchar(2048)");
  432. b.Property<string>("PublicKey")
  433. .HasMaxLength(256)
  434. .HasColumnType("nvarchar(256)");
  435. b.Property<int>("TransactionId")
  436. .HasColumnType("int");
  437. b.HasKey("Id")
  438. .HasName("PK_dbo.OCMF");
  439. b.ToTable("OCMF", (string)null);
  440. });
  441. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.ServerMessage", b =>
  442. {
  443. b.Property<int>("Id")
  444. .ValueGeneratedOnAdd()
  445. .HasColumnType("int");
  446. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  447. b.Property<string>("ChargeBoxId")
  448. .HasMaxLength(50)
  449. .HasColumnType("nvarchar(50)");
  450. b.Property<string>("CreatedBy")
  451. .HasMaxLength(36)
  452. .HasColumnType("nvarchar(36)");
  453. b.Property<DateTime>("CreatedOn")
  454. .HasColumnType("datetime");
  455. b.Property<string>("InMessage")
  456. .HasColumnType("nvarchar(max)");
  457. b.Property<string>("OutAction")
  458. .HasMaxLength(30)
  459. .HasColumnType("nvarchar(30)");
  460. b.Property<string>("OutRequest")
  461. .HasColumnType("nvarchar(max)");
  462. b.Property<DateTime>("ReceivedOn")
  463. .HasColumnType("datetime");
  464. b.Property<string>("SerialNo")
  465. .HasMaxLength(36)
  466. .HasColumnType("nvarchar(36)");
  467. b.Property<DateTime>("UpdatedOn")
  468. .HasColumnType("datetime");
  469. b.HasKey("Id")
  470. .HasName("PK_dbo.ServerMessage");
  471. b.HasIndex(new[] { "ReceivedOn", "UpdatedOn", "CreatedOn" }, "nci_wi_ServerMessage_EC00C205420F6CB01974705B93F9507F");
  472. b.ToTable("ServerMessage", (string)null);
  473. });
  474. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.TransactionRecord", b =>
  475. {
  476. b.Property<int>("Id")
  477. .ValueGeneratedOnAdd()
  478. .HasColumnType("int");
  479. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  480. b.Property<bool>("BillingDone")
  481. .HasColumnType("bit");
  482. b.Property<string>("ChargeBoxId")
  483. .IsRequired()
  484. .HasMaxLength(50)
  485. .HasColumnType("nvarchar(50)");
  486. b.Property<byte>("ConnectorId")
  487. .HasColumnType("tinyint");
  488. b.Property<decimal>("Cost")
  489. .HasColumnType("decimal(18, 2)");
  490. b.Property<DateTime>("CreatedOn")
  491. .HasColumnType("datetime");
  492. b.Property<Guid>("CustomerId")
  493. .HasColumnType("uniqueidentifier");
  494. b.Property<string>("ErrorMsg")
  495. .HasColumnType("nvarchar(max)");
  496. b.Property<string>("Evccid")
  497. .HasMaxLength(30)
  498. .HasColumnType("nvarchar(30)")
  499. .HasColumnName("EVCCID");
  500. b.Property<string>("Fee")
  501. .HasMaxLength(1500)
  502. .HasColumnType("nvarchar(1500)");
  503. b.Property<decimal>("MeterStart")
  504. .HasColumnType("decimal(18, 2)");
  505. b.Property<decimal>("MeterStop")
  506. .HasColumnType("decimal(18, 2)");
  507. b.Property<bool>("NotifyPnC")
  508. .HasColumnType("bit");
  509. b.Property<string>("Receipt")
  510. .HasMaxLength(3000)
  511. .HasColumnType("nvarchar(3000)");
  512. b.Property<int>("ReservationId")
  513. .HasColumnType("int");
  514. b.Property<int>("RetryStartTransactionTimes")
  515. .HasColumnType("int");
  516. b.Property<int>("RetryStopTransactionTimes")
  517. .HasColumnType("int");
  518. b.Property<string>("StartIdTag")
  519. .HasMaxLength(20)
  520. .HasColumnType("nvarchar(20)");
  521. b.Property<string>("StartSoc")
  522. .HasMaxLength(3)
  523. .HasColumnType("nvarchar(3)")
  524. .HasColumnName("StartSOC");
  525. b.Property<DateTime>("StartTime")
  526. .HasColumnType("datetime");
  527. b.Property<DateTime>("StartTransactionReportedOn")
  528. .HasColumnType("datetime");
  529. b.Property<string>("StopIdTag")
  530. .HasMaxLength(20)
  531. .HasColumnType("nvarchar(20)");
  532. b.Property<string>("StopReason")
  533. .HasMaxLength(60)
  534. .HasColumnType("nvarchar(60)");
  535. b.Property<int>("StopReasonId")
  536. .HasColumnType("int");
  537. b.Property<string>("StopSoc")
  538. .HasMaxLength(3)
  539. .HasColumnType("nvarchar(3)")
  540. .HasColumnName("StopSOC");
  541. b.Property<DateTime>("StopTime")
  542. .HasColumnType("datetime");
  543. b.Property<DateTime>("StopTransactionReportedOn")
  544. .HasColumnType("datetime");
  545. b.Property<DateTime>("UpdatedOn")
  546. .HasColumnType("datetime");
  547. b.Property<bool>("UploadedtoTtia")
  548. .HasColumnType("bit")
  549. .HasColumnName("UploadedtoTTIA");
  550. b.HasKey("Id")
  551. .HasName("PK_dbo.TransactionRecord");
  552. b.HasIndex(new[] { "CustomerId", "ConnectorId", "StartTime", "ChargeBoxId" }, "IX_TransactionRecord_StartTime");
  553. b.HasIndex(new[] { "CustomerId", "StopTransactionReportedOn", "StopTime" }, "nci_wi_TransactionRecord_92D4DF08E7034102014AC91760F890FE");
  554. b.ToTable("TransactionRecord", (string)null);
  555. });
  556. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.UploadFile", b =>
  557. {
  558. b.Property<string>("Id")
  559. .HasMaxLength(36)
  560. .HasColumnType("nvarchar(36)");
  561. b.Property<string>("CreatedBy")
  562. .HasMaxLength(50)
  563. .HasColumnType("nvarchar(50)");
  564. b.Property<DateTime>("CreatedOn")
  565. .HasColumnType("datetime");
  566. b.Property<string>("FileExtensionName")
  567. .HasMaxLength(50)
  568. .HasColumnType("nvarchar(50)");
  569. b.Property<string>("FileMd5")
  570. .HasMaxLength(50)
  571. .HasColumnType("nvarchar(50)")
  572. .HasColumnName("FileMD5");
  573. b.Property<string>("FileName")
  574. .IsRequired()
  575. .HasMaxLength(500)
  576. .HasColumnType("nvarchar(500)");
  577. b.Property<string>("FilePath")
  578. .IsRequired()
  579. .HasMaxLength(500)
  580. .HasColumnType("nvarchar(500)");
  581. b.Property<int>("FileSize")
  582. .HasColumnType("int");
  583. b.Property<string>("FileType")
  584. .HasMaxLength(200)
  585. .HasColumnType("nvarchar(200)");
  586. b.Property<string>("FileUrl")
  587. .HasMaxLength(512)
  588. .HasColumnType("nvarchar(512)");
  589. b.Property<string>("ModelName")
  590. .IsRequired()
  591. .HasMaxLength(50)
  592. .HasColumnType("nvarchar(50)");
  593. b.Property<int>("ModuleId")
  594. .HasColumnType("int");
  595. b.Property<string>("OriginName")
  596. .IsRequired()
  597. .HasMaxLength(500)
  598. .HasColumnType("nvarchar(500)");
  599. b.Property<string>("VendorId")
  600. .IsRequired()
  601. .HasMaxLength(50)
  602. .HasColumnType("nvarchar(50)");
  603. b.HasKey("Id")
  604. .HasName("PK_dbo.UploadFile");
  605. b.ToTable("UploadFile", (string)null);
  606. });
  607. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.VConnectorStatus", b =>
  608. {
  609. b.Property<string>("ChargeBoxId")
  610. .HasMaxLength(50)
  611. .HasColumnType("nvarchar(50)");
  612. b.Property<int>("ChargePointErrorCodeId")
  613. .HasColumnType("int");
  614. b.Property<byte>("ConnectorId")
  615. .HasColumnType("tinyint");
  616. b.Property<DateTime>("CreatedOn")
  617. .HasColumnType("datetime");
  618. b.Property<string>("ErrorInfo")
  619. .HasMaxLength(50)
  620. .HasColumnType("nvarchar(50)");
  621. b.Property<string>("Id")
  622. .IsRequired()
  623. .HasMaxLength(36)
  624. .HasColumnType("nvarchar(36)");
  625. b.Property<int>("Status")
  626. .HasColumnType("int");
  627. b.Property<decimal>("TotalEnergy")
  628. .HasColumnType("decimal(10, 2)");
  629. b.Property<int>("Type")
  630. .HasColumnType("int");
  631. b.Property<string>("VendorErrorCode")
  632. .HasMaxLength(100)
  633. .HasColumnType("nvarchar(100)");
  634. b.Property<string>("VendorId")
  635. .HasMaxLength(255)
  636. .HasColumnType("nvarchar(255)");
  637. b.ToTable((string)null);
  638. b.ToView("vConnectorStatus", (string)null);
  639. });
  640. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.VConnectorStatusCombind", b =>
  641. {
  642. b.Property<string>("ChargeBoxId")
  643. .HasMaxLength(50)
  644. .HasColumnType("nvarchar(50)");
  645. b.Property<int>("ChargePointErrorCodeId")
  646. .HasColumnType("int");
  647. b.Property<byte>("ConnectorId")
  648. .HasColumnType("tinyint");
  649. b.Property<string>("Ocpp")
  650. .IsRequired()
  651. .HasMaxLength(3)
  652. .IsUnicode(false)
  653. .HasColumnType("varchar(3)")
  654. .HasColumnName("OCPP");
  655. b.Property<int>("Status")
  656. .HasColumnType("int");
  657. b.Property<decimal>("TotalEnergy")
  658. .HasColumnType("decimal(10, 2)");
  659. b.Property<int>("Type")
  660. .HasColumnType("int");
  661. b.Property<string>("VendorErrorCode")
  662. .HasMaxLength(100)
  663. .HasColumnType("nvarchar(100)");
  664. b.ToTable((string)null);
  665. b.ToView("vConnectorStatusCombind", (string)null);
  666. });
  667. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.VMachine", b =>
  668. {
  669. b.Property<string>("ChargeBoxId")
  670. .HasMaxLength(50)
  671. .HasColumnType("nvarchar(50)");
  672. b.Property<int>("ConnectionType")
  673. .HasColumnType("int");
  674. b.Property<string>("ConnectorType")
  675. .HasMaxLength(50)
  676. .HasColumnType("nvarchar(50)");
  677. b.Property<Guid>("CustomerId")
  678. .HasColumnType("uniqueidentifier");
  679. b.Property<int>("GunAmt")
  680. .HasColumnType("int");
  681. b.Property<DateTime>("HeartbeatUpdatedOn")
  682. .HasColumnType("datetime");
  683. b.Property<string>("Id")
  684. .IsRequired()
  685. .HasMaxLength(36)
  686. .HasColumnType("nvarchar(36)");
  687. b.Property<bool>("IsDelete")
  688. .HasColumnType("bit");
  689. b.Property<string>("ModelName")
  690. .IsRequired()
  691. .HasMaxLength(50)
  692. .HasColumnType("nvarchar(50)");
  693. b.Property<DateTime?>("OfflineOn")
  694. .HasColumnType("datetime");
  695. b.Property<bool>("Online")
  696. .HasColumnType("bit");
  697. b.Property<decimal>("RatedPower")
  698. .HasColumnType("decimal(6, 2)");
  699. b.Property<int>("Ttiatag")
  700. .HasColumnType("int")
  701. .HasColumnName("TTIATag");
  702. b.Property<string>("VendorId")
  703. .HasMaxLength(50)
  704. .HasColumnType("nvarchar(50)");
  705. b.ToTable((string)null);
  706. b.ToView("vMachine", (string)null);
  707. });
  708. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.VMachineCombind", b =>
  709. {
  710. b.Property<string>("ChargeBoxId")
  711. .HasMaxLength(50)
  712. .HasColumnType("nvarchar(50)");
  713. b.Property<int>("ConnectionType")
  714. .HasColumnType("int");
  715. b.Property<string>("ConnectorType")
  716. .HasMaxLength(50)
  717. .HasColumnType("nvarchar(50)");
  718. b.Property<Guid>("CustomerId")
  719. .HasColumnType("uniqueidentifier");
  720. b.Property<int>("GunAmt")
  721. .HasColumnType("int");
  722. b.Property<DateTime>("HeartbeatUpdatedOn")
  723. .HasColumnType("datetime");
  724. b.Property<string>("Id")
  725. .IsRequired()
  726. .HasMaxLength(36)
  727. .HasColumnType("nvarchar(36)");
  728. b.Property<bool>("IsDelete")
  729. .HasColumnType("bit");
  730. b.Property<string>("ModelName")
  731. .IsRequired()
  732. .HasMaxLength(50)
  733. .HasColumnType("nvarchar(50)");
  734. b.Property<string>("Ocpp")
  735. .IsRequired()
  736. .HasMaxLength(3)
  737. .IsUnicode(false)
  738. .HasColumnType("varchar(3)")
  739. .HasColumnName("OCPP");
  740. b.Property<DateTime?>("OfflineOn")
  741. .HasColumnType("datetime");
  742. b.Property<bool>("Online")
  743. .HasColumnType("bit");
  744. b.Property<decimal>("RatedPower")
  745. .HasColumnType("decimal(6, 2)");
  746. b.Property<int>("Ttiatag")
  747. .HasColumnType("int")
  748. .HasColumnName("TTIATag");
  749. b.Property<string>("VendorId")
  750. .HasMaxLength(50)
  751. .HasColumnType("nvarchar(50)");
  752. b.ToTable((string)null);
  753. b.ToView("vMachineCombind", (string)null);
  754. });
  755. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.Machine", b =>
  756. {
  757. b.HasOne("EVCB_OCPP.Domain.Models.MainDb.Customer", "Customer")
  758. .WithMany("Machines")
  759. .HasForeignKey("CustomerId")
  760. .OnDelete(DeleteBehavior.Cascade)
  761. .IsRequired()
  762. .HasConstraintName("FK_dbo.Machine_dbo.Customer_CustomerId");
  763. b.Navigation("Customer");
  764. });
  765. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.MachineVersionFile", b =>
  766. {
  767. b.HasOne("EVCB_OCPP.Domain.Models.MainDb.UploadFile", "UploadFile")
  768. .WithMany("MachineVersionFiles")
  769. .HasForeignKey("UploadFileId")
  770. .OnDelete(DeleteBehavior.Cascade)
  771. .IsRequired()
  772. .HasConstraintName("FK_dbo.MachineVersionFile_dbo.UploadFile_UploadFileId");
  773. b.Navigation("UploadFile");
  774. });
  775. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.Customer", b =>
  776. {
  777. b.Navigation("Machines");
  778. });
  779. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.UploadFile", b =>
  780. {
  781. b.Navigation("MachineVersionFiles");
  782. });
  783. #pragma warning restore 612, 618
  784. }
  785. }
  786. }