123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578 |
- // <auto-generated />
- using System;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore.Infrastructure;
- using Microsoft.EntityFrameworkCore.Migrations;
- using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
- using ProductionLineMonitor.EntityFramework;
- namespace ProductionLineMonitor.Web.Migrations
- {
- [DbContext(typeof(ProductionLineContext))]
- [Migration("20221110055218_202211101352")]
- partial class _202211101352
- {
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
- #pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("ProductVersion", "5.0.17");
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.Cim", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<bool>("EAPIsConnected")
- .HasColumnType("INTEGER");
- b.Property<string>("IpAddress")
- .HasColumnType("TEXT");
- b.Property<bool>("IsConnected")
- .HasColumnType("INTEGER");
- b.Property<bool>("PLCIsConnected")
- .HasColumnType("INTEGER");
- b.Property<DateTime>("Time")
- .HasColumnType("TEXT");
- b.Property<string>("Topic")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.Property<string>("User")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("Cims");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.Machine", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<string>("FaultTopic")
- .HasColumnType("TEXT");
- b.Property<bool?>("IsInclusionLineStatistics")
- .HasColumnType("INTEGER");
- b.Property<string>("Name")
- .HasColumnType("TEXT");
- b.Property<string>("ProductionLineId")
- .HasColumnType("TEXT");
- b.Property<int?>("ProductionLineOrder")
- .HasColumnType("INTEGER");
- b.Property<string>("Topic")
- .HasColumnType("TEXT");
- b.Property<string>("Type")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("Machines");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachineFaultComparison", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<string>("FaultCategory")
- .HasColumnType("TEXT");
- b.Property<int?>("FaultCode")
- .HasColumnType("INTEGER");
- b.Property<string>("FaultInfo")
- .HasColumnType("TEXT");
- b.Property<int?>("FaultLevel")
- .HasColumnType("INTEGER");
- b.Property<string>("FaultTopic")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("MachineFaultComparisons");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachineFaultRecord", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("EndTime")
- .HasColumnType("TEXT");
- b.Property<int?>("FaultCode")
- .HasColumnType("INTEGER");
- b.Property<string>("MachineId")
- .HasColumnType("TEXT");
- b.Property<int?>("MachineState")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("StartTime")
- .HasColumnType("TEXT");
- b.Property<int?>("State")
- .HasColumnType("INTEGER");
- b.Property<int?>("TriggerNumber")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("MachineFaultRecords");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachineOutPutPerHour", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<int?>("ActualTT")
- .HasColumnType("INTEGER");
- b.Property<int?>("AlarmSum")
- .HasColumnType("INTEGER");
- b.Property<int?>("AlarmTime")
- .HasColumnType("INTEGER");
- b.Property<int?>("AutoRunTime")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("DataTime")
- .HasColumnType("TEXT");
- b.Property<int?>("IdleTime")
- .HasColumnType("INTEGER");
- b.Property<int?>("IdleTimeDownstream")
- .HasColumnType("INTEGER");
- b.Property<int?>("IdleTimeSelf")
- .HasColumnType("INTEGER");
- b.Property<int?>("IdleTimeUpstream")
- .HasColumnType("INTEGER");
- b.Property<int?>("LoadMATSum")
- .HasColumnType("INTEGER");
- b.Property<int?>("LoadMATTime")
- .HasColumnType("INTEGER");
- b.Property<string>("MachineId")
- .HasColumnType("TEXT");
- b.Property<string>("ModuleType")
- .HasColumnType("TEXT");
- b.Property<int?>("OutPut")
- .HasColumnType("INTEGER");
- b.Property<int?>("TargetTT")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("MachineOutPutPerHours");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachinePowerConsumption", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<int>("Capacity")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<DateTime>("DataTime")
- .HasColumnType("TEXT");
- b.Property<string>("MachineId")
- .HasColumnType("TEXT");
- b.Property<float>("PowerConsumption")
- .HasColumnType("REAL");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("MachinePowerConsumptions");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachineProcessBT", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<int>("BTAOI检查成功率")
- .HasColumnType("INTEGER");
- b.Property<int>("BTAOI检测NG数")
- .HasColumnType("INTEGER");
- b.Property<int>("BT贴附对位NG数")
- .HasColumnType("INTEGER");
- b.Property<int>("BT贴附对位成功率")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<DateTime>("DataTime")
- .HasColumnType("TEXT");
- b.Property<string>("MachineId")
- .HasColumnType("TEXT");
- b.Property<int>("No")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.Property<int>("生产总数")
- .HasColumnType("INTEGER");
- b.HasKey("Id");
- b.ToTable("MachineProcessBTs");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachineProcessFOG", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<DateTime>("DataTime")
- .HasColumnType("TEXT");
- b.Property<int>("FPC总投入数")
- .HasColumnType("INTEGER");
- b.Property<int>("FPC抛料总数")
- .HasColumnType("INTEGER");
- b.Property<float>("FPC抛料率")
- .HasColumnType("REAL");
- b.Property<int>("FPC拍照抛料总数")
- .HasColumnType("INTEGER");
- b.Property<int>("FPC真空抛料总数")
- .HasColumnType("INTEGER");
- b.Property<string>("MachineId")
- .HasColumnType("TEXT");
- b.Property<int>("No")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.Property<int>("校正平台FPC拍照抛料数")
- .HasColumnType("INTEGER");
- b.Property<int>("校正平台FPC真空抛料数")
- .HasColumnType("INTEGER");
- b.Property<int>("预压头FPC拍照抛料数")
- .HasColumnType("INTEGER");
- b.Property<int>("预压头FPC真空抛料数")
- .HasColumnType("INTEGER");
- b.HasKey("Id");
- b.ToTable("MachineProcessFOGs");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachineProcessPS", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<DateTime>("DataTime")
- .HasColumnType("TEXT");
- b.Property<string>("MachineId")
- .HasColumnType("TEXT");
- b.Property<int>("No")
- .HasColumnType("INTEGER");
- b.Property<int>("PS拍照NG抛料数")
- .HasColumnType("INTEGER");
- b.Property<int>("PS撕膜NG抛料数")
- .HasColumnType("INTEGER");
- b.Property<int>("PS撕膜总数")
- .HasColumnType("INTEGER");
- b.Property<int>("PS撕膜成功率")
- .HasColumnType("INTEGER");
- b.Property<int>("PS放反抛料数")
- .HasColumnType("INTEGER");
- b.Property<int>("PS本体撕落抛料数")
- .HasColumnType("INTEGER");
- b.Property<int>("PS生产总数")
- .HasColumnType("INTEGER");
- b.Property<int>("PS真空异常抛料数")
- .HasColumnType("INTEGER");
- b.Property<int>("PS贴附精度NG数")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("MachineProcessPSs");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachineProcessPSEPD", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<DateTime>("DataTime")
- .HasColumnType("TEXT");
- b.Property<int>("EPD一次撕膜数")
- .HasColumnType("INTEGER");
- b.Property<int>("EPD二次撕膜数")
- .HasColumnType("INTEGER");
- b.Property<int>("EPD撕膜NG数")
- .HasColumnType("INTEGER");
- b.Property<int>("EPD撕膜成功率")
- .HasColumnType("INTEGER");
- b.Property<int>("EPD撕膜数")
- .HasColumnType("INTEGER");
- b.Property<string>("MachineId")
- .HasColumnType("TEXT");
- b.Property<int>("No")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("MachineProcessPSEPDs");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.MachineStatistic", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<double?>("Availability")
- .HasColumnType("REAL");
- b.Property<int?>("Capacity")
- .HasColumnType("INTEGER");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<DateTime>("Date")
- .HasColumnType("TEXT");
- b.Property<string>("MachineId")
- .HasColumnType("TEXT");
- b.Property<string>("ModuleType")
- .HasColumnType("TEXT");
- b.Property<double?>("OEE")
- .HasColumnType("REAL");
- b.Property<double?>("Performance")
- .HasColumnType("REAL");
- b.Property<double?>("Quality")
- .HasColumnType("REAL");
- b.Property<double?>("TT")
- .HasColumnType("REAL");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("MachineStatistics");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.ProductionLine", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<string>("Name")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("ProductionLines");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.Recipe", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<string>("ModuleType")
- .HasColumnType("TEXT");
- b.Property<string>("ProductionLineId")
- .HasColumnType("TEXT");
- b.Property<int?>("TheoryCapacity")
- .HasColumnType("INTEGER");
- b.Property<float?>("TheoryTT")
- .HasColumnType("REAL");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("Recipes");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.Role", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<string>("Name")
- .HasColumnType("TEXT");
- b.Property<string>("Permissions")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("Roles");
- });
- modelBuilder.Entity("ProductionLineMonitor.Core.Models.User", b =>
- {
- b.Property<string>("Id")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("CreateTime")
- .HasColumnType("TEXT");
- b.Property<string>("JobNo")
- .HasColumnType("TEXT");
- b.Property<string>("Name")
- .HasColumnType("TEXT");
- b.Property<string>("Password")
- .HasColumnType("TEXT");
- b.Property<string>("RoleId")
- .HasColumnType("TEXT");
- b.Property<DateTime?>("UpdateTime")
- .HasColumnType("TEXT");
- b.HasKey("Id");
- b.ToTable("Users");
- });
- #pragma warning restore 612, 618
- }
- }
- }
|