2023-05-17 16:30:13 +10:00
// <auto-generated />
2023-05-19 15:15:52 +10:00
using System ;
2023-05-17 16:30:13 +10:00
using Microsoft.EntityFrameworkCore ;
using Microsoft.EntityFrameworkCore.Infrastructure ;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion ;
using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata ;
using PARR.DAL.Context ;
#nullable disable
namespace PARR.DAL.Migrations
{
[DbContext(typeof(DataContext))]
partial class DataContextModelSnapshot : ModelSnapshot
{
protected override void BuildModel ( ModelBuilder modelBuilder )
{
#pragma warning disable 612 , 618
modelBuilder
2026-05-20 14:26:25 +10:00
. HasAnnotation ( "ProductVersion" , "9.0.16" )
2023-05-17 16:30:13 +10:00
. HasAnnotation ( "Relational:MaxIdentifierLength" , 63 ) ;
NpgsqlModelBuilderExtensions . UseIdentityByDefaultColumns ( modelBuilder ) ;
2023-05-19 15:15:52 +10:00
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.AgentHistory" , b = >
2023-10-19 11:22:35 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < int > ( "HistoryLevelId" )
. HasColumnType ( "integer" ) ;
b . Property < string > ( "Message" )
. HasColumnType ( "text" ) ;
2023-10-24 10:38:21 +10:00
b . Property < Guid ? > ( "OrderId" )
. HasColumnType ( "uuid" ) ;
2023-10-19 11:22:35 +10:00
b . Property < Guid > ( "TemplateId" )
. HasColumnType ( "uuid" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "HistoryLevelId" ) ;
2023-10-24 10:38:21 +10:00
b . HasIndex ( "OrderId" ) ;
2023-10-19 11:22:35 +10:00
b . HasIndex ( "TemplateId" ) ;
2026-05-12 16:34:31 +10:00
b . ToTable ( "AgentHistories" ) ;
2023-10-19 11:22:35 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.AgentHistoryLevel" , b = >
2023-10-19 11:22:35 +10:00
{
b . Property < int > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "integer" ) ;
NpgsqlPropertyBuilderExtensions . UseIdentityByDefaultColumn ( b . Property < int > ( "Id" ) ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
2026-05-12 16:34:31 +10:00
b . ToTable ( "AgentHistoryLevels" ) ;
2023-10-19 11:22:35 +10:00
b . HasData (
new
{
Id = 1 ,
Description = "Агент начал выполнять задание" ,
Name = "Start"
} ,
new
{
Id = 5 ,
Description = "Агент завершил выполнение задания" ,
Name = "End"
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.DistributionPeriod" , b = >
2024-07-01 12:09:01 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
2024-07-01 16:56:59 +10:00
b . Property < string > ( "Duration" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
2024-07-01 12:09:01 +10:00
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
2024-07-01 16:56:59 +10:00
b . Property < string > ( "Type" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
2024-07-01 12:09:01 +10:00
b . HasKey ( "Id" ) ;
2024-07-01 16:56:59 +10:00
b . HasIndex ( "Type" ) ;
2026-01-20 16:17:09 +10:00
b . ToTable ( "DistributionPeriods" , "schedule" ) ;
2024-07-01 12:09:01 +10:00
b . HasData (
2026-01-20 16:17:09 +10:00
new
{
Id = new Guid ( "9bd0bfa8-c316-480b-a001-e09ffe8c9340" ) ,
Duration = "7" ,
Name = "Еженедельно" ,
Type = "Day"
} ,
2024-07-01 12:09:01 +10:00
new
{
Id = new Guid ( "3a7341a8-085c-461c-babc-6b78dd5d2c67" ) ,
2026-01-20 16:17:09 +10:00
Duration = "30" ,
2024-07-01 16:56:59 +10:00
Name = "Ежемесячно" ,
2026-01-20 16:17:09 +10:00
Type = "Day"
2024-07-01 12:09:01 +10:00
} ,
new
{
Id = new Guid ( "0ad2dfdb-3833-46d9-979a-c408b7eadc6c" ) ,
2024-07-01 16:56:59 +10:00
Duration = "90" ,
Name = "Каждые 90 дней" ,
Type = "Day"
2026-01-20 16:17:09 +10:00
} ,
new
{
Id = new Guid ( "31dd3947-8471-4f09-852c-a4f075f1ba7f" ) ,
Duration = "182" ,
Name = "Каждые пол года" ,
Type = "Day"
2024-07-01 16:56:59 +10:00
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.DistributionPeriodType" , b = >
2024-07-01 16:56:59 +10:00
{
b . Property < string > ( "Type" )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Type" ) ;
2026-01-20 16:17:09 +10:00
b . ToTable ( "DistributionPeriodTypes" , "schedule" ) ;
2024-07-01 16:56:59 +10:00
b . HasData (
new
{
Type = "Day" ,
Description = "День"
} ,
new
{
Type = "Month" ,
Description = "Месяц"
} ,
new
{
Type = "Year" ,
Description = "Год"
2024-07-01 12:09:01 +10:00
} ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.Job" , b = >
2023-10-10 15:52:34 +10:00
{
2026-05-12 16:34:31 +10:00
b . Property < Guid > ( "Id" )
2023-10-10 15:52:34 +10:00
. ValueGeneratedOnAdd ( )
2026-05-12 16:34:31 +10:00
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "DateModified" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < Guid > ( "GroupId" )
. HasColumnType ( "uuid" ) ;
b . Property < bool? > ( "IsParentRelationships" )
. HasColumnType ( "boolean" ) ;
b . Property < int? > ( "MaxValueRelationships" )
2023-10-10 15:52:34 +10:00
. HasColumnType ( "integer" ) ;
2026-05-12 16:34:31 +10:00
b . Property < int? > ( "MinValueRelationships" )
. HasColumnType ( "integer" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . Property < string > ( "Name" )
2023-10-10 15:52:34 +10:00
. IsRequired ( )
. HasColumnType ( "text" ) ;
2026-05-12 16:34:31 +10:00
b . Property < string > ( "ResponseAreaMask" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "TemplateNameMask" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < Guid > ( "TnkId" )
. HasColumnType ( "uuid" ) ;
b . Property < string > ( "WorkGroupMask" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "WorkName" )
2023-10-10 15:52:34 +10:00
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
2026-05-12 16:34:31 +10:00
b . HasIndex ( "GroupId" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . HasIndex ( "TnkId" ) ;
b . ToTable ( "Jobs" , "job" , t = >
2023-10-10 15:52:34 +10:00
{
2026-05-12 16:34:31 +10:00
t . HasComment ( "Таблица видов работ" ) ;
} ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.JobAutoControl" , b = >
2026-05-12 16:34:31 +10:00
{
b . Property < Guid > ( "JobId" )
. HasColumnType ( "uuid" ) ;
b . Property < bool > ( "InitUsedScheduleState" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "InitUsedTemplateState" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "IsEnable" )
. HasColumnType ( "boolean" ) ;
b . HasKey ( "JobId" ) ;
b . ToTable ( "AutoControls" , "job" , t = >
2023-10-10 15:52:34 +10:00
{
2026-05-12 16:34:31 +10:00
t . HasComment ( "Таблица управления автоконтролем для работ" ) ;
2023-10-10 15:52:34 +10:00
} ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.JobFieldFilter" , b = >
2023-10-10 15:52:34 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
2026-05-12 16:34:31 +10:00
b . Property < Guid > ( "FieldId" )
. HasColumnType ( "uuid" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . Property < bool > ( "IsInverse" )
. HasColumnType ( "boolean" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . Property < Guid > ( "UnitFilterId" )
. HasColumnType ( "uuid" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . Property < string > ( "ValueMask" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . HasKey ( "Id" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . HasIndex ( "FieldId" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . HasIndex ( "UnitFilterId" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . ToTable ( "FieldFilters" , "job" , t = >
2023-10-10 15:52:34 +10:00
{
2026-05-12 16:34:31 +10:00
t . HasComment ( "Таблица описания критериев выборки аттрибутов ЭК" ) ;
2023-10-10 15:52:34 +10:00
} ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.JobRelationshipFilter" , b = >
2026-06-15 16:56:23 +10:00
{
b . Property < Guid > ( "UnitFilterId" )
. HasColumnType ( "uuid" ) ;
b . Property < Guid > ( "FieldId" )
. HasColumnType ( "uuid" ) ;
b . Property < bool > ( "IsFullMatch" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "IsInverse" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "IsParent" )
. HasColumnType ( "boolean" ) ;
b . Property < string > ( "ValueMask" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "UnitFilterId" , "FieldId" ) ;
b . HasIndex ( "FieldId" ) ;
b . ToTable ( "RelationshipFilters" , "job" , t = >
{
t . HasComment ( "Таблица фильтров связей ЭК" ) ;
} ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.JobUnitFilter" , b = >
2026-06-15 16:56:23 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < Guid > ( "JobId" )
. HasColumnType ( "uuid" ) ;
b . Property < string > ( "UnitFilter" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "JobId" ) ;
b . ToTable ( "UnitFilters" , "job" , t = >
{
t . HasComment ( "Таблица описания критериев выборки ЭК, описание полей в А С У ЕСПП" ) ;
} ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.UnitsInTemplate" , b = >
2026-06-15 16:56:23 +10:00
{
b . Property < Guid > ( "TemplateId" )
. HasColumnType ( "uuid" ) ;
b . Property < Guid > ( "UnitId" )
. HasColumnType ( "uuid" ) ;
b . Property < Guid > ( "UnitFieldValueId" )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . HasKey ( "TemplateId" , "UnitId" , "UnitFieldValueId" ) ;
b . HasIndex ( "UnitFieldValueId" ) ;
b . HasIndex ( "UnitId" ) ;
b . ToTable ( "UnitsInTemplates" , "job" , t = >
{
t . HasComment ( "Таблица связи ЭК в шаблонах" ) ;
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroup" , b = >
2023-10-10 15:52:34 +10:00
{
2026-05-12 16:34:31 +10:00
b . Property < Guid > ( "Id" )
2023-10-10 15:52:34 +10:00
. ValueGeneratedOnAdd ( )
2026-05-12 16:34:31 +10:00
. HasColumnType ( "uuid" ) ;
b . Property < string > ( "AgentName" )
. HasColumnType ( "text" ) ;
b . Property < string > ( "AgentScript" )
. HasColumnType ( "text" ) ;
b . Property < int? > ( "AgentTimeOutSec" )
2023-10-10 15:52:34 +10:00
. HasColumnType ( "integer" ) ;
2026-05-12 16:34:31 +10:00
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . Property < DateTimeOffset ? > ( "DateModified" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "FullDescription" )
2023-10-10 15:52:34 +10:00
. IsRequired ( )
. HasColumnType ( "text" ) ;
2026-05-12 16:34:31 +10:00
b . Property < string > ( "GroupName" )
2023-10-10 15:52:34 +10:00
. IsRequired ( )
. HasColumnType ( "text" ) ;
2026-05-12 16:34:31 +10:00
b . Property < Guid > ( "GroupTypeId" )
. HasColumnType ( "uuid" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . Property < Guid ? > ( "GroupingUnitFieldId" )
. HasColumnType ( "uuid" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . Property < bool > ( "IsAgent" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "IsAutoDistributionEnabled" )
. HasColumnType ( "boolean" ) ;
b . Property < bool? > ( "IsGroupByResponsible" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "IsResponseAreaTimezone" )
. HasColumnType ( "boolean" ) ;
b . Property < DateTimeOffset > ( "ReferenceDate" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < Guid ? > ( "ScheduleExcludeTypeCalendarId" )
. HasColumnType ( "uuid" ) ;
b . Property < Guid > ( "ScheduleExcludeTypeId" )
. HasColumnType ( "uuid" ) ;
b . Property < string > ( "ShortDescription" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Solution" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "TemplateDuration" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < int? > ( "UserTimeZoneOffsetMinutes" )
. HasColumnType ( "integer" )
. HasComment ( "Смещение часового пояса пользователя в минутах относительно UTC на момент ReferenceDate" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "GroupTypeId" ) ;
b . HasIndex ( "GroupingUnitFieldId" ) ;
b . HasIndex ( "ScheduleExcludeTypeCalendarId" ) ;
b . HasIndex ( "ScheduleExcludeTypeId" ) ;
2026-06-15 16:56:23 +10:00
b . ToTable ( "Groups" , "jobGroup" , t = >
2023-10-10 15:52:34 +10:00
{
2026-05-12 16:34:31 +10:00
t . HasComment ( "Таблица описания групп работ, для реализации зонтиков" ) ;
} ) ;
} ) ;
2026-06-15 16:56:23 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupAutoControl" , b = >
{
b . Property < Guid > ( "JobGroupId" )
. HasColumnType ( "uuid" ) ;
b . Property < bool > ( "InitUsedScheduleState" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "InitUsedTemplateState" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "IsEnable" )
. HasColumnType ( "boolean" ) ;
b . HasKey ( "JobGroupId" ) ;
b . ToTable ( "AutoControls" , "jobGroup" , t = >
{
t . HasComment ( "Таблица управления автоконтролем для группы работ" ) ;
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupDistributionConfig" , b = >
2026-05-12 16:34:31 +10:00
{
b . Property < Guid > ( "GroupId" )
. HasColumnType ( "uuid" ) ;
b . Property < Guid > ( "DistributionPeriodId" )
. HasColumnType ( "uuid" ) ;
b . Property < bool > ( "IsExcludeWeekends" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "IsGroupingByWorkGroup" )
. HasColumnType ( "boolean" ) ;
b . HasKey ( "GroupId" ) ;
b . HasIndex ( "DistributionPeriodId" ) ;
2026-06-15 16:56:23 +10:00
b . ToTable ( "GroupDistributionConfigs" , "jobGroup" , t = >
2023-10-10 15:52:34 +10:00
{
2026-05-12 16:34:31 +10:00
t . HasComment ( "Настройки автораспределения для группы работ" ) ;
2023-10-10 15:52:34 +10:00
} ) ;
} ) ;
2026-06-15 16:56:23 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupFieldFilter" , b = >
2023-10-10 15:52:34 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
2026-06-15 16:56:23 +10:00
b . Property < Guid > ( "FieldId" )
. HasColumnType ( "uuid" ) ;
2023-11-27 12:06:16 +10:00
2026-06-15 16:56:23 +10:00
b . Property < bool > ( "IsInverse" )
. HasColumnType ( "boolean" ) ;
b . Property < Guid > ( "UnitFilterId" )
. HasColumnType ( "uuid" ) ;
b . Property < string > ( "ValueMask" )
2023-10-10 15:52:34 +10:00
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
2026-06-15 16:56:23 +10:00
b . HasIndex ( "FieldId" )
. HasDatabaseName ( "IX_FieldFilters_FieldId1" ) ;
2023-10-10 15:52:34 +10:00
2026-06-15 16:56:23 +10:00
b . HasIndex ( "UnitFilterId" )
. HasDatabaseName ( "IX_FieldFilters_UnitFilterId1" ) ;
b . ToTable ( "FieldFilters" , "jobGroup" , t = >
2023-10-10 15:52:34 +10:00
{
2026-06-15 16:56:23 +10:00
t . HasComment ( "Таблица описания критериев выборки аттрибутов ЭК" ) ;
2026-05-12 16:34:31 +10:00
} ) ;
} ) ;
2026-06-15 16:56:23 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupRelationshipFilter" , b = >
2026-05-12 16:34:31 +10:00
{
b . Property < Guid > ( "UnitFilterId" )
. HasColumnType ( "uuid" ) ;
b . Property < Guid > ( "FieldId" )
. HasColumnType ( "uuid" ) ;
b . Property < bool > ( "IsFullMatch" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "IsInverse" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "IsParent" )
. HasColumnType ( "boolean" ) ;
b . Property < string > ( "ValueMask" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "UnitFilterId" , "FieldId" ) ;
2026-06-15 16:56:23 +10:00
b . HasIndex ( "FieldId" )
. HasDatabaseName ( "IX_RelationshipFilters_FieldId1" ) ;
2026-05-12 16:34:31 +10:00
2026-06-15 16:56:23 +10:00
b . ToTable ( "RelationshipFilters" , "jobGroup" , t = >
2023-10-10 15:52:34 +10:00
{
2026-05-12 16:34:31 +10:00
t . HasComment ( "Таблица фильтров связей ЭК" ) ;
} ) ;
} ) ;
2026-06-15 16:56:23 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupType" , b = >
2026-05-12 16:34:31 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
2026-06-15 16:56:23 +10:00
b . Property < int > ( "Code" )
. HasColumnType ( "integer" ) ;
2026-05-12 16:34:31 +10:00
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
2026-06-15 16:56:23 +10:00
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
2026-05-12 16:34:31 +10:00
2026-06-15 16:56:23 +10:00
b . Property < bool > ( "IsAllowJobUnitFilter" )
. HasColumnType ( "boolean" )
. HasComment ( "Разрешить Job фильтры. Влияет только на интерфейс. Мэтчер собирает все фильтры из группы и работ всегда." ) ;
b . Property < bool > ( "IsJobGroupAutoControl" )
. HasColumnType ( "boolean" )
. HasComment ( "Автоконтролем управляет JobGroup? true - да JobGroup, false - Job. Влияет на интерфейс и на логику работы автоконтроля." ) ;
2026-06-18 16:39:35 +10:00
b . Property < bool > ( "IsRelationshipsAllowed" )
. HasColumnType ( "boolean" )
. HasComment ( "Разрешена настройка кол-ва связей" ) ;
2026-06-15 16:56:23 +10:00
b . Property < string > ( "Name" )
2026-05-12 16:34:31 +10:00
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
2026-06-15 16:56:23 +10:00
b . ToTable ( "GroupTypes" , "jobGroup" , t = >
{
t . HasComment ( "Таблица типов групп работ" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
2026-06-15 16:56:23 +10:00
b . HasData (
new
2023-10-10 15:52:34 +10:00
{
2026-06-15 16:56:23 +10:00
Id = new Guid ( "4fa62e79-86bb-47c2-be1a-72a716a170fa" ) ,
Code = 0 ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
Description = "Обычный" ,
IsAllowJobUnitFilter = true ,
IsJobGroupAutoControl = false ,
2026-06-18 16:39:35 +10:00
IsRelationshipsAllowed = false ,
2026-06-15 16:56:23 +10:00
Name = "Simple"
} ,
new
{
Id = new Guid ( "6ec58b1a-5c40-47b9-b036-4fa490e8d503" ) ,
Code = 1 ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
Description = "Зонтик" ,
IsAllowJobUnitFilter = false ,
IsJobGroupAutoControl = true ,
2026-06-18 16:39:35 +10:00
IsRelationshipsAllowed = true ,
2026-06-15 16:56:23 +10:00
Name = "Umbrella"
} ,
new
{
Id = new Guid ( "318625e5-f833-436a-99df-2a382a1e71c7" ) ,
Code = 2 ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
Description = "Сгруппированный" ,
IsAllowJobUnitFilter = false ,
IsJobGroupAutoControl = true ,
2026-06-18 16:39:35 +10:00
IsRelationshipsAllowed = true ,
2026-06-15 16:56:23 +10:00
Name = "Group"
2026-05-12 16:34:31 +10:00
} ) ;
} ) ;
2026-06-15 16:56:23 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupUnitFilter" , b = >
2026-05-12 16:34:31 +10:00
{
2026-06-15 16:56:23 +10:00
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
2026-05-12 16:34:31 +10:00
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
2026-06-15 16:56:23 +10:00
b . Property < Guid > ( "JobGroupId" )
. HasColumnType ( "uuid" ) ;
2026-05-12 16:34:31 +10:00
2026-06-15 16:56:23 +10:00
b . Property < string > ( "UnitFilter" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
2026-05-12 16:34:31 +10:00
2026-06-15 16:56:23 +10:00
b . HasKey ( "Id" ) ;
2026-05-12 16:34:31 +10:00
2026-06-15 16:56:23 +10:00
b . HasIndex ( "JobGroupId" ) ;
b . ToTable ( "UnitFilters" , "jobGroup" , t = >
2023-10-10 15:52:34 +10:00
{
2026-06-15 16:56:23 +10:00
t . HasComment ( "Таблица описания критериев выборки ЭК, описание полей в А С У ЕСПП" ) ;
2026-05-12 16:34:31 +10:00
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Order" , b = >
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "DateModified" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset > ( "ExpirationDate" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "GenerateDate" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < int? > ( "NextStatusCode" )
. HasColumnType ( "integer" ) ;
b . Property < string > ( "Number" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "ShortName" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < int > ( "StatusCode" )
. HasColumnType ( "integer" ) ;
b . Property < Guid ? > ( "TemplateId" )
. HasColumnType ( "uuid" ) ;
b . Property < string > ( "WorkGroup" )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "NextStatusCode" ) ;
b . HasIndex ( "Number" )
. IsUnique ( ) ;
b . HasIndex ( "StatusCode" ) ;
b . HasIndex ( "TemplateId" ) ;
b . ToTable ( "Orders" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.OrderStatus" , b = >
{
b . Property < int > ( "Code" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "integer" ) ;
NpgsqlPropertyBuilderExtensions . UseIdentityByDefaultColumn ( b . Property < int > ( "Code" ) ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Code" ) ;
b . ToTable ( "OrderStatuses" ) ;
b . HasData (
2023-10-10 15:52:34 +10:00
new
{
2026-05-12 16:34:31 +10:00
Code = 1 ,
Description = "1-Направлен в группу" ,
Name = "New"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Code = 2 ,
Description = "2-В работе" ,
Name = "InWork"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Code = 3 ,
Description = "3-Приостановлен" ,
Name = "Stop"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Code = 4 ,
Description = "4-Выполнен" ,
Name = "Complete"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Code = 5 ,
Description = "5-Закрыт" ,
Name = "Closed"
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.ParrComponent" , b = >
{
b . Property < int > ( "Id" )
. HasColumnType ( "integer" ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "Name" )
. IsUnique ( ) ;
b . ToTable ( "ParrComponents" ) ;
b . HasData (
2023-10-10 15:52:34 +10:00
new
{
2026-05-12 16:34:31 +10:00
Id = 0 ,
Description = "API" ,
Name = "Api"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 1 ,
Description = "Загрузчик из АИХИТ" ,
Name = "AihitLoader"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 2 ,
Description = "Синхронизатор АИХИТ" ,
Name = "AihitSyncer"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 3 ,
Description = "Загрузчик нарядов из ЕСПП" ,
Name = "EsppOrderLoader"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 4 ,
Description = "Управление нарядами ЕСПП" ,
Name = "EsppOrderManager"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 5 ,
Description = "Синхронизатор расписаний" ,
Name = "EsppScheduleSync"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 6 ,
Description = "Синхронизатор шаблонов" ,
Name = "EsppTemplateSync"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 7 ,
Description = "Генератор шаблонов" ,
Name = "GeneratorTemplates"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 8 ,
Description = "Авто-контроль Р Р " ,
Name = "JobAutoControl"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 9 ,
Description = "Связывание нарядов ЕСПП с ПАРР (шаблонами, агентами)" ,
Name = "Master"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 10 ,
Description = "Рассчет даты следующего срабатывания" ,
Name = "NextRun"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 11 ,
Description = "Активатор шаблонов / расписаний" ,
Name = "TemplateActivator"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 12 ,
Description = "Автораспределение Р Р " ,
Name = "TemplateDistributor"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 13 ,
Description = "Генератор шаблонов" ,
Name = "TemplateTaskGenerator"
2026-05-20 14:26:25 +10:00
} ,
new
{
Id = 14 ,
Description = "Генератор кэша отчетов workload" ,
Name = "WorkloadBuilder"
2026-05-12 16:34:31 +10:00
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Process" , b = >
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "DateModified" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < int > ( "EsppId" )
. HasColumnType ( "integer" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "EsppId" )
. IsUnique ( ) ;
b . ToTable ( "Processes" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.RobotConfiguration" , b = >
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < int > ( "AttemptsNumber" )
. HasColumnType ( "integer" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "LastRobotStatusUpdated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < int > ( "RobotCode" )
. HasColumnType ( "integer" ) ;
b . Property < int > ( "RobotStatusCode" )
. HasColumnType ( "integer" ) ;
b . Property < int > ( "TaskStatusCode" )
. HasColumnType ( "integer" ) ;
b . Property < Guid > ( "TemplateId" )
. HasColumnType ( "uuid" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "RobotStatusCode" ) ;
b . HasIndex ( "TaskStatusCode" ) ;
2026-07-29 09:50:21 +10:00
b . HasIndex ( "RobotCode" , "RobotStatusCode" ) ;
b . HasIndex ( "RobotCode" , "TaskStatusCode" ) ;
2026-05-12 16:34:31 +10:00
b . HasIndex ( "TemplateId" , "RobotCode" )
. IsUnique ( ) ;
b . HasIndex ( "TemplateId" , "RobotStatusCode" ) ;
b . HasIndex ( "TemplateId" , "TaskStatusCode" ) ;
b . ToTable ( "RobotConfigurations" ) ;
} ) ;
2026-07-21 11:48:21 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.Robot" , b = >
{
b . Property < int > ( "Code" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "integer" ) ;
NpgsqlPropertyBuilderExtensions . UseIdentityByDefaultColumn ( b . Property < int > ( "Code" ) ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Code" ) ;
b . HasIndex ( "Name" )
. IsUnique ( ) ;
b . ToTable ( "Robots" , "robot" ) ;
b . HasData (
new
{
Code = 1 ,
Description = "Робот по созданию/изменению шаблона наряда ЕСПП" ,
Name = "TemplateOrder"
} ,
new
{
Code = 2 ,
Description = "Робот по созданию/изменению расписания шаблона наряда в ЕСПП" ,
Name = "ScheduleOrder"
} ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.RobotConfigurationSnapshot" , b = >
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < int > ( "Count" )
. HasColumnType ( "integer" )
. HasComment ( "Количество заданий в этой комбинации статусов" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < int > ( "RobotCode" )
. HasColumnType ( "integer" ) ;
b . Property < int > ( "RobotStatusCode" )
. HasColumnType ( "integer" ) ;
b . Property < int > ( "TaskStatusCode" )
. HasColumnType ( "integer" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "RobotStatusCode" ) ;
b . HasIndex ( "TaskStatusCode" ) ;
b . HasIndex ( "RobotCode" , "DateCreated" ) ;
b . ToTable ( "ConfigurationSnapshots" , "robot" , t = >
{
t . HasComment ( "Снимки заданий роботам" ) ;
} ) ;
} ) ;
2026-07-21 11:48:21 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.RobotHistory" , b = >
2026-05-12 16:34:31 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "EsppMessage" )
. HasColumnType ( "text" ) ;
b . Property < int > ( "HistoryLevel" )
. HasColumnType ( "integer" ) ;
b . Property < Guid > ( "RobotConfigurationId" )
. HasColumnType ( "uuid" ) ;
2026-05-26 11:43:15 +10:00
b . Property < string > ( "RobotId" )
. HasColumnType ( "text" )
. HasComment ( "Идентификатор робота. Форматы: H20-R1-T, H20-R1-S, H20-R1-ET, H20-R1-ES." ) ;
2026-05-12 16:34:31 +10:00
b . Property < string > ( "RobotIp" )
. HasColumnType ( "text" ) ;
b . Property < string > ( "RobotMessage" )
. HasColumnType ( "text" ) ;
b . Property < int > ( "TaskStatusCode" )
. HasColumnType ( "integer" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "DateCreated" ) ;
b . HasIndex ( "TaskStatusCode" ) ;
b . HasIndex ( "HistoryLevel" , "DateCreated" )
. IsDescending ( false , true ) ;
b . HasIndex ( "RobotConfigurationId" , "DateCreated" ) ;
2026-07-21 11:48:21 +10:00
b . ToTable ( "Histories" , "robot" ) ;
2026-05-12 16:34:31 +10:00
} ) ;
2026-07-21 11:48:21 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.RobotHistoryLevel" , b = >
2026-05-12 16:34:31 +10:00
{
b . Property < int > ( "Level" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "integer" ) ;
NpgsqlPropertyBuilderExtensions . UseIdentityByDefaultColumn ( b . Property < int > ( "Level" ) ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Level" ) ;
2026-07-21 11:48:21 +10:00
b . ToTable ( "HistoryLevels" , "robot" ) ;
2026-05-12 16:34:31 +10:00
b . HasData (
2023-10-10 15:52:34 +10:00
new
{
2026-05-12 16:34:31 +10:00
Level = 1 ,
Description = "Робот начал работу " ,
Name = "Start"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Level = 5 ,
Description = "Информация" ,
Name = "Information"
2023-09-25 15:32:22 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Level = 10 ,
Description = "Ошибка" ,
Name = "Error"
2023-09-25 15:32:22 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Level = 15 ,
Description = "Успешно завершил работу" ,
Name = "Complete"
} ) ;
} ) ;
2026-07-21 11:48:21 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.RobotSnapshot" , b = >
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "Ip" )
. IsRequired ( )
. HasMaxLength ( 45 )
. HasColumnType ( "character varying(45)" )
. HasComment ( "Текущий IP-адрес сервера" ) ;
b . Property < int > ( "MaxRobots" )
. HasColumnType ( "integer" )
. HasComment ( "Максимально разрешенное количество роботов на сервере" ) ;
b . Property < int > ( "ScheduleRobotsCount" )
. HasColumnType ( "integer" )
. HasComment ( "Количество запущенных роботов по расписаниям" ) ;
b . Property < int > ( "TemplateRobotsCount" )
. HasColumnType ( "integer" )
. HasComment ( "Количество запущенных роботов по шаблонам" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "Ip" , "DateCreated" ) ;
b . ToTable ( "Snapshots" , "robot" , t = >
{
t . HasComment ( "Снимки роботов" ) ;
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.RobotStatus" , b = >
2026-05-12 16:34:31 +10:00
{
b . Property < int > ( "Code" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "integer" ) ;
NpgsqlPropertyBuilderExtensions . UseIdentityByDefaultColumn ( b . Property < int > ( "Code" ) ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Code" ) ;
2026-07-21 11:48:21 +10:00
b . ToTable ( "RobotStatuses" , "robot" ) ;
2026-05-12 16:34:31 +10:00
b . HasData (
new
{
Code = 11 ,
Description = "Ожидание, ждет пока робот возьмет в работу." ,
Name = "Wait"
2023-09-25 15:32:22 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Code = 22 ,
Description = "Робот взял в работу." ,
Name = "InProgress"
2023-09-25 15:32:22 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Code = 33 ,
Description = "Ошибка отработки роботом. Требует ручного вмешательства." ,
Name = "Error"
2023-09-25 15:32:22 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Code = 44 ,
Description = "Робот успешно отработал." ,
Name = "Complete"
} ) ;
} ) ;
2026-07-21 11:48:21 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.TaskStatus" , b = >
{
b . Property < int > ( "Code" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "integer" ) ;
NpgsqlPropertyBuilderExtensions . UseIdentityByDefaultColumn ( b . Property < int > ( "Code" ) ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Code" ) ;
b . ToTable ( "TaskStatuses" , "robot" ) ;
b . HasData (
new
{
Code = 10 ,
Description = "Требуется создание объекта в ЕСПП" ,
Name = "Creating"
} ,
new
{
Code = 20 ,
Description = "Требуется обновление объекта в ЕСПП" ,
Name = "Updating"
} ,
new
{
Code = 30 ,
Description = "Нормальное состояние объекта в ЕСПП и ПАРР. Объект в ПАРР соответствует объекту в ЕСПП" ,
Name = "Ok"
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Role" , b = >
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
b . ToTable ( "Roles" ) ;
b . HasData (
2023-09-25 15:32:22 +10:00
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "c8f2f144-e6c2-45d7-ba66-5e9bbd376376" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
Description = "Администратор" ,
Name = "administrator"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "13bca225-7fa4-42fa-9d80-d2d46de261fe" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
Description = "Робот ЕСПП" ,
Name = "espp-robot"
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.EsppSchType" , b = >
{
b . Property < int > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "integer" ) ;
NpgsqlPropertyBuilderExtensions . UseIdentityByDefaultColumn ( b . Property < int > ( "Id" ) ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
b . ToTable ( "EsppSchTypes" , "schedule" ) ;
b . HasData (
2023-10-10 15:52:34 +10:00
new
{
2026-05-12 16:34:31 +10:00
Id = 1 ,
Description = "Через интервал" ,
Name = "Interval"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 2 ,
Description = "День недели: пнд, вт..." ,
Name = "DayOfWeek"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 3 ,
Description = "Число месяца: 1,2,3,4" ,
Name = "DayOfMonth"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 4 ,
Description = "Каждый: первый, второй, третий, четвертый, последний" ,
Name = "Order"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 5 ,
Description = "Месяц: январь, февраль..." ,
Name = "Month"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 6 ,
Description = "Месяц (родительный падеж): января, февраля..." ,
Name = "MonthGenitive"
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.EsppSchTypeConfig" , b = >
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "DateModified" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < int > ( "Order" )
. HasColumnType ( "integer" ) ;
b . Property < int > ( "TypeId" )
. HasColumnType ( "integer" ) ;
b . Property < int > ( "TypeScheduleId" )
. HasColumnType ( "integer" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "TypeId" ) ;
b . HasIndex ( "TypeScheduleId" , "TypeId" )
. IsUnique ( ) ;
b . ToTable ( "EsppSchTypeConfigs" , "schedule" ) ;
b . HasData (
2023-10-10 15:52:34 +10:00
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "d2693562-b3eb-41e9-97db-c6b5d2ef1bea" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
Order = 0 ,
TypeId = 1 ,
TypeScheduleId = 1
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "06b2e7aa-6927-4fbf-99fb-67c92a4fce8a" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
Order = 0 ,
TypeId = 2 ,
TypeScheduleId = 2
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "78079071-ff80-417e-9bb0-d928cec853e7" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
Order = 0 ,
2023-10-10 15:52:34 +10:00
TypeId = 3 ,
2026-05-12 16:34:31 +10:00
TypeScheduleId = 3
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "accb1d46-e1c1-4396-9182-4c0766155921" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
Order = 0 ,
TypeId = 4 ,
TypeScheduleId = 4
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "162ffe73-2428-4abe-8f83-235c2593664c" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
Order = 1 ,
TypeId = 2 ,
TypeScheduleId = 4
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "8470d1ef-165d-42fc-ab05-8203e4d263cf" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
Order = 0 ,
TypeId = 5 ,
TypeScheduleId = 5
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "006900b5-f65c-413e-bc67-09e6dae60b7c" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
Order = 1 ,
2023-10-10 15:52:34 +10:00
TypeId = 3 ,
2026-05-12 16:34:31 +10:00
TypeScheduleId = 5
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "85635bc8-f17a-46b8-9c15-8615761be3d9" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2024-04-08 12:16:14 +10:00
Order = 0 ,
2023-10-10 15:52:34 +10:00
TypeId = 4 ,
2026-05-12 16:34:31 +10:00
TypeScheduleId = 6
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "439460c2-deca-4b54-80e7-2f20806696ec" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2024-04-08 12:16:14 +10:00
Order = 1 ,
2026-05-12 16:34:31 +10:00
TypeId = 2 ,
TypeScheduleId = 6
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "5c63ad8c-e9b4-43fd-9d24-5c2eed80dadd" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2024-04-08 12:16:14 +10:00
Order = 2 ,
2026-05-12 16:34:31 +10:00
TypeId = 6 ,
TypeScheduleId = 6
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.EsppSchTypeSchedule" , b = >
{
b . Property < int > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "integer" ) ;
NpgsqlPropertyBuilderExtensions . UseIdentityByDefaultColumn ( b . Property < int > ( "Id" ) ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
b . ToTable ( "EsppSchTypeSchedules" , "schedule" ) ;
b . HasData (
new
{
Id = 1 ,
Description = "Регулярно" ,
Name = "Regularly"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 2 ,
Description = "Еженедельно" ,
Name = "Weekly"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 3 ,
Description = "Ежемесячно" ,
Name = "Monthly"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = 4 ,
Description = "Ежемесячно-2" ,
Name = "Monthly2"
} ,
new
{
Id = 5 ,
Description = "Ежегодно" ,
Name = "Annually"
} ,
new
{
Id = 6 ,
Description = "Ежегодно-2" ,
Name = "Annually2"
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.EsppSchTypeValue" , b = >
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "EsppExportValue" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < int > ( "Order" )
. HasColumnType ( "integer" ) ;
b . Property < int > ( "TypeId" )
. HasColumnType ( "integer" ) ;
b . Property < string > ( "Value" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "TypeId" ) ;
b . ToTable ( "EsppSchTypeValues" , "schedule" ) ;
b . HasData (
new
{
Id = new Guid ( "6e3b5dd2-b2f7-40bc-bace-15bfa6bbd4ff" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "01:00:00" ,
2024-04-08 12:16:14 +10:00
Order = 0 ,
2026-05-12 16:34:31 +10:00
TypeId = 1 ,
Value = "Каждый час"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "4df04834-f14f-43d9-8984-334f080f4107" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "02:00:00" ,
2024-04-08 12:16:14 +10:00
Order = 1 ,
2026-05-12 16:34:31 +10:00
TypeId = 1 ,
Value = "Каждые 2 часа"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "dab6e3f9-2385-4966-b77c-133ad233c592" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "03:00:00" ,
2024-04-08 12:16:14 +10:00
Order = 2 ,
2026-05-12 16:34:31 +10:00
TypeId = 1 ,
Value = "Каждые 3 часа"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "035f485d-8451-47df-bfaa-ba4dd36cf146" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "04:00:00" ,
2024-04-08 12:16:14 +10:00
Order = 3 ,
2026-05-12 16:34:31 +10:00
TypeId = 1 ,
Value = "Каждые 4 часа"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "d627daa7-3eed-4571-acae-ffbb3c5bedb9" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "06:00:00" ,
2024-04-08 12:16:14 +10:00
Order = 4 ,
2026-05-12 16:34:31 +10:00
TypeId = 1 ,
Value = "Каждые 6 часов"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "ae0a0015-0f1e-4496-b71e-6244f7e321e7" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "12:00:00" ,
2024-04-08 12:16:14 +10:00
Order = 5 ,
2026-05-12 16:34:31 +10:00
TypeId = 1 ,
Value = "Каждые 12 часов"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "8df097aa-9860-4a62-9675-a8eecd3f2ce7" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "1 00:00:00" ,
2024-04-08 12:16:14 +10:00
Order = 6 ,
2026-05-12 16:34:31 +10:00
TypeId = 1 ,
Value = "Ежедневно"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "dee32e60-c1a1-4206-98bc-aa03deabfdf6" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "3 00:00:00" ,
2024-04-08 12:16:14 +10:00
Order = 7 ,
2026-05-12 16:34:31 +10:00
TypeId = 1 ,
Value = "Каждые 72 часа"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "e0465fbf-e3a5-4486-9f53-5bb85c6feeca" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "4 00:00:00" ,
2024-04-08 12:16:14 +10:00
Order = 8 ,
2026-05-12 16:34:31 +10:00
TypeId = 1 ,
Value = "Каждые 96 часов"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "4e3f73d1-a0f3-4dd1-bca9-68ada0dd5ce2" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "14 00:00:00" ,
2024-04-08 12:16:14 +10:00
Order = 9 ,
2026-05-12 16:34:31 +10:00
TypeId = 1 ,
Value = "Каждые 2 недели"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "55833417-6a24-42f6-bcc2-5d032f883202" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "60 00:00:00" ,
2024-04-08 12:16:14 +10:00
Order = 10 ,
2026-05-12 16:34:31 +10:00
TypeId = 1 ,
Value = "Каждые 60 дней"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "7fefa052-29db-4ce5-9c57-2fd9ff855f21" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "80 00:00:00" ,
2024-04-08 12:16:14 +10:00
Order = 11 ,
2026-05-12 16:34:31 +10:00
TypeId = 1 ,
Value = "Каждые 80 дней"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "b0ca99f9-5ee0-45b3-bb80-948f82b1fcb1" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "90 00:00:00" ,
Order = 12 ,
TypeId = 1 ,
Value = "Каждые 90 дней"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "086f7a37-9848-423a-a3cc-36dbb5ad43e3" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "182 00:00:00" ,
Order = 13 ,
TypeId = 1 ,
Value = "Каждые полгода"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "f2da9e02-d619-4517-a598-374880a8c8e8" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "540 00:00:00" ,
Order = 14 ,
TypeId = 1 ,
Value = "Каждые 1,5 года"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "f38d7d30-8923-4ea0-aa7c-5b251e19ab61" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "1095 00:00:00" ,
Order = 15 ,
TypeId = 1 ,
Value = "Каждые 3 года"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "b7303461-9a30-43fa-8e55-305aa13f186f" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "1" ,
Order = 0 ,
TypeId = 2 ,
Value = "Понедельник"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "e951135e-71f2-4262-9342-df4d5315ab6c" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "2" ,
Order = 1 ,
TypeId = 2 ,
Value = "Вторник"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "c34d5375-70e7-4632-b3af-30e279a0621a" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "3" ,
Order = 2 ,
TypeId = 2 ,
Value = "Среда"
} ,
new
{
Id = new Guid ( "ec9540df-c2de-4bda-a063-34d02d4b6e03" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "4" ,
Order = 3 ,
TypeId = 2 ,
Value = "Четверг"
} ,
new
{
Id = new Guid ( "2ed85534-4684-4eb2-9ccb-e264d212c945" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "5" ,
Order = 4 ,
TypeId = 2 ,
Value = "Пятница"
} ,
new
{
Id = new Guid ( "a6804315-96ef-484e-82ee-c5795694468b" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "6" ,
Order = 5 ,
TypeId = 2 ,
Value = "Суббота"
} ,
new
{
Id = new Guid ( "eb71e699-937f-4894-9688-f7a7f95e5e58" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2023-11-27 12:06:16 +10:00
EsppExportValue = "7" ,
2024-04-08 12:16:14 +10:00
Order = 6 ,
2026-05-12 16:34:31 +10:00
TypeId = 2 ,
Value = "Воскресенье"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "e86adbfb-3345-4e0c-aa3b-b4418f9cfe88" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "1" ,
Order = 0 ,
TypeId = 3 ,
Value = "1"
} ,
new
{
Id = new Guid ( "5b4d7ca6-31e7-475b-b7c8-13c6680c3dc3" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "2" ,
Order = 1 ,
TypeId = 3 ,
Value = "2"
} ,
new
{
Id = new Guid ( "0da03db0-9404-425d-bea1-5da0c9b60b59" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "3" ,
Order = 2 ,
TypeId = 3 ,
Value = "3"
} ,
new
{
Id = new Guid ( "199474c8-0a77-47e5-aab8-ba33c216cc9e" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "4" ,
Order = 3 ,
TypeId = 3 ,
Value = "4"
} ,
new
{
Id = new Guid ( "e6619da1-f7e8-45b9-bbd3-9c17bec2ccd3" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "5" ,
Order = 4 ,
TypeId = 3 ,
Value = "5"
} ,
new
{
Id = new Guid ( "a8708763-c838-49a5-95fe-bf4f73518d71" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "6" ,
Order = 5 ,
TypeId = 3 ,
Value = "6"
} ,
new
{
Id = new Guid ( "7ec056aa-820c-4900-96cb-4564d2ea6398" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "7" ,
Order = 6 ,
TypeId = 3 ,
Value = "7"
} ,
new
{
Id = new Guid ( "554d7d0c-91b1-4b81-b94d-1ee864192962" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2023-11-27 12:06:16 +10:00
EsppExportValue = "8" ,
2024-04-08 12:16:14 +10:00
Order = 7 ,
2026-05-12 16:34:31 +10:00
TypeId = 3 ,
Value = "8"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "8b7847a4-23de-4199-8aad-3b5c0323b5a2" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2023-11-27 12:06:16 +10:00
EsppExportValue = "9" ,
2024-04-08 12:16:14 +10:00
Order = 8 ,
2026-05-12 16:34:31 +10:00
TypeId = 3 ,
Value = "9"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "fb7f41ca-950b-4dc1-a0a6-bd9a221ab2ad" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2023-11-27 12:06:16 +10:00
EsppExportValue = "10" ,
2024-04-08 12:16:14 +10:00
Order = 9 ,
2026-05-12 16:34:31 +10:00
TypeId = 3 ,
Value = "10"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "a28b530f-ea38-4a2c-a16b-0b7fa3770d3c" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2023-11-27 12:06:16 +10:00
EsppExportValue = "11" ,
2024-04-08 12:16:14 +10:00
Order = 10 ,
2026-05-12 16:34:31 +10:00
TypeId = 3 ,
Value = "11"
2023-10-10 15:52:34 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "7a004a11-32e1-40ae-ab35-0d3dc3a69785" ) ,
2023-10-10 15:52:34 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2023-11-27 12:06:16 +10:00
EsppExportValue = "12" ,
2024-04-08 12:16:14 +10:00
Order = 11 ,
2026-05-12 16:34:31 +10:00
TypeId = 3 ,
Value = "12"
} ,
new
2025-06-04 11:55:23 +10:00
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "e0f2f4d1-4a5e-4997-8336-83c3c35f38df" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "13" ,
Order = 12 ,
TypeId = 3 ,
Value = "13"
} ,
new
2025-12-05 14:07:48 +10:00
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "9c5aaf48-88ec-4c67-b936-2be45550f8bf" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "14" ,
Order = 13 ,
TypeId = 3 ,
Value = "14"
} ,
new
2025-09-22 15:25:17 +10:00
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "8dbd680c-ce49-4d2e-8a1a-05619685e240" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "15" ,
Order = 14 ,
TypeId = 3 ,
Value = "15"
} ,
new
2025-06-11 11:14:27 +10:00
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "2f476f70-b1ef-419d-aad5-3911f1e3231f" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "16" ,
Order = 15 ,
TypeId = 3 ,
Value = "16"
} ,
new
2026-01-20 16:17:09 +10:00
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "2c635ce2-fc18-47be-b3e9-98c211abf312" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "17" ,
Order = 16 ,
TypeId = 3 ,
Value = "17"
} ,
new
2025-11-14 14:48:56 +10:00
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "f9d5b03b-624a-4f9f-8da3-1490ea5d2914" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "18" ,
Order = 17 ,
TypeId = 3 ,
Value = "18"
} ,
2025-11-14 14:48:56 +10:00
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "4f4b249c-db60-4582-86ed-75cfee4edd0c" ) ,
2025-11-14 14:48:56 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "19" ,
Order = 18 ,
TypeId = 3 ,
Value = "19"
2025-11-14 14:48:56 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "220a1464-4d39-416c-b4b2-3093eb007298" ) ,
2025-11-14 14:48:56 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "20" ,
Order = 19 ,
TypeId = 3 ,
Value = "20"
2025-11-14 14:48:56 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "c887ca60-b05d-4d3c-ad1f-223c879b1a6d" ) ,
2025-11-14 14:48:56 +10:00
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
2026-05-12 16:34:31 +10:00
EsppExportValue = "21" ,
Order = 20 ,
TypeId = 3 ,
Value = "21"
} ,
new
{
Id = new Guid ( "2905765d-63fb-41fe-a111-ee2f1d03d62e" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "22" ,
Order = 21 ,
TypeId = 3 ,
Value = "22"
} ,
new
{
Id = new Guid ( "dbbe704a-8d6d-40e7-bd30-6974035b1fab" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "23" ,
Order = 22 ,
TypeId = 3 ,
Value = "23"
} ,
new
{
Id = new Guid ( "cf7b9645-52ed-43a2-8267-267e0aed19b1" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "24" ,
Order = 23 ,
TypeId = 3 ,
Value = "24"
} ,
new
{
Id = new Guid ( "454788d6-d0ad-4c07-878c-da3fd3cd05e1" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "25" ,
Order = 24 ,
TypeId = 3 ,
Value = "25"
} ,
new
{
Id = new Guid ( "40d70d73-8582-4be6-a9e6-503b96ae3d49" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "26" ,
Order = 25 ,
TypeId = 3 ,
Value = "26"
} ,
new
{
Id = new Guid ( "8f6610dc-ef46-4842-a57e-18d7aaa75931" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "27" ,
Order = 26 ,
TypeId = 3 ,
Value = "27"
} ,
new
{
Id = new Guid ( "03858472-d4ce-47fd-9497-8051728766e4" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "28" ,
Order = 27 ,
TypeId = 3 ,
Value = "28"
} ,
new
{
Id = new Guid ( "b1018e07-e90e-42ee-b399-19f3d0c14dd6" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "29" ,
Order = 28 ,
TypeId = 3 ,
Value = "29"
} ,
new
{
Id = new Guid ( "a1669207-aa31-40fe-98d0-d941008d1655" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "30" ,
Order = 29 ,
TypeId = 3 ,
Value = "30"
} ,
new
2025-08-01 17:14:39 +10:00
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "0936aa99-73e0-43de-b6df-334c1228a226" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "31" ,
Order = 30 ,
TypeId = 3 ,
Value = "31"
} ,
new
2025-06-04 11:55:23 +10:00
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "626ca076-f09e-4a7a-8610-b7de6337b24a" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "1" ,
Order = 0 ,
TypeId = 4 ,
Value = "Первый"
} ,
2023-10-23 16:17:42 +10:00
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "032fbd02-67d0-4b8c-bed0-42629ab7113b" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "2" ,
Order = 1 ,
TypeId = 4 ,
Value = "Второй"
2023-10-23 16:17:42 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "fa8a8f60-e41e-495e-ac86-35174d9976bf" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "3" ,
Order = 2 ,
TypeId = 4 ,
Value = "Третий"
2023-10-23 16:17:42 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "d2f90168-2b49-42f2-820b-79db2c522adf" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "4" ,
Order = 3 ,
TypeId = 4 ,
Value = "Четвертый"
2023-10-23 16:17:42 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "12bb8db2-cf7f-4113-baff-6883770f1ba5" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "5" ,
Order = 4 ,
TypeId = 4 ,
Value = "Последний"
2023-10-23 16:17:42 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "18260e91-3fbe-4401-9edc-78dbc419370e" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "1" ,
Order = 0 ,
TypeId = 5 ,
Value = "Январь"
} ,
2024-10-07 15:08:46 +10:00
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "361526aa-3e1c-452e-bb44-0ade8521830d" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "2" ,
Order = 1 ,
TypeId = 5 ,
Value = "Февраль"
2024-10-07 15:08:46 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "fad4bdb0-6c51-4810-a30b-6d031a0d4c46" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "3" ,
Order = 2 ,
TypeId = 5 ,
Value = "Март"
2024-10-07 15:08:46 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "06ab835d-3d3e-4057-8422-a553b6b40995" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "4" ,
Order = 3 ,
TypeId = 5 ,
Value = "Апрель"
2024-10-07 15:08:46 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "83f56b5d-b16b-4aa5-89d7-a253fee4e4ad" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "5" ,
Order = 4 ,
TypeId = 5 ,
Value = "Май"
2024-10-07 15:08:46 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "e679ec84-a9ee-4bed-a051-2b14edddcb18" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "6" ,
Order = 5 ,
TypeId = 5 ,
Value = "Июнь"
2024-10-07 15:08:46 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "d439808a-6a10-409b-8809-a755b7cca60b" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "7" ,
Order = 6 ,
TypeId = 5 ,
Value = "Июль"
2024-10-07 15:08:46 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "6e9972c4-6bf7-4fe4-b4ea-bbb333fb69c8" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "8" ,
Order = 7 ,
TypeId = 5 ,
Value = "Август"
2024-10-07 15:08:46 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "0883aac2-9d5b-4098-b672-c684d2a3a0c9" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "9" ,
Order = 8 ,
TypeId = 5 ,
Value = "Сентябрь"
2024-10-07 15:08:46 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "5e6592bc-acb2-45a4-979b-fdecf8457453" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "10" ,
Order = 9 ,
TypeId = 5 ,
Value = "Октябрь"
2024-10-07 15:08:46 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "edd7cb49-d6a0-4969-b2d6-1967da69b336" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "11" ,
Order = 10 ,
TypeId = 5 ,
Value = "Ноябрь"
2024-10-07 15:08:46 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "dd695fb2-4ad0-4cda-a4df-e15059c56b24" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "12" ,
Order = 11 ,
TypeId = 5 ,
Value = "Декабрь"
2024-10-07 15:08:46 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "2f473624-4eb3-49b4-a4b9-cc7fc08a50f5" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "1" ,
Order = 0 ,
TypeId = 6 ,
Value = "Января"
2024-10-07 15:08:46 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "f0003490-a249-44bd-814f-4566999915d8" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "2" ,
Order = 1 ,
TypeId = 6 ,
Value = "Февраля"
2026-03-20 15:50:00 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "f4c3fe38-aeaa-42f7-a9ba-190ea2dfe339" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "3" ,
Order = 2 ,
TypeId = 6 ,
Value = "Марта"
} ,
2023-09-28 14:28:10 +10:00
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "06a8bd2f-68e1-42f5-961c-ac3b98a2181e" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "4" ,
Order = 3 ,
TypeId = 6 ,
Value = "Апреля"
2023-10-05 12:28:31 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "963b9c41-d607-444a-9fe0-fe429590e326" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "5" ,
Order = 4 ,
TypeId = 6 ,
Value = "Мая"
} ,
2023-10-03 14:30:54 +10:00
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "ec8554c8-dee4-49a1-b1b7-474ad8ec1473" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "6" ,
Order = 5 ,
TypeId = 6 ,
Value = "Июня"
2023-10-03 14:30:54 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "e15c7c63-e29f-41a3-9c82-f70eb6c24fde" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "7" ,
Order = 6 ,
TypeId = 6 ,
Value = "Июля"
2023-10-03 14:30:54 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "0b1f3cea-301a-4d74-9ce1-2cd93b41897d" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "8" ,
Order = 7 ,
TypeId = 6 ,
Value = "Августа"
2023-10-03 14:30:54 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "e2fa3769-f66f-4753-a161-35adad7717a5" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "9" ,
Order = 8 ,
TypeId = 6 ,
Value = "Сентября"
2023-10-03 14:30:54 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "c1de4aca-9f49-48ae-9279-cf9ec4092112" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "10" ,
Order = 9 ,
TypeId = 6 ,
Value = "Октября"
2023-10-03 14:30:54 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "a74b9ebd-bcd8-4537-b371-194de2fe0a4d" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "11" ,
Order = 10 ,
TypeId = 6 ,
Value = "Ноября"
2023-10-03 14:30:54 +10:00
} ,
new
{
2026-05-12 16:34:31 +10:00
Id = new Guid ( "852a5ebd-4545-494b-bc69-c27409a41adc" ) ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppExportValue = "12" ,
Order = 11 ,
TypeId = 6 ,
Value = "Декабря"
2023-10-03 14:30:54 +10:00
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.EsppSchValue" , b = >
2023-12-01 10:05:54 +10:00
{
2026-05-12 16:34:31 +10:00
b . Property < Guid > ( "JobGroupId" )
2023-12-01 10:05:54 +10:00
. HasColumnType ( "uuid" ) ;
2026-05-12 16:34:31 +10:00
b . Property < Guid > ( "TypeValueId" )
. HasColumnType ( "uuid" ) ;
2023-12-01 10:05:54 +10:00
2026-05-12 16:34:31 +10:00
b . Property < Guid > ( "TypeConfigId" )
. HasColumnType ( "uuid" ) ;
2023-12-01 10:05:54 +10:00
2026-05-12 16:34:31 +10:00
b . HasKey ( "JobGroupId" , "TypeValueId" , "TypeConfigId" ) ;
2023-12-01 10:05:54 +10:00
2026-05-12 16:34:31 +10:00
b . HasIndex ( "TypeConfigId" ) ;
2023-12-01 10:05:54 +10:00
2026-05-12 16:34:31 +10:00
b . HasIndex ( "TypeValueId" ) ;
2023-12-01 10:05:54 +10:00
2026-05-12 16:34:31 +10:00
b . ToTable ( "EsppSchValues" , "schedule" ) ;
2023-12-01 10:05:54 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.ScheduleExcludeType" , b = >
2025-12-26 11:21:45 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < string > ( "Code" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "EsppName" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "EsppValue" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Title" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
b . ToTable ( "ExcludeTypes" , "schedule" , t = >
{
t . HasComment ( "Расписание регламентной работы - Тип исключения" ) ;
} ) ;
b . HasData (
new
{
Id = new Guid ( "0595b8e0-f322-4661-b5e3-064af8fbe7cd" ) ,
Code = "None" ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppName = "Нет исключений" ,
EsppValue = "NONE" ,
Title = "Нет исключений"
} ,
new
{
Id = new Guid ( "2b7a4356-9aaf-4e00-b444-42f0b5010e25" ) ,
Code = "Only" ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppName = "Выполнить ТОЛЬКО В указанном календаре" ,
EsppValue = "ONLY" ,
Title = "Выполнить ТОЛЬКО В указанном календаре"
} ,
new
{
Id = new Guid ( "38cd9e64-27c1-4672-a805-2211952a48bd" ) ,
Code = "Except" ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppName = "Выполнить везде, К Р О М Е указанного календаря" ,
EsppValue = "EXCEPT" ,
Title = "Выполнить везде, К Р О М Е указанного календаря"
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.ScheduleExcludeTypeCalendar" , b = >
2025-12-26 11:21:45 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < string > ( "Code" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "EsppName" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "EsppValue" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Title" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
b . ToTable ( "ExcludeTypeCalendars" , "schedule" , t = >
{
t . HasComment ( "Расписание регламентной работы, исключение - Календарь" ) ;
} ) ;
b . HasData (
new
{
Id = new Guid ( "a26edb88-0267-4fbf-b7ec-d172b0a86c9c" ) ,
Code = "24x5" ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppName = "24x5" ,
EsppValue = "24x5" ,
Title = "24x5"
} ,
new
{
Id = new Guid ( "6834f1d5-ac51-43d5-974e-4c759d7bbf9f" ) ,
Code = "24x7" ,
DateCreated = new DateTimeOffset ( new DateTime ( 2023 , 5 , 1 , 0 , 0 , 0 , 0 , DateTimeKind . Unspecified ) , new TimeSpan ( 0 , 0 , 0 , 0 , 0 ) ) ,
EsppName = "24x7" ,
EsppValue = "24x7" ,
Title = "24x7"
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.ScheduleResponseAreaTimeOffset" , b = >
2026-01-30 10:40:55 +10:00
{
b . Property < string > ( "ResponseArea" )
. HasColumnType ( "text" ) ;
2026-02-03 16:15:19 +10:00
b . Property < string > ( "EsppValue" )
2026-01-30 10:40:55 +10:00
. IsRequired ( )
. HasColumnType ( "text" ) ;
2026-02-03 16:15:19 +10:00
b . Property < TimeSpan > ( "UtcTimeOffset" )
. HasColumnType ( "interval" ) ;
2026-01-30 10:40:55 +10:00
b . HasKey ( "ResponseArea" ) ;
b . ToTable ( "ResponseAreaTimeOffsets" , "schedule" , t = >
{
t . HasComment ( "Расписание в ЕСПП. Смещение часового пояса относительно М С К для зоны ответственности рабочей группы" ) ;
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Setting" , b = >
2023-09-19 12:17:05 +10:00
{
b . Property < string > ( "Name" )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Value" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Name" ) ;
2026-05-12 16:34:31 +10:00
b . ToTable ( "Settings" ) ;
2023-09-19 12:17:05 +10:00
b . HasData (
new
{
Name = "Initiator" ,
Description = "Инициатор регламентной работы, указывается при создании шаблона в ЕСПП." ,
2026-06-15 16:56:23 +10:00
Value = "А К С Е Н О В АЛЕКСАНДР ЕВГЕНЬЕВИЧ (AKSENOVAE@GVC.OAO.RZD)"
2023-09-19 12:17:05 +10:00
} ,
new
{
Name = "ClosingCode" ,
Description = "Код закрытия регламентной работы, указывается при создании шаблона в ЕСПП." ,
Value = "выполнен"
} ,
new
{
Name = "Category" ,
Description = "Категория создаваемого объекта в ЕСПП" ,
Value = "регламентная работа"
2023-09-20 12:09:07 +10:00
} ,
new
{
Name = "TemplatePrefixName" ,
Description = "Префикс имени шаблона в ЕСПП" ,
2024-02-13 14:34:12 +10:00
Value = "%PREFIX%-ЭИТИ-ПТК-ПАРР"
2023-10-03 14:30:54 +10:00
} ,
new
{
Name = "RobotAttemptsNumber" ,
Description = "Количество попыток выполнения задания роботом" ,
Value = "3"
} ,
new
{
Name = "RobotWaitTime" ,
Description = "Время ожидания выполнения роботом задания" ,
2026-06-10 16:48:16 +10:00
Value = "00:10:00"
2023-10-09 16:11:27 +10:00
} ,
new
{
2026-02-26 14:42:53 +10:00
Name = "EsppScheduleTimezone" ,
Description = "Расписание регламентной работы - В каком часовом поясе" ,
Value = "MSK"
} ,
new
{
2023-10-09 16:11:27 +10:00
Name = "ScheduleRepeatRange" ,
Description = "Расписание регламентной работы - Диапазн повторов" ,
Value = "Отсутствует дата завершения"
2023-10-23 13:50:43 +10:00
} ,
new
{
Name = "OrderSearchDeltaDate" ,
Description = "Промежуток времени для поиска нарядов в ЕСПП" ,
2024-02-27 13:40:51 +10:00
Value = "01:30:00"
2024-08-06 10:52:27 +10:00
} ,
new
{
Name = "EsppRobotAccountTimeZoneHour" ,
Description = "Таймзона У З роботов в ЕСПП, в часах (может быть положительная и отрицательная)" ,
Value = "3"
2024-09-17 11:55:55 +10:00
} ,
new
{
Name = "WeekendCacheTtl" ,
Description = "Время хранения в кэше данных о выходных и рабочих днях" ,
Value = "01:00:00"
2025-06-18 09:58:23 +10:00
} ,
new
{
Name = "TemplateNameConstantParts" ,
Description = "Список неизменных частей имени шаблона" ,
2026-02-03 16:15:19 +10:00
Value = "[{\"Name\":\"П-1\",\"Value\":\"ЭИТИ-ПАРР\"}]"
2025-12-25 13:53:38 +10:00
} ,
new
{
Name = "EsppUnitTag" ,
Description = "Префикс тега в поле ЭК \"Дополнительная информация\"" ,
2025-12-26 11:21:45 +10:00
Value = "ПА Р Р _"
2025-12-30 12:16:51 +10:00
} ,
new
{
Name = "JobIdForUnusedTemplates" ,
Description = "Job в который перемещаем ниспользованные шаблоны" ,
Value = "8f85a91c-a223-4686-bb69-1f0ee73624f2"
2026-02-03 16:15:19 +10:00
} ,
new
{
Name = "DefaultResponseAreaToTimeOffset" ,
Description = "Зона ответственности для получения тайм зоны по умолчанию для расписаний" ,
Value = "17-М С К "
2026-07-14 10:29:01 +10:00
} ,
new
{
Name = "MinRelationshipsThresholdPct" ,
Description = "Минимально допустимый процент связей для продолжения синхронизации. Защищает от удаления данных, если передающая система АИХ ИТ передала аномально малый объем связей. 0 — Защита ОТКЛЮЧЕНА, 100 — Строгий режим." ,
Value = "97"
2023-09-19 12:17:05 +10:00
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Subprocess" , b = >
2023-10-05 16:56:02 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "DateModified" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < int > ( "EsppId" )
. HasColumnType ( "integer" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < Guid > ( "ProcessId" )
. HasColumnType ( "uuid" ) ;
2026-05-12 16:34:31 +10:00
b . HasKey ( "Id" ) ;
b . HasIndex ( "EsppId" )
. IsUnique ( ) ;
b . HasIndex ( "ProcessId" ) ;
b . ToTable ( "Subprocesses" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.TaskEntities.TaskError" , b = >
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < int > ( "AttemptNumber" )
. HasColumnType ( "integer" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "ErrorMessage" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "StackTrace" )
. HasColumnType ( "text" ) ;
b . Property < Guid > ( "TaskId" )
. HasColumnType ( "uuid" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "TaskId" ) ;
b . ToTable ( "Errors" , "task" , t = >
{
t . HasComment ( "Таблица ошибок заданий" ) ;
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.TaskEntities.TaskItem" , b = >
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "DateModified" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "InitiatorComment" )
. HasColumnType ( "text" ) ;
b . Property < string > ( "InitiatorIp" )
. HasColumnType ( "text" ) ;
b . Property < int? > ( "InitiatorParrComponentId" )
. HasColumnType ( "integer" ) ;
b . Property < string > ( "Payload" )
. HasColumnType ( "text" ) ;
b . Property < DateTimeOffset ? > ( "ProcessedAt" )
. HasColumnType ( "timestamp with time zone" ) ;
2026-05-20 14:26:25 +10:00
b . Property < int? > ( "ProgressPercent" )
. HasColumnType ( "integer" )
. HasComment ( "Процент выполнения задачи" ) ;
2026-05-12 16:34:31 +10:00
b . Property < int > ( "RetryCount" )
. HasColumnType ( "integer" ) ;
b . Property < int > ( "StatusCode" )
. HasColumnType ( "integer" ) ;
b . Property < int > ( "TypeCode" )
. HasColumnType ( "integer" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "StatusCode" ) ;
b . HasIndex ( "TypeCode" ) ;
b . ToTable ( "Tasks" , "task" , t = >
{
t . HasComment ( "Таблица заданий" ) ;
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.TaskEntities.TaskStatus" , b = >
{
b . Property < int > ( "Code" )
. HasColumnType ( "integer" ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Code" ) ;
b . ToTable ( "Statuses" , "task" , t = >
{
t . HasComment ( "Таблица статусов заданий" ) ;
} ) ;
b . HasData (
new
{
Code = 0 ,
Description = "Ожидание" ,
Name = "Pending"
} ,
new
{
Code = 1 ,
Description = "В работе" ,
Name = "Processing"
} ,
new
{
Code = 2 ,
Description = "Выполнено успешно" ,
Name = "Success"
} ,
new
{
Code = 3 ,
Description = "Ошибка" ,
Name = "Failed"
} ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.TaskEntities.TaskType" , b = >
{
b . Property < int > ( "Code" )
. HasColumnType ( "integer" ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < bool > ( "IsSingleton" )
. HasColumnType ( "boolean" ) ;
b . Property < int > ( "MaxExecutionTimeMinutes" )
. HasColumnType ( "integer" ) ;
b . Property < int > ( "MaxRetries" )
. HasColumnType ( "integer" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < int > ( "RetentionDays" )
. HasColumnType ( "integer" ) ;
2023-10-05 16:56:02 +10:00
2026-05-12 16:34:31 +10:00
b . HasKey ( "Code" ) ;
2024-05-20 11:38:48 +10:00
2026-05-12 16:34:31 +10:00
b . ToTable ( "Types" , "task" , t = >
{
t . HasComment ( "Таблица типов заданий" ) ;
} ) ;
2023-10-05 16:56:02 +10:00
2026-05-12 16:34:31 +10:00
b . HasData (
new
{
Code = 0 ,
Description = "Формирование данных для отчетности - Загруженность" ,
IsSingleton = true ,
2026-05-20 14:26:25 +10:00
MaxExecutionTimeMinutes = 90 ,
2026-05-12 16:34:31 +10:00
MaxRetries = 2 ,
Name = "Workload" ,
RetentionDays = 90
} ) ;
2023-10-05 16:56:02 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Template" , b = >
2023-09-01 12:40:41 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "DateModified" )
. HasColumnType ( "timestamp with time zone" ) ;
2025-11-14 14:48:56 +10:00
b . Property < int? > ( "Index" )
. HasColumnType ( "integer" ) ;
2024-10-07 15:08:46 +10:00
b . Property < string > ( "InitiatorComment" )
. HasColumnType ( "text" ) ;
b . Property < string > ( "InitiatorIp" )
. HasColumnType ( "text" ) ;
b . Property < int? > ( "InitiatorParrComponentId" )
. HasColumnType ( "integer" ) ;
2023-10-05 16:56:02 +10:00
b . Property < bool > ( "IsActiveSchedule" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "IsActiveTemplate" )
2023-09-14 17:00:56 +10:00
. HasColumnType ( "boolean" ) ;
2025-06-11 11:14:27 +10:00
b . Property < Guid > ( "JobId" )
. HasColumnType ( "uuid" ) ;
2024-07-01 14:04:24 +10:00
b . Property < DateTimeOffset ? > ( "LastRun" )
. HasColumnType ( "timestamp with time zone" ) ;
2023-09-13 14:44:21 +10:00
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
2023-09-01 12:40:41 +10:00
2024-07-01 14:04:24 +10:00
b . Property < DateTimeOffset > ( "NextRun" )
. HasColumnType ( "timestamp with time zone" ) ;
2023-10-09 16:11:27 +10:00
b . Property < string > ( "ScheduleEsppId" )
. HasColumnType ( "text" ) ;
2025-12-01 15:27:18 +10:00
b . Property < int > ( "StatusTypeId" )
. HasColumnType ( "integer" ) ;
2025-06-11 11:14:27 +10:00
b . Property < Guid > ( "UnitId" )
. HasColumnType ( "uuid" ) ;
2023-09-01 12:40:41 +10:00
b . HasKey ( "Id" ) ;
2025-06-11 11:14:27 +10:00
b . HasIndex ( "JobId" ) ;
2025-12-01 15:27:18 +10:00
b . HasIndex ( "StatusTypeId" ) ;
2025-06-11 11:14:27 +10:00
b . HasIndex ( "UnitId" ) ;
2025-11-14 14:48:56 +10:00
b . HasIndex ( "Name" , "Index" )
. IsUnique ( ) ;
2026-05-12 16:34:31 +10:00
b . ToTable ( "Templates" ) ;
2024-10-07 15:08:46 +10:00
} ) ;
2026-07-21 11:48:21 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.TemplateEntities.TemplateRenamePending" , b = >
{
b . Property < Guid > ( "TemplateId" )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
2026-07-29 16:31:50 +10:00
b . Property < DateTimeOffset ? > ( "DateModified" )
. HasColumnType ( "timestamp with time zone" ) ;
2026-07-21 11:48:21 +10:00
b . Property < string > ( "OldName" )
. IsRequired ( )
. HasColumnType ( "text" )
. HasComment ( "Старое имя шаблона" ) ;
b . HasKey ( "TemplateId" ) ;
2026-07-29 16:31:50 +10:00
b . HasIndex ( "OldName" ) ;
2026-07-21 11:48:21 +10:00
b . ToTable ( "TemplateRenamePendings" , "template" , t = >
{
t . HasComment ( "Шаблоны находящиеся в процессе переименования" ) ;
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.TemplateHistory" , b = >
2024-10-07 15:08:46 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateAddedToHistory" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "DateModified" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "InitiatorComment" )
. HasColumnType ( "text" ) ;
b . Property < string > ( "InitiatorIp" )
. HasColumnType ( "text" ) ;
b . Property < int? > ( "InitiatorParrComponentId" )
. HasColumnType ( "integer" ) ;
b . Property < bool > ( "IsActiveSchedule" )
. HasColumnType ( "boolean" ) ;
b . Property < bool > ( "IsActiveTemplate" )
. HasColumnType ( "boolean" ) ;
b . Property < DateTimeOffset ? > ( "LastRun" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < DateTimeOffset > ( "NextRun" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < Guid > ( "ParentId" )
. HasColumnType ( "uuid" ) ;
2026-03-05 12:29:41 +10:00
b . Property < string > ( "ScheduleEsppId" )
. HasColumnType ( "text" ) ;
2025-12-01 15:27:18 +10:00
b . Property < int > ( "StatusTypeId" )
. HasColumnType ( "integer" ) ;
2024-10-07 15:08:46 +10:00
b . HasKey ( "Id" ) ;
b . HasIndex ( "ParentId" ) ;
2026-05-12 16:34:31 +10:00
b . ToTable ( "TemplateHistories" ) ;
2023-09-01 12:40:41 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.TemplateStatusType" , b = >
2025-12-01 15:27:18 +10:00
{
b . Property < int > ( "Id" )
. HasColumnType ( "integer" ) ;
b . Property < string > ( "Description" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
2026-05-12 16:34:31 +10:00
b . ToTable ( "TemplateStatusTypes" , t = >
2025-12-01 15:27:18 +10:00
{
t . HasComment ( "Таблица описания критериев выборки аттрибутов ЭК" ) ;
} ) ;
b . HasData (
new
{
Id = 0 ,
Description = "В работе" ,
Name = "Used"
} ,
new
{
Id = 1 ,
Description = "Н е используется" ,
Name = "Unused"
} ,
new
{
Id = 2 ,
Description = "Обновляется" ,
Name = "Updating"
2026-01-26 14:29:47 +10:00
} ,
new
{
Id = 3 ,
Description = "Ошибка" ,
Name = "Error"
2025-12-01 15:27:18 +10:00
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Tnk" , b = >
2023-09-19 10:01:50 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "DateModified" )
. HasColumnType ( "timestamp with time zone" ) ;
2025-12-09 10:25:41 +10:00
b . Property < int? > ( "EsppId" )
2023-09-19 10:01:50 +10:00
. HasColumnType ( "integer" ) ;
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
2025-12-09 10:25:41 +10:00
b . Property < string > ( "ShortName" )
. HasColumnType ( "text" ) ;
2023-09-19 10:01:50 +10:00
b . Property < Guid > ( "SubprocessId" )
. HasColumnType ( "uuid" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "SubprocessId" ) ;
2026-05-12 16:34:31 +10:00
b . ToTable ( "Tnks" ) ;
2023-09-19 10:01:50 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.Unit" , b = >
2025-05-14 15:13:30 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
2025-08-26 14:04:49 +10:00
b . Property < DateTimeOffset ? > ( "LastLogon" )
. HasColumnType ( "timestamp with time zone" ) ;
2025-05-14 15:13:30 +10:00
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "Name" )
. IsUnique ( ) ;
b . ToTable ( "Units" , "unit" , t = >
{
t . HasComment ( "Таблица с ЭК" ) ;
2025-10-31 17:35:54 +10:00
t . HasCheckConstraint ( "CK_Units_Name_Upper" , "\"Name\" = UPPER(\"Name\") AND \"Name\" IS NOT NULL AND LENGTH(\"Name\")>0" ) ;
2025-05-14 15:13:30 +10:00
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitField" , b = >
2025-05-14 15:13:30 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < string > ( "AihitName" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
2025-11-28 09:12:26 +10:00
b . Property < string > ( "Code" )
. HasColumnType ( "text" ) ;
2025-05-14 15:13:30 +10:00
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "DisplayName" )
. HasColumnType ( "text" ) ;
b . Property < string > ( "EsppName" )
. HasColumnType ( "text" ) ;
2025-09-22 15:25:17 +10:00
b . Property < bool? > ( "IsMultipleValue" )
. HasColumnType ( "boolean" ) ;
2025-05-14 15:13:30 +10:00
b . HasKey ( "Id" ) ;
b . HasIndex ( "AihitName" ) ;
b . HasIndex ( "EsppName" ) ;
b . ToTable ( "Fields" , "unit" , t = >
{
t . HasComment ( "Справочник полей ЭК" ) ;
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitFieldInUnitFieldValue" , b = >
2025-05-14 15:13:30 +10:00
{
b . Property < Guid > ( "FieldId" )
. HasColumnType ( "uuid" ) ;
b . Property < Guid > ( "FieldValueId" )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . HasKey ( "FieldId" , "FieldValueId" ) ;
b . HasIndex ( "FieldValueId" ) ;
b . ToTable ( "FieldInFieldValues" , "unit" , t = >
{
t . HasComment ( "Значения полей ЭК" ) ;
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitFieldValue" , b = >
2025-05-14 15:13:30 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "Value" )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
2025-05-21 16:50:00 +10:00
b . HasIndex ( "Value" )
. IsUnique ( ) ;
2025-05-14 15:13:30 +10:00
b . ToTable ( "FieldValues" , "unit" , t = >
{
t . HasComment ( "Значения полей ЭК" ) ;
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitInUnit" , b = >
2025-05-27 11:32:05 +10:00
{
b . Property < Guid > ( "ParentUnitId" )
. HasColumnType ( "uuid" ) ;
b . Property < Guid > ( "ChildUnitId" )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "DateSynced" )
. HasColumnType ( "timestamp with time zone" ) ;
b . HasKey ( "ParentUnitId" , "ChildUnitId" ) ;
b . HasIndex ( "ChildUnitId" ) ;
b . ToTable ( "UnitInUnits" , "unit" , t = >
{
t . HasComment ( "Таблица связей иерархии между ЭК" ) ;
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitInValue" , b = >
2025-05-14 15:13:30 +10:00
{
b . Property < Guid > ( "UnitId" )
. HasColumnType ( "uuid" ) ;
b . Property < Guid > ( "FieldId" )
. HasColumnType ( "uuid" ) ;
2025-09-22 15:25:17 +10:00
b . Property < Guid > ( "ValueId" )
. HasColumnType ( "uuid" ) ;
2025-05-14 15:13:30 +10:00
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < DateTimeOffset ? > ( "DateModified" )
. HasColumnType ( "timestamp with time zone" ) ;
2025-09-22 15:25:17 +10:00
b . HasKey ( "UnitId" , "FieldId" , "ValueId" ) ;
2025-05-14 15:13:30 +10:00
2025-05-21 11:53:07 +10:00
b . HasIndex ( "ValueId" ) ;
2025-05-14 15:13:30 +10:00
2025-12-29 12:30:09 +10:00
b . HasIndex ( "FieldId" , "UnitId" ) ;
2025-11-21 10:56:30 +10:00
b . HasIndex ( "FieldId" , "ValueId" ) ;
2025-12-29 12:30:09 +10:00
b . HasIndex ( "UnitId" , "FieldId" ) ;
2025-05-14 15:13:30 +10:00
b . ToTable ( "UnitInValues" , "unit" , t = >
{
t . HasComment ( "Таблица связи ЭК с полями и с о значениями" ) ;
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitKiiUnit" , b = >
2025-12-19 09:09:22 +10:00
{
b . Property < Guid > ( "UnitId" )
. HasColumnType ( "uuid" ) ;
b . HasKey ( "UnitId" ) ;
b . ToTable ( "KiiUnits" , "unit" , t = >
{
t . HasComment ( "Таблица - Список ЭК КИИ, которые учавствуют в групповых работах. Создавалась как временная" ) ;
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitRegionalEkPtkGroup" , b = >
2025-12-18 16:48:48 +10:00
{
b . Property < Guid > ( "FieldValueId" )
. HasColumnType ( "uuid" ) ;
b . HasKey ( "FieldValueId" ) ;
b . ToTable ( "RegionalEkPtkGroups" , "unit" , t = >
{
t . HasComment ( "Таблица - региональные группы ПТК" ) ;
} ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.User" , b = >
2023-12-01 10:05:54 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateTimeOffset > ( "DateCreated" )
. HasColumnType ( "timestamp with time zone" ) ;
b . Property < string > ( "Description" )
. HasColumnType ( "text" ) ;
b . Property < string > ( "Ip" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
2023-12-06 11:08:14 +10:00
b . Property < DateTimeOffset ? > ( "LastLogon" )
. HasColumnType ( "timestamp with time zone" ) ;
2023-12-01 10:05:54 +10:00
b . Property < string > ( "Name" )
. IsRequired ( )
. HasColumnType ( "text" ) ;
b . HasKey ( "Id" ) ;
b . HasIndex ( "Ip" )
. IsUnique ( ) ;
2026-05-12 16:34:31 +10:00
b . ToTable ( "Users" ) ;
2023-12-01 10:05:54 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.UsersInRole" , b = >
2023-12-01 10:05:54 +10:00
{
b . Property < Guid > ( "RoleId" )
. HasColumnType ( "uuid" ) ;
b . Property < Guid > ( "UserId" )
. HasColumnType ( "uuid" ) ;
b . HasKey ( "RoleId" , "UserId" ) ;
b . HasIndex ( "UserId" ) ;
2026-05-12 16:34:31 +10:00
b . ToTable ( "UsersInRoles" ) ;
2023-12-01 10:05:54 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.WeekendDay" , b = >
2024-07-01 11:32:19 +10:00
{
b . Property < Guid > ( "Id" )
. ValueGeneratedOnAdd ( )
. HasColumnType ( "uuid" ) ;
b . Property < DateOnly > ( "Date" )
2026-05-12 16:34:31 +10:00
. HasColumnType ( "date" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . HasKey ( "Id" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . HasIndex ( "Date" )
. IsUnique ( ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . ToTable ( "WeekendDays" , "schedule" ) ;
2023-10-10 15:52:34 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.AgentHistory" , b = >
2023-10-10 15:52:34 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.AgentHistoryLevel" , "AgentHistoryLevel" )
. WithMany ( "AgentHistories" )
. HasForeignKey ( "HistoryLevelId" )
2023-10-10 15:52:34 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Order" , "Order" )
. WithMany ( "AgentHistories" )
. HasForeignKey ( "OrderId" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Template" , "Template" )
. WithMany ( "AgentHistories" )
. HasForeignKey ( "TemplateId" )
2023-10-10 15:52:34 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . Navigation ( "AgentHistoryLevel" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . Navigation ( "Order" ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
b . Navigation ( "Template" ) ;
} ) ;
2023-10-10 15:52:34 +10:00
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.DistributionPeriod" , b = >
{
b . HasOne ( "PARR.Domain.Entities.DistributionPeriodType" , "DistributionPeriodType" )
. WithMany ( "Periods" )
. HasForeignKey ( "Type" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2025-06-25 14:17:34 +10:00
2026-05-12 16:34:31 +10:00
b . Navigation ( "DistributionPeriodType" ) ;
2023-10-10 15:52:34 +10:00
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.Job" , b = >
2025-06-04 11:55:23 +10:00
{
2026-06-15 16:56:23 +10:00
b . HasOne ( "PARR.Domain.Entities.JobGroupEntities.JobGroup" , "Group" )
2025-09-22 15:25:17 +10:00
. WithMany ( "Jobs" )
. HasForeignKey ( "GroupId" )
2025-06-04 11:55:23 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Tnk" , "Tnk" )
2025-12-09 16:00:38 +10:00
. WithMany ( "Jobs" )
2025-09-22 15:25:17 +10:00
. HasForeignKey ( "TnkId" )
2025-06-04 11:55:23 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2025-09-22 15:25:17 +10:00
b . Navigation ( "Group" ) ;
2025-06-04 11:55:23 +10:00
2025-09-22 15:25:17 +10:00
b . Navigation ( "Tnk" ) ;
2025-06-04 11:55:23 +10:00
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.JobAutoControl" , b = >
2025-12-05 14:07:48 +10:00
{
2026-07-13 15:29:48 +10:00
b . HasOne ( "PARR.Domain.Entities.JobEntities.Job" , "Job" )
2025-12-05 14:07:48 +10:00
. WithOne ( "AutoControl" )
2026-07-13 15:29:48 +10:00
. HasForeignKey ( "PARR.Domain.Entities.JobEntities.JobAutoControl" , "JobId" )
2025-12-05 14:07:48 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Job" ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.JobFieldFilter" , b = >
2025-06-04 11:55:23 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.UnitField" , "UnitField" )
2026-06-15 16:56:23 +10:00
. WithMany ( "JobFieldFilters" )
2025-09-22 15:25:17 +10:00
. HasForeignKey ( "FieldId" )
2025-06-11 11:14:27 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-07-13 15:29:48 +10:00
b . HasOne ( "PARR.Domain.Entities.JobEntities.JobUnitFilter" , "UnitFilter" )
2025-09-22 15:25:17 +10:00
. WithMany ( "FieldFilters" )
. HasForeignKey ( "UnitFilterId" )
2025-06-04 11:55:23 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2025-09-22 15:25:17 +10:00
b . Navigation ( "UnitField" ) ;
2025-06-11 11:14:27 +10:00
2025-09-22 15:25:17 +10:00
b . Navigation ( "UnitFilter" ) ;
2025-06-04 11:55:23 +10:00
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.JobRelationshipFilter" , b = >
2026-06-15 16:56:23 +10:00
{
b . HasOne ( "PARR.Domain.Entities.Unit.UnitField" , "UnitField" )
. WithMany ( "RelationshipFilters" )
. HasForeignKey ( "FieldId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-07-13 15:29:48 +10:00
b . HasOne ( "PARR.Domain.Entities.JobEntities.JobUnitFilter" , "UnitFilter" )
2026-06-15 16:56:23 +10:00
. WithMany ( "RelationshipFilters" )
. HasForeignKey ( "UnitFilterId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "UnitField" ) ;
b . Navigation ( "UnitFilter" ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.JobUnitFilter" , b = >
2025-11-14 14:48:56 +10:00
{
2026-07-13 15:29:48 +10:00
b . HasOne ( "PARR.Domain.Entities.JobEntities.Job" , "Job" )
2026-06-15 16:56:23 +10:00
. WithMany ( "UnitFilters" )
. HasForeignKey ( "JobId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Job" ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.UnitsInTemplate" , b = >
2026-06-15 16:56:23 +10:00
{
b . HasOne ( "PARR.Domain.Entities.Template" , "Template" )
. WithMany ( "UnitsInTemplate" )
. HasForeignKey ( "TemplateId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . HasOne ( "PARR.Domain.Entities.Unit.UnitFieldValue" , "UnitFieldValue" )
. WithMany ( "UnitsInTemplates" )
. HasForeignKey ( "UnitFieldValueId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . HasOne ( "PARR.Domain.Entities.Unit.Unit" , "Unit" )
. WithMany ( "TemplatesInUnit" )
. HasForeignKey ( "UnitId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Template" ) ;
b . Navigation ( "Unit" ) ;
b . Navigation ( "UnitFieldValue" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroup" , b = >
{
b . HasOne ( "PARR.Domain.Entities.JobGroupEntities.JobGroupType" , "GroupType" )
2025-11-14 14:48:56 +10:00
. WithMany ( "JobGroups" )
. HasForeignKey ( "GroupTypeId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.UnitField" , "GroupingUnitField" )
2025-12-19 09:31:25 +10:00
. WithMany ( "JobGroupWithGrouping" )
. HasForeignKey ( "GroupingUnitFieldId" )
. OnDelete ( DeleteBehavior . Restrict ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Schedule.ScheduleExcludeTypeCalendar" , "ScheduleExcludeTypeCalendar" )
2025-12-26 11:21:45 +10:00
. WithMany ( "JobGroups" )
. HasForeignKey ( "ScheduleExcludeTypeCalendarId" ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Schedule.ScheduleExcludeType" , "ScheduleExcludeType" )
2025-12-26 11:21:45 +10:00
. WithMany ( "JobGroups" )
. HasForeignKey ( "ScheduleExcludeTypeId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2025-11-14 14:48:56 +10:00
b . Navigation ( "GroupType" ) ;
2025-12-19 09:31:25 +10:00
b . Navigation ( "GroupingUnitField" ) ;
2025-12-26 11:21:45 +10:00
b . Navigation ( "ScheduleExcludeType" ) ;
b . Navigation ( "ScheduleExcludeTypeCalendar" ) ;
2025-11-14 14:48:56 +10:00
} ) ;
2026-06-15 16:56:23 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupAutoControl" , b = >
{
b . HasOne ( "PARR.Domain.Entities.JobGroupEntities.JobGroup" , "JobGroup" )
. WithOne ( "AutoControl" )
. HasForeignKey ( "PARR.Domain.Entities.JobGroupEntities.JobGroupAutoControl" , "JobGroupId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "JobGroup" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupDistributionConfig" , b = >
2026-01-20 16:17:09 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.DistributionPeriod" , "DistributionPeriod" )
2026-01-20 16:17:09 +10:00
. WithMany ( "GroupDistributionConfig" )
. HasForeignKey ( "DistributionPeriodId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-06-15 16:56:23 +10:00
b . HasOne ( "PARR.Domain.Entities.JobGroupEntities.JobGroup" , "Group" )
2026-01-20 16:17:09 +10:00
. WithOne ( "DistributionConfig" )
2026-06-15 16:56:23 +10:00
. HasForeignKey ( "PARR.Domain.Entities.JobGroupEntities.JobGroupDistributionConfig" , "GroupId" )
2026-01-20 16:17:09 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "DistributionPeriod" ) ;
b . Navigation ( "Group" ) ;
} ) ;
2026-06-15 16:56:23 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupFieldFilter" , b = >
2025-08-01 17:14:39 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.UnitField" , "UnitField" )
2026-06-15 16:56:23 +10:00
. WithMany ( "JobGroupFieldFilters" )
2025-08-01 17:14:39 +10:00
. HasForeignKey ( "FieldId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-06-15 16:56:23 +10:00
b . HasOne ( "PARR.Domain.Entities.JobGroupEntities.JobGroupUnitFilter" , "UnitFilter" )
. WithMany ( "FieldFilters" )
2025-08-01 17:14:39 +10:00
. HasForeignKey ( "UnitFilterId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "UnitField" ) ;
b . Navigation ( "UnitFilter" ) ;
} ) ;
2026-06-15 16:56:23 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupRelationshipFilter" , b = >
2025-06-04 11:55:23 +10:00
{
2026-06-15 16:56:23 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.UnitField" , "UnitField" )
. WithMany ( "JobGroupRelationshipFilters" )
. HasForeignKey ( "FieldId" )
2025-06-04 11:55:23 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-06-15 16:56:23 +10:00
b . HasOne ( "PARR.Domain.Entities.JobGroupEntities.JobGroupUnitFilter" , "UnitFilter" )
. WithMany ( "RelationshipFilters" )
. HasForeignKey ( "UnitFilterId" )
2026-05-12 16:34:31 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-06-15 16:56:23 +10:00
b . Navigation ( "UnitField" ) ;
2026-05-12 16:34:31 +10:00
2026-06-15 16:56:23 +10:00
b . Navigation ( "UnitFilter" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupUnitFilter" , b = >
{
b . HasOne ( "PARR.Domain.Entities.JobGroupEntities.JobGroup" , "JobGroup" )
. WithMany ( )
. HasForeignKey ( "JobGroupId" )
2026-05-12 16:34:31 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-06-15 16:56:23 +10:00
b . Navigation ( "JobGroup" ) ;
2026-05-12 16:34:31 +10:00
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Order" , b = >
2023-10-23 16:17:42 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.OrderStatus" , "NextStatus" )
2023-10-24 12:14:22 +10:00
. WithMany ( "OrdersNext" )
. HasForeignKey ( "NextStatusCode" ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.OrderStatus" , "OrderStatus" )
2023-10-23 16:17:42 +10:00
. WithMany ( "Orders" )
2023-10-24 12:14:22 +10:00
. HasForeignKey ( "StatusCode" )
2023-10-23 16:17:42 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Template" , "Template" )
2023-10-23 16:17:42 +10:00
. WithMany ( "Orders" )
. HasForeignKey ( "TemplateId" ) ;
2023-10-24 12:14:22 +10:00
b . Navigation ( "NextStatus" ) ;
2023-10-23 16:17:42 +10:00
b . Navigation ( "OrderStatus" ) ;
b . Navigation ( "Template" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotConfiguration" , b = >
2023-10-05 12:28:31 +10:00
{
2026-07-21 11:48:21 +10:00
b . HasOne ( "PARR.Domain.Entities.RobotEntities.Robot" , "Robot" )
2023-10-05 12:28:31 +10:00
. WithMany ( "RobotConfigurations" )
. HasForeignKey ( "RobotCode" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-07-21 11:48:21 +10:00
b . HasOne ( "PARR.Domain.Entities.RobotEntities.RobotStatus" , "RobotStatus" )
2023-10-06 15:13:40 +10:00
. WithMany ( "RobotConfigurations" )
2023-10-05 12:28:31 +10:00
. HasForeignKey ( "RobotStatusCode" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-07-21 11:48:21 +10:00
b . HasOne ( "PARR.Domain.Entities.RobotEntities.TaskStatus" , "TaskStatus" )
2023-10-06 15:13:40 +10:00
. WithMany ( "RobotConfigurations" )
2023-10-05 12:28:31 +10:00
. HasForeignKey ( "TaskStatusCode" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Template" , "Template" )
2023-10-05 12:28:31 +10:00
. WithMany ( "RobotConfigurations" )
. HasForeignKey ( "TemplateId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Robot" ) ;
b . Navigation ( "RobotStatus" ) ;
2023-10-06 15:13:40 +10:00
b . Navigation ( "TaskStatus" ) ;
2023-10-05 12:28:31 +10:00
b . Navigation ( "Template" ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.RobotConfigurationSnapshot" , b = >
{
2026-07-21 11:48:21 +10:00
b . HasOne ( "PARR.Domain.Entities.RobotEntities.Robot" , "Robot" )
2026-07-13 15:29:48 +10:00
. WithMany ( "ConfigurationSnapshots" )
. HasForeignKey ( "RobotCode" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-07-21 11:48:21 +10:00
b . HasOne ( "PARR.Domain.Entities.RobotEntities.RobotStatus" , "RobotStatus" )
2026-07-13 15:29:48 +10:00
. WithMany ( "ConfigurationSnapshots" )
. HasForeignKey ( "RobotStatusCode" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-07-21 11:48:21 +10:00
b . HasOne ( "PARR.Domain.Entities.RobotEntities.TaskStatus" , "TaskStatus" )
2026-07-13 15:29:48 +10:00
. WithMany ( "ConfigurationSnapshots" )
. HasForeignKey ( "TaskStatusCode" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Robot" ) ;
b . Navigation ( "RobotStatus" ) ;
b . Navigation ( "TaskStatus" ) ;
} ) ;
2026-07-21 11:48:21 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.RobotHistory" , b = >
2023-10-05 12:28:31 +10:00
{
2026-07-21 11:48:21 +10:00
b . HasOne ( "PARR.Domain.Entities.RobotEntities.RobotHistoryLevel" , "RobotHistoryLevel" )
2023-10-05 12:28:31 +10:00
. WithMany ( "RobotHistories" )
. HasForeignKey ( "HistoryLevel" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.RobotConfiguration" , "RobotConfiguration" )
2023-10-05 12:28:31 +10:00
. WithMany ( "RobotHistories" )
. HasForeignKey ( "RobotConfigurationId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-07-21 11:48:21 +10:00
b . HasOne ( "PARR.Domain.Entities.RobotEntities.TaskStatus" , "StatusTask" )
2023-10-06 15:13:40 +10:00
. WithMany ( "RobotHistories" )
2023-10-05 12:28:31 +10:00
. HasForeignKey ( "TaskStatusCode" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "RobotConfiguration" ) ;
b . Navigation ( "RobotHistoryLevel" ) ;
b . Navigation ( "StatusTask" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.EsppSchTypeConfig" , b = >
{
b . HasOne ( "PARR.Domain.Entities.Schedule.EsppSchType" , "EsppSchType" )
. WithMany ( "EsppSchTypeConfigs" )
. HasForeignKey ( "TypeId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . HasOne ( "PARR.Domain.Entities.Schedule.EsppSchTypeSchedule" , "EsppSchTypeSchedule" )
. WithMany ( "EsppSchTypeConfigs" )
. HasForeignKey ( "TypeScheduleId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "EsppSchType" ) ;
b . Navigation ( "EsppSchTypeSchedule" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.EsppSchTypeValue" , b = >
{
b . HasOne ( "PARR.Domain.Entities.Schedule.EsppSchType" , "EsppSchType" )
. WithMany ( "EsppSchTypeValues" )
. HasForeignKey ( "TypeId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "EsppSchType" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.EsppSchValue" , b = >
{
2026-06-15 16:56:23 +10:00
b . HasOne ( "PARR.Domain.Entities.JobGroupEntities.JobGroup" , "JobGroup" )
2026-05-12 16:34:31 +10:00
. WithMany ( "EsppSchValues" )
. HasForeignKey ( "JobGroupId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . HasOne ( "PARR.Domain.Entities.Schedule.EsppSchTypeConfig" , "EsppSchTypeConfig" )
. WithMany ( "EsppSchValues" )
. HasForeignKey ( "TypeConfigId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . HasOne ( "PARR.Domain.Entities.Schedule.EsppSchTypeValue" , "EsppSchTypeValue" )
. WithMany ( "EsppSchValues" )
. HasForeignKey ( "TypeValueId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "EsppSchTypeConfig" ) ;
b . Navigation ( "EsppSchTypeValue" ) ;
b . Navigation ( "JobGroup" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Subprocess" , b = >
2023-09-19 10:01:50 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Process" , "Process" )
2023-09-19 10:01:50 +10:00
. WithMany ( "Subprocesses" )
. HasForeignKey ( "ProcessId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Process" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.TaskEntities.TaskError" , b = >
{
b . HasOne ( "PARR.Domain.Entities.TaskEntities.TaskItem" , "TaskItem" )
. WithMany ( "TaskErrors" )
. HasForeignKey ( "TaskId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "TaskItem" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.TaskEntities.TaskItem" , b = >
{
b . HasOne ( "PARR.Domain.Entities.TaskEntities.TaskStatus" , "TaskStatus" )
. WithMany ( "Tasks" )
. HasForeignKey ( "StatusCode" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . HasOne ( "PARR.Domain.Entities.TaskEntities.TaskType" , "TaskType" )
. WithMany ( "Tasks" )
. HasForeignKey ( "TypeCode" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "TaskStatus" ) ;
b . Navigation ( "TaskType" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Template" , b = >
2023-09-14 17:00:56 +10:00
{
2026-07-13 15:29:48 +10:00
b . HasOne ( "PARR.Domain.Entities.JobEntities.Job" , "Job" )
2025-08-01 17:14:39 +10:00
. WithMany ( "Templates" )
2025-06-11 11:14:27 +10:00
. HasForeignKey ( "JobId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.TemplateStatusType" , "StatusType" )
2025-12-01 15:27:18 +10:00
. WithMany ( "Templates" )
. HasForeignKey ( "StatusTypeId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.Unit" , "Unit" )
2025-06-25 14:17:34 +10:00
. WithMany ( "Templates" )
2025-06-11 11:14:27 +10:00
. HasForeignKey ( "UnitId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Job" ) ;
2025-12-01 15:27:18 +10:00
b . Navigation ( "StatusType" ) ;
2025-06-11 11:14:27 +10:00
b . Navigation ( "Unit" ) ;
2023-09-14 17:00:56 +10:00
} ) ;
2026-07-21 11:48:21 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.TemplateEntities.TemplateRenamePending" , b = >
{
b . HasOne ( "PARR.Domain.Entities.Template" , "Template" )
. WithOne ( "TemplateRenamePending" )
. HasForeignKey ( "PARR.Domain.Entities.TemplateEntities.TemplateRenamePending" , "TemplateId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Template" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.TemplateHistory" , b = >
2024-10-07 15:08:46 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Template" , "Template" )
2024-10-07 15:08:46 +10:00
. WithMany ( "TemplateHistories" )
. HasForeignKey ( "ParentId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Template" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Tnk" , b = >
2023-09-19 10:01:50 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Subprocess" , "Subprocess" )
2023-09-19 10:01:50 +10:00
. WithMany ( "Tnks" )
. HasForeignKey ( "SubprocessId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Subprocess" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitFieldInUnitFieldValue" , b = >
2025-05-14 15:13:30 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.UnitField" , "Field" )
2025-09-22 15:25:17 +10:00
. WithMany ( "UnitFieldValues" )
2025-05-14 15:13:30 +10:00
. HasForeignKey ( "FieldId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.UnitFieldValue" , "FieldValue" )
2025-05-14 15:13:30 +10:00
. WithMany ( "FieldValues" )
. HasForeignKey ( "FieldValueId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Field" ) ;
b . Navigation ( "FieldValue" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitInUnit" , b = >
2025-05-27 11:32:05 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.Unit" , "ChildUnit" )
2025-06-04 11:55:23 +10:00
. WithMany ( "ParentUnits" )
2025-05-27 11:32:05 +10:00
. HasForeignKey ( "ChildUnitId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.Unit" , "ParentUnit" )
2025-06-04 11:55:23 +10:00
. WithMany ( "ChildUnits" )
2025-05-27 11:32:05 +10:00
. HasForeignKey ( "ParentUnitId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2025-06-04 11:55:23 +10:00
b . Navigation ( "ChildUnit" ) ;
2025-05-27 11:32:05 +10:00
2025-06-04 11:55:23 +10:00
b . Navigation ( "ParentUnit" ) ;
2025-05-27 11:32:05 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitInValue" , b = >
2025-05-14 15:13:30 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.UnitField" , "Field" )
2025-05-14 15:13:30 +10:00
. WithMany ( "UnitInValues" )
. HasForeignKey ( "FieldId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.Unit" , "Unit" )
2025-05-21 11:53:07 +10:00
. WithMany ( "UnitValues" )
2025-05-14 15:13:30 +10:00
. HasForeignKey ( "UnitId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.UnitFieldValue" , "Value" )
2025-05-14 15:13:30 +10:00
. WithMany ( "UnitInValues" )
2025-05-21 11:53:07 +10:00
. HasForeignKey ( "ValueId" )
2025-05-14 15:13:30 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Field" ) ;
b . Navigation ( "Unit" ) ;
b . Navigation ( "Value" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitKiiUnit" , b = >
2025-12-19 09:09:22 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.Unit" , "Unit" )
2025-12-19 09:09:22 +10:00
. WithOne ( "UnitKii" )
2026-05-12 16:34:31 +10:00
. HasForeignKey ( "PARR.Domain.Entities.Unit.UnitKiiUnit" , "UnitId" )
2025-12-19 09:09:22 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Unit" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitRegionalEkPtkGroup" , b = >
2025-12-18 16:48:48 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Unit.UnitFieldValue" , "FieldValue" )
2025-12-18 16:48:48 +10:00
. WithOne ( "RegionalEkPtkGroup" )
2026-05-12 16:34:31 +10:00
. HasForeignKey ( "PARR.Domain.Entities.Unit.UnitRegionalEkPtkGroup" , "FieldValueId" )
2025-12-18 16:48:48 +10:00
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "FieldValue" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.UsersInRole" , b = >
2023-12-01 10:05:54 +10:00
{
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.Role" , "Role" )
2023-12-01 10:05:54 +10:00
. WithMany ( "Users" )
. HasForeignKey ( "RoleId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
2026-05-12 16:34:31 +10:00
b . HasOne ( "PARR.Domain.Entities.User" , "User" )
2023-12-01 10:05:54 +10:00
. WithMany ( "Roles" )
. HasForeignKey ( "UserId" )
. OnDelete ( DeleteBehavior . Cascade )
. IsRequired ( ) ;
b . Navigation ( "Role" ) ;
b . Navigation ( "User" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.AgentHistoryLevel" , b = >
2023-09-19 10:01:50 +10:00
{
2026-04-15 09:35:03 +10:00
b . Navigation ( "AgentHistories" ) ;
2023-09-19 10:01:50 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.DistributionPeriod" , b = >
2024-07-01 12:09:01 +10:00
{
2026-01-20 16:17:09 +10:00
b . Navigation ( "GroupDistributionConfig" ) ;
2024-07-01 12:09:01 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.DistributionPeriodType" , b = >
2024-07-01 16:56:59 +10:00
{
b . Navigation ( "Periods" ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.Job" , b = >
2025-06-04 11:55:23 +10:00
{
2025-12-05 14:07:48 +10:00
b . Navigation ( "AutoControl" ) ;
2025-08-01 17:14:39 +10:00
b . Navigation ( "Templates" ) ;
2025-06-11 11:14:27 +10:00
b . Navigation ( "UnitFilters" ) ;
} ) ;
2026-07-13 15:29:48 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobEntities.JobUnitFilter" , b = >
2026-06-15 16:56:23 +10:00
{
b . Navigation ( "FieldFilters" ) ;
b . Navigation ( "RelationshipFilters" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroup" , b = >
2025-06-11 11:14:27 +10:00
{
2026-06-15 16:56:23 +10:00
b . Navigation ( "AutoControl" ) ;
2026-01-20 16:17:09 +10:00
b . Navigation ( "DistributionConfig" ) ;
2025-06-25 14:17:34 +10:00
b . Navigation ( "EsppSchValues" ) ;
b . Navigation ( "Jobs" ) ;
2025-06-04 11:55:23 +10:00
} ) ;
2026-06-15 16:56:23 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupType" , b = >
2025-11-14 14:48:56 +10:00
{
b . Navigation ( "JobGroups" ) ;
} ) ;
2026-06-15 16:56:23 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.JobGroupEntities.JobGroupUnitFilter" , b = >
2025-06-04 11:55:23 +10:00
{
2025-08-01 17:14:39 +10:00
b . Navigation ( "FieldFilters" ) ;
b . Navigation ( "RelationshipFilters" ) ;
2025-06-04 11:55:23 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Order" , b = >
2023-10-24 10:38:21 +10:00
{
b . Navigation ( "AgentHistories" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.OrderStatus" , b = >
2023-10-23 16:17:42 +10:00
{
b . Navigation ( "Orders" ) ;
2023-10-24 12:14:22 +10:00
b . Navigation ( "OrdersNext" ) ;
2023-10-23 16:17:42 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Process" , b = >
2023-09-19 10:01:50 +10:00
{
b . Navigation ( "Subprocesses" ) ;
} ) ;
2026-07-21 11:48:21 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotConfiguration" , b = >
{
b . Navigation ( "RobotHistories" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.Robot" , b = >
2023-10-05 12:28:31 +10:00
{
2026-07-13 15:29:48 +10:00
b . Navigation ( "ConfigurationSnapshots" ) ;
2023-10-05 12:28:31 +10:00
b . Navigation ( "RobotConfigurations" ) ;
} ) ;
2026-07-21 11:48:21 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.RobotHistoryLevel" , b = >
2023-10-05 12:28:31 +10:00
{
b . Navigation ( "RobotHistories" ) ;
} ) ;
2026-07-21 11:48:21 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.RobotStatus" , b = >
2023-10-03 14:30:54 +10:00
{
2026-07-21 11:48:21 +10:00
b . Navigation ( "ConfigurationSnapshots" ) ;
b . Navigation ( "RobotConfigurations" ) ;
2023-10-03 14:30:54 +10:00
} ) ;
2026-07-21 11:48:21 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.RobotEntities.TaskStatus" , b = >
2023-10-03 14:30:54 +10:00
{
2026-07-13 15:29:48 +10:00
b . Navigation ( "ConfigurationSnapshots" ) ;
2023-10-06 15:13:40 +10:00
b . Navigation ( "RobotConfigurations" ) ;
2026-07-21 11:48:21 +10:00
b . Navigation ( "RobotHistories" ) ;
2023-10-03 14:30:54 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Role" , b = >
2023-12-01 10:05:54 +10:00
{
b . Navigation ( "Users" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.EsppSchType" , b = >
{
b . Navigation ( "EsppSchTypeConfigs" ) ;
b . Navigation ( "EsppSchTypeValues" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.EsppSchTypeConfig" , b = >
{
b . Navigation ( "EsppSchValues" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.EsppSchTypeSchedule" , b = >
{
b . Navigation ( "EsppSchTypeConfigs" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.EsppSchTypeValue" , b = >
{
b . Navigation ( "EsppSchValues" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.ScheduleExcludeType" , b = >
2025-12-26 11:21:45 +10:00
{
b . Navigation ( "JobGroups" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Schedule.ScheduleExcludeTypeCalendar" , b = >
2025-12-26 11:21:45 +10:00
{
b . Navigation ( "JobGroups" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Subprocess" , b = >
2023-09-14 17:00:56 +10:00
{
2023-10-05 16:56:02 +10:00
b . Navigation ( "Tnks" ) ;
2023-09-14 17:00:56 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.TaskEntities.TaskItem" , b = >
{
b . Navigation ( "TaskErrors" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.TaskEntities.TaskStatus" , b = >
{
b . Navigation ( "Tasks" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.TaskEntities.TaskType" , b = >
{
b . Navigation ( "Tasks" ) ;
} ) ;
modelBuilder . Entity ( "PARR.Domain.Entities.Template" , b = >
2023-10-03 14:30:54 +10:00
{
2023-10-19 11:22:35 +10:00
b . Navigation ( "AgentHistories" ) ;
2023-10-23 16:17:42 +10:00
b . Navigation ( "Orders" ) ;
2023-10-05 12:28:31 +10:00
b . Navigation ( "RobotConfigurations" ) ;
2024-10-07 15:08:46 +10:00
b . Navigation ( "TemplateHistories" ) ;
2025-11-14 14:48:56 +10:00
2026-07-21 11:48:21 +10:00
b . Navigation ( "TemplateRenamePending" ) ;
2025-11-14 14:48:56 +10:00
b . Navigation ( "UnitsInTemplate" ) ;
2023-10-03 14:30:54 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.TemplateStatusType" , b = >
2025-12-01 15:27:18 +10:00
{
b . Navigation ( "Templates" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Tnk" , b = >
2023-09-19 10:01:50 +10:00
{
2025-12-09 16:00:38 +10:00
b . Navigation ( "Jobs" ) ;
2023-09-19 10:01:50 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.Unit" , b = >
2025-05-14 15:13:30 +10:00
{
2025-06-04 11:55:23 +10:00
b . Navigation ( "ChildUnits" ) ;
2025-05-27 11:32:05 +10:00
2025-06-04 11:55:23 +10:00
b . Navigation ( "ParentUnits" ) ;
2025-05-27 11:32:05 +10:00
2025-06-25 14:17:34 +10:00
b . Navigation ( "Templates" ) ;
2025-11-14 14:48:56 +10:00
b . Navigation ( "TemplatesInUnit" ) ;
2025-12-19 09:09:22 +10:00
b . Navigation ( "UnitKii" ) ;
2025-05-21 11:53:07 +10:00
b . Navigation ( "UnitValues" ) ;
2025-05-14 15:13:30 +10:00
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitField" , b = >
2025-05-14 15:13:30 +10:00
{
2026-06-15 16:56:23 +10:00
b . Navigation ( "JobFieldFilters" ) ;
b . Navigation ( "JobGroupFieldFilters" ) ;
b . Navigation ( "JobGroupRelationshipFilters" ) ;
2025-12-19 09:31:25 +10:00
b . Navigation ( "JobGroupWithGrouping" ) ;
2025-08-01 17:14:39 +10:00
b . Navigation ( "RelationshipFilters" ) ;
2025-09-22 15:25:17 +10:00
b . Navigation ( "UnitFieldValues" ) ;
2025-05-14 15:13:30 +10:00
b . Navigation ( "UnitInValues" ) ;
} ) ;
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.Unit.UnitFieldValue" , b = >
2025-05-14 15:13:30 +10:00
{
b . Navigation ( "FieldValues" ) ;
2025-12-18 16:48:48 +10:00
b . Navigation ( "RegionalEkPtkGroup" ) ;
2025-05-14 15:13:30 +10:00
b . Navigation ( "UnitInValues" ) ;
2026-04-15 09:35:03 +10:00
2026-05-12 16:34:31 +10:00
b . Navigation ( "UnitsInTemplates" ) ;
2026-04-15 09:35:03 +10:00
} ) ;
2024-06-03 15:17:14 +10:00
2026-05-12 16:34:31 +10:00
modelBuilder . Entity ( "PARR.Domain.Entities.User" , b = >
2026-04-15 09:35:03 +10:00
{
2026-05-12 16:34:31 +10:00
b . Navigation ( "Roles" ) ;
2024-06-03 15:17:14 +10:00
} ) ;
2023-05-17 16:30:13 +10:00
#pragma warning restore 612 , 618
}
}
}