MainDBContextModelSnapshot.cs 39 KB

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