// 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_AGVTask", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("AGVID") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("AGVStatus") .HasColumnType("int"); b.Property("AGVUpdateTime") .HasColumnType("datetime2"); b.Property("CreateTime") .HasColumnType("datetime2"); b.Property("Position") .IsRequired() .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("Station") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("Status") .HasColumnType("int"); b.Property("TaskType") .HasColumnType("int"); b.Property("UpdateTime") .HasColumnType("datetime2"); b.Property("Workshop") .HasColumnType("int"); b.HasKey("ID"); b.ToTable("WCS_AGVTask"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_BCR80", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("CONTENT") .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_BCR80"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_DRGV520", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("DestPosition_1") .HasColumnType("smallint"); b.Property("DestPosition_2") .HasColumnType("smallint"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("PRIORITY_1") .HasColumnType("smallint"); b.Property("PRIORITY_2") .HasColumnType("smallint"); b.Property("RES1_1") .HasColumnType("smallint"); b.Property("RES1_2") .HasColumnType("smallint"); b.Property("StartPosition_1") .HasColumnType("smallint"); b.Property("StartPosition_2") .HasColumnType("smallint"); b.Property("TaskID_1") .HasColumnType("int"); b.Property("TaskID_2") .HasColumnType("int"); b.Property("TaskType_1") .HasColumnType("smallint"); b.Property("TaskType_2") .HasColumnType("smallint"); b.Property("Trigger_1") .HasColumnType("smallint"); b.Property("Trigger_2") .HasColumnType("smallint"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.Property("res2_1") .HasColumnType("smallint"); b.Property("res2_2") .HasColumnType("smallint"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_DRGV520"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_DRGV521", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("ACT_V_1") .HasColumnType("smallint"); b.Property("ACT_V_2") .HasColumnType("smallint"); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("DestPosition_1") .HasColumnType("smallint"); b.Property("DestPosition_2") .HasColumnType("smallint"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("Finish_1") .HasColumnType("bit"); b.Property("Finish_2") .HasColumnType("bit"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("Mileage") .HasColumnType("real"); b.Property("PH_Status_1") .HasColumnType("bit"); b.Property("PH_Status_2") .HasColumnType("bit"); b.Property("PRIORITY_1") .HasColumnType("smallint"); b.Property("PRIORITY_2") .HasColumnType("smallint"); b.Property("Position") .HasColumnType("real"); b.Property("RES") .HasColumnType("smallint"); b.Property("RES2_1") .HasColumnType("smallint"); b.Property("RES2_2") .HasColumnType("smallint"); b.Property("Runtime") .HasColumnType("real"); b.Property("StartPosition_1") .HasColumnType("smallint"); b.Property("StartPosition_2") .HasColumnType("smallint"); b.Property("SystemStatus") .HasColumnType("smallint"); b.Property("TaskID_1") .HasColumnType("int"); b.Property("TaskID_2") .HasColumnType("int"); b.Property("TaskType_1") .HasColumnType("smallint"); b.Property("TaskType_2") .HasColumnType("smallint"); b.Property("ToSition_1") .HasColumnType("bit"); b.Property("ToSition_2") .HasColumnType("bit"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.Property("WorkMode") .HasColumnType("smallint"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_DRGV521"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_DRGV523", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("Fault") .HasColumnType("int"); b.Property("Fault1") .HasColumnType("int"); b.Property("Fault2") .HasColumnType("int"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("Status") .HasColumnType("int"); b.Property("Status1") .HasColumnType("int"); b.Property("Status2") .HasColumnType("int"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_DRGV523"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_MAPPINGENTRY", b => { b.Property("MEP_ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("MEP_ISSTOP") .HasColumnType("bit"); b.Property("MEP_MAPPINGCHNAME") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("MEP_MAPPINGNO") .HasColumnType("int"); b.Property("MEP_MAPPINGTYPE") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.HasKey("MEP_ID"); b.ToTable("WCS_MAPPINGENTRY"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV520", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("DestPosition") .HasColumnType("smallint"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("FinishedACK") .HasColumnType("smallint"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("PRIORITY") .HasColumnType("smallint"); b.Property("RES1") .HasColumnType("smallint"); b.Property("StartPosition") .HasColumnType("smallint"); b.Property("TaskID") .HasColumnType("int"); b.Property("TaskType") .HasColumnType("smallint"); b.Property("Trigger") .HasColumnType("smallint"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_RGV520"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV521", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("ACT_V") .HasColumnType("smallint"); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("DestPosition") .HasColumnType("smallint"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("Finish") .HasColumnType("bit"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("Mileage") .HasColumnType("real"); b.Property("PH_Status") .HasColumnType("bit"); b.Property("PRIORITY") .HasColumnType("smallint"); b.Property("Position") .HasColumnType("real"); b.Property("RES") .HasColumnType("smallint"); b.Property("RES2") .HasColumnType("smallint"); b.Property("Runtime") .HasColumnType("real"); b.Property("StartPosition") .HasColumnType("smallint"); b.Property("SystemStatus") .HasColumnType("smallint"); b.Property("TaskID") .HasColumnType("int"); b.Property("TaskType") .HasColumnType("smallint"); b.Property("ToSition") .HasColumnType("bit"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.Property("WorkMode") .HasColumnType("smallint"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_RGV521"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV523", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("Fault") .HasColumnType("int"); b.Property("Fault1") .HasColumnType("int"); b.Property("Fault2") .HasColumnType("int"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("Status") .HasColumnType("int"); b.Property("Status1") .HasColumnType("int"); b.Property("Status2") .HasColumnType("int"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_RGV523"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_Robot", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("FinishedTask") .HasColumnType("int"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("Mode") .HasColumnType("smallint"); b.Property("Status") .HasColumnType("smallint"); b.Property("Target") .HasColumnType("smallint"); b.Property("TaskID") .HasColumnType("int"); b.Property("Trigger") .HasColumnType("smallint"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_Robot"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_RobotStation", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("DocId") .HasColumnType("int"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("MaxQty") .HasColumnType("smallint"); b.Property("PalletType") .HasColumnType("smallint"); b.Property("Qty") .HasColumnType("smallint"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_RobotStation"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC520", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ECol") .HasColumnType("smallint"); b.Property("EDepth") .HasColumnType("smallint"); b.Property("ELayer") .HasColumnType("smallint"); b.Property("ELine") .HasColumnType("smallint"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("Endnumber2") .HasColumnType("smallint"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("FinishedACK") .HasColumnType("smallint"); b.Property("GoodsType") .HasColumnType("smallint"); b.Property("Handshake") .HasColumnType("smallint"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("SCol") .HasColumnType("smallint"); b.Property("SDepth") .HasColumnType("smallint"); b.Property("SLayer") .HasColumnType("smallint"); b.Property("SLine") .HasColumnType("smallint"); b.Property("SpeedMode") .HasColumnType("smallint"); b.Property("Startnumber1") .HasColumnType("smallint"); b.Property("TaskID") .HasColumnType("int"); b.Property("Trigger") .HasColumnType("smallint"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_SC520"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC521", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("Alarm") .HasColumnType("bit"); b.Property("Col") .HasColumnType("smallint"); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ECol") .HasColumnType("smallint"); b.Property("EDepth") .HasColumnType("smallint"); b.Property("ELayer") .HasColumnType("smallint"); b.Property("ELine") .HasColumnType("smallint"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("Endnumber2") .HasColumnType("smallint"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("FinishedTask") .HasColumnType("int"); b.Property("ForkCenter") .HasColumnType("bit"); b.Property("ForkPos") .HasColumnType("int"); b.Property("GetFinishi") .HasColumnType("bit"); b.Property("GoodsType") .HasColumnType("smallint"); b.Property("Handshake") .HasColumnType("bit"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("Layer") .HasColumnType("smallint"); b.Property("LiftPos") .HasColumnType("int"); b.Property("Line") .HasColumnType("smallint"); b.Property("Loaded") .HasColumnType("bit"); b.Property("Mode") .HasColumnType("smallint"); b.Property("PutFinishi") .HasColumnType("bit"); b.Property("RES") .HasColumnType("tinyint"); b.Property("Runtime") .HasColumnType("real"); b.Property("SCol") .HasColumnType("smallint"); b.Property("SDepth") .HasColumnType("smallint"); b.Property("SLayer") .HasColumnType("smallint"); b.Property("SLine") .HasColumnType("smallint"); b.Property("Status") .HasColumnType("smallint"); b.Property("TaskFinishi") .HasColumnType("bit"); b.Property("TaskID") .HasColumnType("int"); b.Property("TotalKM") .HasColumnType("real"); b.Property("TravelPos") .HasColumnType("int"); b.Property("Trigger") .HasColumnType("smallint"); b.Property("Tunnel") .HasColumnType("smallint"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_SC521"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC537", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("SCAlarm") .HasColumnType("decimal(20,0)"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_SC537"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION520", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("CONFIRM") .HasColumnType("bit"); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("GOODSCODE") .HasColumnType("int"); b.Property("GOODSEND") .HasColumnType("smallint"); b.Property("GOODSSIZE") .HasColumnType("smallint"); b.Property("GOODSSTART") .HasColumnType("smallint"); b.Property("GOODSTYPE") .HasColumnType("smallint"); b.Property("HEIGHT") .HasColumnType("int"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("RES") .HasColumnType("bit"); b.Property("RES2") .HasColumnType("tinyint"); b.Property("TASKNUM") .HasColumnType("int"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_STATION520"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION521", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("BCR_NOREAD") .HasColumnType("bit"); b.Property("B_OUTSIDE") .HasColumnType("bit"); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("F_OUTSIDE") .HasColumnType("bit"); b.Property("GOODSCODE") .HasColumnType("int"); b.Property("GOODSEND") .HasColumnType("smallint"); b.Property("GOODSSIZE") .HasColumnType("smallint"); b.Property("GOODSSTART") .HasColumnType("smallint"); b.Property("GOODSTYPE") .HasColumnType("smallint"); b.Property("GOODS_ERR") .HasColumnType("bit"); b.Property("HEIGHT") .HasColumnType("smallint"); b.Property("H_OUTSIDE") .HasColumnType("bit"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("L_OUTSIDE") .HasColumnType("bit"); b.Property("OVERLOAD") .HasColumnType("bit"); b.Property("PH_STATUS") .HasColumnType("bit"); b.Property("PH_STATUS2") .HasColumnType("bit"); b.Property("REQUEST") .HasColumnType("bit"); b.Property("RES") .HasColumnType("bit"); b.Property("RES1") .HasColumnType("bit"); b.Property("RES2") .HasColumnType("bit"); b.Property("RES4") .HasColumnType("bit"); b.Property("RES5") .HasColumnType("bit"); b.Property("R_OUTSIDE") .HasColumnType("bit"); b.Property("TASKNUM") .HasColumnType("int"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_STATION521"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION523", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("Fault") .HasColumnType("bigint"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("RunTime") .HasColumnType("real"); b.Property("Status") .HasColumnType("smallint"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_STATION523"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_StatusLog", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("ENABLED") .HasColumnType("bit"); b.Property("NewStatus") .HasColumnType("int"); b.Property("Node") .HasColumnType("nvarchar(max)"); b.Property("OldStatus") .HasColumnType("int"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCS_TASKID") .HasColumnType("int"); b.Property("upStatus") .HasColumnType("int"); b.HasKey("ID"); b.ToTable("WCS_StatusLog"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_SystemConfig", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("Code") .HasColumnType("nvarchar(max)"); b.Property("DEVICECODE") .HasColumnType("nvarchar(max)"); b.Property("Describe") .HasColumnType("nvarchar(max)"); b.Property("Direction") .HasColumnType("nvarchar(max)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("TUNNEL") .HasColumnType("nvarchar(max)"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.HasKey("ID"); b.ToTable("WCS_SystemConfig"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_Users", b => { b.Property("USER_NO") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property("USER_PWD") .IsRequired() .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property("USER_TEXT") .HasColumnType("varbinary(max)"); b.HasKey("USER_NO"); b.ToTable("WCS_Users"); }); modelBuilder.Entity("WCS.Entity.WCS_CMD", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DEVICE_CODE") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("PROPERTY") .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.Property("PROTOCOL") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VALUE") .HasMaxLength(512) .HasColumnType("nvarchar(512)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WCSVERSION") .HasColumnType("int"); b.HasKey("ID"); b.ToTable("WCS_CMD"); }); modelBuilder.Entity("WCS.Entity.WCS_DATABLOCK", b => { b.Property("CODE") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("DATALENGTH") .HasColumnType("int"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("LENGTH") .HasColumnType("int"); b.Property("NAME") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("NO") .HasColumnType("int"); b.Property("NOUPDATE") .HasColumnType("bit"); b.Property("PLCCODE") .HasColumnType("nvarchar(20)"); b.Property("PROTOCOL") .IsRequired() .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.HasKey("CODE"); b.HasIndex("PLCCODE"); b.ToTable("WCS_DATABLOCK"); }); modelBuilder.Entity("WCS.Entity.WCS_DEVICE", b => { b.Property("CODE") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("NAME") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.HasKey("CODE"); b.ToTable("WCS_DEVICE"); }); modelBuilder.Entity("WCS.Entity.WCS_DEVICEPROTOCOL", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DBCODE") .HasColumnType("nvarchar(20)"); b.Property("DEVICECODE") .IsRequired() .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("POSITION") .HasColumnType("smallint"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.HasKey("ID"); b.HasIndex("DBCODE"); b.HasIndex("DEVICECODE"); b.ToTable("WCS_DEVICEPROTOCOL"); }); modelBuilder.Entity("WCS.Entity.WCS_EXCEPTION", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("ENABLED") .HasColumnType("bit"); b.Property("MSG") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property("STARTTIME") .HasColumnType("datetime2"); b.Property("TIMES") .HasColumnType("int"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.HasKey("ID"); b.ToTable("WCS_EXCEPTION"); }); modelBuilder.Entity("WCS.Entity.WCS_PATH", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("ENABLED") .HasColumnType("bit"); b.Property("ENDCODE") .HasColumnType("nvarchar(50)"); b.Property("PATH") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("STARTCODE") .IsRequired() .HasColumnType("nvarchar(50)"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.HasKey("ID"); b.HasIndex("ENDCODE"); b.HasIndex("STARTCODE"); b.ToTable("WCS_PATH"); }); modelBuilder.Entity("WCS.Entity.WCS_PATHPOINT", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("ENDCODE") .HasColumnType("nvarchar(50)"); b.Property("NEXTCODE") .HasColumnType("nvarchar(50)"); b.Property("PREVCODE") .HasColumnType("nvarchar(50)"); b.Property("STARTCODE") .HasColumnType("nvarchar(50)"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.HasIndex("ENDCODE"); b.HasIndex("NEXTCODE"); b.HasIndex("PREVCODE"); b.HasIndex("STARTCODE"); b.ToTable("WCS_PATHPOINT"); }); modelBuilder.Entity("WCS.Entity.WCS_PLC", b => { b.Property("CODE") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("IP") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("MODEL") .HasMaxLength(10) .HasColumnType("nvarchar(10)"); b.Property("NAME") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("PORT") .HasColumnType("int"); b.Property("RACK") .HasColumnType("int"); b.Property("SLOT") .HasColumnType("int"); b.Property("TYPE") .HasColumnType("int"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.HasKey("CODE"); b.ToTable("WCS_PLC"); }); modelBuilder.Entity("WCS.Entity.WCS_ROUTE", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DEVICECODE") .IsRequired() .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("NEXTCODE") .HasColumnType("nvarchar(50)"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.HasKey("ID"); b.HasIndex("DEVICECODE"); b.HasIndex("NEXTCODE"); b.ToTable("WCS_ROUTE"); }); modelBuilder.Entity("WCS.Entity.WCS_TASK", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("ADDRFROM") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("ADDRNEXT") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("ADDRTO") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("AgvTask") .HasColumnType("int"); b.Property("BARCODE") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("CREATETIME") .HasColumnType("datetime2"); b.Property("DEVICE") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("DOCID") .HasColumnType("int"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("ENDTIME") .HasColumnType("datetime2"); b.Property("FLOOR") .HasColumnType("int"); b.Property("FULLQTY") .HasColumnType("smallint"); b.Property("GROUPTASK") .HasColumnType("int"); b.Property("HEIGHT") .HasColumnType("smallint"); b.Property("PALLETTYPE") .HasColumnType("smallint"); b.Property("PRODLINE") .HasColumnType("smallint"); b.Property("Priority") .HasColumnType("int"); b.Property("SCSTATION") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("STARTTIME") .HasColumnType("datetime2"); b.Property("STATUS") .HasColumnType("int"); b.Property("TUNNEL") .HasMaxLength(10) .HasColumnType("nvarchar(10)"); b.Property("TYPE") .HasColumnType("int"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("UPLOADED") .HasColumnType("int"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WMSTASK") .HasColumnType("int"); b.HasKey("ID"); b.ToTable("WCS_TASK"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_BCR80", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_DRGV520", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_DRGV521", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_DRGV523", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV520", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV521", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV523", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_Robot", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_RobotStation", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC520", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC521", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC537", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION520", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION521", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION523", 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("PLCCODE"); b.Navigation("PLC"); }); modelBuilder.Entity("WCS.Entity.WCS_DEVICEPROTOCOL", b => { b.HasOne("WCS.Entity.WCS_DATABLOCK", "DB") .WithMany() .HasForeignKey("DBCODE"); 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_PATH", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "END") .WithMany() .HasForeignKey("ENDCODE"); b.HasOne("WCS.Entity.WCS_DEVICE", "START") .WithMany("PATHS") .HasForeignKey("STARTCODE") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("END"); b.Navigation("START"); }); modelBuilder.Entity("WCS.Entity.WCS_PATHPOINT", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.HasOne("WCS.Entity.WCS_DEVICE", "END") .WithMany() .HasForeignKey("ENDCODE"); b.HasOne("WCS.Entity.WCS_DEVICE", "NEXT") .WithMany() .HasForeignKey("NEXTCODE"); b.HasOne("WCS.Entity.WCS_DEVICE", "PREV") .WithMany() .HasForeignKey("PREVCODE"); b.HasOne("WCS.Entity.WCS_DEVICE", "START") .WithMany() .HasForeignKey("STARTCODE"); b.Navigation("DEVICE"); b.Navigation("END"); b.Navigation("NEXT"); b.Navigation("PREV"); b.Navigation("START"); }); modelBuilder.Entity("WCS.Entity.WCS_ROUTE", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany("ROUTES") .HasForeignKey("DEVICECODE") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("WCS.Entity.WCS_DEVICE", "NEXT") .WithMany() .HasForeignKey("NEXTCODE"); b.Navigation("DEVICE"); b.Navigation("NEXT"); }); modelBuilder.Entity("WCS.Entity.WCS_DEVICE", b => { b.Navigation("PATHS"); b.Navigation("PROTOCOLS"); b.Navigation("ROUTES"); }); #pragma warning restore 612, 618 } } }