using System; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; #nullable disable namespace Ropin.Inspection.Model.Entities { public partial class InspectionDbContext : DbContext { public InspectionDbContext() { } public InspectionDbContext(DbContextOptions options) : base(options) { } public DatabaseFacade GetDatabase() => Database; /// /// create DbSet /// /// 实体 /// public virtual DbSet GetDbSet() where T : class { if (Model.FindEntityType(typeof(T)) != null) { return Set(); } else { throw new Exception($"type {typeof(T).Name} is not add into DbContext "); } } public virtual DbSet TMTN_DevOpsContent { get; set; } public virtual DbSet TMTN_SpotDevOpsContent { get; set; } public virtual DbSet TMTN_DevOps { get; set; } public virtual DbSet TMTN_DevOpsRecord { get; set; } public virtual DbSet TMTN_DevOpsRecordApp { get; set; } public virtual DbSet TMTN_DevOperateRecord { get; set; } public virtual DbSet TMTN_DevOperateRecordApp { get; set; } public virtual DbSet TMTN_RepairOrderItemApp { get; set; } public virtual DbSet TMTN_RepairOrderItem { get; set; } public virtual DbSet TMTN_RepairOrder { get; set; } public virtual DbSet TMTN_PushMsgTo { get; set; } public virtual DbSet TMTN_PushMsgResult { get; set; } public virtual DbSet TDEV_DeviceArchives { get; set; } public virtual DbSet TDEV_DevSpot { get; set; } public virtual DbSet TDEV_DevOpeAccount { get; set; } public virtual DbSet TBDM_Area { get; set; } public virtual DbSet TBDM_City { get; set; } public virtual DbSet TBDM_CodeDetail { get; set; } public virtual DbSet TBDM_CodeMain { get; set; } public virtual DbSet TBDM_Prov { get; set; } public virtual DbSet TDEV_DevAlert { get; set; } public virtual DbSet TDEV_DevAlertConfig { get; set; } public virtual DbSet TDEV_DevDataConfig { get; set; } public virtual DbSet TDEV_DevData { get; set; } public virtual DbSet TDEV_Device { get; set; } public virtual DbSet TDEV_DeviceTemplate { get; set; } public virtual DbSet TDEV_BoxTemplate { get; set; } public virtual DbSet TDEV_Box { get; set; } public virtual DbSet TDEV_BoxDevSpot { get; set; } public virtual DbSet TDEV_DeviceTempArchives { get; set; } public virtual DbSet TDEV_MaintenanceKnowledge { get; set; } public virtual DbSet TDEV_MaintenanceTemplate { get; set; } public virtual DbSet TDEV_MaintenancePlan { get; set; } public virtual DbSet TDEV_DevStore { get; set; } public virtual DbSet TDEV_DevStoreMigrate { get; set; } public virtual DbSet TDEV_DevStoreDoc { get; set; } public virtual DbSet TDEV_DevStoreLog { get; set; } public virtual DbSet TDEV_DevicePart { get; set; } public virtual DbSet TDEV_DevicePartItem { get; set; } public virtual DbSet TDEV_WebScada { get; set; } public virtual DbSet TDEV_WebScadaDevSpot { get; set; } public virtual DbSet TISP_Content { get; set; } public virtual DbSet TISP_ContentGroup { get; set; } public virtual DbSet TISP_ContentGroupItem { get; set; } public virtual DbSet TISP_Record { get; set; } public virtual DbSet TISP_RecordImage { get; set; } public virtual DbSet TISP_RecordItem { get; set; } public virtual DbSet TISP_Report { get; set; } public virtual DbSet TISP_SecurityImage { get; set; } public virtual DbSet TISP_SecurityItem { get; set; } public virtual DbSet TISP_Spot { get; set; } public virtual DbSet TISP_SpotContent { get; set; } public virtual DbSet TISP_SpotUser { get; set; } public virtual DbSet TPNT_Area { get; set; } public virtual DbSet TPNT_Store { get; set; } public virtual DbSet TPNT_StoreOrg { get; set; } public virtual DbSet TPNT_Type { get; set; } public virtual DbSet TPRD_Log { get; set; } public virtual DbSet TPRD_ProdSKU { get; set; } public virtual DbSet TPRD_Product { get; set; } public virtual DbSet TPRD_Type { get; set; } public virtual DbSet TSYS_License { get; set; } public virtual DbSet TSYS_LicenseType { get; set; } public virtual DbSet TSYS_LicenseTypePriv { get; set; } public virtual DbSet TSYS_Message { get; set; } public virtual DbSet TSYS_MessageFile { get; set; } public virtual DbSet TSYS_Org { get; set; } public virtual DbSet TSYS_Priv { get; set; } public virtual DbSet TSYS_Role { get; set; } public virtual DbSet TSYS_RolePriv { get; set; } public virtual DbSet TSYS_User { get; set; } public virtual DbSet TSYS_UserRole { get; set; } public virtual DbSet TSYS_Version { get; set; } public virtual DbSet TaskInfoDto { get; set; } public virtual DbSet TasksQz { get; set; } public virtual DbSet TSYS_UserPost { get; set; } public virtual DbSet TISP_Region { get; set; } public virtual DbSet TSEC_Record { get; set; } //public virtual DbSet TSEC_RecordItem { get; set; } public virtual DbSet TISP_SpotRegion { get; set; } public virtual DbSet TISP_Route { get; set; } public virtual DbSet TISP_SpotRoute { get; set; } public virtual DbSet TDEV_DeviceTempOpsContent { get; set; } public virtual DbSet TDEV_MaintenancePlanContent { get; set; } public virtual DbSet TDEV_DevOpeAccountConfig { get; set; } public virtual DbSet TDEV_Hand { get; set; } public virtual DbSet TSYS_RoleHand { get; set; } public virtual DbSet TMTN_AlarmOrder { get; set; } public virtual DbSet TMTN_AlarmHandleRecord { get; set; } public virtual DbSet TMTN_AlarmHandleRecordApp { get; set; } public virtual DbSet TDEV_DevBoxMigrate { get; set; } public virtual DbSet TSYS_Login { get; set; } public virtual DbSet TLGS_LargeScreenTemplate { get; set; } public virtual DbSet TLGS_LargeScreen { get; set; } public virtual DbSet TSYS_LicenseLargeScreenTemplate { get; set; } public virtual DbSet TLGS_LargeScreenControl { get; set; } public virtual DbSet TLGS_LargeScreenEvent { get; set; } public virtual DbSet TDEV_DevBox { get; set; } public virtual DbSet TDEV_Cmd { get; set; } public virtual DbSet TDEV_Instruction { get; set; } public virtual DbSet TDEV_CmdInstruction { get; set; } public virtual DbSet TVMC_CameraTemplate { get; set; } public virtual DbSet TVMC_Camera { get; set; } public virtual DbSet TVMC_CameraMigrate { get; set; } public virtual DbSet TVMC_DevCamera { get; set; } public virtual DbSet TMTN_AlarmShadowRecord { get; set; } public virtual DbSet TaicAiboxTemplates { get; set; } public virtual DbSet TaicAiboxes { get; set; } public virtual DbSet TaicAiboxMigrates { get; set; } public virtual DbSet TaicDevAiboxes { get; set; } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { if (!optionsBuilder.IsConfigured) { #warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see http://go.microsoft.com/fwlink/?LinkId=723263. optionsBuilder.UseMySql("server=117.78.26.193;user id=root;password=Xhrz@2018;port=8635;persistsecurityinfo=True;database=SH_HB_Test;sslmode=None", Microsoft.EntityFrameworkCore.ServerVersion.FromString("5.7.21-mysql")); } } protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TBDM_Area"); entity.HasIndex(e => e.C_CityCode, "FK_TBDM_Area_C_CityCode"); entity.Property(e => e.C_Code) .HasColumnType("varchar(20)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CityCode) .IsRequired() .HasColumnType("varchar(20)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_CityCodeNavigation) .WithMany(p => p.TBDM_Areas) .HasForeignKey(d => d.C_CityCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TBDM_Area_C_CityCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TBDM_City"); entity.HasIndex(e => e.C_ProvCode, "FK_TBDM_City_C_ProvCode"); entity.Property(e => e.C_Code) .HasColumnType("varchar(20)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ProvCode) .IsRequired() .HasColumnType("varchar(20)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_ProvCodeNavigation) .WithMany(p => p.TBDM_Cities) .HasForeignKey(d => d.C_ProvCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TBDM_City_C_ProvCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TBDM_CodeDetail"); entity.HasIndex(e => e.C_CreateBy, "FK_TBDM_CodeDetail_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TBDM_CodeDetail_C_LastUpdatedBy"); entity.HasIndex(e => e.C_MainCode, "FK_TBDM_CodeDetail_C_MainCode"); entity.Property(e => e.C_Code) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Default) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'0'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_IsSys) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'0'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_MainCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Value) .IsRequired() .HasColumnType("varchar(255)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TBDM_CodeDetailC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TBDM_CodeDetail_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TBDM_CodeDetailC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TBDM_CodeDetail_C_LastUpdatedBy"); entity.HasOne(d => d.C_MainCodeNavigation) .WithMany(p => p.TBDM_CodeDetails) .HasForeignKey(d => d.C_MainCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TBDM_CodeDetail_C_MainCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TBDM_CodeMain"); entity.HasIndex(e => e.C_CreateBy, "FK_TBDM_CodeMain_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TBDM_CodeMain_C_LastUpdatedBy"); entity.Property(e => e.C_Code) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TBDM_CodeMainC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TBDM_CodeMain_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TBDM_CodeMainC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TBDM_CodeMain_C_LastUpdatedBy"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TBDM_Prov"); entity.Property(e => e.C_Code) .HasColumnType("varchar(20)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TDEV_DevAlert"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ConfigCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_DeviceCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Value) .IsRequired() .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TDEV_DevAlertConfig"); entity.HasIndex(e => e.C_CreateBy, "FK_TDEV_DevAlertConfig_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TDEV_DevAlertConfig_C_LastUpdatedBy"); entity.Property(e => e.C_Code) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(1024)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TDEV_DevAlertConfigC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TDEV_DevAlertConfig_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TDEV_DevAlertConfigC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TDEV_DevAlertConfig_C_LastUpdatedBy"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TDEV_DevDataConfig"); entity.HasIndex(e => e.C_CreateBy, "FK_TDEV_DevDataConfig_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TDEV_DevDataConfig_C_LastUpdatedBy"); entity.Property(e => e.C_Code) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(1024)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.I_Interval).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TDEV_DevDataConfigC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TDEV_DevDataConfig_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TDEV_DevDataConfigC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TDEV_DevDataConfig_C_LastUpdatedBy"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ConfigCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_DeviceCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Value) .IsRequired() .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TDEV_Device"); entity.HasIndex(e => e.C_CreateBy, "FK_TDEV_Device_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TDEV_Device_C_LastUpdatedBy"); //entity.HasIndex(e => e.C_ProductCode, "FK_TDEV_Device_C_ProductCode"); entity.Property(e => e.C_Code) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_MachineCode) .HasColumnType("varchar(255)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); //entity.Property(e => e.C_ProductCode) // .HasCharSet("utf8") // .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(1024)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TDEV_DeviceC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TDEV_Device_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TDEV_DeviceC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TDEV_Device_C_LastUpdatedBy"); //entity.HasOne(d => d.C_ProductCodeNavigation) // .WithMany(p => p.TDEV_Devices) // .HasForeignKey(d => d.C_ProductCode) // .OnDelete(DeleteBehavior.ClientSetNull) // .HasConstraintName("FK_TDEV_Device_C_ProductCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TISP_Content"); entity.HasIndex(e => e.C_CreateBy, "FK_TISP_Content_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TISP_Content_C_LastUpdatedBy"); entity.HasIndex(e => e.C_StoreCode, "FK_TISP_Content_C_StoreCode"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_AlarmLevel) .IsRequired() .HasColumnType("char(1)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_StoreCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TISP_ContentC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_Content_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TISP_ContentC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TISP_Content_C_LastUpdatedBy"); entity.HasOne(d => d.C_StoreCodeNavigation) .WithMany(p => p.TISP_Contents) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_StoreCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_Content_C_StoreCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.G_ID) .HasName("PRIMARY"); entity.ToTable("TISP_ContentGroup"); entity.HasIndex(e => e.G_CreateBy, "FK_TISP_ContentGroup_C_CreateBy"); entity.HasIndex(e => e.G_LastUpdatedBy, "FK_TISP_ContentGroup_C_LastUpdatedBy"); entity.HasIndex(e => e.C_StoreCode, "FK_TISP_ContentGroup_C_StoreCode"); entity.Property(e => e.G_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_PatrolItem) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_StoreCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.G_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.G_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.Property(e => e.I_Type).HasColumnType("int(11)"); entity.HasOne(d => d.C_StoreCodeNavigation) .WithMany(p => p.TISP_ContentGroups) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_StoreCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_ContentGroup_C_StoreCode"); entity.HasOne(d => d.G_CreateByNavigation) .WithMany(p => p.TISP_ContentGroupG_CreateByNavigations) .HasForeignKey(d => d.G_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_ContentGroup_C_CreateBy"); entity.HasOne(d => d.G_LastUpdatedByNavigation) .WithMany(p => p.TISP_ContentGroupG_LastUpdatedByNavigations) .HasForeignKey(d => d.G_LastUpdatedBy) .HasConstraintName("FK_TISP_ContentGroup_C_LastUpdatedBy"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.G_ID) .HasName("PRIMARY"); entity.ToTable("TISP_ContentGroupItem"); entity.HasIndex(e => e.G_ContentCode, "FK_TISP_ContentGroupItem_G_ContentCode"); entity.HasIndex(e => e.G_ContentGroupCode, "FK_TISP_ContentGroupItem_G_ContentGroupCode"); entity.Property(e => e.G_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.G_ContentCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.G_ContentGroupCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.HasOne(d => d.G_ContentCodeNavigation) .WithMany(p => p.TISP_ContentGroupItems) .HasForeignKey(d => d.G_ContentCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_ContentGroupItem_G_ContentCode"); entity.HasOne(d => d.G_ContentGroupCodeNavigation) .WithMany(p => p.TISP_ContentGroupItems) .HasForeignKey(d => d.G_ContentGroupCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_ContentGroupItem_G_ContentGroupCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TISP_Record"); entity.HasIndex(e => e.C_CreateBy, "FK_TISP_Record_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TISP_Record_C_LastUpdatedBy"); entity.HasIndex(e => e.C_SpotCode, "FK_TISP_Record_C_SpotCode"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_SpotCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TISP_RecordC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_Record_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TISP_RecordC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TISP_Record_C_LastUpdatedBy"); entity.HasOne(d => d.C_SpotCodeNavigation) .WithMany(p => p.TISP_Records) .HasForeignKey(d => d.C_SpotCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_Record_C_SpotCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TISP_RecordImage"); entity.HasIndex(e => e.C_RecordItemCode, "FK_TISP_RecordImage_C_RecordItemCode"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ImageUrl) .IsRequired() .HasColumnType("varchar(200)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_RecordItemCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.HasOne(d => d.C_RecordItemCodeNavigation) .WithMany(p => p.TISP_RecordImages) .HasForeignKey(d => d.C_RecordItemCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_RecordImage_C_RecordItemCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TISP_RecordItem"); entity.HasIndex(e => e.C_ContentCode, "FK_TISP_RecordItem_C_ContentCode"); entity.HasIndex(e => e.C_CreateBy, "FK_TISP_RecordItem_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TISP_RecordItem_C_LastUpdatedBy"); entity.HasIndex(e => e.C_RecordCode, "FK_TISP_RecordItem_C_RecordCode"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ContentCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_InspectionContent) .IsRequired() .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_RecordCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.HasOne(d => d.C_ContentCodeNavigation) .WithMany(p => p.TISP_RecordItems) .HasForeignKey(d => d.C_ContentCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_RecordItem_C_ContentCode"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TISP_RecordItemC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_RecordItem_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TISP_RecordItemC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TISP_RecordItem_C_LastUpdatedBy"); entity.HasOne(d => d.C_RecordCodeNavigation) .WithMany(p => p.TISP_RecordItems) .HasForeignKey(d => d.C_RecordCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_RecordItem_C_RecordCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.G_ID) .HasName("PRIMARY"); entity.ToTable("TISP_Report"); entity.HasIndex(e => e.C_StoreCode, "FK_TISP_Report_C_StoreCode"); entity.Property(e => e.G_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Data) .HasColumnType("longtext") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_GroupName) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_StoreCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateTime).HasColumnType("datetime"); entity.Property(e => e.D_End).HasColumnType("datetime"); entity.Property(e => e.D_Start).HasColumnType("datetime"); entity.Property(e => e.I_Type).HasColumnType("int(11)"); entity.HasOne(d => d.C_StoreCodeNavigation) .WithMany(p => p.TISP_Reports) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_StoreCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_Report_C_StoreCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TISP_SecurityImage"); entity.HasIndex(e => e.C_SecurityRecordCode, "FK_TISP_SecurityImage_C_SecurityRecordCode"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ImageUrl) .IsRequired() .HasColumnType("varchar(200)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_SecurityRecordCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.HasOne(d => d.C_SecurityRecordCodeNavigation) .WithMany(p => p.TISP_SecurityImages) .HasForeignKey(d => d.C_SecurityRecordCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_SecurityImage_C_SecurityRecordCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TISP_SecurityItem"); entity.HasIndex(e => e.C_CreateBy, "FK_TISP_SecurityItem_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TISP_SecurityItem_C_LastUpdatedBy"); entity.HasIndex(e => e.C_RecordItemCode, "FK_TISP_SecurityItem_C_RecordItemCode"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_RecordItemCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_SecurityContent) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TISP_SecurityItemC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_SecurityItem_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TISP_SecurityItemC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TISP_SecurityItem_C_LastUpdatedBy"); entity.HasOne(d => d.C_RecordItemCodeNavigation) .WithMany(p => p.TISP_SecurityItems) .HasForeignKey(d => d.C_RecordItemCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_SecurityItem_C_RecordItemCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TISP_Spot"); entity.HasIndex(e => e.C_QRCode, "AK_Key") .IsUnique(); entity.HasIndex(e => e.C_AreaCode, "FK_TISP_Spot_C_AreaCode"); entity.HasIndex(e => e.C_CreateBy, "FK_TISP_Spot_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TISP_Spot_C_LastUpdatedBy"); entity.HasIndex(e => e.C_StoreCode, "FK_TISP_Spot_C_StoreCode"); entity.Property(e => e.C_Code) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_AreaCode) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_GPS) .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ImageUrl) .HasColumnType("varchar(255)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Number) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Position) .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_QRCode) .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(1024)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_StoreCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.F_Map_X).HasPrecision(12, 2); entity.Property(e => e.F_Map_Y).HasPrecision(12, 2); entity.Property(e => e.I_Offset).HasColumnType("int(11)"); entity.HasOne(d => d.C_AreaCodeNavigation) .WithMany(p => p.TISP_Spots) .HasForeignKey(d => d.C_AreaCode) .HasConstraintName("FK_TISP_Spot_C_AreaCode"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TISP_SpotC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_Spot_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TISP_SpotC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TISP_Spot_C_LastUpdatedBy"); entity.HasOne(d => d.C_StoreCodeNavigation) .WithMany(p => p.TISP_Spots) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_StoreCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_Spot_C_StoreCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TISP_SpotContent"); entity.HasIndex(e => new { e.C_SpotCode, e.C_ContentCode }, "AK_Key") .IsUnique(); entity.HasIndex(e => e.C_ContentCode, "FK_TISP_SpotContent_C_ContentCode"); entity.HasIndex(e => e.C_CreateBy, "FK_TISP_SpotContent_C_CreateBy"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ContentCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_SpotCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.HasOne(d => d.C_ContentCodeNavigation) .WithMany(p => p.TISP_SpotContents) .HasForeignKey(d => d.C_ContentCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_SpotContent_C_ContentCode"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TISP_SpotContents) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_SpotContent_C_CreateBy"); entity.HasOne(d => d.C_SpotCodeNavigation) .WithMany(p => p.TISP_SpotContents) .HasForeignKey(d => d.C_SpotCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_SpotContent_C_SpotCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TISP_SpotUser"); entity.HasIndex(e => new { e.C_UserCode, e.C_SpotCode }, "AK_Key") .IsUnique(); entity.HasIndex(e => e.C_CreateBy, "FK_TISP_SpotUser_C_CreateBy"); entity.HasIndex(e => e.C_SpotCode, "FK_TISP_SpotUser_C_SpotCode"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_SpotCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_UserCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TISP_SpotUserC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_SpotUser_C_CreateBy"); entity.HasOne(d => d.C_SpotCodeNavigation) .WithMany(p => p.TISP_SpotUsers) .HasForeignKey(d => d.C_SpotCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_SpotUser_C_SpotCode"); entity.HasOne(d => d.C_UserCodeNavigation) .WithMany(p => p.TISP_SpotUserC_UserCodeNavigations) .HasForeignKey(d => d.C_UserCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TISP_SpotUser_C_UserCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TPNT_Area"); entity.HasIndex(e => e.C_CreateBy, "FK_TPNT_Area_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TPNT_Area_C_LastUpdatedBy"); entity.HasIndex(e => e.C_StoreCode, "FK_TPNT_Area_C_StoreCode"); entity.Property(e => e.C_Code) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ImageUrl) .HasColumnType("varchar(255)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(255)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(1024)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_SName) .HasColumnType("varchar(16)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_StoreCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TPNT_AreaC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPNT_Area_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TPNT_AreaC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TPNT_Area_C_LastUpdatedBy"); entity.HasOne(d => d.C_StoreCodeNavigation) .WithMany(p => p.TPNT_Areas) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_StoreCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPNT_Area_C_StoreCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TPNT_Store"); entity.HasIndex(e => e.C_Code, "AK_Key") .IsUnique(); entity.HasIndex(e => e.C_AreaCode, "FK_TPNT_Store_C_AreaCode"); entity.HasIndex(e => e.C_CreateBy, "FK_TPNT_Store_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TPNT_Store_C_LastUpdatedBy"); entity.HasIndex(e => e.C_LicenseCode, "FK_TPNT_Store_C_LicenseCode"); entity.HasIndex(e => e.C_TypeCode, "FK_TPNT_Store_C_TypeCode"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Address) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_AreaCode) .HasColumnType("varchar(20)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Code) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_GPS) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LicenseCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(255)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(1024)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_SName) .IsRequired() .HasColumnType("varchar(16)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_TypeCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_AreaCodeNavigation) .WithMany(p => p.TPNT_Stores) .HasForeignKey(d => d.C_AreaCode) .HasConstraintName("FK_TPNT_Store_C_AreaCode"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TPNT_StoreC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPNT_Store_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TPNT_StoreC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TPNT_Store_C_LastUpdatedBy"); entity.HasOne(d => d.C_LicenseCodeNavigation) .WithMany(p => p.TPNT_Stores) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_LicenseCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPNT_Store_C_LicenseCode"); entity.HasOne(d => d.C_TypeCodeNavigation) .WithMany(p => p.TPNT_Stores) .HasForeignKey(d => d.C_TypeCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPNT_Store_C_TypeCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => new { e.C_StoreCode, e.C_OrgCode }) .HasName("PRIMARY") .HasAnnotation("MySql:IndexPrefixLength", new[] { 0, 0 }); entity.ToTable("TPNT_StoreOrg"); entity.HasIndex(e => e.C_CreateBy, "FK_TPNT_StoreOrg_C_CreateBy"); entity.HasIndex(e => e.C_OrgCode, "FK_TPNT_StoreOrg_C_OrgCode"); entity.Property(e => e.C_StoreCode) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_OrgCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TPNT_StoreOrgs) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPNT_StoreOrg_C_CreateBy"); entity.HasOne(d => d.C_OrgCodeNavigation) .WithMany(p => p.TPNT_StoreOrgs) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_OrgCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPNT_StoreOrg_C_OrgCode"); entity.HasOne(d => d.C_StoreCodeNavigation) .WithMany(p => p.TPNT_StoreOrgs) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_StoreCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPNT_StoreOrg_C_StoreCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TPNT_Type"); entity.Property(e => e.C_Code) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TPRD_Log"); entity.HasIndex(e => e.C_CreateBy, "FK_TPRD_Log_C_CreateBy"); entity.HasIndex(e => e.C_ProductCode, "FK_TPRD_Log_C_ProductCode"); entity.HasIndex(e => e.C_StoreCode, "FK_TPRD_Log_C_StoreCode"); entity.Property(e => e.C_Code) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_AlarmMsg) .HasColumnType("varchar(1024)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_DeviceCode) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ProductCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(1024)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_SpotCode) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_StoreCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.I_Type).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TPRD_Logs) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPRD_Log_C_CreateBy"); entity.HasOne(d => d.C_ProductCodeNavigation) .WithMany(p => p.TPRD_Logs) .HasForeignKey(d => d.C_ProductCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPRD_Log_C_ProductCode"); entity.HasOne(d => d.C_StoreCodeNavigation) .WithMany(p => p.TPRD_Logs) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_StoreCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPRD_Log_C_StoreCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_SKUCode) .HasName("PRIMARY"); entity.ToTable("TPRD_ProdSKU"); entity.HasIndex(e => e.C_CreateBy, "FK_TPRD_ProdSKU_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TPRD_ProdSKU_C_LastUpdatedBy"); entity.HasIndex(e => e.C_TypeCode, "FK_TPRD_ProdSKU_C_TypeCode"); entity.Property(e => e.C_SKUCode) .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Brand) .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_IconPath) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ImagePath) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(255)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ProdArea) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(1024)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Spec) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_TypeCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Unit) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Vender) .HasColumnType("varchar(255)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.I_AlarmDays).HasColumnType("int(11)"); entity.Property(e => e.I_MinStock).HasColumnType("int(11)"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.Property(e => e.I_ValiDays).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TPRD_ProdSKUC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPRD_ProdSKU_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TPRD_ProdSKUC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TPRD_ProdSKU_C_LastUpdatedBy"); entity.HasOne(d => d.C_TypeCodeNavigation) .WithMany(p => p.TPRD_ProdSKUs) .HasForeignKey(d => d.C_TypeCode) .HasConstraintName("FK_TPRD_ProdSKU_C_TypeCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TPRD_Product"); entity.HasIndex(e => e.C_QRCode, "AK_Key") .IsUnique(); entity.HasIndex(e => new { e.C_SKUCode, e.C_Code }, "C_SKUCode"); entity.HasIndex(e => e.C_AreaCode, "FK_TPRD_Product_C_AreaCode"); entity.HasIndex(e => e.C_CreateBy, "FK_TPRD_Product_C_CreateBy"); entity.HasIndex(e => e.C_DeviceCode, "FK_TPRD_Product_C_DeviceCode"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TPRD_Product_C_LastUpdatedBy"); entity.HasIndex(e => e.C_SpotCode, "FK_TPRD_Product_C_SpotCode"); entity.HasIndex(e => e.C_StoreCode, "FK_TPRD_Product_C_StoreCode"); entity.Property(e => e.C_Code) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_AlarmMsg) .HasColumnType("varchar(1024)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_AreaCode) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_DeviceCode) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ImageUrl) .HasColumnType("varchar(255)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_QRCode) .IsRequired() .HasColumnType("varchar(255)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(1024)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_SKUCode) .IsRequired() .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_SpotCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_StoreCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastISP).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.D_ProdDate).HasColumnType("date"); entity.Property(e => e.D_ValiDate).HasColumnType("date"); entity.Property(e => e.F_Map_X).HasPrecision(12, 2); entity.Property(e => e.F_Map_Y).HasPrecision(12, 2); entity.Property(e => e.I_IsAlarm) .HasColumnType("int(11)") .HasDefaultValueSql("'0'"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.Property(e => e.I_Status).HasColumnType("int(11)"); entity.HasOne(d => d.C_AreaCodeNavigation) .WithMany(p => p.TPRD_Products) .HasForeignKey(d => d.C_AreaCode) .HasConstraintName("FK_TPRD_Product_C_AreaCode"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TPRD_ProductC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPRD_Product_C_CreateBy"); //entity.HasOne(d => d.C_DeviceCodeNavigation) // .WithMany(p => p.TPRD_Products) // .HasForeignKey(d => d.C_DeviceCode) // .HasConstraintName("FK_TPRD_Product_C_DeviceCode"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TPRD_ProductC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TPRD_Product_C_LastUpdatedBy"); entity.HasOne(d => d.C_SKUCodeNavigation) .WithMany(p => p.TPRD_Products) .HasForeignKey(d => d.C_SKUCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPRD_Product_C_SKUCode"); entity.HasOne(d => d.C_SpotCodeNavigation) .WithMany(p => p.TPRD_Products) .HasForeignKey(d => d.C_SpotCode) .HasConstraintName("FK_TPRD_Product_C_SpotCode"); entity.HasOne(d => d.C_StoreCodeNavigation) .WithMany(p => p.TPRD_Products) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_StoreCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPRD_Product_C_StoreCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TPRD_Type"); entity.HasIndex(e => e.C_CreateBy, "FK_TPRD_Type_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TPRD_Type_C_LastUpdatedBy"); entity.Property(e => e.C_Code) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.I_IfFPP).HasColumnType("int(11)"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TPRD_TypeC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TPRD_Type_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TPRD_TypeC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TPRD_Type_C_LastUpdatedBy"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TSYS_License"); entity.HasIndex(e => e.C_Code, "AK_Key") .IsUnique(); entity.HasIndex(e => e.C_CreateBy, "FK_TSYS_License_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TSYS_License_C_LastUpdatedBy"); entity.HasIndex(e => e.C_TypeCode, "FK_TSYS_License_C_TypeCode"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Code) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_FilePath) .IsRequired() .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_TypeCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_EndDate).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.D_StartDate).HasColumnType("datetime"); entity.Property(e => e.I_MemberQty).HasColumnType("int(11)"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.Property(e => e.I_SpotQty).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TSYS_LicenseC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_License_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TSYS_LicenseC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TSYS_License_C_LastUpdatedBy"); entity.HasOne(d => d.C_TypeCodeNavigation) .WithMany(p => p.TSYS_Licenses) .HasForeignKey(d => d.C_TypeCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_License_C_TypeCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TSYS_LicenseType"); entity.HasIndex(e => e.C_CreateBy, "FK_TSYS_LicenseType_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TSYS_LicenseType_C_LastUpdatedBy"); entity.Property(e => e.C_Code) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.I_MaxFileSize).HasColumnType("int(11)"); entity.Property(e => e.I_MaxMemberQty).HasColumnType("int(11)"); entity.Property(e => e.I_MaxSpotQty).HasColumnType("int(11)"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TSYS_LicenseTypeC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_LicenseType_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TSYS_LicenseTypeC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TSYS_LicenseType_C_LastUpdatedBy"); }); modelBuilder.Entity(entity => { entity.HasKey(e => new { e.C_LicenseTypeCode, e.C_PrivilegeCode }) .HasName("PRIMARY") .HasAnnotation("MySql:IndexPrefixLength", new[] { 0, 0 }); entity.ToTable("TSYS_LicenseTypePriv"); entity.HasIndex(e => e.C_CreateBy, "FK_TSYS_LicenseTypePriv_C_CreateBy"); entity.HasIndex(e => e.C_PrivilegeCode, "FK_TSYS_LicenseTypePriv_C_PrivilegeCode"); entity.Property(e => e.C_LicenseTypeCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_PrivilegeCode) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TSYS_LicenseTypePrivs) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_LicenseTypePriv_C_CreateBy"); entity.HasOne(d => d.C_LicenseTypeCodeNavigation) .WithMany(p => p.TSYS_LicenseTypePrivs) .HasForeignKey(d => d.C_LicenseTypeCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_LicenseTypePriv_C_LicenseTypeCode"); entity.HasOne(d => d.C_PrivilegeCodeNavigation) .WithMany(p => p.TSYS_LicenseTypePrivs) .HasForeignKey(d => d.C_PrivilegeCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_LicenseTypePriv_C_PrivilegeCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TSYS_Message"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.K_ID) .HasName("PRIMARY"); entity.ToTable("TSYS_Org"); entity.HasIndex(e => e.C_Code, "AK_Key") .IsUnique(); entity.HasIndex(e => e.C_CreateBy, "FK_TSYS_Org_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TSYS_Org_C_LastUpdatedBy"); entity.HasIndex(e => e.C_LicenseCode, "FK_TSYS_Org_C_LicenseCode"); entity.HasIndex(e => e.C_ParentCode, "FK_TSYS_Org_C_ParentCode"); entity.Property(e => e.K_ID).HasColumnType("int(11)"); entity.Property(e => e.C_Code) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_GIS) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LName) .HasColumnType("varchar(2550)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Level) .IsRequired() .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LicenseCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Linker) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ParentCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Phone) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_SName) .HasColumnType("varchar(16)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Type) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TSYS_OrgC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_Org_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TSYS_OrgC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TSYS_Org_C_LastUpdatedBy"); entity.HasOne(d => d.C_LicenseCodeNavigation) .WithMany(p => p.TSYS_Orgs) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_LicenseCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_Org_C_LicenseCode"); entity.HasOne(d => d.C_ParentCodeNavigation) .WithMany(p => p.InverseC_ParentCodeNavigation) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_ParentCode) .HasConstraintName("FK_TSYS_Org_C_ParentCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TSYS_Priv"); entity.HasIndex(e => e.C_ParentCode, "FK_TSYS_Priv_C_ParentCode"); entity.Property(e => e.C_Code) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ImageUrl) .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Module) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_PageUrl) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ParentCode) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Type) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_ParentCodeNavigation) .WithMany(p => p.InverseC_ParentCodeNavigation) .HasForeignKey(d => d.C_ParentCode) .HasConstraintName("FK_TSYS_Priv_C_ParentCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_Code) .HasName("PRIMARY"); entity.ToTable("TSYS_Role"); entity.HasIndex(e => e.C_CreateBy, "FK_TSYS_Role_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TSYS_Role_C_LastUpdatedBy"); entity.HasIndex(e => e.C_LicenseCode, "FK_TSYS_Role_C_LicenseCode"); entity.Property(e => e.C_Code) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Description) .IsRequired() .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LicenseCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TSYS_RoleC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_Role_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TSYS_RoleC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TSYS_Role_C_LastUpdatedBy"); entity.HasOne(d => d.C_LicenseCodeNavigation) .WithMany(p => p.TSYS_Roles) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_LicenseCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_Role_C_LicenseCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => new { e.C_RoleCode, e.C_PrivilegeCode }) .HasName("PRIMARY") .HasAnnotation("MySql:IndexPrefixLength", new[] { 0, 0 }); entity.ToTable("TSYS_RolePriv"); entity.HasIndex(e => e.C_CreateBy, "FK_TSYS_RolePriv_C_CreateBy"); entity.HasIndex(e => e.C_PrivilegeCode, "FK_TSYS_RolePriv_C_PrivilegeCode"); entity.Property(e => e.C_RoleCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_PrivilegeCode) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.I_Type).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TSYS_RolePrivs) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_RolePriv_C_CreateBy"); entity.HasOne(d => d.C_PrivilegeCodeNavigation) .WithMany(p => p.TSYS_RolePrivs) .HasForeignKey(d => d.C_PrivilegeCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_RolePriv_C_PrivilegeCode"); entity.HasOne(d => d.C_RoleCodeNavigation) .WithMany(p => p.TSYS_RolePrivs) .HasForeignKey(d => d.C_RoleCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_RolePriv_C_RoleCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_UserID) .HasName("PRIMARY"); entity.ToTable("TSYS_User"); entity.HasIndex(e => e.C_UserName, "AK_Key") .IsUnique(); entity.HasIndex(e => e.C_IDNum, "AK_Key_2") .IsUnique(); entity.HasIndex(e => e.C_Mobile, "AK_Key_3") .IsUnique(); entity.HasIndex(e => e.C_CreateBy, "FK_TSYS_User_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TSYS_User_C_LastUpdatedBy"); entity.HasIndex(e => e.C_LicenseCode, "FK_TSYS_User_C_LicenseCode"); entity.HasIndex(e => e.C_OrgCode, "FK_TSYS_User_C_OrgCode"); entity.Property(e => e.C_UserID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Address) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Email) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_IDNum) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ImagePath) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LicenseCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Mobile) .IsRequired() .HasColumnType("varchar(20)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Name) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_OrgCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Password) .IsRequired() .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Phone) .HasColumnType("varchar(20)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Post) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_ProgramID) .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Remark) .HasColumnType("varchar(500)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_UserName) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_WechatID) .HasColumnType("varchar(100)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_Birthday).HasColumnType("datetime"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.Property(e => e.I_Render).HasColumnType("int(11)"); entity.Property(e => e.I_Sort).HasColumnType("int(11)"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.InverseC_CreateByNavigation) .HasForeignKey(d => d.C_CreateBy) .HasConstraintName("FK_TSYS_User_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.InverseC_LastUpdatedByNavigation) .HasForeignKey(d => d.C_LastUpdatedBy) .OnDelete(DeleteBehavior.Cascade) .HasConstraintName("FK_TSYS_User_C_LastUpdatedBy"); entity.HasOne(d => d.C_LicenseCodeNavigation) .WithMany(p => p.TSYS_Users) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_LicenseCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_User_C_LicenseCode"); entity.HasOne(d => d.C_OrgCodeNavigation) .WithMany(p => p.TSYS_Users) .HasPrincipalKey(p => p.C_Code) .HasForeignKey(d => d.C_OrgCode) .HasConstraintName("FK_TSYS_User_C_OrgCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => new { e.C_UserCode, e.C_RoleCode }) .HasName("PRIMARY") .HasAnnotation("MySql:IndexPrefixLength", new[] { 0, 0 }); entity.ToTable("TSYS_UserRole"); entity.HasIndex(e => e.C_CreateBy, "FK_TSYS_UserRole_C_CreateBy"); entity.HasIndex(e => e.C_RoleCode, "FK_TSYS_UserRole_C_RoleCode"); entity.Property(e => e.C_UserCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_RoleCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TSYS_UserRoleC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_UserRole_C_CreateBy"); entity.HasOne(d => d.C_RoleCodeNavigation) .WithMany(p => p.TSYS_UserRoles) .HasForeignKey(d => d.C_RoleCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_UserRole_C_RoleCode"); entity.HasOne(d => d.C_UserCodeNavigation) .WithMany(p => p.TSYS_UserRoleC_UserCodeNavigations) .HasForeignKey(d => d.C_UserCode) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_UserRole_C_UserCode"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.C_ID) .HasName("PRIMARY"); entity.ToTable("TSYS_Version"); entity.HasIndex(e => e.C_CreateBy, "FK_TSYS_Version_C_CreateBy"); entity.HasIndex(e => e.C_LastUpdatedBy, "FK_TSYS_Version_C_LastUpdatedBy"); entity.Property(e => e.C_ID) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_AppCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_DownloadURL) .HasColumnType("varchar(1000)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LastUpdatedBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_Status) .IsRequired() .HasColumnType("char(1)") .HasDefaultValueSql("'1'") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_UpdateContent) .HasColumnType("varchar(1000)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_VersionCode) .HasColumnType("varchar(50)") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); entity.Property(e => e.D_LastUpdatedOn).HasColumnType("datetime"); entity.HasOne(d => d.C_CreateByNavigation) .WithMany(p => p.TSYS_VersionC_CreateByNavigations) .HasForeignKey(d => d.C_CreateBy) .OnDelete(DeleteBehavior.ClientSetNull) .HasConstraintName("FK_TSYS_Version_C_CreateBy"); entity.HasOne(d => d.C_LastUpdatedByNavigation) .WithMany(p => p.TSYS_VersionC_LastUpdatedByNavigations) .HasForeignKey(d => d.C_LastUpdatedBy) .HasConstraintName("FK_TSYS_Version_C_LastUpdatedBy"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.jobId) .HasName("PRIMARY"); entity.ToTable("TaskInfoDto"); entity.HasIndex(e => e.TasksQzId, "IX_TaskInfoDto_TasksQzId"); entity.Property(e => e.jobId) .HasColumnType("varchar(255)") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.TasksQzId) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.jobGroup) .HasColumnType("longtext") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.jobName) .HasColumnType("longtext") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.triggerGroup) .HasColumnType("longtext") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.triggerId) .HasColumnType("longtext") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.triggerName) .HasColumnType("longtext") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.triggerStatus) .HasColumnType("longtext") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.HasOne(d => d.TasksQz) .WithMany(p => p.TaskInfoDtos) .HasForeignKey(d => d.TasksQzId) .HasConstraintName("TaskInfoDto_ibfk_1"); }); modelBuilder.Entity(entity => { entity.ToTable("TasksQz"); entity.Property(e => e.Id) .ValueGeneratedNever() .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.AssemblyName) .HasColumnType("varchar(200)") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.BeginTime).HasMaxLength(6); entity.Property(e => e.C_StoreCode) .IsRequired() .HasColumnType("varchar(50)") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.ClassName) .HasColumnType("varchar(200)") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CreateTime).HasMaxLength(6); entity.Property(e => e.Cron) .HasColumnType("varchar(200)") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.CycleRunTimes).HasColumnType("int(11)"); entity.Property(e => e.EndTime).HasMaxLength(6); entity.Property(e => e.IntervalSecond).HasColumnType("int(11)"); entity.Property(e => e.JobGroup) .HasColumnType("varchar(200)") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.JobParams) .HasColumnType("longtext") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.Name) .HasColumnType("varchar(200)") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.Remark) .HasColumnType("varchar(1000)") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_general_ci"); entity.Property(e => e.RunTimes).HasColumnType("int(11)"); entity.Property(e => e.TriggerType).HasColumnType("int(11)"); }); modelBuilder.Entity(entity => { entity.HasKey(e => new { e.C_RoleCode,e.C_HandCode }) .HasName("PRIMARY") .HasAnnotation("MySql:IndexPrefixLength", new[] { 0, 0 }); entity.ToTable("TSYS_RoleHand"); entity.Property(e => e.C_HandCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_RoleCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); }); modelBuilder.Entity(entity => { entity.HasKey(e => new { e.C_LicenseCode, e.C_LargeScreenTemplateCode }) .HasName("PRIMARY") .HasAnnotation("MySql:IndexPrefixLength", new[] { 0, 0 }); entity.ToTable("TSYS_LicenseLargeScreenTemplate"); entity.HasIndex(e => e.C_CreateBy, "FK_TSYS_LicenseLargeScreenTemplate_C_CreateBy"); entity.HasIndex(e => e.C_LargeScreenTemplateCode, "FK_TSYS_LicenseLargeScreenTemplate_C_RoleCode"); entity.Property(e => e.C_LicenseCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_LargeScreenTemplateCode) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.C_CreateBy) .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.D_CreateOn).HasColumnType("datetime"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.CId) .HasName("PRIMARY"); entity.HasComment("AI盒子模版表"); entity.Property(e => e.CId) .HasComment("Guid") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CContactPhone) .HasComment("联系电话") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CContacts) .HasComment("联系人") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CCreateBy) .HasComment("记录创建人") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CIconPath) .HasComment("图标路径") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CImagePath) .HasComment("照片路径") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CLastUpdatedBy) .HasComment("记录修改人") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CManufacturer) .HasComment("制造商") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CMarker) .HasComment("型号") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CName) .HasComment("名称") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.COfficialWebsiteUrl) .HasComment("官网") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CParameter) .HasComment("参数") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CProdArea) .HasComment("产地") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CQrcode) .HasComment("二维码") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CRemark) .HasComment("备注") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CStatus) .HasComment("状态 1启用,0禁用") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.CThreeDpath) .HasComment("3D路径") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.DCreateOn) .HasDefaultValueSql("CURRENT_TIMESTAMP") .HasComment("记录创建时间"); entity.Property(e => e.DLastUpdatedOn).HasComment("记录创建时间"); entity.Property(e => e.I_Sort).HasComment("排序号"); entity.Property(e => e.IValiDays).HasComment("有效期"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.CId) .HasName("PRIMARY"); entity.HasComment("AI盒子表"); entity.Property(e => e.CId) .HasComment("guid主键") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CAiboxNo) .HasComment("编号") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CAiboxTemplateCode) .HasComment("模板编号") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CCfgUrl) .HasComment("配置地址") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CCreateBy) .HasComment("记录创建人") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CLastUpdatedBy) .HasComment("记录修改人") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CMachineCode) .HasComment("设备码（序列号）") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CName) .HasComment("名称") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CQrcode) .HasComment("二维码") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CRemark) .HasComment("备注") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.CRunStatus).HasComment("4=报警\r\n3=预警\r\n2=掉线\r\n1=在线\r\n0=故障"); entity.Property(e => e.CStatus).HasComment("3=报废\r\n2=停用 \r\n1=启用、分配、业主已购买\r\n0=禁用"); entity.Property(e => e.CStoreCode) .HasComment("网点(业主)编号") .HasCharSet("utf8") .HasCollation("utf8_general_ci"); entity.Property(e => e.DCreateOn) .HasDefaultValueSql("CURRENT_TIMESTAMP") .HasComment("记录创建时间"); entity.Property(e => e.DLastUpdatedOn).HasComment("记录修改时间"); entity.Property(e => e.DProdDate).HasComment("生产日期"); entity.Property(e => e.I_Sort).HasComment("排序号"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.CId) .HasName("PRIMARY"); entity.HasComment("AI盒子迁移表"); entity.Property(e => e.CId) .HasComment("Guid") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.CAiboxCode) .HasComment("AI盒子ID") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.CCreateBy) .HasComment("记录创建人") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.CCurrentStoreCode) .HasComment("当前业主编号") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.CLastStoreCode) .HasComment("上家业主编号") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.CName) .HasComment("名称") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.CRemark) .HasComment("备注") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.DCreateOn) .HasComment("记录创建时间") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.CId) .HasName("PRIMARY"); entity.HasComment("设备AI盒子表"); entity.Property(e => e.CId) .HasComment("GUID") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.CAiboxCode) .HasComment("AI盒子ID") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.CCameraCode) .HasComment("摄像头ID") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.CCreateBy) .HasComment("记录创建人") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.CCreator) .HasComment("创建人") .HasCharSet("utf8mb4") .HasCollation("utf8mb4_unicode_ci"); entity.Property(e => e.DCreateOn) .HasDefaultValueSql("CURRENT_TIMESTAMP") .HasComment("记录创建时间"); }); OnModelCreatingPartial(modelBuilder); } partial void OnModelCreatingPartial(ModelBuilder modelBuilder); } }