SmartDoorLock/Repository/Migrations/20241218054316_2024-12-18-1.Designer.cs

// <auto-generated />
using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Migrations;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
using Repository;

namespace Repository.Migrations
{
    [DbContext(typeof(TeamDataContext))]
    [Migration("20241218054316_2024-12-18-1")]
    partial class _202412181
    {
        protected override void BuildTargetModel(ModelBuilder modelBuilder)
        {
#pragma warning disable 612, 618
            modelBuilder
                .HasAnnotation("ProductVersion", "3.1.32");

            modelBuilder.Entity("Repository.DeviceStatus", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<double>("AlarmTime")
                        .HasColumnType("REAL");

                    b.Property<DateTime>("DateDS")
                        .HasColumnType("TEXT");

                    b.HasKey("Id");

                    b.ToTable("DeviceStatus");
                });

            modelBuilder.Entity("Repository.Entiies.Account", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<string>("AccountID")
                        .HasColumnType("TEXT");

                    b.Property<string>("ChangePassword")
                        .HasColumnType("TEXT");

                    b.HasKey("Id");

                    b.ToTable("Accounts");
                });

            modelBuilder.Entity("Repository.Entiies.AllNumber", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<DateTime>("DateA")
                        .HasColumnType("TEXT");

                    b.Property<double>("ErrA")
                        .HasColumnType("REAL");

                    b.Property<double>("NgA")
                        .HasColumnType("REAL");

                    b.Property<double>("OkA")
                        .HasColumnType("REAL");

                    b.Property<double>("PlanA")
                        .HasColumnType("REAL");

                    b.Property<double>("RealityA")
                        .HasColumnType("REAL");

                    b.HasKey("Id");

                    b.ToTable("AllNumbers");
                });

            modelBuilder.Entity("Repository.Entiies.House", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<DateTime>("DateH")
                        .HasColumnType("TEXT");

                    b.Property<string>("LackH")
                        .HasColumnType("TEXT");

                    b.Property<string>("TotalH")
                        .HasColumnType("TEXT");

                    b.Property<string>("UsedH")
                        .HasColumnType("TEXT");

                    b.HasKey("Id");

                    b.ToTable("Houses");
                });

            modelBuilder.Entity("Repository.Entiies.Information", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<DateTime>("CreateTime")
                        .HasColumnType("TEXT");

                    b.Property<string>("ItemCode")
                        .HasColumnType("TEXT");

                    b.Property<string>("OperatorCode")
                        .HasColumnType("TEXT");

                    b.Property<string>("OrderNo")
                        .HasColumnType("TEXT");

                    b.Property<string>("ProCode")
                        .HasColumnType("TEXT");

                    b.Property<string>("ProNo")
                        .HasColumnType("TEXT");

                    b.Property<string>("ProType")
                        .HasColumnType("TEXT");

                    b.Property<double>("SpendTime")
                        .HasColumnType("REAL");

                    b.Property<string>("TestResult")
                        .HasColumnType("TEXT");

                    b.Property<string>("WorkDev")
                        .HasColumnType("TEXT");

                    b.HasKey("Id");

                    b.ToTable("Informations");
                });

            modelBuilder.Entity("Repository.Entiies.OutofWork", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<int>("Absenteeism")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Actual")
                        .HasColumnType("INTEGER");

                    b.Property<DateTime>("DateOutWork")
                        .HasColumnType("TEXT");

                    b.Property<int>("FallIll")
                        .HasColumnType("INTEGER");

                    b.HasKey("Id");

                    b.ToTable("OutofWorks");
                });

            modelBuilder.Entity("Repository.Entiies.ParamLog", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<string>("Content")
                        .HasColumnType("TEXT");

                    b.Property<DateTime>("Occured")
                        .HasColumnType("TEXT");

                    b.Property<int>("OperateAction")
                        .HasColumnType("INTEGER");

                    b.Property<string>("OperateObject")
                        .HasColumnType("TEXT");

                    b.Property<string>("UserName")
                        .HasColumnType("TEXT");

                    b.HasKey("Id");

                    b.ToTable("ParamLogs");
                });

            modelBuilder.Entity("Repository.Entiies.Person", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<string>("EmployeeName")
                        .HasColumnType("TEXT");

                    b.Property<string>("ProProcess")
                        .HasColumnType("TEXT");

                    b.Property<string>("WorkTime")
                        .HasColumnType("TEXT");

                    b.Property<int>("Yield")
                        .HasColumnType("INTEGER");

                    b.HasKey("Id");

                    b.ToTable("Persons");
                });

            modelBuilder.Entity("Repository.Entiies.ProStatus", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<DateTime>("DateS")
                        .HasColumnType("TEXT");

                    b.Property<int>("ErrS")
                        .HasColumnType("INTEGER");

                    b.Property<int>("NgS")
                        .HasColumnType("INTEGER");

                    b.Property<int>("OkS")
                        .HasColumnType("INTEGER");

                    b.Property<string>("OrdNoS")
                        .HasColumnType("TEXT");

                    b.Property<double>("PlanS")
                        .HasColumnType("REAL");

                    b.Property<int>("RealityS")
                        .HasColumnType("INTEGER");

                    b.HasKey("Id");

                    b.ToTable("ProStatus");
                });

            modelBuilder.Entity("Repository.Entiies.Quality", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<DateTime>("DateQuality")
                        .HasColumnType("TEXT");

                    b.Property<string>("ProTName")
                        .HasColumnType("TEXT");

                    b.Property<int>("Q1")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q10")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q11")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q12")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q13")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q14")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q15")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q16")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q17")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q18")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q19")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q2")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q20")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q21")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q22")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q23")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q24")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q25")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q26")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q27")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q28")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q29")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q3")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q30")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q4")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q5")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q6")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q7")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q8")
                        .HasColumnType("INTEGER");

                    b.Property<int>("Q9")
                        .HasColumnType("INTEGER");

                    b.Property<string>("QuPCode")
                        .HasColumnType("TEXT");

                    b.HasKey("Id");

                    b.ToTable("Qualitys");
                });

            modelBuilder.Entity("Repository.Entiies.StatisticsLog", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<int>("RequestCode")
                        .HasColumnType("INTEGER");

                    b.Property<int>("RequstType")
                        .HasColumnType("INTEGER");

                    b.Property<DateTime>("Timestamp")
                        .HasColumnType("TEXT");

                    b.Property<int>("TraceState")
                        .HasColumnType("INTEGER");

                    b.HasKey("Id");

                    b.ToTable("StatisticsLogs");
                });

            modelBuilder.Entity("Repository.Entiies.TestResult", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<string>("Barcode")
                        .HasColumnType("TEXT");

                    b.Property<DateTime>("Datetime")
                        .HasColumnType("TEXT");

                    b.Property<int>("Juge")
                        .HasColumnType("INTEGER");

                    b.Property<double>("Result")
                        .HasColumnType("REAL");

                    b.HasKey("Id");

                    b.ToTable("ProductResult");
                });

            modelBuilder.Entity("Repository.LocalFile2Db", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<string>("Count")
                        .HasColumnType("TEXT");

                    b.Property<string>("MaterialName")
                        .HasColumnType("TEXT");

                    b.Property<string>("MaterialNum")
                        .HasColumnType("TEXT");

                    b.Property<string>("Num")
                        .HasColumnType("TEXT");

                    b.Property<Guid?>("SopFileID")
                        .HasColumnType("TEXT");

                    b.Property<string>("Unit")
                        .HasColumnType("TEXT");

                    b.HasKey("Id");

                    b.HasIndex("SopFileID");

                    b.ToTable("LocalFile2");
                });

            modelBuilder.Entity("Repository.LocalFile3Db", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<string>("After")
                        .HasColumnType("TEXT");

                    b.Property<string>("Before")
                        .HasColumnType("TEXT");

                    b.Property<string>("Equipment")
                        .HasColumnType("TEXT");

                    b.Property<string>("Inn")
                        .HasColumnType("TEXT");

                    b.Property<string>("LookOut")
                        .HasColumnType("TEXT");

                    b.Property<Guid?>("SopFileID")
                        .HasColumnType("TEXT");

                    b.HasKey("Id");

                    b.HasIndex("SopFileID");

                    b.ToTable("LocalFile3");
                });

            modelBuilder.Entity("Repository.LocalFileDb", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<string>("Date")
                        .HasColumnType("TEXT");

                    b.Property<string>("Edition")
                        .HasColumnType("TEXT");

                    b.Property<string>("FileNum")
                        .HasColumnType("TEXT");

                    b.Property<string>("Name")
                        .HasColumnType("TEXT");

                    b.Property<string>("People")
                        .HasColumnType("TEXT");

                    b.Property<string>("Process")
                        .HasColumnType("TEXT");

                    b.Property<Guid?>("SopFileID")
                        .HasColumnType("TEXT");

                    b.Property<string>("Type")
                        .HasColumnType("TEXT");

                    b.Property<string>("WorkTime")
                        .HasColumnType("TEXT");

                    b.HasKey("Id");

                    b.HasIndex("SopFileID");

                    b.ToTable("LocalFile");
                });

            modelBuilder.Entity("Repository.SopFile", b =>
                {
                    b.Property<Guid>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("TEXT");

                    b.Property<string>("ProductName")
                        .HasColumnType("TEXT");

                    b.HasKey("ID");

                    b.ToTable("SopFiles");
                });

            modelBuilder.Entity("Repository.LocalFile2Db", b =>
                {
                    b.HasOne("Repository.SopFile", "SopFile")
                        .WithMany("LocalFile2Db")
                        .HasForeignKey("SopFileID");
                });

            modelBuilder.Entity("Repository.LocalFile3Db", b =>
                {
                    b.HasOne("Repository.SopFile", "SopFile")
                        .WithMany("LocalFile3Db")
                        .HasForeignKey("SopFileID");
                });

            modelBuilder.Entity("Repository.LocalFileDb", b =>
                {
                    b.HasOne("Repository.SopFile", "SopFile")
                        .WithMany("LocalFileDb")
                        .HasForeignKey("SopFileID");
                });
#pragma warning restore 612, 618
        }
    }
}