// using System; using DAL; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace DAL.Migrations { [DbContext(typeof(WebApiContext))] [Migration("20240806071714_InitialCreate")] partial class InitialCreate { protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("ProductVersion", "6.0.32") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1); modelBuilder.Entity("DAL._Shared.SharedModels.WebAppEmployeeInfo", b => { b.Property("WebAppEmployeeInfoId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WEB_APP_EMPLOYEE_INFO_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WebAppEmployeeInfoId"), 1L, 1); b.Property("ClientId") .HasColumnType("int") .HasColumnName("CLIENT_ID"); b.Property("CostCentreId") .HasColumnType("int") .HasColumnName("COST_CENTRE_ID"); b.Property("DepartmentId") .HasColumnType("int") .HasColumnName("DEPARTMENT_ID"); b.Property("DepartmentName") .HasColumnType("nvarchar(max)") .HasColumnName("DEPARTMENT_NAME"); b.Property("Email") .HasColumnType("nvarchar(max)") .HasColumnName("EMAIL"); b.Property("EmployeeId") .HasColumnType("int") .HasColumnName("EMPLOYEE_ID"); b.Property("EmployeeNo") .HasColumnType("nvarchar(max)") .HasColumnName("EMPLOYEE_NO"); b.Property("ExtendedDepartmentIdList") .HasColumnType("nvarchar(max)") .HasColumnName("EXTENDED_DEPARTMENT_ID_LIST"); b.Property("FirstName") .HasColumnType("nvarchar(max)") .HasColumnName("FIRST_NAME"); b.Property("LastName") .HasColumnType("nvarchar(max)") .HasColumnName("LAST_NAME"); b.Property("LoginName") .HasColumnType("nvarchar(max)") .HasColumnName("LOGIN_NAME"); b.Property("Position") .HasColumnType("nvarchar(max)") .HasColumnName("POSITION"); b.Property("RangName") .HasColumnType("nvarchar(max)") .HasColumnName("RANG_NAME"); b.Property("RangOrder") .HasColumnType("int") .HasColumnName("RANG_ORDER"); b.Property("RangShortname") .HasColumnType("nvarchar(max)") .HasColumnName("RANG_SHORTNAME"); b.Property("Salutation") .HasColumnType("nvarchar(max)") .HasColumnName("SALUTATION"); b.Property("ShortName") .HasColumnType("nvarchar(max)") .HasColumnName("SHORT_NAME"); b.Property("Title") .HasColumnType("nvarchar(max)") .HasColumnName("TITLE"); b.Property("WebAppId") .HasColumnType("int") .HasColumnName("WEB_APP_ID"); b.HasKey("WebAppEmployeeInfoId"); b.ToTable("TBSTF_WEB_APP_EMPLOYEE_INFO", "dbo"); }); modelBuilder.Entity("DAL._Shared.SharedModels.WebAppUser", b => { b.Property("WebAppUserId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WEB_APP_USER_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WebAppUserId"), 1L, 1); b.Property("ClientVersion") .HasColumnType("nvarchar(max)") .HasColumnName("CLIENT_VERSION"); b.Property("Culture") .HasColumnType("nvarchar(max)") .HasColumnName("CULTURE"); b.Property("JwtExpiredOn") .HasColumnType("datetime2") .HasColumnName("JWT_EXPIRED_ON"); b.Property("Language") .HasColumnType("nvarchar(max)") .HasColumnName("LANGUAGE"); b.Property("LastLogin") .HasColumnType("datetime2") .HasColumnName("LAST_LOGIN"); b.Property("LoginName") .HasColumnType("nvarchar(max)") .HasColumnName("LOGIN_NAME"); b.Property("Name") .HasColumnType("nvarchar(max)") .HasColumnName("NAME"); b.Property("Password") .HasColumnType("nvarchar(max)") .HasColumnName("PASSWORD"); b.Property("RoleList") .HasColumnType("nvarchar(max)") .HasColumnName("ROLE_LIST"); b.Property("ShortName") .HasColumnType("nvarchar(max)") .HasColumnName("SHORT_NAME"); b.Property("WebAppRoleList") .HasColumnType("nvarchar(max)") .HasColumnName("WEB_APP_ROLE_LIST"); b.HasKey("WebAppUserId"); b.ToTable("TBSTF_WEB_APP_USER", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.AdWebAppToWebAppRole", b => { b.Property("AdWebAppToWebAppRoleId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("AD_WEB_APP_TO_WEB_APP_ROLE_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("AdWebAppToWebAppRoleId"), 1L, 1); b.Property("AdWebAppName") .HasColumnType("nvarchar(max)") .HasColumnName("AD_WEB_APP_NAME"); b.Property("AdWebAppRoleName") .HasColumnType("nvarchar(max)") .HasColumnName("AD_WEB_APP_ROLE_NAME"); b.Property("WebAppId") .HasColumnType("int") .HasColumnName("WEB_APP_ID"); b.HasKey("AdWebAppToWebAppRoleId"); b.ToTable("TBSTF_AD_WEB_APP_TO_WEB_APP_ROLE", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.CostCentre", b => { b.Property("CostCentreId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("COST_CENTRE_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("CostCentreId"), 1L, 1); b.Property("CostCentreName") .HasColumnType("nvarchar(max)") .HasColumnName("COST_CENTRE_NAME"); b.Property("SortOrder") .HasColumnType("int") .HasColumnName("SORT_ORDER"); b.HasKey("CostCentreId"); b.ToTable("TBSTF_COST_CENTRE", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.Department", b => { b.Property("DepartmentId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("DEPARTMENT_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("DepartmentId"), 1L, 1); b.Property("AdGroupDepartmentName") .HasColumnType("nvarchar(max)") .HasColumnName("AD_GROUP_DEPARTMENT_NAME"); b.Property("ClientId") .HasColumnType("int") .HasColumnName("CLIENT_ID"); b.Property("CostCentre") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("COST_CENTRE"); b.Property("CostCentreId") .HasColumnType("int") .HasColumnName("COST_CENTRE_ID"); b.Property("DepartmentName") .HasColumnType("nvarchar(max)") .HasColumnName("DEPARTMENT_NAME"); b.Property("DepartmentNameFolder") .HasColumnType("nvarchar(max)") .HasColumnName("DEPARTMENT_NAME_FOLDER"); b.Property("DepartmentTypeId") .HasColumnType("int") .HasColumnName("DEPARTMENT_TYPE_ID"); b.Property("ExecutiveDirector") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("EXECUTIVE_DIRECTOR"); b.Property("ExecutiveDirectorId") .HasColumnType("int") .HasColumnName("EXECUTIVE_DIRECTOR_ID"); b.Property("HeadofDepartment") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("HEADOF_DEPARTMENT"); b.Property("HeadofDepartmentId") .HasColumnType("int") .HasColumnName("HEADOF_DEPARTMENT_ID"); b.Property("IsVirtual") .HasColumnType("bit") .HasColumnName("IS_VIRTUAL"); b.Property("ManagingDirector") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("MANAGING_DIRECTOR"); b.Property("ManagingDirectorId") .HasColumnType("int") .HasColumnName("MANAGING_DIRECTOR_ID"); b.HasKey("DepartmentId"); b.ToTable("TBSTF_DEPARTMENT", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.DepartmentToWebAppToEmployeeForWindream", b => { b.Property("DepartmentToWebAppToEmployeeForWindreamId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("DEPARTMENT_TO_WEB_APP_TO_EMPLOYEE_FOR_WINDREAM_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("DepartmentToWebAppToEmployeeForWindreamId"), 1L, 1); b.Property("ClientId") .HasColumnType("int") .HasColumnName("CLIENT_ID"); b.Property("DepartmentId") .HasColumnType("int") .HasColumnName("DEPARTMENT_ID"); b.Property("DepartmentName") .HasColumnType("nvarchar(max)") .HasColumnName("DEPARTMENT_NAME"); b.Property("EmployeeId") .HasColumnType("int") .HasColumnName("EMPLOYEE_ID"); b.Property("IsMain") .HasColumnType("int") .HasColumnName("IS_MAIN"); b.Property("LoginName") .HasColumnType("nvarchar(max)") .HasColumnName("LOGIN_NAME"); b.Property("ShortName") .HasColumnType("nvarchar(max)") .HasColumnName("SHORT_NAME"); b.HasKey("DepartmentToWebAppToEmployeeForWindreamId"); b.ToTable("TBSTF_DEPARTMENT_TO_WEB_APP_TO_EMPLOYEE_FOR_WINDREAM", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.DocumentArt", b => { b.Property("DocumentArtId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("DOCUMENT_ART_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("DocumentArtId"), 1L, 1); b.Property("ClientId") .HasColumnType("int") .HasColumnName("CLIENT_ID"); b.Property("Comment") .HasColumnType("nvarchar(max)") .HasColumnName("COMMENT"); b.Property("DepartmentNamesList") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("DEPARTMENT_NAMES_LIST"); b.Property("Folder") .HasColumnType("nvarchar(max)") .HasColumnName("FOLDER"); b.Property("Name") .HasColumnType("nvarchar(max)") .HasColumnName("NAME"); b.Property("RootPath") .HasColumnType("nvarchar(max)") .HasColumnName("ROOT_PATH"); b.Property("Shortname") .HasColumnType("nvarchar(max)") .HasColumnName("SHORTNAME"); b.HasKey("DocumentArtId"); b.ToTable("TBSTF_DOCUMENT_ART", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.DocumentArtToDepartment", b => { b.Property("DocumentArtToDepartmentId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("DOCUMENT_ART_TO_DEPARTMENT_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("DocumentArtToDepartmentId"), 1L, 1); b.Property("DepartmentId") .HasColumnType("int") .HasColumnName("DEPARTMENT_ID"); b.Property("DocumentArtFolder") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("DOCUMENT_ART_FOLDER"); b.Property("DocumentArtId") .HasColumnType("int") .HasColumnName("DOCUMENT_ART_ID"); b.Property("DocumentArtName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("DOCUMENT_ART_NAME"); b.Property("DocumentArtShortname") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("DOCUMENT_ART_SHORTNAME"); b.Property("IsActive") .HasColumnType("bit") .HasColumnName("IS_ACTIVE"); b.Property("UseGlobix") .HasColumnType("bit") .HasColumnName("USE_GLOBIX"); b.HasKey("DocumentArtToDepartmentId"); b.ToTable("TBSTF_DOCUMENT_ART_TO_DEPARTMENT", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.Employee", b => { b.Property("EmployeeId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("EMPLOYEE_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("EmployeeId"), 1L, 1); b.Property("AttributeIdList") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("ATTRIBUTE_ID_LIST"); b.Property("AttributeNamesList") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("ATTRIBUTE_NAMES_LIST"); b.Property("ClientId") .HasColumnType("int") .HasColumnName("CLIENT_ID"); b.Property("DepartmentIdList") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("DEPARTMENT_ID_LIST"); b.Property("DepartmentNamesList") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("DEPARTMENT_NAMES_LIST"); b.Property("Email") .HasColumnType("nvarchar(max)") .HasColumnName("EMAIL"); b.Property("EmployeeNo") .HasColumnType("nvarchar(max)") .HasColumnName("EMPLOYEE_NO"); b.Property("FirstName") .HasColumnType("nvarchar(max)") .HasColumnName("FIRST_NAME"); b.Property("IsActive") .HasColumnType("bit") .HasColumnName("IS_ACTIVE"); b.Property("LastName") .HasColumnType("nvarchar(max)") .HasColumnName("LAST_NAME"); b.Property("LoginName") .HasColumnType("nvarchar(max)") .HasColumnName("LOGIN_NAME"); b.Property("MainDepartmentId") .ValueGeneratedOnAddOrUpdate() .HasColumnType("int") .HasColumnName("MAIN_DEPARTMENT_ID"); b.Property("MandantCode") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("MANDANT_CODE"); b.Property("MobilePhoneNo") .HasColumnType("nvarchar(max)") .HasColumnName("MOBILE_PHONE_NO"); b.Property("PhoneNo") .HasColumnType("nvarchar(max)") .HasColumnName("PHONE_NO"); b.Property("Position") .HasColumnType("nvarchar(max)") .HasColumnName("POSITION"); b.Property("RangId") .HasColumnType("int") .HasColumnName("RANG_ID"); b.Property("Salutation") .HasColumnType("nvarchar(max)") .HasColumnName("SALUTATION"); b.Property("ShortName") .HasColumnType("nvarchar(max)") .HasColumnName("SHORT_NAME"); b.Property("Title") .HasColumnType("nvarchar(max)") .HasColumnName("TITLE"); b.Property("WebappIdList") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WEBAPP_ID_LIST"); b.Property("WebappNamesList") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WEBAPP_NAMES_LIST"); b.HasKey("EmployeeId"); b.ToTable("TBSTF_EMPLOYEE", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.EmployeeAttribute", b => { b.Property("EmployeeAttributeId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("EMPLOYEE_ATTRIBUTE_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("EmployeeAttributeId"), 1L, 1); b.Property("Name") .HasColumnType("nvarchar(max)") .HasColumnName("NAME"); b.Property("RoleList") .HasColumnType("nvarchar(max)") .HasColumnName("ROLE_LIST"); b.Property("SeqNo") .HasColumnType("int") .HasColumnName("SEQ_NO"); b.Property("Shortname") .HasColumnType("nvarchar(max)") .HasColumnName("SHORTNAME"); b.HasKey("EmployeeAttributeId"); b.ToTable("TBSTF_EMPLOYEE_ATTRIBUTE", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.EmployeeStatus", b => { b.Property("EmployeeStatusId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("EMPLOYEE_STATUS_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("EmployeeStatusId"), 1L, 1); b.Property("EmployeeStatusName") .HasColumnType("nvarchar(max)") .HasColumnName("EMPLOYEE_STATUS_NAME"); b.HasKey("EmployeeStatusId"); b.ToTable("TBSTF_EMPLOYEE_STATUS", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.EmployeeToAttribute", b => { b.Property("EmployeeToAttributeId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("EMPLOYEE_TO_ATTRIBUTE_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("EmployeeToAttributeId"), 1L, 1); b.Property("EmployeeAttributeId") .HasColumnType("int") .HasColumnName("EMPLOYEE_ATTRIBUTE_ID"); b.Property("EmployeeId") .HasColumnType("int") .HasColumnName("EMPLOYEE_ID"); b.HasKey("EmployeeToAttributeId"); b.ToTable("TBSTF_EMPLOYEE_TO_ATTRIBUTE", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.EmployeeToDepartment", b => { b.Property("EmployeeToDepartmentId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("EMPLOYEE_TO_DEPARTMENT_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("EmployeeToDepartmentId"), 1L, 1); b.Property("DepartmentId") .HasColumnType("int") .HasColumnName("DEPARTMENT_ID"); b.Property("DepartmentName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("DEPARTMENT_NAME"); b.Property("EmployeeBudget") .HasColumnType("decimal(18,2)") .HasColumnName("EMPLOYEE_BUDGET"); b.Property("EmployeeId") .HasColumnType("int") .HasColumnName("EMPLOYEE_ID"); b.Property("EmployeeStatusId") .HasColumnType("int") .HasColumnName("EMPLOYEE_STATUS_ID"); b.Property("RangId") .HasColumnType("int") .HasColumnName("RANG_ID"); b.HasKey("EmployeeToDepartmentId"); b.ToTable("TBSTF_EMPLOYEE_TO_DEPARTMENT", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.EmployeeToWebApp", b => { b.Property("EmployeeToWebAppId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("EMPLOYEE_TO_WEB_APP_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("EmployeeToWebAppId"), 1L, 1); b.Property("AdditionalRoleIdList") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("ADDITIONAL_ROLE_ID_LIST"); b.Property("AdditionalRoleNameList") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("ADDITIONAL_ROLE_NAME_LIST"); b.Property("DepartmentId") .HasColumnType("int") .HasColumnName("DEPARTMENT_ID"); b.Property("DepartmentName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("DEPARTMENT_NAME"); b.Property("EmployeeId") .HasColumnType("int") .HasColumnName("EMPLOYEE_ID"); b.Property("ExtendedDepartmentIdList") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("EXTENDED_DEPARTMENT_ID_LIST"); b.Property("ExtendedDepartmentNameList") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("EXTENDED_DEPARTMENT_NAME_LIST"); b.Property("WebAppId") .HasColumnType("int") .HasColumnName("WEB_APP_ID"); b.Property("WebAppName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WEB_APP_NAME"); b.Property("WebAppRoleId") .HasColumnType("int") .HasColumnName("WEB_APP_ROLE_ID"); b.Property("WebAppRoleName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WEB_APP_ROLE_NAME"); b.HasKey("EmployeeToWebAppId"); b.ToTable("TBSTF_EMPLOYEE_TO_WEB_APP", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.Project", b => { b.Property("ProjectId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("PROJECT_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ProjectId"), 1L, 1); b.Property("ProjectName") .HasColumnType("nvarchar(max)") .HasColumnName("PROJECT_NAME"); b.HasKey("ProjectId"); b.ToTable("TBSTF_PROJECT", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.Rang", b => { b.Property("RangId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("RANG_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("RangId"), 1L, 1); b.Property("RangName") .HasColumnType("nvarchar(max)") .HasColumnName("RANG_NAME"); b.Property("RangOrder") .HasColumnType("int") .HasColumnName("RANG_ORDER"); b.Property("RangShortname") .HasColumnType("nvarchar(max)") .HasColumnName("RANG_SHORTNAME"); b.HasKey("RangId"); b.ToTable("TBSTF_RANG", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.Subsidiary", b => { b.Property("SubsidiaryId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("SUBSIDIARY_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("SubsidiaryId"), 1L, 1); b.Property("ClientId") .HasColumnType("int") .HasColumnName("CLIENT_ID"); b.Property("Comment") .HasColumnType("nvarchar(max)") .HasColumnName("COMMENT"); b.Property("Name") .HasColumnType("nvarchar(max)") .HasColumnName("NAME"); b.Property("SubsidiaryCode") .HasColumnType("nvarchar(max)") .HasColumnName("SUBSIDIARY_CODE"); b.HasKey("SubsidiaryId"); b.ToTable("TBSTF_SUBSIDIARY", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WebApp", b => { b.Property("WebAppId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WEB_APP_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WebAppId"), 1L, 1); b.Property("AdWebAppName") .HasColumnType("nvarchar(max)") .HasColumnName("AD_WEB_APP_NAME"); b.Property("IsActive") .HasColumnType("bit") .HasColumnName("IS_ACTIVE"); b.Property("WebAppLinkDev") .HasColumnType("nvarchar(max)") .HasColumnName("WEB_APP_LINK_DEV"); b.Property("WebAppLinkLive") .HasColumnType("nvarchar(max)") .HasColumnName("WEB_APP_LINK_LIVE"); b.Property("WebAppName") .HasColumnType("nvarchar(max)") .HasColumnName("WEB_APP_NAME"); b.HasKey("WebAppId"); b.ToTable("TBSTF_WEB_APP", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WebAppAdditionalRole", b => { b.Property("WebAppAdditionalRoleId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WEB_APP_ADDITIONAL_ROLE_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WebAppAdditionalRoleId"), 1L, 1); b.Property("AdWebAppAdditionalRoleName") .HasColumnType("nvarchar(max)") .HasColumnName("AD_WEB_APP_ADDITIONAL_ROLE_NAME"); b.Property("WebAppAdditionalRoleName") .HasColumnType("nvarchar(max)") .HasColumnName("WEB_APP_ADDITIONAL_ROLE_NAME"); b.Property("WebAppId") .HasColumnType("int") .HasColumnName("WEB_APP_ID"); b.HasKey("WebAppAdditionalRoleId"); b.ToTable("TBSTF_WEB_APP_ADDITIONAL_ROLE", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WebAppRole", b => { b.Property("WebAppRoleId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WEB_APP_ROLE_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WebAppRoleId"), 1L, 1); b.Property("WebAppRoleHierarchy") .HasColumnType("int") .HasColumnName("WEB_APP_ROLE_HIERARCHY"); b.Property("WebAppRoleName") .HasColumnType("nvarchar(max)") .HasColumnName("WEB_APP_ROLE_NAME"); b.HasKey("WebAppRoleId"); b.ToTable("TBSTF_WEB_APP_ROLE", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WebAppToDepartment", b => { b.Property("WebAppToDepartmentId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WEB_APP_TO_DEPARTMENT_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WebAppToDepartmentId"), 1L, 1); b.Property("DepartmentId") .HasColumnType("int") .HasColumnName("DEPARTMENT_ID"); b.Property("DepartmentName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("DEPARTMENT_NAME"); b.Property("EmployeeToWebAppId") .HasColumnType("int") .HasColumnName("EMPLOYEE_TO_WEB_APP_ID"); b.HasKey("WebAppToDepartmentId"); b.ToTable("TBSTF_WEB_APP_TO_DEPARTMENT", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WebAppToWebAppAdditionalRole", b => { b.Property("WebAppToWebAppAdditionalRoleId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WEB_APP_TO_WEB_APP_ADDITIONAL_ROLE_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WebAppToWebAppAdditionalRoleId"), 1L, 1); b.Property("EmployeeToWebAppId") .HasColumnType("int") .HasColumnName("EMPLOYEE_TO_WEB_APP_ID"); b.Property("WebAppAdditionalRoleId") .HasColumnType("int") .HasColumnName("WEB_APP_ADDITIONAL_ROLE_ID"); b.HasKey("WebAppToWebAppAdditionalRoleId"); b.ToTable("TBSTF_WEB_APP_TO_WEB_APP_ADDITIONAL_ROLE", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WebAppToWebAppRole", b => { b.Property("WebAppToWebAppRoleId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WEB_APP_TO_WEB_APP_ROLE_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WebAppToWebAppRoleId"), 1L, 1); b.Property("WebAppId") .HasColumnType("int") .HasColumnName("WEB_APP_ID"); b.Property("WebAppRoleHierarchy") .ValueGeneratedOnAddOrUpdate() .HasColumnType("int") .HasColumnName("WEB_APP_ROLE_HIERARCHY"); b.Property("WebAppRoleId") .HasColumnType("int") .HasColumnName("WEB_APP_ROLE_ID"); b.Property("WebAppRoleName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WEB_APP_ROLE_NAME"); b.HasKey("WebAppToWebAppRoleId"); b.ToTable("TBSTF_WEB_APP_TO_WEB_APP_ROLE", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WindreamColumnsToDepartment", b => { b.Property("WindreamColumnsToDepartmentId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WINDREAM_COLUMNS_TO_DEPARTMENT_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WindreamColumnsToDepartmentId"), 1L, 1); b.Property("AttributeDwAttrId") .HasColumnType("int") .HasColumnName("ATTRIBUTE_DW_ATTR_ID"); b.Property("AttributeDwAttrType") .HasColumnType("int") .HasColumnName("ATTRIBUTE_DW_ATTR_TYPE"); b.Property("AttributeSzColumnName") .HasColumnType("nvarchar(max)") .HasColumnName("ATTRIBUTE_SZ_COLUMN_NAME"); b.Property("ClientId") .HasColumnType("int") .HasColumnName("CLIENT_ID"); b.Property("Comment") .HasColumnType("nvarchar(max)") .HasColumnName("COMMENT"); b.Property("ComumnLength") .HasColumnType("int") .HasColumnName("COMUMN_LENGTH"); b.Property("DepartmentId") .HasColumnType("int") .HasColumnName("DEPARTMENT_ID"); b.Property("ObjectTypeAttributeSzName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("OBJECT_TYPE_ATTRIBUTE_SZ_NAME"); b.Property("ObjectTypeszDocTypeName") .HasColumnType("nvarchar(max)") .HasColumnName("OBJECT_TYPESZ_DOC_TYPE_NAME"); b.Property("Seq") .HasColumnType("int") .HasColumnName("SEQ"); b.Property("WindreamSearchId") .HasColumnType("int") .HasColumnName("WINDREAM_SEARCH_ID"); b.HasKey("WindreamColumnsToDepartmentId"); b.ToTable("TBSTF_WINDREAM_COLUMNS_TO_DEPARTMENT", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WindreamIndex", b => { b.Property("WindreamIndexId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WINDREAM_INDEX_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WindreamIndexId"), 1L, 1); b.Property("AttributeDwAttrId") .HasColumnType("int") .HasColumnName("ATTRIBUTE_DW_ATTR_ID"); b.Property("AttributeDwAttrType") .HasColumnType("int") .HasColumnName("ATTRIBUTE_DW_ATTR_TYPE"); b.Property("AttributeSzColumnName") .HasColumnType("nvarchar(max)") .HasColumnName("ATTRIBUTE_SZ_COLUMN_NAME"); b.Property("ClientId") .HasColumnType("int") .HasColumnName("CLIENT_ID"); b.Property("Comment") .HasColumnType("nvarchar(max)") .HasColumnName("COMMENT"); b.Property("ComumnLength") .HasColumnType("int") .HasColumnName("COMUMN_LENGTH"); b.Property("ObjectTypeAttributeSzName") .HasColumnType("nvarchar(max)") .HasColumnName("OBJECT_TYPE_ATTRIBUTE_SZ_NAME"); b.HasKey("WindreamIndexId"); b.ToTable("TBSTF_WINDREAM_INDEX", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WindreamIndexToWindreamSearchToDepartment", b => { b.Property("WindreamIndexToWindreamSearchToDepartmentId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WINDREAM_INDEX_TO_WINDREAM_SEARCH_TO_DEPARTMENT_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WindreamIndexToWindreamSearchToDepartmentId"), 1L, 1); b.Property("AttributeSzColumnName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("ATTRIBUTE_SZ_COLUMN_NAME"); b.Property("ObjectTypeAttributeSzName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("OBJECT_TYPE_ATTRIBUTE_SZ_NAME"); b.Property("Seq") .HasColumnType("int") .HasColumnName("SEQ"); b.Property("WindreamIndexId") .HasColumnType("int") .HasColumnName("WINDREAM_INDEX_ID"); b.Property("WindreamSearchToDepartmentId") .HasColumnType("int") .HasColumnName("WINDREAM_SEARCH_TO_DEPARTMENT_ID"); b.HasKey("WindreamIndexToWindreamSearchToDepartmentId"); b.ToTable("TBSTF_WINDREAM_INDEX_TO_WINDREAM_SEARCH_TO_DEPARTMENT", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WindreamInputFolder", b => { b.Property("WindreamInputFolderId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WINDREAM_INPUT_FOLDER_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WindreamInputFolderId"), 1L, 1); b.Property("ClientId") .HasColumnType("int") .HasColumnName("CLIENT_ID"); b.Property("Comment") .HasColumnType("nvarchar(max)") .HasColumnName("COMMENT"); b.Property("Name") .HasColumnType("nvarchar(max)") .HasColumnName("NAME"); b.Property("XMLPath") .HasColumnType("nvarchar(max)") .HasColumnName("XMLPATH"); b.HasKey("WindreamInputFolderId"); b.ToTable("TBSTF_WINDREAM_INPUT_FOLDER", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WindreamSearch", b => { b.Property("WindreamSearchId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WINDREAM_SEARCH_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WindreamSearchId"), 1L, 1); b.Property("ClientId") .HasColumnType("int") .HasColumnName("CLIENT_ID"); b.Property("Color") .HasColumnType("int") .HasColumnName("COLOR"); b.Property("Comment") .HasColumnType("nvarchar(max)") .HasColumnName("COMMENT"); b.Property("Name") .HasColumnType("nvarchar(max)") .HasColumnName("NAME"); b.Property("SearchIndex") .HasColumnType("int") .HasColumnName("SEARCH_INDEX"); b.Property("XMLPath") .HasColumnType("nvarchar(max)") .HasColumnName("XMLPATH"); b.HasKey("WindreamSearchId"); b.ToTable("TBSTF_WINDREAM_SEARCH", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WindreamSearchItem", b => { b.Property("WindreamSearchItemId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WINDREAM_SEARCH_ITEM_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WindreamSearchItemId"), 1L, 1); b.Property("AlternativeWindreamSearchItemIdList") .HasColumnType("nvarchar(max)") .HasColumnName("ALTERNATIVE_WINDREAM_SEARCH_ITEM_ID_LIST"); b.Property("Caption") .HasColumnType("nvarchar(max)") .HasColumnName("CAPTION"); b.Property("ClientId") .HasColumnType("int") .HasColumnName("CLIENT_ID"); b.Property("Comment") .HasColumnType("nvarchar(max)") .HasColumnName("COMMENT"); b.Property("ConnectedList") .HasColumnType("nvarchar(max)") .HasColumnName("CONNECTED_LIST"); b.Property("Name") .HasColumnType("nvarchar(max)") .HasColumnName("NAME"); b.Property("PlaceHolder") .HasColumnType("nvarchar(max)") .HasColumnName("PLACE_HOLDER"); b.Property("SearchTemplate") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("SEARCH_TEMPLATE"); b.HasKey("WindreamSearchItemId"); b.ToTable("TBSTF_WINDREAM_SEARCH_ITEM", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WindreamSearchItemToWindreamSearchToDepartment", b => { b.Property("WindreamSearchItemToWindreamSearchToDepartmentId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WINDREAM_SEARCH_ITEM_TO_WINDREAM_SEARCH_TO_DEPARTMENT_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WindreamSearchItemToWindreamSearchToDepartmentId"), 1L, 1); b.Property("DepartmentId") .ValueGeneratedOnAddOrUpdate() .HasColumnType("int") .HasColumnName("DEPARTMENT_ID"); b.Property("Seq") .HasColumnType("int") .HasColumnName("SEQ"); b.Property("WindreamSearchIndexType") .ValueGeneratedOnAddOrUpdate() .HasColumnType("int") .HasColumnName("WINDREAM_SEARCH_INDEX_TYPE"); b.Property("WindreamSearchItemCaption") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WINDREAM_SEARCH_ITEM_CAPTION"); b.Property("WindreamSearchItemComment") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WINDREAM_SEARCH_ITEM_COMMENT"); b.Property("WindreamSearchItemConnectedList") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WINDREAM_SEARCH_ITEM_CONNECTED_LIST"); b.Property("WindreamSearchItemId") .HasColumnType("int") .HasColumnName("WINDREAM_SEARCH_ITEM_ID"); b.Property("WindreamSearchItemName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WINDREAM_SEARCH_ITEM_NAME"); b.Property("WindreamSearchItemPlaceHolder") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WINDREAM_SEARCH_ITEM_PLACE_HOLDER"); b.Property("WindreamSearchItemSearchTemplate") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WINDREAM_SEARCH_ITEM_SEARCH_TEMPLATE"); b.Property("WindreamSearchItemTemplate") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WINDREAM_SEARCH_ITEM_TEMPLATE"); b.Property("WindreamSearchToDepartmentId") .HasColumnType("int") .HasColumnName("WINDREAM_SEARCH_TO_DEPARTMENT_ID"); b.HasKey("WindreamSearchItemToWindreamSearchToDepartmentId"); b.ToTable("TBSTF_WINDREAM_SEARCH_ITEM_TO_WINDREAM_SEARCH_TO_DEPARTMENT", "dbo"); }); modelBuilder.Entity("DAL.Models.Entities.WindreamSearchToDepartment", b => { b.Property("WindreamSearchToDepartmentId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("WINDREAM_SEARCH_TO_DEPARTMENT_ID"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("WindreamSearchToDepartmentId"), 1L, 1); b.Property("DepartmentId") .HasColumnType("int") .HasColumnName("DEPARTMENT_ID"); b.Property("DepartmentName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("DEPARTMENT_NAME"); b.Property("IsActive") .HasColumnType("bit") .HasColumnName("IS_ACTIVE"); b.Property("Seq") .HasColumnType("int") .HasColumnName("SEQ"); b.Property("WindreamSearchColor") .ValueGeneratedOnAddOrUpdate() .HasColumnType("int") .HasColumnName("WINDREAM_SEARCH_COLOR"); b.Property("WindreamSearchComment") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WINDREAM_SEARCH_COMMENT"); b.Property("WindreamSearchId") .HasColumnType("int") .HasColumnName("WINDREAM_SEARCH_ID"); b.Property("WindreamSearchName") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WINDREAM_SEARCH_NAME"); b.Property("WindreamSearchXMLPath") .ValueGeneratedOnAddOrUpdate() .HasColumnType("nvarchar(max)") .HasColumnName("WINDREAM_SEARCH_XMLPATH"); b.HasKey("WindreamSearchToDepartmentId"); b.ToTable("TBSTF_WINDREAM_SEARCH_TO_DEPARTMENT", "dbo"); }); #pragma warning restore 612, 618 } } }