// using System; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; using Ropin.Inspection.Model.Entities; namespace Ropin.Inspection.Model.Migrations { [DbContext(typeof(InspectionDbContext))] [Migration("20211125073707_EditPRD")] partial class EditPRD { protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("Relational:MaxIdentifierLength", 64) .HasAnnotation("ProductVersion", "5.0.4"); modelBuilder.Entity("Ropin.Inspection.Model.Entities.Report", b => { b.Property("G_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_Data") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("C_GroupName") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("C_Name") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("C_Status") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("D_CreateTime") .HasColumnType("datetime(6)"); b.Property("D_End") .HasColumnType("datetime(6)"); b.Property("D_Start") .HasColumnType("datetime(6)"); b.Property("I_Type") .HasColumnType("int"); b.HasKey("G_ID"); b.ToTable("Report"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TBDM_Area", b => { b.Property("C_Code") .HasMaxLength(20) .HasColumnType("varchar(20) CHARACTER SET utf8mb4"); b.Property("C_CityCode") .IsRequired() .HasMaxLength(20) .HasColumnType("varchar(20) CHARACTER SET utf8mb4"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_Code"); b.HasIndex("C_CityCode"); b.ToTable("TBDM_Area"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TBDM_City", b => { b.Property("C_Code") .HasMaxLength(20) .HasColumnType("varchar(20) CHARACTER SET utf8mb4"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_ProvCode") .IsRequired() .HasMaxLength(20) .HasColumnType("varchar(20) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_Code"); b.HasIndex("C_ProvCode"); b.ToTable("TBDM_City"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TBDM_CodeDetail", b => { b.Property("C_Code") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_Default") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_IsSys") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_MainCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_Value") .IsRequired() .HasMaxLength(255) .HasColumnType("varchar(255) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_Code"); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.ToTable("TBDM_CodeDetail"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TBDM_CodeMain", b => { b.Property("C_Code") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_Code"); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.ToTable("TBDM_CodeMain"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TBDM_Prov", b => { b.Property("C_Code") .HasMaxLength(20) .HasColumnType("varchar(20) CHARACTER SET utf8mb4"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_Code"); b.ToTable("TBDM_Prov"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_Content", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_AlarmLevel") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_ID"); b.ToTable("TISP_Content"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_ContentGroup", b => { b.Property("G_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_PatrolItem") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("G_CreateBy") .HasColumnType("char(36)"); b.Property("G_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("I_Sort") .HasColumnType("int"); b.Property("I_Type") .HasColumnType("int"); b.HasKey("G_ID"); b.ToTable("TISP_ContentGroup"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_ContentGroupItem", b => { b.Property("G_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("G_ContentCode") .HasColumnType("char(36)"); b.Property("G_ContentGroupCode") .HasColumnType("char(36)"); b.HasKey("G_ID"); b.ToTable("TISP_ContentGroupItem"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_Record", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_SpotCode") .HasColumnType("char(36)"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_ID"); b.ToTable("TISP_Record"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_RecordAlarm", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_InspectionRecordCode") .HasColumnType("char(36)"); b.Property("C_SpotContentCode") .HasColumnType("char(36)"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.HasKey("C_ID"); b.ToTable("TISP_RecordAlarm"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_RecordImage", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_ImageURL") .IsRequired() .HasMaxLength(200) .HasColumnType("varchar(200) CHARACTER SET utf8mb4"); b.Property("C_RecordItemCode") .HasColumnType("char(36)"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.HasKey("C_ID"); b.ToTable("TISP_RecordImage"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_RecordItem", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_ContentCode") .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasMaxLength(50) .HasColumnType("char(50)"); b.Property("C_InspectionContent") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasMaxLength(50) .HasColumnType("char(50)"); b.Property("C_RecordCode") .HasColumnType("char(36)"); b.Property("C_Remark") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_ID"); b.ToTable("TISP_RecordItem"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_Region", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasMaxLength(50) .HasColumnType("char(50)"); b.Property("C_ImageUrl") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasMaxLength(50) .HasColumnType("char(50)"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_ID"); b.ToTable("TISP_Region"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_Route", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasMaxLength(50) .HasColumnType("char(50)"); b.Property("C_ImageUrl") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasMaxLength(50) .HasColumnType("char(50)"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_ID"); b.ToTable("TISP_Route"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_Spot", b => { b.Property("C_Code") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasMaxLength(50) .HasColumnType("char(50)"); b.Property("C_GPS") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_ImageUrl") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasMaxLength(50) .HasColumnType("char(50)"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Number") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Position") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_QRCode") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("I_Offset") .HasColumnType("int"); b.HasKey("C_Code"); b.ToTable("TISP_Spot"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_SpotContent", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_ContentCode") .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_SpotCode") .HasColumnType("char(36)"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_ID"); b.ToTable("TISP_SpotContent"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_SpotRegion", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_RegionCode") .HasColumnType("char(36)"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_SpotCode") .HasColumnType("char(36)"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_ID"); b.ToTable("TISP_SpotRegion"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_SpotRoute", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_RouteCode") .HasColumnType("char(36)"); b.Property("C_SpotCode") .HasColumnType("char(36)"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_ID"); b.ToTable("TISP_SpotRoute"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TISP_SpotUser", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_SpotCode") .HasColumnType("char(36)"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_UserCode") .HasColumnType("char(36)"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_ID"); b.ToTable("TISP_SpotUser"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPNT_Area", b => { b.Property("C_Code") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_ImageUrl") .HasMaxLength(255) .HasColumnType("varchar(255) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Name") .IsRequired() .HasMaxLength(255) .HasColumnType("varchar(255) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_SName") .HasMaxLength(16) .HasColumnType("varchar(16) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_StoreCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_Code"); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.ToTable("TPNT_Area"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPNT_Store", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_Address") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_AreaCode") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Code") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_GPS") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_LicenseCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Name") .IsRequired() .HasMaxLength(255) .HasColumnType("varchar(255) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_SName") .HasMaxLength(16) .HasColumnType("varchar(16) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_TypeCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_ID"); b.HasIndex("C_AreaCode"); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.ToTable("TPNT_Store"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPNT_StoreOrg", b => { b.Property("C_StoreCode") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_OrgCode") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.HasKey("C_StoreCode", "C_OrgCode"); b.HasIndex("C_CreateBy"); b.ToTable("TPNT_StoreOrg"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPNT_Type", b => { b.Property("C_Code") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_Code"); b.ToTable("TPNT_Type"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPRD_Log", b => { b.Property("C_Code") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_AlarmMsg") .HasMaxLength(1024) .HasColumnType("varchar(1024) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_DeviceCode") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_ProductCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(1024) .HasColumnType("varchar(1024) CHARACTER SET utf8mb4"); b.Property("C_SpotCode") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_StoreCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("I_Type") .HasColumnType("int"); b.HasKey("C_Code"); b.ToTable("TPRD_Log"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPRD_ProdSKU", b => { b.Property("C_SKUCode") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_Brand") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_IconPath") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_ImagePath") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Name") .IsRequired() .HasMaxLength(255) .HasColumnType("varchar(255) CHARACTER SET utf8mb4"); b.Property("C_ProdArea") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Spec") .IsRequired() .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_TypeCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Unit") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Vender") .IsRequired() .HasMaxLength(255) .HasColumnType("varchar(255) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("I_AlarmDays") .HasColumnType("int"); b.Property("I_MinStock") .HasColumnType("int"); b.Property("I_Sort") .HasColumnType("int"); b.Property("I_ValiDays") .HasColumnType("int"); b.HasKey("C_SKUCode"); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.ToTable("TPRD_ProdSKU"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPRD_Product", b => { b.Property("C_Code") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_AlarmMsg") .IsRequired() .HasMaxLength(1024) .HasColumnType("varchar(1024) CHARACTER SET utf8mb4"); b.Property("C_AreaCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_DeviceCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_ImageUrl") .IsRequired() .HasMaxLength(255) .HasColumnType("varchar(255) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_QRCode") .IsRequired() .HasMaxLength(255) .HasColumnType("varchar(255) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(1024) .HasColumnType("varchar(1024) CHARACTER SET utf8mb4"); b.Property("C_SKUCode") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_SpotCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_StoreCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastISP") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("D_ProdDate") .HasColumnType("datetime(6)"); b.Property("D_ValiDate") .HasColumnType("datetime(6)"); b.Property("F_Map_X") .HasColumnType("decimal(12,2)"); b.Property("F_Map_Y") .HasColumnType("decimal(12,2)"); b.Property("I_IsAlarm") .HasColumnType("int"); b.Property("I_Sort") .HasColumnType("int"); b.Property("I_Status") .HasColumnType("int"); b.HasKey("C_Code"); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.ToTable("TPRD_Product"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPRD_Type", b => { b.Property("C_Code") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("I_IfFPP") .HasColumnType("int"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_Code"); b.HasIndex("C_CreateBy"); b.ToTable("TPRD_Type"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSEC_Record", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_SecurityContent") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("C_SpotCode") .HasColumnType("char(36)"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_ID"); b.ToTable("TSEC_Record"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSEC_RecordImage", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_ImageURL") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_SecurityRecordCode") .HasColumnType("char(36)"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.HasKey("C_ID"); b.ToTable("TSEC_RecordImage"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSEC_RecordItem", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_RecordItemCode") .HasColumnType("char(36)"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_SecurityContent") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_ID"); b.ToTable("TSEC_RecordItem"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_License", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_Code") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_FilePath") .IsRequired() .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Name") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_TypeCode") .HasColumnType("char(36)"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_EndDate") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("D_StartDate") .HasColumnType("datetime(6)"); b.Property("I_DiskCapacity") .HasColumnType("int"); b.Property("I_MemberQty") .HasColumnType("int"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_ID"); b.HasIndex("C_Code") .IsUnique(); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.HasIndex("C_TypeCode"); b.ToTable("TSYS_License"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_LicenseType", b => { b.Property("C_Code") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Name") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("I_MaxFileSize") .HasColumnType("int"); b.Property("I_MaxMemberQty") .HasColumnType("int"); b.Property("I_MaxStoreQty") .HasColumnType("int"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_Code"); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.ToTable("TSYS_LicenseType"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_LicenseTypePriv", b => { b.Property("C_LicenseTypeCode") .HasColumnType("char(36)"); b.Property("C_PrivilegeCode") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.HasKey("C_LicenseTypeCode", "C_PrivilegeCode"); b.HasIndex("C_CreateBy"); b.HasIndex("C_PrivilegeCode"); b.ToTable("TSYS_LicenseTypePriv"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_Message", b => { b.Property("C_Code") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_Content") .IsRequired() .HasMaxLength(1000) .HasColumnType("varchar(1000) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_LicenseCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_RelatedID") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_RelatedModule") .HasMaxLength(200) .HasColumnType("varchar(200) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_Type") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_UserID") .HasColumnType("char(36)"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_Code"); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.HasIndex("C_UserID"); b.ToTable("TSYS_Message"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_Org", b => { b.Property("K_ID") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("C_Code") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_GIS") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Level") .IsRequired() .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_LicenseCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Linker") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Lname") .HasMaxLength(2550) .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("C_Name") .IsRequired() .HasMaxLength(255) .HasColumnType("varchar(255) CHARACTER SET utf8mb4"); b.Property("C_ParentCode") .HasColumnType("int"); b.Property("C_Phone") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_SName") .HasMaxLength(16) .HasColumnType("varchar(16) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_Type") .HasColumnType("char(36)"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("K_ID"); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.HasIndex("C_ParentCode"); b.ToTable("TSYS_Org"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_Organize", b => { b.Property("G_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_Address") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_GPS") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_ImageUrl") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Number") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_ParentCodeList") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_ParentName") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("G_CreateBy") .HasColumnType("char(36)"); b.Property("G_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("G_ParentCode") .HasColumnType("char(36)"); b.Property("I_Layer") .HasColumnType("int"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("G_ID"); b.ToTable("TSYS_Organize"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_Post", b => { b.Property("G_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_Code") .IsRequired() .HasMaxLength(20) .HasColumnType("varchar(20) CHARACTER SET utf8mb4"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("G_CreateBy") .HasColumnType("char(36)"); b.Property("G_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("G_ID"); b.ToTable("TSYS_Post"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_Priv", b => { b.Property("C_Code") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_ImageUrl") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Module") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Name") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_PageUrl") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_ParentCode") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_Type") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_Code"); b.HasIndex("C_ParentCode"); b.ToTable("TSYS_Priv"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_Role", b => { b.Property("C_Code") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_Description") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_LicenseCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Name") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_Code"); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.ToTable("TSYS_Role"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_RolePriv", b => { b.Property("C_RoleCode") .HasColumnType("char(36)"); b.Property("C_PrivilegeCode") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("I_Type") .HasColumnType("int"); b.HasKey("C_RoleCode", "C_PrivilegeCode"); b.HasIndex("C_CreateBy"); b.ToTable("TSYS_RolePriv"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_User", b => { b.Property("C_UserID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_Address") .HasMaxLength(255) .HasColumnType("varchar(255) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_Email") .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_IDNum") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_ImagePath") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_LicenseCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_Mobile") .HasMaxLength(20) .HasColumnType("varchar(20) CHARACTER SET utf8mb4"); b.Property("C_Name") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_OrgCode") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_Password") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_Phone") .HasMaxLength(20) .HasColumnType("varchar(20) CHARACTER SET utf8mb4"); b.Property("C_Post") .HasColumnType("char(36)"); b.Property("C_ProgramID") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("C_Remark") .HasMaxLength(500) .HasColumnType("varchar(500) CHARACTER SET utf8mb4"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_UserName") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_WechatID") .HasMaxLength(100) .HasColumnType("varchar(100) CHARACTER SET utf8mb4"); b.Property("D_BirthDay") .HasColumnType("datetime(6)"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.Property("I_Render") .HasColumnType("int"); b.Property("I_Sort") .HasColumnType("int"); b.HasKey("C_UserID"); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.ToTable("TSYS_User"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_UserPost", b => { b.Property("G_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("G_CreateBy") .HasColumnType("char(36)"); b.Property("G_PostCode") .HasColumnType("char(36)"); b.Property("G_UserCode") .HasColumnType("char(36)"); b.HasKey("G_ID"); b.ToTable("TSYS_UserPost"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_UserRole", b => { b.Property("C_UserCode") .HasColumnType("char(36)"); b.Property("C_RoleCode") .HasColumnType("char(36)"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.HasKey("C_UserCode", "C_RoleCode"); b.HasIndex("C_CreateBy"); b.HasIndex("C_RoleCode"); b.ToTable("TSYS_UserRole"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_Version", b => { b.Property("C_ID") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("C_AppCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("C_CreateBy") .HasColumnType("char(36)"); b.Property("C_DownloadURL") .IsRequired() .HasMaxLength(1000) .HasColumnType("varchar(1000) CHARACTER SET utf8mb4"); b.Property("C_LastUpdatedBy") .HasColumnType("char(36)"); b.Property("C_Status") .IsRequired() .HasMaxLength(1) .HasColumnType("varchar(1) CHARACTER SET utf8mb4"); b.Property("C_UpdateContent") .IsRequired() .HasMaxLength(1000) .HasColumnType("varchar(1000) CHARACTER SET utf8mb4"); b.Property("C_VersionCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("D_CreateOn") .HasColumnType("datetime(6)"); b.Property("D_LastUpdatedOn") .HasColumnType("datetime(6)"); b.HasKey("C_ID"); b.HasIndex("C_CreateBy"); b.HasIndex("C_LastUpdatedBy"); b.ToTable("TSYS_Version"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TaskInfoDto", b => { b.Property("jobId") .HasColumnType("varchar(255) CHARACTER SET utf8mb4"); b.Property("TasksQzId") .HasColumnType("char(36)"); b.Property("jobGroup") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("jobName") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("triggerGroup") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("triggerId") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("triggerName") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("triggerStatus") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.HasKey("jobId"); b.HasIndex("TasksQzId"); b.ToTable("TaskInfoDto"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TasksQz", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("AssemblyName") .HasMaxLength(200) .HasColumnType("varchar(200) CHARACTER SET utf8mb4"); b.Property("BeginTime") .IsRequired() .HasColumnType("datetime(6)"); b.Property("C_LicenseCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50) CHARACTER SET utf8mb4"); b.Property("ClassName") .HasMaxLength(200) .HasColumnType("varchar(200) CHARACTER SET utf8mb4"); b.Property("CreateBy") .HasColumnType("char(36)"); b.Property("CreateTime") .HasColumnType("datetime(6)"); b.Property("Cron") .HasMaxLength(200) .HasColumnType("varchar(200) CHARACTER SET utf8mb4"); b.Property("CycleRunTimes") .HasColumnType("int"); b.Property("EndTime") .IsRequired() .HasColumnType("datetime(6)"); b.Property("IntervalSecond") .HasColumnType("int"); b.Property("IsDeleted") .HasColumnType("tinyint(1)"); b.Property("IsStart") .HasColumnType("tinyint(1)"); b.Property("JobGroup") .HasMaxLength(200) .HasColumnType("varchar(200) CHARACTER SET utf8mb4"); b.Property("JobParams") .HasColumnType("longtext CHARACTER SET utf8mb4"); b.Property("Name") .HasMaxLength(200) .HasColumnType("varchar(200) CHARACTER SET utf8mb4"); b.Property("Remark") .HasMaxLength(1000) .HasColumnType("varchar(1000) CHARACTER SET utf8mb4"); b.Property("RunTimes") .HasColumnType("int"); b.Property("TriggerType") .HasColumnType("int"); b.HasKey("Id"); b.ToTable("TasksQz"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TBDM_Area", b => { b.HasOne("Ropin.Inspection.Model.Entities.TBDM_City", "CityCityCode") .WithMany() .HasForeignKey("C_CityCode") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("CityCityCode"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TBDM_City", b => { b.HasOne("Ropin.Inspection.Model.Entities.TBDM_Prov", "ProvProvCode") .WithMany() .HasForeignKey("C_ProvCode") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("ProvProvCode"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TBDM_CodeDetail", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TBDM_CodeMain", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPNT_Area", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPNT_Store", b => { b.HasOne("Ropin.Inspection.Model.Entities.TBDM_Area", "AreaAreaCode") .WithMany() .HasForeignKey("C_AreaCode"); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.Navigation("AreaAreaCode"); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPNT_StoreOrg", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("UsersCreateBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPRD_ProdSKU", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPRD_Product", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TPRD_Type", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("UsersCreateBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_License", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_LicenseType", "LicenseTypeTypeCode") .WithMany() .HasForeignKey("C_TypeCode") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("LicenseTypeTypeCode"); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_LicenseType", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_LicenseTypePriv", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_LicenseType", "LicenseTypeCode") .WithMany() .HasForeignKey("C_LicenseTypeCode") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_Priv", "PrivPrivilegeCode") .WithMany() .HasForeignKey("C_PrivilegeCode") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("LicenseTypeCode"); b.Navigation("PrivPrivilegeCode"); b.Navigation("UsersCreateBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_Message", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersUserID") .WithMany() .HasForeignKey("C_UserID") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); b.Navigation("UsersUserID"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_Org", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_Org", "OrgParentCode") .WithMany() .HasForeignKey("C_ParentCode") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("OrgParentCode"); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_Priv", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_Priv", "PrivPrivilegeCode") .WithMany() .HasForeignKey("C_ParentCode"); b.Navigation("PrivPrivilegeCode"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_Role", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_RolePriv", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_Role", "Roles") .WithMany() .HasForeignKey("C_RoleCode") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Roles"); b.Navigation("UsersCreateBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_User", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_UserRole", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_Role", "Roles") .WithMany() .HasForeignKey("C_RoleCode") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "Users") .WithMany() .HasForeignKey("C_UserCode") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Roles"); b.Navigation("Users"); b.Navigation("UsersCreateBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TSYS_Version", b => { b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersCreateBy") .WithMany() .HasForeignKey("C_CreateBy") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("Ropin.Inspection.Model.Entities.TSYS_User", "UsersLastUpdatedBy") .WithMany() .HasForeignKey("C_LastUpdatedBy"); b.Navigation("UsersCreateBy"); b.Navigation("UsersLastUpdatedBy"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TaskInfoDto", b => { b.HasOne("Ropin.Inspection.Model.Entities.TasksQz", null) .WithMany("Triggers") .HasForeignKey("TasksQzId"); }); modelBuilder.Entity("Ropin.Inspection.Model.Entities.TasksQz", b => { b.Navigation("Triggers"); }); #pragma warning restore 612, 618 } } }