// using System; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; using WCS.Service; #nullable disable namespace WCS.Service.Migrations { [DbContext(typeof(WCSDB))] partial class WCSDBModelSnapshot : ModelSnapshot { protected override void BuildModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("ProductVersion", "6.0.3") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1); modelBuilder.Entity("WCS.Entity.Protocol.BCR.WCS_BCR80", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("Content") .IsRequired() .HasMaxLength(130) .HasColumnType("nvarchar(130)"); 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.Station.WCS_Station50", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("G_BCR_NoRead") .HasColumnType("bit"); b.Property("G_B_Outside") .HasColumnType("bit"); b.Property("G_F_Outside") .HasColumnType("bit"); b.Property("G_GoodsCode") .HasColumnType("int"); b.Property("G_GoodsEnd") .HasColumnType("smallint"); b.Property("G_GoodsError") .HasColumnType("bit"); b.Property("G_GoodsSize") .HasColumnType("smallint"); b.Property("G_GoodsStart") .HasColumnType("smallint"); b.Property("G_GoodsType") .HasColumnType("smallint"); b.Property("G_H_Outside") .HasColumnType("bit"); b.Property("G_Height") .HasColumnType("smallint"); b.Property("G_L_Outside") .HasColumnType("bit"); b.Property("G_Notask") .HasColumnType("bit"); b.Property("G_Overload") .HasColumnType("bit"); b.Property("G_PhStatus") .HasColumnType("bit"); b.Property("G_R_Outside") .HasColumnType("bit"); b.Property("G_Request") .HasColumnType("bit"); b.Property("G_Station_Ready") .HasColumnType("bit"); b.Property("G_TaskId") .HasColumnType("int"); b.Property("G_Weight") .HasColumnType("smallint"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("S_AGV_Get_OK") .HasColumnType("bit"); b.Property("S_AGV_Put_OK") .HasColumnType("bit"); b.Property("S_Confirm") .HasColumnType("bit"); b.Property("S_GoodsCode") .HasColumnType("int"); b.Property("S_GoodsEnd") .HasColumnType("smallint"); b.Property("S_GoodsSize") .HasColumnType("smallint"); b.Property("S_GoodsStart") .HasColumnType("smallint"); b.Property("S_GoodsType") .HasColumnType("smallint"); b.Property("S_Height") .HasColumnType("smallint"); b.Property("S_TaskDelete") .HasColumnType("bit"); b.Property("S_TaskId") .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_STATION50"); }); modelBuilder.Entity("WCS.Entity.Protocol.Station.WCS_Station70", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("Alarm") .HasColumnType("int"); b.Property("DEVICECODE") .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("FRAME") .HasColumnType("datetime2"); b.Property("ISLAST") .HasColumnType("bit"); b.Property("RES") .HasColumnType("smallint"); b.Property("RunTime") .HasColumnType("real"); b.Property("Status") .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_STATION70"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_AGVTask", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("AGVID") .IsRequired() .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") .IsRequired() .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_MAPPINGENTRY", b => { b.Property("MEP_ID") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("MEP_ID"), 1L, 1); 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") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); 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("RES2_1") .HasColumnType("smallint"); b.Property("RES2_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("int"); b.Property("Trigger_2") .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_RGV520"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV521", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); 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("RES1_1") .HasColumnType("smallint"); b.Property("RES1_2") .HasColumnType("smallint"); b.Property("RES2_1") .HasColumnType("smallint"); b.Property("RES2_2") .HasColumnType("smallint"); b.Property("RES3_1") .HasColumnType("bit"); b.Property("RES3_2") .HasColumnType("bit"); b.Property("RES4_1") .HasColumnType("bit"); b.Property("RES4_2") .HasColumnType("bit"); b.Property("RES5_1") .HasColumnType("bit"); b.Property("RES5_2") .HasColumnType("bit"); b.Property("RES6_1") .HasColumnType("bit"); b.Property("RES6_2") .HasColumnType("bit"); b.Property("RES7_1") .HasColumnType("bit"); b.Property("RES7_2") .HasColumnType("bit"); 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("Trigger_1") .HasColumnType("int"); b.Property("Trigger_2") .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.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") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); 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_StatusLog", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("ENABLED") .HasColumnType("bit"); b.Property("NewStatus") .HasColumnType("int"); b.Property("Node") .IsRequired() .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") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("Code") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("DEVICECODE") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("Describe") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("Direction") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("TUNNEL") .IsRequired() .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") .IsRequired() .HasColumnType("varbinary(max)"); b.HasKey("USER_NO"); b.ToTable("WCS_Users"); }); modelBuilder.Entity("WCS.Entity.WCS_CMD", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); 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") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("DBCODE") .IsRequired() .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") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); 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") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("ENABLED") .HasColumnType("bit"); b.Property("ENDCODE") .IsRequired() .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") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("DEVICECODE") .IsRequired() .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("ENDCODE") .IsRequired() .HasColumnType("nvarchar(50)"); b.Property("NEXTCODE") .HasColumnType("nvarchar(50)"); b.Property("PREVCODE") .HasColumnType("nvarchar(50)"); 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("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") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("DEVICECODE") .IsRequired() .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("NEXTCODE") .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("DEVICECODE"); b.HasIndex("NEXTCODE"); b.ToTable("WCS_ROUTE"); }); modelBuilder.Entity("WCS.Entity.WCS_TASK", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("ADDRFROM") .IsRequired() .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("ADDRNEXT") .IsRequired() .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("ADDRTO") .IsRequired() .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("AgvTask") .HasColumnType("int"); b.Property("BARCODE") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("CREATETIME") .HasColumnType("datetime2"); b.Property("DEVICE") .IsRequired() .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("HEIGHT") .HasColumnType("smallint"); b.Property("ManualRemarks") .HasColumnType("nvarchar(max)"); b.Property("PALLETTYPE") .HasColumnType("smallint"); b.Property("PRODLINE") .HasColumnType("smallint"); b.Property("Priority") .HasColumnType("int"); b.Property("SCSTATION") .IsRequired() .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("STARTTIME") .HasColumnType("datetime2"); b.Property("STATUS") .HasColumnType("int"); b.Property("TUNNEL") .IsRequired() .HasMaxLength(10) .HasColumnType("nvarchar(10)"); b.Property("TYPE") .HasColumnType("int"); b.Property("TaskGroupKey") .IsRequired() .HasColumnType("nvarchar(max)"); 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.BCR.WCS_BCR80", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.Station.WCS_Station50", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.Station.WCS_Station70", 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.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") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); 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") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); 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") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("WCS.Entity.WCS_DEVICE", "END") .WithMany() .HasForeignKey("ENDCODE") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); 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") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); 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") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); 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 } } }