ProductionLineMonitor/ProductionLineMonitor.Web/Migrations/20221103031847_202211031118.Designer.cs

// <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("20221103031847_202211031118")]
    partial class _202211031118
    {
        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<int?>("TT")
                        .HasColumnType("INTEGER");

                    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
        }
    }
}