qlhb/Ropin.Inspection.Model/Entities/InspectionDbContext.cs

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<InspectionDbContext> options)
            : base(options)
        {
        }
        public DatabaseFacade GetDatabase() => Database;
        /// <summary>
        /// create DbSet 
        /// </summary>
        /// <typeparam name="T">实体</typeparam>
        /// <returns></returns>
        public virtual DbSet<T> GetDbSet<T>() where T : class
        {
            if (Model.FindEntityType(typeof(T)) != null)
            {
                return Set<T>();
            }
            else
            {
                throw new Exception($"type {typeof(T).Name} is not add into DbContext ");
            }
        }
        public virtual DbSet<TMTN_DevOpsContent> TMTN_DevOpsContent { get; set; }
        public virtual DbSet<TMTN_SpotDevOpsContent> TMTN_SpotDevOpsContent { get; set; }
        public virtual DbSet<TMTN_DevOps> TMTN_DevOps { get; set; }
        public virtual DbSet<TMTN_DevOpsRecord> TMTN_DevOpsRecord { get; set; }
        public virtual DbSet<TMTN_DevOpsRecordApp> TMTN_DevOpsRecordApp { get; set; }
        public virtual DbSet<TMTN_DevOperateRecord> TMTN_DevOperateRecord { get; set; }
        public virtual DbSet<TMTN_DevOperateRecordApp> TMTN_DevOperateRecordApp { get; set; }
        public virtual DbSet<TMTN_RepairOrderItemApp> TMTN_RepairOrderItemApp { get; set; }
        public virtual DbSet<TMTN_RepairOrderItem> TMTN_RepairOrderItem { get; set; }
        public virtual DbSet<TMTN_RepairOrder> TMTN_RepairOrder { get; set; }
        public virtual DbSet<TMTN_PushMsgTo> TMTN_PushMsgTo { get; set; }
        public virtual DbSet<TMTN_PushMsgResult> TMTN_PushMsgResult { get; set; }
        public virtual DbSet<TDEV_DeviceArchives> TDEV_DeviceArchives { get; set; }
        public virtual DbSet<TDEV_DevSpot> TDEV_DevSpot { get; set; }

        public virtual DbSet<TDEV_DevOpeAccount> TDEV_DevOpeAccount { get; set; }

        public virtual DbSet<TBDM_Area> TBDM_Area { get; set; }
        public virtual DbSet<TBDM_City> TBDM_City { get; set; }
        public virtual DbSet<TBDM_CodeDetail> TBDM_CodeDetail { get; set; }
        public virtual DbSet<TBDM_CodeMain> TBDM_CodeMain { get; set; }
        public virtual DbSet<TBDM_Prov> TBDM_Prov { get; set; }
        public virtual DbSet<TDEV_DevAlert> TDEV_DevAlert { get; set; }
        public virtual DbSet<TDEV_DevAlertConfig> TDEV_DevAlertConfig { get; set; }
        public virtual DbSet<TDEV_DevDataConfig> TDEV_DevDataConfig { get; set; }
        public virtual DbSet<TDEV_DevData> TDEV_DevData { get; set; }
        public virtual DbSet<TDEV_Device> TDEV_Device { get; set; }
        public virtual DbSet<TDEV_DeviceTemplate> TDEV_DeviceTemplate { get; set; }


        public virtual DbSet<TDEV_BoxTemplate> TDEV_BoxTemplate { get; set; }
        public virtual DbSet<TDEV_Box> TDEV_Box { get; set; }
        public virtual DbSet<TDEV_BoxDevSpot> TDEV_BoxDevSpot { get; set; }
       

        public virtual DbSet<TDEV_DeviceTempArchives> TDEV_DeviceTempArchives { get; set; }
        public virtual DbSet<TDEV_MaintenanceKnowledge> TDEV_MaintenanceKnowledge { get; set; }
        public virtual DbSet<TDEV_MaintenanceTemplate> TDEV_MaintenanceTemplate { get; set; }
        public virtual DbSet<TDEV_MaintenancePlan> TDEV_MaintenancePlan { get; set; }
        public virtual DbSet<TDEV_DevStore> TDEV_DevStore { get; set; }
        public virtual DbSet<TDEV_DevStoreMigrate> TDEV_DevStoreMigrate { get; set; }
        public virtual DbSet<TDEV_DevStoreDoc> TDEV_DevStoreDoc { get; set; }
        public virtual DbSet<TDEV_DevStoreLog> TDEV_DevStoreLog { get; set; }
        public virtual DbSet<TDEV_DevicePart> TDEV_DevicePart { get; set; }
        public virtual DbSet<TDEV_DevicePartItem> TDEV_DevicePartItem { get; set; }
        public virtual DbSet<TDEV_WebScada> TDEV_WebScada { get; set; }
        public virtual DbSet<TDEV_WebScadaDevSpot> TDEV_WebScadaDevSpot { get; set; }

        public virtual DbSet<TISP_Content> TISP_Content { get; set; }
        public virtual DbSet<TISP_ContentGroup> TISP_ContentGroup { get; set; }
        public virtual DbSet<TISP_ContentGroupItem> TISP_ContentGroupItem { get; set; }
        public virtual DbSet<TISP_Record> TISP_Record { get; set; }
        public virtual DbSet<TISP_RecordImage> TISP_RecordImage { get; set; }
        public virtual DbSet<TISP_RecordItem> TISP_RecordItem { get; set; }
        public virtual DbSet<TISP_Report> TISP_Report { get; set; }
        public virtual DbSet<TISP_SecurityImage> TISP_SecurityImage { get; set; }
        public virtual DbSet<TISP_SecurityItem> TISP_SecurityItem { get; set; }
        public virtual DbSet<TISP_Spot> TISP_Spot { get; set; }
        public virtual DbSet<TISP_SpotContent> TISP_SpotContent { get; set; }
        public virtual DbSet<TISP_SpotUser> TISP_SpotUser { get; set; }
        public virtual DbSet<TPNT_Area> TPNT_Area { get; set; }
        public virtual DbSet<TPNT_Store> TPNT_Store { get; set; }
        public virtual DbSet<TPNT_StoreOrg> TPNT_StoreOrg { get; set; }
        public virtual DbSet<TPNT_Type> TPNT_Type { get; set; }
        public virtual DbSet<TPRD_Log> TPRD_Log { get; set; }
        public virtual DbSet<TPRD_ProdSKU> TPRD_ProdSKU { get; set; }
        public virtual DbSet<TPRD_Product> TPRD_Product { get; set; }
        public virtual DbSet<TPRD_Type> TPRD_Type { get; set; }
        public virtual DbSet<TSYS_License> TSYS_License { get; set; }
        public virtual DbSet<TSYS_LicenseType> TSYS_LicenseType { get; set; }
        public virtual DbSet<TSYS_LicenseTypePriv> TSYS_LicenseTypePriv { get; set; }
        public virtual DbSet<TSYS_Message> TSYS_Message { get; set; }
        public virtual DbSet<TSYS_MessageFile> TSYS_MessageFile { get; set; }
        public virtual DbSet<TSYS_Org> TSYS_Org { get; set; }
        public virtual DbSet<TSYS_Priv> TSYS_Priv { get; set; }
        public virtual DbSet<TSYS_Role> TSYS_Role { get; set; }
        public virtual DbSet<TSYS_RolePriv> TSYS_RolePriv { get; set; }
        public virtual DbSet<TSYS_User> TSYS_User { get; set; }
        public virtual DbSet<TSYS_UserRole> TSYS_UserRole { get; set; }
        public virtual DbSet<TSYS_Version> TSYS_Version { get; set; }
        public virtual DbSet<TaskInfoDto> TaskInfoDto { get; set; }
        public virtual DbSet<TasksQz> TasksQz { get; set; }

        public virtual DbSet<TSYS_UserPost> TSYS_UserPost { get; set; }
        public virtual DbSet<TISP_Region> TISP_Region { get; set; }
        public virtual DbSet<TSEC_Record> TSEC_Record { get; set; }
        //public virtual DbSet<TISP_SecurityItem> TSEC_RecordItem { get; set; }
        public virtual DbSet<TISP_SpotRegion> TISP_SpotRegion { get; set; }
        public virtual DbSet<TISP_Route> TISP_Route { get; set; }
        public virtual DbSet<TISP_SpotRoute> TISP_SpotRoute { get; set; }
        public virtual DbSet<TDEV_DeviceTempOpsContent> TDEV_DeviceTempOpsContent { get; set; }
        public virtual DbSet<TDEV_MaintenancePlanContent> TDEV_MaintenancePlanContent { get; set; }
        public virtual DbSet<TDEV_DevOpeAccountConfig> TDEV_DevOpeAccountConfig { get; set; }
        public virtual DbSet<TDEV_Hand> TDEV_Hand { get; set; }
        public virtual DbSet<TSYS_RoleHand> TSYS_RoleHand { get; set; }
        public virtual DbSet<TMTN_AlarmOrder> TMTN_AlarmOrder { get; set; }
        public virtual DbSet<TMTN_AlarmHandleRecord> TMTN_AlarmHandleRecord { get; set; }
        public virtual DbSet<TMTN_AlarmHandleRecordApp> TMTN_AlarmHandleRecordApp { get; set; }
        public virtual DbSet<TDEV_DevBoxMigrate> TDEV_DevBoxMigrate { get; set; }
        public virtual DbSet<TSYS_Login> TSYS_Login { get; set; }
        public virtual DbSet<TLGS_LargeScreenTemplate> TLGS_LargeScreenTemplate { get; set; }
        public virtual DbSet<TLGS_LargeScreen> TLGS_LargeScreen { get; set; }
        public virtual DbSet<TSYS_LicenseLargeScreenTemplate> TSYS_LicenseLargeScreenTemplate { get; set; }
        public virtual DbSet<TLGS_LargeScreenControl> TLGS_LargeScreenControl { get; set; }
        public virtual DbSet<TLGS_LargeScreenEvent> TLGS_LargeScreenEvent { get; set; }
        public virtual DbSet<TDEV_DevBox> TDEV_DevBox { get; set; }
        public virtual DbSet<TDEV_Cmd> TDEV_Cmd { get; set; }
        public virtual DbSet<TDEV_Instruction> TDEV_Instruction { get; set; }
        public virtual DbSet<TDEV_CmdInstruction> TDEV_CmdInstruction { get; set; }
        public virtual DbSet<TVMC_CameraTemplate> TVMC_CameraTemplate { get; set; }
        public virtual DbSet<TVMC_Camera> TVMC_Camera { get; set; }
        public virtual DbSet<TVMC_CameraMigrate> TVMC_CameraMigrate { get; set; }
        public virtual DbSet<TVMC_DevCamera> TVMC_DevCamera { get; set; }
        public virtual DbSet<TMTN_AlarmShadowRecord> TMTN_AlarmShadowRecord { get; set; }
        public virtual DbSet<TaicAiboxTemplate> TaicAiboxTemplates { get; set; }
        public virtual DbSet<TaicAibox> TaicAiboxes { get; set; }
        public virtual DbSet<TaicAiboxMigrate> TaicAiboxMigrates { get; set; }
        public virtual DbSet<TaicDevAibox> 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<TBDM_Area>(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<TBDM_City>(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<TBDM_CodeDetail>(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<TBDM_CodeMain>(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<TBDM_Prov>(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<TDEV_DevAlert>(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<TDEV_DevAlertConfig>(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<TDEV_DevDataConfig>(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<TDEV_DevData>(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<TDEV_Device>(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<TISP_Content>(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<TISP_ContentGroup>(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<TISP_ContentGroupItem>(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<TISP_Record>(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<TISP_RecordImage>(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<TISP_RecordItem>(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<TISP_Report>(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<TISP_SecurityImage>(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<TISP_SecurityItem>(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<TISP_Spot>(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<TISP_SpotContent>(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<TISP_SpotUser>(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<TPNT_Area>(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<TPNT_Store>(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<TPNT_StoreOrg>(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<TPNT_Type>(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<TPRD_Log>(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<TPRD_ProdSKU>(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<TPRD_Product>(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<TPRD_Type>(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<TSYS_License>(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<TSYS_LicenseType>(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<TSYS_LicenseTypePriv>(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<TSYS_Message>(entity =>
            {
                entity.HasKey(e => e.C_ID)
                    .HasName("PRIMARY");
                entity.ToTable("TSYS_Message");
            });

            modelBuilder.Entity<TSYS_Org>(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<TSYS_Priv>(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<TSYS_Role>(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<TSYS_RolePriv>(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<TSYS_User>(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<TSYS_UserRole>(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<TSYS_Version>(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<TaskInfoDto>(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<TasksQz>(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<TSYS_RoleHand>(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<TSYS_LicenseLargeScreenTemplate>(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<TaicAiboxTemplate>(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<TaicAibox>(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<TaicAiboxMigrate>(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<TaicDevAibox>(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);
    }
}