4134 lines
170 KiB
C#
4134 lines
170 KiB
C#
// <auto-generated />
|
||
using System;
|
||
using Microsoft.EntityFrameworkCore;
|
||
using Microsoft.EntityFrameworkCore.Infrastructure;
|
||
using Microsoft.EntityFrameworkCore.Migrations;
|
||
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
|
||
using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
|
||
using PARR.DAL.Context;
|
||
|
||
#nullable disable
|
||
|
||
namespace PARR.DAL.Migrations
|
||
{
|
||
[DbContext(typeof(DataContext))]
|
||
[Migration("20260721013444_tblTemplateRenamePendings")]
|
||
partial class tblTemplateRenamePendings
|
||
{
|
||
/// <inheritdoc />
|
||
protected override void BuildTargetModel(ModelBuilder modelBuilder)
|
||
{
|
||
#pragma warning disable 612, 618
|
||
modelBuilder
|
||
.HasAnnotation("ProductVersion", "9.0.16")
|
||
.HasAnnotation("Relational:MaxIdentifierLength", 63);
|
||
|
||
NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.AgentHistory", b =>
|
||
{
|
||
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");
|
||
|
||
b.Property<Guid?>("OrderId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<Guid>("TemplateId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("HistoryLevelId");
|
||
|
||
b.HasIndex("OrderId");
|
||
|
||
b.HasIndex("TemplateId");
|
||
|
||
b.ToTable("AgentHistories");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.AgentHistoryLevel", 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("AgentHistoryLevels");
|
||
|
||
b.HasData(
|
||
new
|
||
{
|
||
Id = 1,
|
||
Description = "Агент начал выполнять задание",
|
||
Name = "Start"
|
||
},
|
||
new
|
||
{
|
||
Id = 5,
|
||
Description = "Агент завершил выполнение задания",
|
||
Name = "End"
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.DistributionPeriod", b =>
|
||
{
|
||
b.Property<Guid>("Id")
|
||
.ValueGeneratedOnAdd()
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<string>("Duration")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.Property<string>("Name")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.Property<string>("Type")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("Type");
|
||
|
||
b.ToTable("DistributionPeriods", "schedule");
|
||
|
||
b.HasData(
|
||
new
|
||
{
|
||
Id = new Guid("9bd0bfa8-c316-480b-a001-e09ffe8c9340"),
|
||
Duration = "7",
|
||
Name = "Еженедельно",
|
||
Type = "Day"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("3a7341a8-085c-461c-babc-6b78dd5d2c67"),
|
||
Duration = "30",
|
||
Name = "Ежемесячно",
|
||
Type = "Day"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("0ad2dfdb-3833-46d9-979a-c408b7eadc6c"),
|
||
Duration = "90",
|
||
Name = "Каждые 90 дней",
|
||
Type = "Day"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("31dd3947-8471-4f09-852c-a4f075f1ba7f"),
|
||
Duration = "182",
|
||
Name = "Каждые пол года",
|
||
Type = "Day"
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.DistributionPeriodType", b =>
|
||
{
|
||
b.Property<string>("Type")
|
||
.HasColumnType("text");
|
||
|
||
b.Property<string>("Description")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.HasKey("Type");
|
||
|
||
b.ToTable("DistributionPeriodTypes", "schedule");
|
||
|
||
b.HasData(
|
||
new
|
||
{
|
||
Type = "Day",
|
||
Description = "День"
|
||
},
|
||
new
|
||
{
|
||
Type = "Month",
|
||
Description = "Месяц"
|
||
},
|
||
new
|
||
{
|
||
Type = "Year",
|
||
Description = "Год"
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.Job", 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<Guid>("GroupId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<bool?>("IsParentRelationships")
|
||
.HasColumnType("boolean");
|
||
|
||
b.Property<int?>("MaxValueRelationships")
|
||
.HasColumnType("integer");
|
||
|
||
b.Property<int?>("MinValueRelationships")
|
||
.HasColumnType("integer");
|
||
|
||
b.Property<string>("Name")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
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")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("GroupId");
|
||
|
||
b.HasIndex("TnkId");
|
||
|
||
b.ToTable("Jobs", "job", t =>
|
||
{
|
||
t.HasComment("Таблица видов работ");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.JobAutoControl", b =>
|
||
{
|
||
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 =>
|
||
{
|
||
t.HasComment("Таблица управления автоконтролем для работ");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.JobFieldFilter", b =>
|
||
{
|
||
b.Property<Guid>("Id")
|
||
.ValueGeneratedOnAdd()
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<DateTimeOffset>("DateCreated")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.Property<Guid>("FieldId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<bool>("IsInverse")
|
||
.HasColumnType("boolean");
|
||
|
||
b.Property<Guid>("UnitFilterId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<string>("ValueMask")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("FieldId");
|
||
|
||
b.HasIndex("UnitFilterId");
|
||
|
||
b.ToTable("FieldFilters", "job", t =>
|
||
{
|
||
t.HasComment("Таблица описания критериев выборки аттрибутов ЭК");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.JobRelationshipFilter", b =>
|
||
{
|
||
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("Таблица фильтров связей ЭК");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.JobUnitFilter", b =>
|
||
{
|
||
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("Таблица описания критериев выборки ЭК, описание полей в АСУ ЕСПП");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.UnitsInTemplate", b =>
|
||
{
|
||
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 =>
|
||
{
|
||
b.Property<Guid>("Id")
|
||
.ValueGeneratedOnAdd()
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<string>("AgentName")
|
||
.HasColumnType("text");
|
||
|
||
b.Property<string>("AgentScript")
|
||
.HasColumnType("text");
|
||
|
||
b.Property<int?>("AgentTimeOutSec")
|
||
.HasColumnType("integer");
|
||
|
||
b.Property<DateTimeOffset>("DateCreated")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.Property<DateTimeOffset?>("DateModified")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.Property<string>("FullDescription")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.Property<string>("GroupName")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.Property<Guid>("GroupTypeId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<Guid?>("GroupingUnitFieldId")
|
||
.HasColumnType("uuid");
|
||
|
||
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");
|
||
|
||
b.ToTable("Groups", "jobGroup", t =>
|
||
{
|
||
t.HasComment("Таблица описания групп работ, для реализации зонтиков");
|
||
});
|
||
});
|
||
|
||
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 =>
|
||
{
|
||
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");
|
||
|
||
b.ToTable("GroupDistributionConfigs", "jobGroup", t =>
|
||
{
|
||
t.HasComment("Настройки автораспределения для группы работ");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobGroupEntities.JobGroupFieldFilter", b =>
|
||
{
|
||
b.Property<Guid>("Id")
|
||
.ValueGeneratedOnAdd()
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<DateTimeOffset>("DateCreated")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.Property<Guid>("FieldId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<bool>("IsInverse")
|
||
.HasColumnType("boolean");
|
||
|
||
b.Property<Guid>("UnitFilterId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<string>("ValueMask")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("FieldId")
|
||
.HasDatabaseName("IX_FieldFilters_FieldId1");
|
||
|
||
b.HasIndex("UnitFilterId")
|
||
.HasDatabaseName("IX_FieldFilters_UnitFilterId1");
|
||
|
||
b.ToTable("FieldFilters", "jobGroup", t =>
|
||
{
|
||
t.HasComment("Таблица описания критериев выборки аттрибутов ЭК");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobGroupEntities.JobGroupRelationshipFilter", b =>
|
||
{
|
||
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")
|
||
.HasDatabaseName("IX_RelationshipFilters_FieldId1");
|
||
|
||
b.ToTable("RelationshipFilters", "jobGroup", t =>
|
||
{
|
||
t.HasComment("Таблица фильтров связей ЭК");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobGroupEntities.JobGroupType", b =>
|
||
{
|
||
b.Property<Guid>("Id")
|
||
.ValueGeneratedOnAdd()
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<int>("Code")
|
||
.HasColumnType("integer");
|
||
|
||
b.Property<DateTimeOffset>("DateCreated")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.Property<string>("Description")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.Property<bool>("IsAllowJobUnitFilter")
|
||
.HasColumnType("boolean")
|
||
.HasComment("Разрешить Job фильтры. Влияет только на интерфейс. Мэтчер собирает все фильтры из группы и работ всегда.");
|
||
|
||
b.Property<bool>("IsJobGroupAutoControl")
|
||
.HasColumnType("boolean")
|
||
.HasComment("Автоконтролем управляет JobGroup? true - да JobGroup, false - Job. Влияет на интерфейс и на логику работы автоконтроля.");
|
||
|
||
b.Property<bool>("IsRelationshipsAllowed")
|
||
.HasColumnType("boolean")
|
||
.HasComment("Разрешена настройка кол-ва связей");
|
||
|
||
b.Property<string>("Name")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.ToTable("GroupTypes", "jobGroup", t =>
|
||
{
|
||
t.HasComment("Таблица типов групп работ");
|
||
});
|
||
|
||
b.HasData(
|
||
new
|
||
{
|
||
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,
|
||
IsRelationshipsAllowed = false,
|
||
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,
|
||
IsRelationshipsAllowed = true,
|
||
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,
|
||
IsRelationshipsAllowed = true,
|
||
Name = "Group"
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobGroupEntities.JobGroupUnitFilter", b =>
|
||
{
|
||
b.Property<Guid>("Id")
|
||
.ValueGeneratedOnAdd()
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<DateTimeOffset>("DateCreated")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.Property<Guid>("JobGroupId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<string>("UnitFilter")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("JobGroupId");
|
||
|
||
b.ToTable("UnitFilters", "jobGroup", t =>
|
||
{
|
||
t.HasComment("Таблица описания критериев выборки ЭК, описание полей в АСУ ЕСПП");
|
||
});
|
||
});
|
||
|
||
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(
|
||
new
|
||
{
|
||
Code = 1,
|
||
Description = "1-Направлен в группу",
|
||
Name = "New"
|
||
},
|
||
new
|
||
{
|
||
Code = 2,
|
||
Description = "2-В работе",
|
||
Name = "InWork"
|
||
},
|
||
new
|
||
{
|
||
Code = 3,
|
||
Description = "3-Приостановлен",
|
||
Name = "Stop"
|
||
},
|
||
new
|
||
{
|
||
Code = 4,
|
||
Description = "4-Выполнен",
|
||
Name = "Complete"
|
||
},
|
||
new
|
||
{
|
||
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(
|
||
new
|
||
{
|
||
Id = 0,
|
||
Description = "API",
|
||
Name = "Api"
|
||
},
|
||
new
|
||
{
|
||
Id = 1,
|
||
Description = "Загрузчик из АИХИТ",
|
||
Name = "AihitLoader"
|
||
},
|
||
new
|
||
{
|
||
Id = 2,
|
||
Description = "Синхронизатор АИХИТ",
|
||
Name = "AihitSyncer"
|
||
},
|
||
new
|
||
{
|
||
Id = 3,
|
||
Description = "Загрузчик нарядов из ЕСПП",
|
||
Name = "EsppOrderLoader"
|
||
},
|
||
new
|
||
{
|
||
Id = 4,
|
||
Description = "Управление нарядами ЕСПП",
|
||
Name = "EsppOrderManager"
|
||
},
|
||
new
|
||
{
|
||
Id = 5,
|
||
Description = "Синхронизатор расписаний",
|
||
Name = "EsppScheduleSync"
|
||
},
|
||
new
|
||
{
|
||
Id = 6,
|
||
Description = "Синхронизатор шаблонов",
|
||
Name = "EsppTemplateSync"
|
||
},
|
||
new
|
||
{
|
||
Id = 7,
|
||
Description = "Генератор шаблонов",
|
||
Name = "GeneratorTemplates"
|
||
},
|
||
new
|
||
{
|
||
Id = 8,
|
||
Description = "Авто-контроль РР",
|
||
Name = "JobAutoControl"
|
||
},
|
||
new
|
||
{
|
||
Id = 9,
|
||
Description = "Связывание нарядов ЕСПП с ПАРР (шаблонами, агентами)",
|
||
Name = "Master"
|
||
},
|
||
new
|
||
{
|
||
Id = 10,
|
||
Description = "Рассчет даты следующего срабатывания",
|
||
Name = "NextRun"
|
||
},
|
||
new
|
||
{
|
||
Id = 11,
|
||
Description = "Активатор шаблонов / расписаний",
|
||
Name = "TemplateActivator"
|
||
},
|
||
new
|
||
{
|
||
Id = 12,
|
||
Description = "Автораспределение РР",
|
||
Name = "TemplateDistributor"
|
||
},
|
||
new
|
||
{
|
||
Id = 13,
|
||
Description = "Генератор шаблонов",
|
||
Name = "TemplateTaskGenerator"
|
||
},
|
||
new
|
||
{
|
||
Id = 14,
|
||
Description = "Генератор кэша отчетов workload",
|
||
Name = "WorkloadBuilder"
|
||
});
|
||
});
|
||
|
||
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("RobotCode");
|
||
|
||
b.HasIndex("RobotStatusCode");
|
||
|
||
b.HasIndex("TaskStatusCode");
|
||
|
||
b.HasIndex("TemplateId", "RobotCode")
|
||
.IsUnique();
|
||
|
||
b.HasIndex("TemplateId", "RobotStatusCode");
|
||
|
||
b.HasIndex("TemplateId", "TaskStatusCode");
|
||
|
||
b.ToTable("RobotConfigurations");
|
||
});
|
||
|
||
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"
|
||
});
|
||
});
|
||
|
||
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("Снимки заданий роботам");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.RobotEntities.RobotHistory", b =>
|
||
{
|
||
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");
|
||
|
||
b.Property<string>("RobotId")
|
||
.HasColumnType("text")
|
||
.HasComment("Идентификатор робота. Форматы: H20-R1-T, H20-R1-S, H20-R1-ET, H20-R1-ES.");
|
||
|
||
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");
|
||
|
||
b.ToTable("Histories", "robot");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.RobotEntities.RobotHistoryLevel", b =>
|
||
{
|
||
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");
|
||
|
||
b.ToTable("HistoryLevels", "robot");
|
||
|
||
b.HasData(
|
||
new
|
||
{
|
||
Level = 1,
|
||
Description = "Робот начал работу ",
|
||
Name = "Start"
|
||
},
|
||
new
|
||
{
|
||
Level = 5,
|
||
Description = "Информация",
|
||
Name = "Information"
|
||
},
|
||
new
|
||
{
|
||
Level = 10,
|
||
Description = "Ошибка",
|
||
Name = "Error"
|
||
},
|
||
new
|
||
{
|
||
Level = 15,
|
||
Description = "Успешно завершил работу",
|
||
Name = "Complete"
|
||
});
|
||
});
|
||
|
||
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 =>
|
||
{
|
||
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("RobotStatuses", "robot");
|
||
|
||
b.HasData(
|
||
new
|
||
{
|
||
Code = 11,
|
||
Description = "Ожидание, ждет пока робот возьмет в работу.",
|
||
Name = "Wait"
|
||
},
|
||
new
|
||
{
|
||
Code = 22,
|
||
Description = "Робот взял в работу.",
|
||
Name = "InProgress"
|
||
},
|
||
new
|
||
{
|
||
Code = 33,
|
||
Description = "Ошибка отработки роботом. Требует ручного вмешательства.",
|
||
Name = "Error"
|
||
},
|
||
new
|
||
{
|
||
Code = 44,
|
||
Description = "Робот успешно отработал.",
|
||
Name = "Complete"
|
||
});
|
||
});
|
||
|
||
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"
|
||
});
|
||
});
|
||
|
||
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(
|
||
new
|
||
{
|
||
Id = new Guid("c8f2f144-e6c2-45d7-ba66-5e9bbd376376"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
Description = "Администратор",
|
||
Name = "administrator"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("13bca225-7fa4-42fa-9d80-d2d46de261fe"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
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(
|
||
new
|
||
{
|
||
Id = 1,
|
||
Description = "Через интервал",
|
||
Name = "Interval"
|
||
},
|
||
new
|
||
{
|
||
Id = 2,
|
||
Description = "День недели: пнд, вт...",
|
||
Name = "DayOfWeek"
|
||
},
|
||
new
|
||
{
|
||
Id = 3,
|
||
Description = "Число месяца: 1,2,3,4",
|
||
Name = "DayOfMonth"
|
||
},
|
||
new
|
||
{
|
||
Id = 4,
|
||
Description = "Каждый: первый, второй, третий, четвертый, последний",
|
||
Name = "Order"
|
||
},
|
||
new
|
||
{
|
||
Id = 5,
|
||
Description = "Месяц: январь, февраль...",
|
||
Name = "Month"
|
||
},
|
||
new
|
||
{
|
||
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(
|
||
new
|
||
{
|
||
Id = new Guid("d2693562-b3eb-41e9-97db-c6b5d2ef1bea"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
Order = 0,
|
||
TypeId = 1,
|
||
TypeScheduleId = 1
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("06b2e7aa-6927-4fbf-99fb-67c92a4fce8a"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
Order = 0,
|
||
TypeId = 2,
|
||
TypeScheduleId = 2
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("78079071-ff80-417e-9bb0-d928cec853e7"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
Order = 0,
|
||
TypeId = 3,
|
||
TypeScheduleId = 3
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("accb1d46-e1c1-4396-9182-4c0766155921"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
Order = 0,
|
||
TypeId = 4,
|
||
TypeScheduleId = 4
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("162ffe73-2428-4abe-8f83-235c2593664c"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
Order = 1,
|
||
TypeId = 2,
|
||
TypeScheduleId = 4
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("8470d1ef-165d-42fc-ab05-8203e4d263cf"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
Order = 0,
|
||
TypeId = 5,
|
||
TypeScheduleId = 5
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("006900b5-f65c-413e-bc67-09e6dae60b7c"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
Order = 1,
|
||
TypeId = 3,
|
||
TypeScheduleId = 5
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("85635bc8-f17a-46b8-9c15-8615761be3d9"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
Order = 0,
|
||
TypeId = 4,
|
||
TypeScheduleId = 6
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("439460c2-deca-4b54-80e7-2f20806696ec"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
Order = 1,
|
||
TypeId = 2,
|
||
TypeScheduleId = 6
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("5c63ad8c-e9b4-43fd-9d24-5c2eed80dadd"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
Order = 2,
|
||
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"
|
||
},
|
||
new
|
||
{
|
||
Id = 2,
|
||
Description = "Еженедельно",
|
||
Name = "Weekly"
|
||
},
|
||
new
|
||
{
|
||
Id = 3,
|
||
Description = "Ежемесячно",
|
||
Name = "Monthly"
|
||
},
|
||
new
|
||
{
|
||
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"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "01:00:00",
|
||
Order = 0,
|
||
TypeId = 1,
|
||
Value = "Каждый час"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("4df04834-f14f-43d9-8984-334f080f4107"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "02:00:00",
|
||
Order = 1,
|
||
TypeId = 1,
|
||
Value = "Каждые 2 часа"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("dab6e3f9-2385-4966-b77c-133ad233c592"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "03:00:00",
|
||
Order = 2,
|
||
TypeId = 1,
|
||
Value = "Каждые 3 часа"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("035f485d-8451-47df-bfaa-ba4dd36cf146"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "04:00:00",
|
||
Order = 3,
|
||
TypeId = 1,
|
||
Value = "Каждые 4 часа"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("d627daa7-3eed-4571-acae-ffbb3c5bedb9"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "06:00:00",
|
||
Order = 4,
|
||
TypeId = 1,
|
||
Value = "Каждые 6 часов"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("ae0a0015-0f1e-4496-b71e-6244f7e321e7"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "12:00:00",
|
||
Order = 5,
|
||
TypeId = 1,
|
||
Value = "Каждые 12 часов"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("8df097aa-9860-4a62-9675-a8eecd3f2ce7"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "1 00:00:00",
|
||
Order = 6,
|
||
TypeId = 1,
|
||
Value = "Ежедневно"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("dee32e60-c1a1-4206-98bc-aa03deabfdf6"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "3 00:00:00",
|
||
Order = 7,
|
||
TypeId = 1,
|
||
Value = "Каждые 72 часа"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("e0465fbf-e3a5-4486-9f53-5bb85c6feeca"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "4 00:00:00",
|
||
Order = 8,
|
||
TypeId = 1,
|
||
Value = "Каждые 96 часов"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("4e3f73d1-a0f3-4dd1-bca9-68ada0dd5ce2"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "14 00:00:00",
|
||
Order = 9,
|
||
TypeId = 1,
|
||
Value = "Каждые 2 недели"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("55833417-6a24-42f6-bcc2-5d032f883202"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "60 00:00:00",
|
||
Order = 10,
|
||
TypeId = 1,
|
||
Value = "Каждые 60 дней"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("7fefa052-29db-4ce5-9c57-2fd9ff855f21"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "80 00:00:00",
|
||
Order = 11,
|
||
TypeId = 1,
|
||
Value = "Каждые 80 дней"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("b0ca99f9-5ee0-45b3-bb80-948f82b1fcb1"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "90 00:00:00",
|
||
Order = 12,
|
||
TypeId = 1,
|
||
Value = "Каждые 90 дней"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("086f7a37-9848-423a-a3cc-36dbb5ad43e3"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "182 00:00:00",
|
||
Order = 13,
|
||
TypeId = 1,
|
||
Value = "Каждые полгода"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("f2da9e02-d619-4517-a598-374880a8c8e8"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "540 00:00:00",
|
||
Order = 14,
|
||
TypeId = 1,
|
||
Value = "Каждые 1,5 года"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("f38d7d30-8923-4ea0-aa7c-5b251e19ab61"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "1095 00:00:00",
|
||
Order = 15,
|
||
TypeId = 1,
|
||
Value = "Каждые 3 года"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("b7303461-9a30-43fa-8e55-305aa13f186f"),
|
||
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 = 2,
|
||
Value = "Понедельник"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("e951135e-71f2-4262-9342-df4d5315ab6c"),
|
||
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 = 2,
|
||
Value = "Вторник"
|
||
},
|
||
new
|
||
{
|
||
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"),
|
||
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 = 2,
|
||
Value = "Воскресенье"
|
||
},
|
||
new
|
||
{
|
||
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"),
|
||
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 = 3,
|
||
Value = "8"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("8b7847a4-23de-4199-8aad-3b5c0323b5a2"),
|
||
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 = 3,
|
||
Value = "9"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("fb7f41ca-950b-4dc1-a0a6-bd9a221ab2ad"),
|
||
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 = 3,
|
||
Value = "10"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("a28b530f-ea38-4a2c-a16b-0b7fa3770d3c"),
|
||
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 = 3,
|
||
Value = "11"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("7a004a11-32e1-40ae-ab35-0d3dc3a69785"),
|
||
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 = 3,
|
||
Value = "12"
|
||
},
|
||
new
|
||
{
|
||
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
|
||
{
|
||
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
|
||
{
|
||
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
|
||
{
|
||
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
|
||
{
|
||
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
|
||
{
|
||
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"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("4f4b249c-db60-4582-86ed-75cfee4edd0c"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "19",
|
||
Order = 18,
|
||
TypeId = 3,
|
||
Value = "19"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("220a1464-4d39-416c-b4b2-3093eb007298"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
EsppExportValue = "20",
|
||
Order = 19,
|
||
TypeId = 3,
|
||
Value = "20"
|
||
},
|
||
new
|
||
{
|
||
Id = new Guid("c887ca60-b05d-4d3c-ad1f-223c879b1a6d"),
|
||
DateCreated = new DateTimeOffset(new DateTime(2023, 5, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 0, 0, 0, 0)),
|
||
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
|
||
{
|
||
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
|
||
{
|
||
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 = "Первый"
|
||
},
|
||
new
|
||
{
|
||
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 = "Второй"
|
||
},
|
||
new
|
||
{
|
||
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 = "Третий"
|
||
},
|
||
new
|
||
{
|
||
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 = "Четвертый"
|
||
},
|
||
new
|
||
{
|
||
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 = "Последний"
|
||
},
|
||
new
|
||
{
|
||
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 = "Январь"
|
||
},
|
||
new
|
||
{
|
||
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 = "Февраль"
|
||
},
|
||
new
|
||
{
|
||
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 = "Март"
|
||
},
|
||
new
|
||
{
|
||
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 = "Апрель"
|
||
},
|
||
new
|
||
{
|
||
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 = "Май"
|
||
},
|
||
new
|
||
{
|
||
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 = "Июнь"
|
||
},
|
||
new
|
||
{
|
||
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 = "Июль"
|
||
},
|
||
new
|
||
{
|
||
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 = "Август"
|
||
},
|
||
new
|
||
{
|
||
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 = "Сентябрь"
|
||
},
|
||
new
|
||
{
|
||
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 = "Октябрь"
|
||
},
|
||
new
|
||
{
|
||
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 = "Ноябрь"
|
||
},
|
||
new
|
||
{
|
||
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 = "Декабрь"
|
||
},
|
||
new
|
||
{
|
||
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 = "Января"
|
||
},
|
||
new
|
||
{
|
||
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 = "Февраля"
|
||
},
|
||
new
|
||
{
|
||
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 = "Марта"
|
||
},
|
||
new
|
||
{
|
||
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 = "Апреля"
|
||
},
|
||
new
|
||
{
|
||
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 = "Мая"
|
||
},
|
||
new
|
||
{
|
||
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 = "Июня"
|
||
},
|
||
new
|
||
{
|
||
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 = "Июля"
|
||
},
|
||
new
|
||
{
|
||
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 = "Августа"
|
||
},
|
||
new
|
||
{
|
||
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 = "Сентября"
|
||
},
|
||
new
|
||
{
|
||
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 = "Октября"
|
||
},
|
||
new
|
||
{
|
||
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 = "Ноября"
|
||
},
|
||
new
|
||
{
|
||
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 = "Декабря"
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Schedule.EsppSchValue", b =>
|
||
{
|
||
b.Property<Guid>("JobGroupId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<Guid>("TypeValueId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<Guid>("TypeConfigId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.HasKey("JobGroupId", "TypeValueId", "TypeConfigId");
|
||
|
||
b.HasIndex("TypeConfigId");
|
||
|
||
b.HasIndex("TypeValueId");
|
||
|
||
b.ToTable("EsppSchValues", "schedule");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Schedule.ScheduleExcludeType", b =>
|
||
{
|
||
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 = "Выполнить везде, КРОМЕ указанного календаря"
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Schedule.ScheduleExcludeTypeCalendar", b =>
|
||
{
|
||
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"
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Schedule.ScheduleResponseAreaTimeOffset", b =>
|
||
{
|
||
b.Property<string>("ResponseArea")
|
||
.HasColumnType("text");
|
||
|
||
b.Property<string>("EsppValue")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.Property<TimeSpan>("UtcTimeOffset")
|
||
.HasColumnType("interval");
|
||
|
||
b.HasKey("ResponseArea");
|
||
|
||
b.ToTable("ResponseAreaTimeOffsets", "schedule", t =>
|
||
{
|
||
t.HasComment("Расписание в ЕСПП. Смещение часового пояса относительно МСК для зоны ответственности рабочей группы");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Setting", b =>
|
||
{
|
||
b.Property<string>("Name")
|
||
.HasColumnType("text");
|
||
|
||
b.Property<string>("Description")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.Property<string>("Value")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.HasKey("Name");
|
||
|
||
b.ToTable("Settings");
|
||
|
||
b.HasData(
|
||
new
|
||
{
|
||
Name = "Initiator",
|
||
Description = "Инициатор регламентной работы, указывается при создании шаблона в ЕСПП.",
|
||
Value = "АКСЕНОВ АЛЕКСАНДР ЕВГЕНЬЕВИЧ (AKSENOVAE@GVC.OAO.RZD)"
|
||
},
|
||
new
|
||
{
|
||
Name = "ClosingCode",
|
||
Description = "Код закрытия регламентной работы, указывается при создании шаблона в ЕСПП.",
|
||
Value = "выполнен"
|
||
},
|
||
new
|
||
{
|
||
Name = "Category",
|
||
Description = "Категория создаваемого объекта в ЕСПП",
|
||
Value = "регламентная работа"
|
||
},
|
||
new
|
||
{
|
||
Name = "TemplatePrefixName",
|
||
Description = "Префикс имени шаблона в ЕСПП",
|
||
Value = "%PREFIX%-ЭИТИ-ПТК-ПАРР"
|
||
},
|
||
new
|
||
{
|
||
Name = "RobotAttemptsNumber",
|
||
Description = "Количество попыток выполнения задания роботом",
|
||
Value = "3"
|
||
},
|
||
new
|
||
{
|
||
Name = "RobotWaitTime",
|
||
Description = "Время ожидания выполнения роботом задания",
|
||
Value = "00:10:00"
|
||
},
|
||
new
|
||
{
|
||
Name = "EsppScheduleTimezone",
|
||
Description = "Расписание регламентной работы - В каком часовом поясе",
|
||
Value = "MSK"
|
||
},
|
||
new
|
||
{
|
||
Name = "ScheduleRepeatRange",
|
||
Description = "Расписание регламентной работы - Диапазн повторов",
|
||
Value = "Отсутствует дата завершения"
|
||
},
|
||
new
|
||
{
|
||
Name = "OrderSearchDeltaDate",
|
||
Description = "Промежуток времени для поиска нарядов в ЕСПП",
|
||
Value = "01:30:00"
|
||
},
|
||
new
|
||
{
|
||
Name = "EsppRobotAccountTimeZoneHour",
|
||
Description = "Таймзона УЗ роботов в ЕСПП, в часах (может быть положительная и отрицательная)",
|
||
Value = "3"
|
||
},
|
||
new
|
||
{
|
||
Name = "WeekendCacheTtl",
|
||
Description = "Время хранения в кэше данных о выходных и рабочих днях",
|
||
Value = "01:00:00"
|
||
},
|
||
new
|
||
{
|
||
Name = "TemplateNameConstantParts",
|
||
Description = "Список неизменных частей имени шаблона",
|
||
Value = "[{\"Name\":\"П-1\",\"Value\":\"ЭИТИ-ПАРР\"}]"
|
||
},
|
||
new
|
||
{
|
||
Name = "EsppUnitTag",
|
||
Description = "Префикс тега в поле ЭК \"Дополнительная информация\"",
|
||
Value = "ПАРР_"
|
||
},
|
||
new
|
||
{
|
||
Name = "JobIdForUnusedTemplates",
|
||
Description = "Job в который перемещаем ниспользованные шаблоны",
|
||
Value = "8f85a91c-a223-4686-bb69-1f0ee73624f2"
|
||
},
|
||
new
|
||
{
|
||
Name = "DefaultResponseAreaToTimeOffset",
|
||
Description = "Зона ответственности для получения тайм зоны по умолчанию для расписаний",
|
||
Value = "17-МСК"
|
||
},
|
||
new
|
||
{
|
||
Name = "MinRelationshipsThresholdPct",
|
||
Description = "Минимально допустимый процент связей для продолжения синхронизации. Защищает от удаления данных, если передающая система АИХ ИТ передала аномально малый объем связей. 0 — Защита ОТКЛЮЧЕНА, 100 — Строгий режим.",
|
||
Value = "97"
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Subprocess", 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.Property<Guid>("ProcessId")
|
||
.HasColumnType("uuid");
|
||
|
||
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");
|
||
|
||
b.Property<int?>("ProgressPercent")
|
||
.HasColumnType("integer")
|
||
.HasComment("Процент выполнения задачи");
|
||
|
||
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");
|
||
|
||
b.HasKey("Code");
|
||
|
||
b.ToTable("Types", "task", t =>
|
||
{
|
||
t.HasComment("Таблица типов заданий");
|
||
});
|
||
|
||
b.HasData(
|
||
new
|
||
{
|
||
Code = 0,
|
||
Description = "Формирование данных для отчетности - Загруженность",
|
||
IsSingleton = true,
|
||
MaxExecutionTimeMinutes = 90,
|
||
MaxRetries = 2,
|
||
Name = "Workload",
|
||
RetentionDays = 90
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Template", 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?>("Index")
|
||
.HasColumnType("integer");
|
||
|
||
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<Guid>("JobId")
|
||
.HasColumnType("uuid");
|
||
|
||
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<string>("ScheduleEsppId")
|
||
.HasColumnType("text");
|
||
|
||
b.Property<int>("StatusTypeId")
|
||
.HasColumnType("integer");
|
||
|
||
b.Property<Guid>("UnitId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("JobId");
|
||
|
||
b.HasIndex("StatusTypeId");
|
||
|
||
b.HasIndex("UnitId");
|
||
|
||
b.HasIndex("Name", "Index")
|
||
.IsUnique();
|
||
|
||
b.ToTable("Templates");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.TemplateEntities.TemplateRenamePending", b =>
|
||
{
|
||
b.Property<Guid>("TemplateId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<DateTimeOffset>("DateCreated")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.Property<string>("OldName")
|
||
.IsRequired()
|
||
.HasColumnType("text")
|
||
.HasComment("Старое имя шаблона");
|
||
|
||
b.HasKey("TemplateId");
|
||
|
||
b.HasIndex("OldName")
|
||
.IsUnique();
|
||
|
||
b.ToTable("TemplateRenamePendings", "template", t =>
|
||
{
|
||
t.HasComment("Шаблоны находящиеся в процессе переименования");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.TemplateHistory", b =>
|
||
{
|
||
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");
|
||
|
||
b.Property<string>("ScheduleEsppId")
|
||
.HasColumnType("text");
|
||
|
||
b.Property<int>("StatusTypeId")
|
||
.HasColumnType("integer");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("ParentId");
|
||
|
||
b.ToTable("TemplateHistories");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.TemplateStatusType", 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.ToTable("TemplateStatusTypes", t =>
|
||
{
|
||
t.HasComment("Таблица описания критериев выборки аттрибутов ЭК");
|
||
});
|
||
|
||
b.HasData(
|
||
new
|
||
{
|
||
Id = 0,
|
||
Description = "В работе",
|
||
Name = "Used"
|
||
},
|
||
new
|
||
{
|
||
Id = 1,
|
||
Description = "Не используется",
|
||
Name = "Unused"
|
||
},
|
||
new
|
||
{
|
||
Id = 2,
|
||
Description = "Обновляется",
|
||
Name = "Updating"
|
||
},
|
||
new
|
||
{
|
||
Id = 3,
|
||
Description = "Ошибка",
|
||
Name = "Error"
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Tnk", 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.Property<string>("ShortName")
|
||
.HasColumnType("text");
|
||
|
||
b.Property<Guid>("SubprocessId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("SubprocessId");
|
||
|
||
b.ToTable("Tnks");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.Unit", b =>
|
||
{
|
||
b.Property<Guid>("Id")
|
||
.ValueGeneratedOnAdd()
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<DateTimeOffset>("DateCreated")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.Property<DateTimeOffset?>("LastLogon")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.Property<string>("Name")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("Name")
|
||
.IsUnique();
|
||
|
||
b.ToTable("Units", "unit", t =>
|
||
{
|
||
t.HasComment("Таблица с ЭК");
|
||
|
||
t.HasCheckConstraint("CK_Units_Name_Upper", "\"Name\" = UPPER(\"Name\") AND \"Name\" IS NOT NULL AND LENGTH(\"Name\")>0");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitField", b =>
|
||
{
|
||
b.Property<Guid>("Id")
|
||
.ValueGeneratedOnAdd()
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<string>("AihitName")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.Property<string>("Code")
|
||
.HasColumnType("text");
|
||
|
||
b.Property<DateTimeOffset>("DateCreated")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.Property<string>("DisplayName")
|
||
.HasColumnType("text");
|
||
|
||
b.Property<string>("EsppName")
|
||
.HasColumnType("text");
|
||
|
||
b.Property<bool?>("IsMultipleValue")
|
||
.HasColumnType("boolean");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("AihitName");
|
||
|
||
b.HasIndex("EsppName");
|
||
|
||
b.ToTable("Fields", "unit", t =>
|
||
{
|
||
t.HasComment("Справочник полей ЭК");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitFieldInUnitFieldValue", b =>
|
||
{
|
||
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("Значения полей ЭК");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitFieldValue", b =>
|
||
{
|
||
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");
|
||
|
||
b.HasIndex("Value")
|
||
.IsUnique();
|
||
|
||
b.ToTable("FieldValues", "unit", t =>
|
||
{
|
||
t.HasComment("Значения полей ЭК");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitInUnit", b =>
|
||
{
|
||
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("Таблица связей иерархии между ЭК");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitInValue", b =>
|
||
{
|
||
b.Property<Guid>("UnitId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<Guid>("FieldId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<Guid>("ValueId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<DateTimeOffset>("DateCreated")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.Property<DateTimeOffset?>("DateModified")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.HasKey("UnitId", "FieldId", "ValueId");
|
||
|
||
b.HasIndex("ValueId");
|
||
|
||
b.HasIndex("FieldId", "UnitId");
|
||
|
||
b.HasIndex("FieldId", "ValueId");
|
||
|
||
b.HasIndex("UnitId", "FieldId");
|
||
|
||
b.ToTable("UnitInValues", "unit", t =>
|
||
{
|
||
t.HasComment("Таблица связи ЭК с полями и со значениями");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitKiiUnit", b =>
|
||
{
|
||
b.Property<Guid>("UnitId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.HasKey("UnitId");
|
||
|
||
b.ToTable("KiiUnits", "unit", t =>
|
||
{
|
||
t.HasComment("Таблица - Список ЭК КИИ, которые учавствуют в групповых работах. Создавалась как временная");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitRegionalEkPtkGroup", b =>
|
||
{
|
||
b.Property<Guid>("FieldValueId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.HasKey("FieldValueId");
|
||
|
||
b.ToTable("RegionalEkPtkGroups", "unit", t =>
|
||
{
|
||
t.HasComment("Таблица - региональные группы ПТК");
|
||
});
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.User", b =>
|
||
{
|
||
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");
|
||
|
||
b.Property<DateTimeOffset?>("LastLogon")
|
||
.HasColumnType("timestamp with time zone");
|
||
|
||
b.Property<string>("Name")
|
||
.IsRequired()
|
||
.HasColumnType("text");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("Ip")
|
||
.IsUnique();
|
||
|
||
b.ToTable("Users");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.UsersInRole", b =>
|
||
{
|
||
b.Property<Guid>("RoleId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<Guid>("UserId")
|
||
.HasColumnType("uuid");
|
||
|
||
b.HasKey("RoleId", "UserId");
|
||
|
||
b.HasIndex("UserId");
|
||
|
||
b.ToTable("UsersInRoles");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.WeekendDay", b =>
|
||
{
|
||
b.Property<Guid>("Id")
|
||
.ValueGeneratedOnAdd()
|
||
.HasColumnType("uuid");
|
||
|
||
b.Property<DateOnly>("Date")
|
||
.HasColumnType("date");
|
||
|
||
b.HasKey("Id");
|
||
|
||
b.HasIndex("Date")
|
||
.IsUnique();
|
||
|
||
b.ToTable("WeekendDays", "schedule");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.AgentHistory", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.AgentHistoryLevel", "AgentHistoryLevel")
|
||
.WithMany("AgentHistories")
|
||
.HasForeignKey("HistoryLevelId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.Order", "Order")
|
||
.WithMany("AgentHistories")
|
||
.HasForeignKey("OrderId");
|
||
|
||
b.HasOne("PARR.Domain.Entities.Template", "Template")
|
||
.WithMany("AgentHistories")
|
||
.HasForeignKey("TemplateId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("AgentHistoryLevel");
|
||
|
||
b.Navigation("Order");
|
||
|
||
b.Navigation("Template");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.DistributionPeriod", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.DistributionPeriodType", "DistributionPeriodType")
|
||
.WithMany("Periods")
|
||
.HasForeignKey("Type")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("DistributionPeriodType");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.Job", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.JobGroupEntities.JobGroup", "Group")
|
||
.WithMany("Jobs")
|
||
.HasForeignKey("GroupId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.Tnk", "Tnk")
|
||
.WithMany("Jobs")
|
||
.HasForeignKey("TnkId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Group");
|
||
|
||
b.Navigation("Tnk");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.JobAutoControl", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.JobEntities.Job", "Job")
|
||
.WithOne("AutoControl")
|
||
.HasForeignKey("PARR.Domain.Entities.JobEntities.JobAutoControl", "JobId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Job");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.JobFieldFilter", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Unit.UnitField", "UnitField")
|
||
.WithMany("JobFieldFilters")
|
||
.HasForeignKey("FieldId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.JobEntities.JobUnitFilter", "UnitFilter")
|
||
.WithMany("FieldFilters")
|
||
.HasForeignKey("UnitFilterId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("UnitField");
|
||
|
||
b.Navigation("UnitFilter");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.JobRelationshipFilter", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Unit.UnitField", "UnitField")
|
||
.WithMany("RelationshipFilters")
|
||
.HasForeignKey("FieldId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.JobEntities.JobUnitFilter", "UnitFilter")
|
||
.WithMany("RelationshipFilters")
|
||
.HasForeignKey("UnitFilterId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("UnitField");
|
||
|
||
b.Navigation("UnitFilter");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.JobUnitFilter", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.JobEntities.Job", "Job")
|
||
.WithMany("UnitFilters")
|
||
.HasForeignKey("JobId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Job");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.UnitsInTemplate", b =>
|
||
{
|
||
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")
|
||
.WithMany("JobGroups")
|
||
.HasForeignKey("GroupTypeId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.Unit.UnitField", "GroupingUnitField")
|
||
.WithMany("JobGroupWithGrouping")
|
||
.HasForeignKey("GroupingUnitFieldId")
|
||
.OnDelete(DeleteBehavior.Restrict);
|
||
|
||
b.HasOne("PARR.Domain.Entities.Schedule.ScheduleExcludeTypeCalendar", "ScheduleExcludeTypeCalendar")
|
||
.WithMany("JobGroups")
|
||
.HasForeignKey("ScheduleExcludeTypeCalendarId");
|
||
|
||
b.HasOne("PARR.Domain.Entities.Schedule.ScheduleExcludeType", "ScheduleExcludeType")
|
||
.WithMany("JobGroups")
|
||
.HasForeignKey("ScheduleExcludeTypeId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("GroupType");
|
||
|
||
b.Navigation("GroupingUnitField");
|
||
|
||
b.Navigation("ScheduleExcludeType");
|
||
|
||
b.Navigation("ScheduleExcludeTypeCalendar");
|
||
});
|
||
|
||
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 =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.DistributionPeriod", "DistributionPeriod")
|
||
.WithMany("GroupDistributionConfig")
|
||
.HasForeignKey("DistributionPeriodId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.JobGroupEntities.JobGroup", "Group")
|
||
.WithOne("DistributionConfig")
|
||
.HasForeignKey("PARR.Domain.Entities.JobGroupEntities.JobGroupDistributionConfig", "GroupId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("DistributionPeriod");
|
||
|
||
b.Navigation("Group");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobGroupEntities.JobGroupFieldFilter", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Unit.UnitField", "UnitField")
|
||
.WithMany("JobGroupFieldFilters")
|
||
.HasForeignKey("FieldId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.JobGroupEntities.JobGroupUnitFilter", "UnitFilter")
|
||
.WithMany("FieldFilters")
|
||
.HasForeignKey("UnitFilterId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("UnitField");
|
||
|
||
b.Navigation("UnitFilter");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobGroupEntities.JobGroupRelationshipFilter", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Unit.UnitField", "UnitField")
|
||
.WithMany("JobGroupRelationshipFilters")
|
||
.HasForeignKey("FieldId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.JobGroupEntities.JobGroupUnitFilter", "UnitFilter")
|
||
.WithMany("RelationshipFilters")
|
||
.HasForeignKey("UnitFilterId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("UnitField");
|
||
|
||
b.Navigation("UnitFilter");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobGroupEntities.JobGroupUnitFilter", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.JobGroupEntities.JobGroup", "JobGroup")
|
||
.WithMany()
|
||
.HasForeignKey("JobGroupId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("JobGroup");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Order", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.OrderStatus", "NextStatus")
|
||
.WithMany("OrdersNext")
|
||
.HasForeignKey("NextStatusCode");
|
||
|
||
b.HasOne("PARR.Domain.Entities.OrderStatus", "OrderStatus")
|
||
.WithMany("Orders")
|
||
.HasForeignKey("StatusCode")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.Template", "Template")
|
||
.WithMany("Orders")
|
||
.HasForeignKey("TemplateId");
|
||
|
||
b.Navigation("NextStatus");
|
||
|
||
b.Navigation("OrderStatus");
|
||
|
||
b.Navigation("Template");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.RobotConfiguration", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.RobotEntities.Robot", "Robot")
|
||
.WithMany("RobotConfigurations")
|
||
.HasForeignKey("RobotCode")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.RobotEntities.RobotStatus", "RobotStatus")
|
||
.WithMany("RobotConfigurations")
|
||
.HasForeignKey("RobotStatusCode")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.RobotEntities.TaskStatus", "TaskStatus")
|
||
.WithMany("RobotConfigurations")
|
||
.HasForeignKey("TaskStatusCode")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.Template", "Template")
|
||
.WithMany("RobotConfigurations")
|
||
.HasForeignKey("TemplateId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Robot");
|
||
|
||
b.Navigation("RobotStatus");
|
||
|
||
b.Navigation("TaskStatus");
|
||
|
||
b.Navigation("Template");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.RobotEntities.RobotConfigurationSnapshot", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.RobotEntities.Robot", "Robot")
|
||
.WithMany("ConfigurationSnapshots")
|
||
.HasForeignKey("RobotCode")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.RobotEntities.RobotStatus", "RobotStatus")
|
||
.WithMany("ConfigurationSnapshots")
|
||
.HasForeignKey("RobotStatusCode")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.RobotEntities.TaskStatus", "TaskStatus")
|
||
.WithMany("ConfigurationSnapshots")
|
||
.HasForeignKey("TaskStatusCode")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Robot");
|
||
|
||
b.Navigation("RobotStatus");
|
||
|
||
b.Navigation("TaskStatus");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.RobotEntities.RobotHistory", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.RobotEntities.RobotHistoryLevel", "RobotHistoryLevel")
|
||
.WithMany("RobotHistories")
|
||
.HasForeignKey("HistoryLevel")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.RobotConfiguration", "RobotConfiguration")
|
||
.WithMany("RobotHistories")
|
||
.HasForeignKey("RobotConfigurationId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.RobotEntities.TaskStatus", "StatusTask")
|
||
.WithMany("RobotHistories")
|
||
.HasForeignKey("TaskStatusCode")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("RobotConfiguration");
|
||
|
||
b.Navigation("RobotHistoryLevel");
|
||
|
||
b.Navigation("StatusTask");
|
||
});
|
||
|
||
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 =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.JobGroupEntities.JobGroup", "JobGroup")
|
||
.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 =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Process", "Process")
|
||
.WithMany("Subprocesses")
|
||
.HasForeignKey("ProcessId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Process");
|
||
});
|
||
|
||
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 =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.JobEntities.Job", "Job")
|
||
.WithMany("Templates")
|
||
.HasForeignKey("JobId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.TemplateStatusType", "StatusType")
|
||
.WithMany("Templates")
|
||
.HasForeignKey("StatusTypeId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.Unit.Unit", "Unit")
|
||
.WithMany("Templates")
|
||
.HasForeignKey("UnitId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Job");
|
||
|
||
b.Navigation("StatusType");
|
||
|
||
b.Navigation("Unit");
|
||
});
|
||
|
||
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");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.TemplateHistory", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Template", "Template")
|
||
.WithMany("TemplateHistories")
|
||
.HasForeignKey("ParentId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Template");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Tnk", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Subprocess", "Subprocess")
|
||
.WithMany("Tnks")
|
||
.HasForeignKey("SubprocessId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Subprocess");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitFieldInUnitFieldValue", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Unit.UnitField", "Field")
|
||
.WithMany("UnitFieldValues")
|
||
.HasForeignKey("FieldId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.Unit.UnitFieldValue", "FieldValue")
|
||
.WithMany("FieldValues")
|
||
.HasForeignKey("FieldValueId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Field");
|
||
|
||
b.Navigation("FieldValue");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitInUnit", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Unit.Unit", "ChildUnit")
|
||
.WithMany("ParentUnits")
|
||
.HasForeignKey("ChildUnitId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.Unit.Unit", "ParentUnit")
|
||
.WithMany("ChildUnits")
|
||
.HasForeignKey("ParentUnitId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("ChildUnit");
|
||
|
||
b.Navigation("ParentUnit");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitInValue", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Unit.UnitField", "Field")
|
||
.WithMany("UnitInValues")
|
||
.HasForeignKey("FieldId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.Unit.Unit", "Unit")
|
||
.WithMany("UnitValues")
|
||
.HasForeignKey("UnitId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.Unit.UnitFieldValue", "Value")
|
||
.WithMany("UnitInValues")
|
||
.HasForeignKey("ValueId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Field");
|
||
|
||
b.Navigation("Unit");
|
||
|
||
b.Navigation("Value");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitKiiUnit", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Unit.Unit", "Unit")
|
||
.WithOne("UnitKii")
|
||
.HasForeignKey("PARR.Domain.Entities.Unit.UnitKiiUnit", "UnitId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Unit");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitRegionalEkPtkGroup", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Unit.UnitFieldValue", "FieldValue")
|
||
.WithOne("RegionalEkPtkGroup")
|
||
.HasForeignKey("PARR.Domain.Entities.Unit.UnitRegionalEkPtkGroup", "FieldValueId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("FieldValue");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.UsersInRole", b =>
|
||
{
|
||
b.HasOne("PARR.Domain.Entities.Role", "Role")
|
||
.WithMany("Users")
|
||
.HasForeignKey("RoleId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.HasOne("PARR.Domain.Entities.User", "User")
|
||
.WithMany("Roles")
|
||
.HasForeignKey("UserId")
|
||
.OnDelete(DeleteBehavior.Cascade)
|
||
.IsRequired();
|
||
|
||
b.Navigation("Role");
|
||
|
||
b.Navigation("User");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.AgentHistoryLevel", b =>
|
||
{
|
||
b.Navigation("AgentHistories");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.DistributionPeriod", b =>
|
||
{
|
||
b.Navigation("GroupDistributionConfig");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.DistributionPeriodType", b =>
|
||
{
|
||
b.Navigation("Periods");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.Job", b =>
|
||
{
|
||
b.Navigation("AutoControl");
|
||
|
||
b.Navigation("Templates");
|
||
|
||
b.Navigation("UnitFilters");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobEntities.JobUnitFilter", b =>
|
||
{
|
||
b.Navigation("FieldFilters");
|
||
|
||
b.Navigation("RelationshipFilters");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobGroupEntities.JobGroup", b =>
|
||
{
|
||
b.Navigation("AutoControl");
|
||
|
||
b.Navigation("DistributionConfig");
|
||
|
||
b.Navigation("EsppSchValues");
|
||
|
||
b.Navigation("Jobs");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobGroupEntities.JobGroupType", b =>
|
||
{
|
||
b.Navigation("JobGroups");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.JobGroupEntities.JobGroupUnitFilter", b =>
|
||
{
|
||
b.Navigation("FieldFilters");
|
||
|
||
b.Navigation("RelationshipFilters");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Order", b =>
|
||
{
|
||
b.Navigation("AgentHistories");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.OrderStatus", b =>
|
||
{
|
||
b.Navigation("Orders");
|
||
|
||
b.Navigation("OrdersNext");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Process", b =>
|
||
{
|
||
b.Navigation("Subprocesses");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.RobotConfiguration", b =>
|
||
{
|
||
b.Navigation("RobotHistories");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.RobotEntities.Robot", b =>
|
||
{
|
||
b.Navigation("ConfigurationSnapshots");
|
||
|
||
b.Navigation("RobotConfigurations");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.RobotEntities.RobotHistoryLevel", b =>
|
||
{
|
||
b.Navigation("RobotHistories");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.RobotEntities.RobotStatus", b =>
|
||
{
|
||
b.Navigation("ConfigurationSnapshots");
|
||
|
||
b.Navigation("RobotConfigurations");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.RobotEntities.TaskStatus", b =>
|
||
{
|
||
b.Navigation("ConfigurationSnapshots");
|
||
|
||
b.Navigation("RobotConfigurations");
|
||
|
||
b.Navigation("RobotHistories");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Role", b =>
|
||
{
|
||
b.Navigation("Users");
|
||
});
|
||
|
||
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 =>
|
||
{
|
||
b.Navigation("JobGroups");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Schedule.ScheduleExcludeTypeCalendar", b =>
|
||
{
|
||
b.Navigation("JobGroups");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Subprocess", b =>
|
||
{
|
||
b.Navigation("Tnks");
|
||
});
|
||
|
||
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 =>
|
||
{
|
||
b.Navigation("AgentHistories");
|
||
|
||
b.Navigation("Orders");
|
||
|
||
b.Navigation("RobotConfigurations");
|
||
|
||
b.Navigation("TemplateHistories");
|
||
|
||
b.Navigation("TemplateRenamePending");
|
||
|
||
b.Navigation("UnitsInTemplate");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.TemplateStatusType", b =>
|
||
{
|
||
b.Navigation("Templates");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Tnk", b =>
|
||
{
|
||
b.Navigation("Jobs");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.Unit", b =>
|
||
{
|
||
b.Navigation("ChildUnits");
|
||
|
||
b.Navigation("ParentUnits");
|
||
|
||
b.Navigation("Templates");
|
||
|
||
b.Navigation("TemplatesInUnit");
|
||
|
||
b.Navigation("UnitKii");
|
||
|
||
b.Navigation("UnitValues");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitField", b =>
|
||
{
|
||
b.Navigation("JobFieldFilters");
|
||
|
||
b.Navigation("JobGroupFieldFilters");
|
||
|
||
b.Navigation("JobGroupRelationshipFilters");
|
||
|
||
b.Navigation("JobGroupWithGrouping");
|
||
|
||
b.Navigation("RelationshipFilters");
|
||
|
||
b.Navigation("UnitFieldValues");
|
||
|
||
b.Navigation("UnitInValues");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.Unit.UnitFieldValue", b =>
|
||
{
|
||
b.Navigation("FieldValues");
|
||
|
||
b.Navigation("RegionalEkPtkGroup");
|
||
|
||
b.Navigation("UnitInValues");
|
||
|
||
b.Navigation("UnitsInTemplates");
|
||
});
|
||
|
||
modelBuilder.Entity("PARR.Domain.Entities.User", b =>
|
||
{
|
||
b.Navigation("Roles");
|
||
});
|
||
#pragma warning restore 612, 618
|
||
}
|
||
}
|
||
}
|