20231019090745_Updatetest.Designer.cs 39 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077
  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("20231019090745_Updatetest")]
  14. partial class Updatetest
  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<string>("Name")
  271. .HasColumnType("nvarchar(max)");
  272. b.Property<DateTime?>("OfflineOn")
  273. .HasColumnType("datetime");
  274. b.Property<bool>("Online")
  275. .HasColumnType("bit");
  276. b.Property<decimal>("RatedPower")
  277. .HasColumnType("decimal(6, 2)");
  278. b.Property<int>("Ttiatag")
  279. .HasColumnType("int")
  280. .HasColumnName("TTIATag");
  281. b.Property<string>("VendorId")
  282. .ValueGeneratedOnAdd()
  283. .HasMaxLength(50)
  284. .HasColumnType("nvarchar(50)")
  285. .HasDefaultValueSql("('Zerova')");
  286. b.HasKey("Id")
  287. .HasName("PK_dbo.Machine");
  288. b.HasIndex(new[] { "CustomerId", "ChargeBoxId" }, "nci_wi_Machine_7CD4A9D1688F96F6967B2244A0666F62");
  289. b.ToTable("Machine", (string)null);
  290. });
  291. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.MachineConfiguration", b =>
  292. {
  293. b.Property<string>("ConfigureName")
  294. .HasMaxLength(50)
  295. .HasColumnType("nvarchar(50)");
  296. b.Property<string>("ChargeBoxId")
  297. .HasMaxLength(50)
  298. .HasColumnType("nvarchar(50)");
  299. b.Property<string>("ConfigureSetting")
  300. .HasMaxLength(500)
  301. .HasColumnType("nvarchar(500)");
  302. b.Property<bool>("Exists")
  303. .HasColumnType("bit");
  304. b.Property<int>("Id")
  305. .ValueGeneratedOnAdd()
  306. .HasColumnType("int");
  307. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  308. b.Property<bool>("ReadOnly")
  309. .HasColumnType("bit");
  310. b.HasKey("ConfigureName", "ChargeBoxId")
  311. .HasName("PK_dbo.MachineConfigurations");
  312. b.HasIndex(new[] { "ConfigureName", "ConfigureSetting" }, "nci_wi_MachineConfigurations_132E765C043BF95A2570D2EA019DD783");
  313. b.ToTable("MachineConfigurations");
  314. });
  315. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.MachineError", b =>
  316. {
  317. b.Property<int>("Id")
  318. .ValueGeneratedOnAdd()
  319. .HasColumnType("int");
  320. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  321. b.Property<string>("ChargeBoxId")
  322. .HasMaxLength(50)
  323. .HasColumnType("nvarchar(50)");
  324. b.Property<byte>("ConnectorId")
  325. .HasColumnType("tinyint");
  326. b.Property<DateTime>("CreatedOn")
  327. .HasColumnType("datetime");
  328. b.Property<int>("ErrorCodeId")
  329. .HasColumnType("int");
  330. b.Property<string>("ErrorInfo")
  331. .HasMaxLength(50)
  332. .HasColumnType("nvarchar(50)");
  333. b.Property<int>("PreStatus")
  334. .HasColumnType("int");
  335. b.Property<int>("Status")
  336. .HasColumnType("int");
  337. b.Property<string>("VendorErrorCode")
  338. .HasMaxLength(100)
  339. .HasColumnType("nvarchar(100)");
  340. b.Property<string>("VendorId")
  341. .HasMaxLength(255)
  342. .HasColumnType("nvarchar(255)");
  343. b.HasKey("Id")
  344. .HasName("PK_dbo.MachineError");
  345. b.ToTable("MachineError", (string)null);
  346. });
  347. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.MachineOperateRecord", b =>
  348. {
  349. b.Property<int>("Id")
  350. .ValueGeneratedOnAdd()
  351. .HasColumnType("int");
  352. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  353. b.Property<string>("Action")
  354. .HasMaxLength(30)
  355. .HasColumnType("nvarchar(30)");
  356. b.Property<string>("ChargeBoxId")
  357. .HasMaxLength(50)
  358. .HasColumnType("nvarchar(50)");
  359. b.Property<DateTime>("CreatedOn")
  360. .HasColumnType("datetime");
  361. b.Property<int>("EvseStatus")
  362. .HasColumnType("int")
  363. .HasColumnName("EVSE_Status");
  364. b.Property<string>("EvseValue")
  365. .HasColumnType("nvarchar(max)")
  366. .HasColumnName("EVSE_Value");
  367. b.Property<DateTime>("FinishedOn")
  368. .HasColumnType("datetime");
  369. b.Property<DateTime>("ReportedOn")
  370. .HasColumnType("datetime");
  371. b.Property<string>("RequestContent")
  372. .HasColumnType("nvarchar(max)");
  373. b.Property<int>("RequestType")
  374. .HasColumnType("int");
  375. b.Property<string>("SerialNo")
  376. .HasMaxLength(36)
  377. .HasColumnType("nvarchar(36)");
  378. b.Property<int>("Status")
  379. .HasColumnType("int");
  380. b.HasKey("Id")
  381. .HasName("PK_dbo.MachineOperateRecord");
  382. b.ToTable("MachineOperateRecord", (string)null);
  383. });
  384. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.MachineVersionFile", b =>
  385. {
  386. b.Property<int>("Id")
  387. .ValueGeneratedOnAdd()
  388. .HasColumnType("int");
  389. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  390. b.Property<string>("ChargeBoxId")
  391. .HasMaxLength(50)
  392. .HasColumnType("nvarchar(50)");
  393. b.Property<DateTime>("CreatedOn")
  394. .HasColumnType("datetime");
  395. b.Property<int>("Seq")
  396. .HasColumnType("int");
  397. b.Property<string>("UploadFileId")
  398. .IsRequired()
  399. .HasMaxLength(36)
  400. .HasColumnType("nvarchar(36)");
  401. b.HasKey("Id")
  402. .HasName("PK_dbo.MachineVersionFile");
  403. b.HasIndex("UploadFileId");
  404. b.ToTable("MachineVersionFile", (string)null);
  405. });
  406. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.MigrationHistory", b =>
  407. {
  408. b.Property<string>("MigrationId")
  409. .HasMaxLength(150)
  410. .HasColumnType("nvarchar(150)");
  411. b.Property<string>("ContextKey")
  412. .HasMaxLength(300)
  413. .HasColumnType("nvarchar(300)");
  414. b.Property<byte[]>("Model")
  415. .IsRequired()
  416. .HasColumnType("varbinary(max)");
  417. b.Property<string>("ProductVersion")
  418. .IsRequired()
  419. .HasMaxLength(32)
  420. .HasColumnType("nvarchar(32)");
  421. b.HasKey("MigrationId", "ContextKey")
  422. .HasName("PK_dbo.__MigrationHistory");
  423. b.ToTable("__MigrationHistory", (string)null);
  424. });
  425. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.Ocmf", b =>
  426. {
  427. b.Property<int>("Id")
  428. .ValueGeneratedOnAdd()
  429. .HasColumnType("int");
  430. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  431. b.Property<string>("DataString")
  432. .HasMaxLength(2048)
  433. .HasColumnType("nvarchar(2048)");
  434. b.Property<string>("PublicKey")
  435. .HasMaxLength(256)
  436. .HasColumnType("nvarchar(256)");
  437. b.Property<int>("TransactionId")
  438. .HasColumnType("int");
  439. b.HasKey("Id")
  440. .HasName("PK_dbo.OCMF");
  441. b.ToTable("OCMF", (string)null);
  442. });
  443. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.ServerMessage", b =>
  444. {
  445. b.Property<int>("Id")
  446. .ValueGeneratedOnAdd()
  447. .HasColumnType("int");
  448. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  449. b.Property<string>("ChargeBoxId")
  450. .HasMaxLength(50)
  451. .HasColumnType("nvarchar(50)");
  452. b.Property<string>("CreatedBy")
  453. .HasMaxLength(36)
  454. .HasColumnType("nvarchar(36)");
  455. b.Property<DateTime>("CreatedOn")
  456. .HasColumnType("datetime");
  457. b.Property<string>("InMessage")
  458. .HasColumnType("nvarchar(max)");
  459. b.Property<string>("OutAction")
  460. .HasMaxLength(30)
  461. .HasColumnType("nvarchar(30)");
  462. b.Property<string>("OutRequest")
  463. .HasColumnType("nvarchar(max)");
  464. b.Property<DateTime>("ReceivedOn")
  465. .HasColumnType("datetime");
  466. b.Property<string>("SerialNo")
  467. .HasMaxLength(36)
  468. .HasColumnType("nvarchar(36)");
  469. b.Property<DateTime>("UpdatedOn")
  470. .HasColumnType("datetime");
  471. b.HasKey("Id")
  472. .HasName("PK_dbo.ServerMessage");
  473. b.HasIndex(new[] { "ReceivedOn", "UpdatedOn", "CreatedOn" }, "nci_wi_ServerMessage_EC00C205420F6CB01974705B93F9507F");
  474. b.ToTable("ServerMessage", (string)null);
  475. });
  476. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.TransactionRecord", b =>
  477. {
  478. b.Property<int>("Id")
  479. .ValueGeneratedOnAdd()
  480. .HasColumnType("int");
  481. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  482. b.Property<bool>("BillingDone")
  483. .HasColumnType("bit");
  484. b.Property<string>("ChargeBoxId")
  485. .IsRequired()
  486. .HasMaxLength(50)
  487. .HasColumnType("nvarchar(50)");
  488. b.Property<byte>("ConnectorId")
  489. .HasColumnType("tinyint");
  490. b.Property<decimal>("Cost")
  491. .HasColumnType("decimal(18, 2)");
  492. b.Property<DateTime>("CreatedOn")
  493. .HasColumnType("datetime");
  494. b.Property<Guid>("CustomerId")
  495. .HasColumnType("uniqueidentifier");
  496. b.Property<string>("ErrorMsg")
  497. .HasColumnType("nvarchar(max)");
  498. b.Property<string>("Evccid")
  499. .HasMaxLength(30)
  500. .HasColumnType("nvarchar(30)")
  501. .HasColumnName("EVCCID");
  502. b.Property<string>("Fee")
  503. .HasMaxLength(1500)
  504. .HasColumnType("nvarchar(1500)");
  505. b.Property<decimal>("MeterStart")
  506. .HasColumnType("decimal(18, 2)");
  507. b.Property<decimal>("MeterStop")
  508. .HasColumnType("decimal(18, 2)");
  509. b.Property<bool>("NotifyPnC")
  510. .HasColumnType("bit");
  511. b.Property<string>("Receipt")
  512. .HasMaxLength(3000)
  513. .HasColumnType("nvarchar(3000)");
  514. b.Property<int>("ReservationId")
  515. .HasColumnType("int");
  516. b.Property<int>("RetryStartTransactionTimes")
  517. .HasColumnType("int");
  518. b.Property<int>("RetryStopTransactionTimes")
  519. .HasColumnType("int");
  520. b.Property<string>("StartIdTag")
  521. .HasMaxLength(20)
  522. .HasColumnType("nvarchar(20)");
  523. b.Property<string>("StartSoc")
  524. .HasMaxLength(3)
  525. .HasColumnType("nvarchar(3)")
  526. .HasColumnName("StartSOC");
  527. b.Property<DateTime>("StartTime")
  528. .HasColumnType("datetime");
  529. b.Property<DateTime>("StartTransactionReportedOn")
  530. .HasColumnType("datetime");
  531. b.Property<string>("StopIdTag")
  532. .HasMaxLength(20)
  533. .HasColumnType("nvarchar(20)");
  534. b.Property<string>("StopReason")
  535. .HasMaxLength(60)
  536. .HasColumnType("nvarchar(60)");
  537. b.Property<int>("StopReasonId")
  538. .HasColumnType("int");
  539. b.Property<string>("StopSoc")
  540. .HasMaxLength(3)
  541. .HasColumnType("nvarchar(3)")
  542. .HasColumnName("StopSOC");
  543. b.Property<DateTime>("StopTime")
  544. .HasColumnType("datetime");
  545. b.Property<DateTime>("StopTransactionReportedOn")
  546. .HasColumnType("datetime");
  547. b.Property<DateTime>("UpdatedOn")
  548. .HasColumnType("datetime");
  549. b.Property<bool>("UploadedtoTtia")
  550. .HasColumnType("bit")
  551. .HasColumnName("UploadedtoTTIA");
  552. b.HasKey("Id")
  553. .HasName("PK_dbo.TransactionRecord");
  554. b.HasIndex(new[] { "CustomerId", "ConnectorId", "StartTime", "ChargeBoxId" }, "IX_TransactionRecord_StartTime");
  555. b.HasIndex(new[] { "CustomerId", "StopTransactionReportedOn", "StopTime" }, "nci_wi_TransactionRecord_92D4DF08E7034102014AC91760F890FE");
  556. b.ToTable("TransactionRecord", (string)null);
  557. });
  558. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.UploadFile", b =>
  559. {
  560. b.Property<string>("Id")
  561. .HasMaxLength(36)
  562. .HasColumnType("nvarchar(36)");
  563. b.Property<string>("CreatedBy")
  564. .HasMaxLength(50)
  565. .HasColumnType("nvarchar(50)");
  566. b.Property<DateTime>("CreatedOn")
  567. .HasColumnType("datetime");
  568. b.Property<string>("FileExtensionName")
  569. .HasMaxLength(50)
  570. .HasColumnType("nvarchar(50)");
  571. b.Property<string>("FileMd5")
  572. .HasMaxLength(50)
  573. .HasColumnType("nvarchar(50)")
  574. .HasColumnName("FileMD5");
  575. b.Property<string>("FileName")
  576. .IsRequired()
  577. .HasMaxLength(500)
  578. .HasColumnType("nvarchar(500)");
  579. b.Property<string>("FilePath")
  580. .IsRequired()
  581. .HasMaxLength(500)
  582. .HasColumnType("nvarchar(500)");
  583. b.Property<int>("FileSize")
  584. .HasColumnType("int");
  585. b.Property<string>("FileType")
  586. .HasMaxLength(200)
  587. .HasColumnType("nvarchar(200)");
  588. b.Property<string>("FileUrl")
  589. .HasMaxLength(512)
  590. .HasColumnType("nvarchar(512)");
  591. b.Property<string>("ModelName")
  592. .IsRequired()
  593. .HasMaxLength(50)
  594. .HasColumnType("nvarchar(50)");
  595. b.Property<int>("ModuleId")
  596. .HasColumnType("int");
  597. b.Property<string>("OriginName")
  598. .IsRequired()
  599. .HasMaxLength(500)
  600. .HasColumnType("nvarchar(500)");
  601. b.Property<string>("VendorId")
  602. .IsRequired()
  603. .HasMaxLength(50)
  604. .HasColumnType("nvarchar(50)");
  605. b.HasKey("Id")
  606. .HasName("PK_dbo.UploadFile");
  607. b.ToTable("UploadFile", (string)null);
  608. });
  609. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.VConnectorStatus", b =>
  610. {
  611. b.Property<string>("ChargeBoxId")
  612. .HasMaxLength(50)
  613. .HasColumnType("nvarchar(50)");
  614. b.Property<int>("ChargePointErrorCodeId")
  615. .HasColumnType("int");
  616. b.Property<byte>("ConnectorId")
  617. .HasColumnType("tinyint");
  618. b.Property<DateTime>("CreatedOn")
  619. .HasColumnType("datetime");
  620. b.Property<string>("ErrorInfo")
  621. .HasMaxLength(50)
  622. .HasColumnType("nvarchar(50)");
  623. b.Property<string>("Id")
  624. .IsRequired()
  625. .HasMaxLength(36)
  626. .HasColumnType("nvarchar(36)");
  627. b.Property<int>("Status")
  628. .HasColumnType("int");
  629. b.Property<decimal>("TotalEnergy")
  630. .HasColumnType("decimal(10, 2)");
  631. b.Property<int>("Type")
  632. .HasColumnType("int");
  633. b.Property<string>("VendorErrorCode")
  634. .HasMaxLength(100)
  635. .HasColumnType("nvarchar(100)");
  636. b.Property<string>("VendorId")
  637. .HasMaxLength(255)
  638. .HasColumnType("nvarchar(255)");
  639. b.ToTable((string)null);
  640. b.ToView("vConnectorStatus", (string)null);
  641. });
  642. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.VConnectorStatusCombind", b =>
  643. {
  644. b.Property<string>("ChargeBoxId")
  645. .HasMaxLength(50)
  646. .HasColumnType("nvarchar(50)");
  647. b.Property<int>("ChargePointErrorCodeId")
  648. .HasColumnType("int");
  649. b.Property<byte>("ConnectorId")
  650. .HasColumnType("tinyint");
  651. b.Property<string>("Ocpp")
  652. .IsRequired()
  653. .HasMaxLength(3)
  654. .IsUnicode(false)
  655. .HasColumnType("varchar(3)")
  656. .HasColumnName("OCPP");
  657. b.Property<int>("Status")
  658. .HasColumnType("int");
  659. b.Property<decimal>("TotalEnergy")
  660. .HasColumnType("decimal(10, 2)");
  661. b.Property<int>("Type")
  662. .HasColumnType("int");
  663. b.Property<string>("VendorErrorCode")
  664. .HasMaxLength(100)
  665. .HasColumnType("nvarchar(100)");
  666. b.ToTable((string)null);
  667. b.ToView("vConnectorStatusCombind", (string)null);
  668. });
  669. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.VMachine", b =>
  670. {
  671. b.Property<string>("ChargeBoxId")
  672. .HasMaxLength(50)
  673. .HasColumnType("nvarchar(50)");
  674. b.Property<int>("ConnectionType")
  675. .HasColumnType("int");
  676. b.Property<string>("ConnectorType")
  677. .HasMaxLength(50)
  678. .HasColumnType("nvarchar(50)");
  679. b.Property<Guid>("CustomerId")
  680. .HasColumnType("uniqueidentifier");
  681. b.Property<int>("GunAmt")
  682. .HasColumnType("int");
  683. b.Property<DateTime>("HeartbeatUpdatedOn")
  684. .HasColumnType("datetime");
  685. b.Property<string>("Id")
  686. .IsRequired()
  687. .HasMaxLength(36)
  688. .HasColumnType("nvarchar(36)");
  689. b.Property<bool>("IsDelete")
  690. .HasColumnType("bit");
  691. b.Property<string>("ModelName")
  692. .IsRequired()
  693. .HasMaxLength(50)
  694. .HasColumnType("nvarchar(50)");
  695. b.Property<DateTime?>("OfflineOn")
  696. .HasColumnType("datetime");
  697. b.Property<bool>("Online")
  698. .HasColumnType("bit");
  699. b.Property<decimal>("RatedPower")
  700. .HasColumnType("decimal(6, 2)");
  701. b.Property<int>("Ttiatag")
  702. .HasColumnType("int")
  703. .HasColumnName("TTIATag");
  704. b.Property<string>("VendorId")
  705. .HasMaxLength(50)
  706. .HasColumnType("nvarchar(50)");
  707. b.ToTable((string)null);
  708. b.ToView("vMachine", (string)null);
  709. });
  710. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.VMachineCombind", b =>
  711. {
  712. b.Property<string>("ChargeBoxId")
  713. .HasMaxLength(50)
  714. .HasColumnType("nvarchar(50)");
  715. b.Property<int>("ConnectionType")
  716. .HasColumnType("int");
  717. b.Property<string>("ConnectorType")
  718. .HasMaxLength(50)
  719. .HasColumnType("nvarchar(50)");
  720. b.Property<Guid>("CustomerId")
  721. .HasColumnType("uniqueidentifier");
  722. b.Property<int>("GunAmt")
  723. .HasColumnType("int");
  724. b.Property<DateTime>("HeartbeatUpdatedOn")
  725. .HasColumnType("datetime");
  726. b.Property<string>("Id")
  727. .IsRequired()
  728. .HasMaxLength(36)
  729. .HasColumnType("nvarchar(36)");
  730. b.Property<bool>("IsDelete")
  731. .HasColumnType("bit");
  732. b.Property<string>("ModelName")
  733. .IsRequired()
  734. .HasMaxLength(50)
  735. .HasColumnType("nvarchar(50)");
  736. b.Property<string>("Ocpp")
  737. .IsRequired()
  738. .HasMaxLength(3)
  739. .IsUnicode(false)
  740. .HasColumnType("varchar(3)")
  741. .HasColumnName("OCPP");
  742. b.Property<DateTime?>("OfflineOn")
  743. .HasColumnType("datetime");
  744. b.Property<bool>("Online")
  745. .HasColumnType("bit");
  746. b.Property<decimal>("RatedPower")
  747. .HasColumnType("decimal(6, 2)");
  748. b.Property<int>("Ttiatag")
  749. .HasColumnType("int")
  750. .HasColumnName("TTIATag");
  751. b.Property<string>("VendorId")
  752. .HasMaxLength(50)
  753. .HasColumnType("nvarchar(50)");
  754. b.ToTable((string)null);
  755. b.ToView("vMachineCombind", (string)null);
  756. });
  757. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.Machine", b =>
  758. {
  759. b.HasOne("EVCB_OCPP.Domain.Models.MainDb.Customer", "Customer")
  760. .WithMany("Machines")
  761. .HasForeignKey("CustomerId")
  762. .OnDelete(DeleteBehavior.Cascade)
  763. .IsRequired()
  764. .HasConstraintName("FK_dbo.Machine_dbo.Customer_CustomerId");
  765. b.Navigation("Customer");
  766. });
  767. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.MachineVersionFile", b =>
  768. {
  769. b.HasOne("EVCB_OCPP.Domain.Models.MainDb.UploadFile", "UploadFile")
  770. .WithMany("MachineVersionFiles")
  771. .HasForeignKey("UploadFileId")
  772. .OnDelete(DeleteBehavior.Cascade)
  773. .IsRequired()
  774. .HasConstraintName("FK_dbo.MachineVersionFile_dbo.UploadFile_UploadFileId");
  775. b.Navigation("UploadFile");
  776. });
  777. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.Customer", b =>
  778. {
  779. b.Navigation("Machines");
  780. });
  781. modelBuilder.Entity("EVCB_OCPP.Domain.Models.MainDb.UploadFile", b =>
  782. {
  783. b.Navigation("MachineVersionFiles");
  784. });
  785. #pragma warning restore 612, 618
  786. }
  787. }
  788. }