FLGE-WCS/Projects/菲林格尔/WCS.Service/Migrations/WCSDBModelSnapshot.cs

// <auto-generated />
using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
using WCS.Service;

namespace WCS.Service.Migrations
{
    [DbContext(typeof(WCSDB))]
    partial class WCSDBModelSnapshot : ModelSnapshot
    {
        protected override void BuildModel(ModelBuilder modelBuilder)
        {
#pragma warning disable 612, 618
            modelBuilder
                .HasAnnotation("Relational:MaxIdentifierLength", 128)
                .HasAnnotation("ProductVersion", "5.0.5")
                .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_BCRDATA", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("CONTENT")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

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

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATIONDATA", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<short>("CONFIRM")
                        .HasColumnType("smallint");

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<short>("FLAGS")
                        .HasColumnType("smallint");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<short>("GOODSCODE")
                        .HasColumnType("smallint");

                    b.Property<short>("GOODSEND")
                        .HasColumnType("smallint");

                    b.Property<short>("GOODSSIZE")
                        .HasColumnType("smallint");

                    b.Property<short>("GOODSSTART")
                        .HasColumnType("smallint");

                    b.Property<short>("GOODSTYPE")
                        .HasColumnType("smallint");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<int>("TASKNUM")
                        .HasColumnType("int");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<short>("WEIGHT")
                        .HasColumnType("smallint");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

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

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATIONSTATUSDATA", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<int>("Flags")
                        .HasColumnType("int");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

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

            modelBuilder.Entity("WCS.Entity.WCS_CMD", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("DEVICE_CODE")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<string>("PROPERTY")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)");

                    b.Property<string>("PROTOCOL")
                        .HasMaxLength(256)
                        .HasColumnType("nvarchar(256)");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("VALUE")
                        .HasMaxLength(512)
                        .HasColumnType("nvarchar(512)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WCSVersion")
                        .HasColumnType("int");

                    b.HasKey("ID");

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

            modelBuilder.Entity("WCS.Entity.WCS_DATABLOCK", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<int>("DATALENGTH")
                        .HasColumnType("int");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<int>("LENGTH")
                        .HasColumnType("int");

                    b.Property<string>("NAME")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<int>("NO")
                        .HasColumnType("int");

                    b.Property<bool>("NOUPDATE")
                        .HasColumnType("bit");

                    b.Property<int?>("PLCID")
                        .HasColumnType("int");

                    b.Property<string>("PROTOCOL")
                        .IsRequired()
                        .HasMaxLength(200)
                        .HasColumnType("nvarchar(200)");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("ID");

                    b.HasIndex("PLCID");

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

            modelBuilder.Entity("WCS.Entity.WCS_DEVICE", b =>
                {
                    b.Property<string>("CODE")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<string>("NAME")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("TYPE")
                        .IsRequired()
                        .HasMaxLength(100)
                        .HasColumnType("nvarchar(100)");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("CODE");

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

            modelBuilder.Entity("WCS.Entity.WCS_DEVICEPROTOCOL", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<int?>("DBID")
                        .HasColumnType("int");

                    b.Property<string>("DEVICECODE")
                        .IsRequired()
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<short>("POSITION")
                        .HasColumnType("smallint");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("ID");

                    b.HasIndex("DBID");

                    b.HasIndex("DEVICECODE");

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

            modelBuilder.Entity("WCS.Entity.WCS_EXCEPTION", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<string>("MSG")
                        .HasMaxLength(1000)
                        .HasColumnType("nvarchar(1000)");

                    b.Property<DateTime>("STARTTIME")
                        .HasColumnType("datetime2");

                    b.Property<int>("TIMES")
                        .HasColumnType("int");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("ID");

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

            modelBuilder.Entity("WCS.Entity.WCS_PLC", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<string>("IP")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<string>("MODEL")
                        .HasMaxLength(10)
                        .HasColumnType("nvarchar(10)");

                    b.Property<string>("NAME")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<int>("PORT")
                        .HasColumnType("int");

                    b.Property<int>("RACK")
                        .HasColumnType("int");

                    b.Property<int>("SLOT")
                        .HasColumnType("int");

                    b.Property<int>("TYPE")
                        .HasColumnType("int");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("ID");

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

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_BCRDATA", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATIONDATA", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATIONSTATUSDATA", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.WCS_DATABLOCK", b =>
                {
                    b.HasOne("WCS.Entity.WCS_PLC", "PLC")
                        .WithMany()
                        .HasForeignKey("PLCID");

                    b.Navigation("PLC");
                });

            modelBuilder.Entity("WCS.Entity.WCS_DEVICEPROTOCOL", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DATABLOCK", "DB")
                        .WithMany()
                        .HasForeignKey("DBID");

                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany("PROTOCOLS")
                        .HasForeignKey("DEVICECODE")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("DB");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.WCS_DEVICE", b =>
                {
                    b.Navigation("PROTOCOLS");
                });
#pragma warning restore 612, 618
        }
    }
}