< Summary - Heimdall API

Information
Class: ArturRios.Heimdall.Data.Migrations.AddDataProtectionKeys
Assembly: ArturRios.Heimdall.Data
File(s): File 1: /home/ci/agent/workspace/heimdall-api-docs_main/app/src/Infrastructure/ArturRios.Heimdall.Data/Migrations/20260814212047_AddDataProtectionKeys.cs
File 2: /home/ci/agent/workspace/heimdall-api-docs_main/app/src/Infrastructure/ArturRios.Heimdall.Data/Migrations/20260814212047_AddDataProtectionKeys.Designer.cs
Line coverage
100%
Covered lines: 957
Uncovered lines: 0
Coverable lines: 957
Total lines: 1031
Line coverage: 100%
Branch coverage
N/A
Covered branches: 0
Total branches: 0
Branch coverage: N/A
Method coverage
100%
Covered methods: 3
Fully covered methods: 3
Total methods: 3
Method coverage: 100%
Full method coverage: 100%

Metrics

MethodBranch coverage Crap Score Cyclomatic complexity Line coverage
File 1: Up(...)100%11100%
File 1: Down(...)100%11100%
File 2: BuildTargetModel(...)100%11100%

File(s)

/home/ci/agent/workspace/heimdall-api-docs_main/app/src/Infrastructure/ArturRios.Heimdall.Data/Migrations/20260814212047_AddDataProtectionKeys.cs

#LineLine coverage
 1using Microsoft.EntityFrameworkCore.Migrations;
 2using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
 3
 4#nullable disable
 5
 6namespace ArturRios.Heimdall.Data.Migrations
 7{
 8    /// <inheritdoc />
 9    public partial class AddDataProtectionKeys : Migration
 10    {
 11        /// <inheritdoc />
 12        protected override void Up(MigrationBuilder migrationBuilder)
 13        {
 1914            migrationBuilder.CreateTable(
 1915                name: "data_protection_keys",
 1916                schema: "heimdall",
 1917                columns: table => new
 1918                {
 1919                    id = table.Column<int>(type: "integer", nullable: false)
 1920                        .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultCol
 1921                    friendly_name = table.Column<string>(type: "text", nullable: true),
 1922                    xml = table.Column<string>(type: "text", nullable: true)
 1923                },
 1924                constraints: table =>
 1925                {
 1926                    table.PrimaryKey("pk_data_protection_keys", x => x.id);
 3827                });
 1928        }
 29
 30        /// <inheritdoc />
 31        protected override void Down(MigrationBuilder migrationBuilder)
 32        {
 133            migrationBuilder.DropTable(
 134                name: "data_protection_keys",
 135                schema: "heimdall");
 136        }
 37    }
 38}

/home/ci/agent/workspace/heimdall-api-docs_main/app/src/Infrastructure/ArturRios.Heimdall.Data/Migrations/20260814212047_AddDataProtectionKeys.Designer.cs

#LineLine coverage
 1// <auto-generated />
 2using System;
 3using ArturRios.Heimdall.Data.Configuration;
 4using Microsoft.EntityFrameworkCore;
 5using Microsoft.EntityFrameworkCore.Infrastructure;
 6using Microsoft.EntityFrameworkCore.Migrations;
 7using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
 8using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
 9
 10#nullable disable
 11
 12namespace ArturRios.Heimdall.Data.Migrations
 13{
 14    [DbContext(typeof(AppDbContext))]
 15    [Migration("20260814212047_AddDataProtectionKeys")]
 16    partial class AddDataProtectionKeys
 17    {
 18        /// <inheritdoc />
 19        protected override void BuildTargetModel(ModelBuilder modelBuilder)
 20        {
 21#pragma warning disable 612, 618
 1022            modelBuilder
 1023                .HasDefaultSchema("heimdall")
 1024                .HasAnnotation("ProductVersion", "10.0.11")
 1025                .HasAnnotation("Relational:MaxIdentifierLength", 63);
 26
 1027            NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
 28
 1029            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Application", b =>
 1030                {
 1031                    b.Property<long>("Id")
 1032                        .ValueGeneratedOnAdd()
 1033                        .HasColumnType("bigint")
 1034                        .HasColumnName("id")
 1035                        .HasColumnOrder(1);
 1036
 1037                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
 1038
 1039                    b.Property<DateTime>("CreatedAt")
 1040                        .ValueGeneratedOnAdd()
 1041                        .HasColumnType("timestamp with time zone")
 1042                        .HasColumnName("created_at")
 1043                        .HasDefaultValueSql("now()");
 1044
 1045                    b.Property<bool>("IsDeleted")
 1046                        .ValueGeneratedOnAdd()
 1047                        .HasColumnType("boolean")
 1048                        .HasDefaultValue(false)
 1049                        .HasColumnName("is_deleted");
 1050
 1051                    b.Property<string>("Name")
 1052                        .IsRequired()
 1053                        .HasMaxLength(200)
 1054                        .HasColumnType("character varying(200)")
 1055                        .HasColumnName("name");
 1056
 1057                    b.Property<long>("OwnerId")
 1058                        .HasColumnType("bigint")
 1059                        .HasColumnName("owner_id");
 1060
 1061                    b.Property<Guid>("PublicId")
 1062                        .HasColumnType("uuid")
 1063                        .HasColumnName("public_id");
 1064
 1065                    b.Property<long>("ScopeId")
 1066                        .HasColumnType("bigint")
 1067                        .HasColumnName("scope_id");
 1068
 1069                    b.Property<DateTime>("UpdatedAt")
 1070                        .ValueGeneratedOnAdd()
 1071                        .HasColumnType("timestamp with time zone")
 1072                        .HasColumnName("updated_at")
 1073                        .HasDefaultValueSql("now()");
 1074
 1075                    b.HasKey("Id")
 1076                        .HasName("pk_application");
 1077
 1078                    b.HasIndex("OwnerId")
 1079                        .HasDatabaseName("ix_application_owner_id");
 1080
 1081                    b.HasIndex("PublicId")
 1082                        .IsUnique()
 1083                        .HasDatabaseName("ix_application_public_id");
 1084
 1085                    b.HasIndex("ScopeId")
 1086                        .HasDatabaseName("ix_application_scope_id");
 1087
 1088                    b.ToTable("application", "heimdall");
 2089                });
 90
 1091            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.AuditLog", b =>
 1092                {
 1093                    b.Property<long>("Id")
 1094                        .ValueGeneratedOnAdd()
 1095                        .HasColumnType("bigint")
 1096                        .HasColumnName("id")
 1097                        .HasColumnOrder(1);
 1098
 1099                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
 10100
 10101                    b.Property<string>("Action")
 10102                        .IsRequired()
 10103                        .HasMaxLength(200)
 10104                        .HasColumnType("character varying(200)")
 10105                        .HasColumnName("action");
 10106
 10107                    b.Property<Guid?>("ActorPersonId")
 10108                        .HasColumnType("uuid")
 10109                        .HasColumnName("actor_person_id");
 10110
 10111                    b.Property<int?>("ActorRole")
 10112                        .HasColumnType("integer")
 10113                        .HasColumnName("actor_role");
 10114
 10115                    b.Property<DateTime>("CreatedAt")
 10116                        .ValueGeneratedOnAdd()
 10117                        .HasColumnType("timestamp with time zone")
 10118                        .HasColumnName("created_at")
 10119                        .HasDefaultValueSql("now()");
 10120
 10121                    b.Property<Guid>("PublicId")
 10122                        .HasColumnType("uuid")
 10123                        .HasColumnName("public_id");
 10124
 10125                    b.Property<Guid?>("TargetId")
 10126                        .HasColumnType("uuid")
 10127                        .HasColumnName("target_id");
 10128
 10129                    b.HasKey("Id")
 10130                        .HasName("pk_audit_log");
 10131
 10132                    b.HasIndex("ActorPersonId")
 10133                        .HasDatabaseName("ix_audit_log_actor_person_id");
 10134
 10135                    b.HasIndex("CreatedAt")
 10136                        .HasDatabaseName("ix_audit_log_created_at");
 10137
 10138                    b.HasIndex("PublicId")
 10139                        .IsUnique()
 10140                        .HasDatabaseName("ix_audit_log_public_id");
 10141
 10142                    b.ToTable("audit_log", "heimdall");
 20143                });
 144
 10145            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.EmailVerificationToken", b =>
 10146                {
 10147                    b.Property<long>("Id")
 10148                        .ValueGeneratedOnAdd()
 10149                        .HasColumnType("bigint")
 10150                        .HasColumnName("id")
 10151                        .HasColumnOrder(1);
 10152
 10153                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
 10154
 10155                    b.Property<DateTime>("ExpiresAt")
 10156                        .HasColumnType("timestamp with time zone")
 10157                        .HasColumnName("expires_at");
 10158
 10159                    b.Property<long>("PersonId")
 10160                        .HasColumnType("bigint")
 10161                        .HasColumnName("person_id");
 10162
 10163                    b.Property<string>("Token")
 10164                        .IsRequired()
 10165                        .HasMaxLength(256)
 10166                        .HasColumnType("character varying(256)")
 10167                        .HasColumnName("token");
 10168
 10169                    b.Property<bool>("Used")
 10170                        .ValueGeneratedOnAdd()
 10171                        .HasColumnType("boolean")
 10172                        .HasDefaultValue(false)
 10173                        .HasColumnName("used");
 10174
 10175                    b.HasKey("Id")
 10176                        .HasName("pk_email_verification_token");
 10177
 10178                    b.HasIndex("PersonId")
 10179                        .HasDatabaseName("ix_email_verification_token_person_id");
 10180
 10181                    b.HasIndex("Token")
 10182                        .IsUnique()
 10183                        .HasDatabaseName("ix_email_verification_token_token");
 10184
 10185                    b.ToTable("email_verification_token", "heimdall");
 20186                });
 187
 10188            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.GoogleUser", b =>
 10189                {
 10190                    b.Property<long>("Id")
 10191                        .ValueGeneratedOnAdd()
 10192                        .HasColumnType("bigint")
 10193                        .HasColumnName("id")
 10194                        .HasColumnOrder(1);
 10195
 10196                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
 10197
 10198                    b.Property<DateTime>("CreatedAt")
 10199                        .ValueGeneratedOnAdd()
 10200                        .HasColumnType("timestamp with time zone")
 10201                        .HasColumnName("created_at")
 10202                        .HasDefaultValueSql("now()");
 10203
 10204                    b.Property<string>("Email")
 10205                        .IsRequired()
 10206                        .HasMaxLength(256)
 10207                        .HasColumnType("character varying(256)")
 10208                        .HasColumnName("email");
 10209
 10210                    b.Property<bool>("EmailVerified")
 10211                        .ValueGeneratedOnAdd()
 10212                        .HasColumnType("boolean")
 10213                        .HasDefaultValue(false)
 10214                        .HasColumnName("email_verified");
 10215
 10216                    b.Property<string>("GoogleId")
 10217                        .IsRequired()
 10218                        .HasMaxLength(255)
 10219                        .HasColumnType("character varying(255)")
 10220                        .HasColumnName("google_id");
 10221
 10222                    b.Property<bool>("IsDeleted")
 10223                        .ValueGeneratedOnAdd()
 10224                        .HasColumnType("boolean")
 10225                        .HasDefaultValue(false)
 10226                        .HasColumnName("is_deleted");
 10227
 10228                    b.Property<string>("Name")
 10229                        .IsRequired()
 10230                        .HasMaxLength(200)
 10231                        .HasColumnType("character varying(200)")
 10232                        .HasColumnName("name");
 10233
 10234                    b.Property<string>("ProfilePictureUrl")
 10235                        .HasMaxLength(2048)
 10236                        .HasColumnType("character varying(2048)")
 10237                        .HasColumnName("profile_picture_url");
 10238
 10239                    b.Property<Guid>("PublicId")
 10240                        .HasColumnType("uuid")
 10241                        .HasColumnName("public_id");
 10242
 10243                    b.Property<long>("ScopeId")
 10244                        .HasColumnType("bigint")
 10245                        .HasColumnName("scope_id");
 10246
 10247                    b.Property<DateTime>("UpdatedAt")
 10248                        .ValueGeneratedOnAdd()
 10249                        .HasColumnType("timestamp with time zone")
 10250                        .HasColumnName("updated_at")
 10251                        .HasDefaultValueSql("now()");
 10252
 10253                    b.HasKey("Id")
 10254                        .HasName("pk_google_user");
 10255
 10256                    b.HasIndex("PublicId")
 10257                        .IsUnique()
 10258                        .HasDatabaseName("ix_google_user_public_id");
 10259
 10260                    b.HasIndex("ScopeId", "Email")
 10261                        .IsUnique()
 10262                        .HasDatabaseName("ix_google_user_scope_id_email");
 10263
 10264                    b.HasIndex("ScopeId", "GoogleId")
 10265                        .IsUnique()
 10266                        .HasDatabaseName("ix_google_user_scope_id_google_id");
 10267
 10268                    b.ToTable("google_user", "heimdall");
 20269                });
 270
 10271            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.PasswordResetToken", b =>
 10272                {
 10273                    b.Property<long>("Id")
 10274                        .ValueGeneratedOnAdd()
 10275                        .HasColumnType("bigint")
 10276                        .HasColumnName("id")
 10277                        .HasColumnOrder(1);
 10278
 10279                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
 10280
 10281                    b.Property<DateTime>("ExpiresAt")
 10282                        .HasColumnType("timestamp with time zone")
 10283                        .HasColumnName("expires_at");
 10284
 10285                    b.Property<long>("PersonId")
 10286                        .HasColumnType("bigint")
 10287                        .HasColumnName("person_id");
 10288
 10289                    b.Property<string>("Token")
 10290                        .IsRequired()
 10291                        .HasMaxLength(256)
 10292                        .HasColumnType("character varying(256)")
 10293                        .HasColumnName("token");
 10294
 10295                    b.Property<bool>("Used")
 10296                        .ValueGeneratedOnAdd()
 10297                        .HasColumnType("boolean")
 10298                        .HasDefaultValue(false)
 10299                        .HasColumnName("used");
 10300
 10301                    b.HasKey("Id")
 10302                        .HasName("pk_password_reset_token");
 10303
 10304                    b.HasIndex("PersonId")
 10305                        .HasDatabaseName("ix_password_reset_token_person_id");
 10306
 10307                    b.HasIndex("Token")
 10308                        .IsUnique()
 10309                        .HasDatabaseName("ix_password_reset_token_token");
 10310
 10311                    b.ToTable("password_reset_token", "heimdall");
 20312                });
 313
 10314            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Person", b =>
 10315                {
 10316                    b.Property<long>("Id")
 10317                        .ValueGeneratedOnAdd()
 10318                        .HasColumnType("bigint")
 10319                        .HasColumnName("id")
 10320                        .HasColumnOrder(1);
 10321
 10322                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
 10323
 10324                    b.Property<DateTime>("CreatedAt")
 10325                        .ValueGeneratedOnAdd()
 10326                        .HasColumnType("timestamp with time zone")
 10327                        .HasColumnName("created_at")
 10328                        .HasDefaultValueSql("now()");
 10329
 10330                    b.Property<string>("Email")
 10331                        .IsRequired()
 10332                        .HasMaxLength(256)
 10333                        .HasColumnType("character varying(256)")
 10334                        .HasColumnName("email");
 10335
 10336                    b.Property<bool>("EmailVerified")
 10337                        .ValueGeneratedOnAdd()
 10338                        .HasColumnType("boolean")
 10339                        .HasDefaultValue(false)
 10340                        .HasColumnName("email_verified");
 10341
 10342                    b.Property<int>("FailedLoginAttempts")
 10343                        .HasColumnType("integer")
 10344                        .HasColumnName("failed_login_attempts");
 10345
 10346                    b.Property<bool>("IsDeleted")
 10347                        .ValueGeneratedOnAdd()
 10348                        .HasColumnType("boolean")
 10349                        .HasDefaultValue(false)
 10350                        .HasColumnName("is_deleted");
 10351
 10352                    b.Property<DateTime?>("LockedOutUntil")
 10353                        .HasColumnType("timestamp with time zone")
 10354                        .HasColumnName("locked_out_until");
 10355
 10356                    b.Property<string>("Name")
 10357                        .IsRequired()
 10358                        .HasMaxLength(200)
 10359                        .HasColumnType("character varying(200)")
 10360                        .HasColumnName("name");
 10361
 10362                    b.Property<byte[]>("PasswordHash")
 10363                        .IsRequired()
 10364                        .HasColumnType("bytea")
 10365                        .HasColumnName("password_hash");
 10366
 10367                    b.Property<Guid>("PublicId")
 10368                        .HasColumnType("uuid")
 10369                        .HasColumnName("public_id");
 10370
 10371                    b.Property<long>("RoleId")
 10372                        .HasColumnType("bigint")
 10373                        .HasColumnName("role_id");
 10374
 10375                    b.Property<byte[]>("Salt")
 10376                        .IsRequired()
 10377                        .HasColumnType("bytea")
 10378                        .HasColumnName("salt");
 10379
 10380                    b.Property<long?>("ScopeId")
 10381                        .HasColumnType("bigint")
 10382                        .HasColumnName("scope_id");
 10383
 10384                    b.Property<DateTime>("UpdatedAt")
 10385                        .ValueGeneratedOnAdd()
 10386                        .HasColumnType("timestamp with time zone")
 10387                        .HasColumnName("updated_at")
 10388                        .HasDefaultValueSql("now()");
 10389
 10390                    b.HasKey("Id")
 10391                        .HasName("pk_person");
 10392
 10393                    b.HasIndex("Email")
 10394                        .HasDatabaseName("ix_person_email");
 10395
 10396                    b.HasIndex("PublicId")
 10397                        .IsUnique()
 10398                        .HasDatabaseName("ix_person_public_id");
 10399
 10400                    b.HasIndex("RoleId")
 10401                        .HasDatabaseName("ix_person_role_id");
 10402
 10403                    b.ToTable("person", "heimdall");
 20404                });
 405
 10406            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Role", b =>
 10407                {
 10408                    b.Property<long>("Id")
 10409                        .HasColumnType("bigint")
 10410                        .HasColumnName("id")
 10411                        .HasColumnOrder(1);
 10412
 10413                    b.Property<string>("Description")
 10414                        .HasMaxLength(500)
 10415                        .HasColumnType("character varying(500)")
 10416                        .HasColumnName("description");
 10417
 10418                    b.Property<string>("Name")
 10419                        .IsRequired()
 10420                        .HasMaxLength(200)
 10421                        .HasColumnType("character varying(200)")
 10422                        .HasColumnName("name");
 10423
 10424                    b.Property<Guid>("PublicId")
 10425                        .HasColumnType("uuid")
 10426                        .HasColumnName("public_id");
 10427
 10428                    b.HasKey("Id")
 10429                        .HasName("pk_role");
 10430
 10431                    b.HasIndex("Name")
 10432                        .IsUnique()
 10433                        .HasDatabaseName("ix_role_name");
 10434
 10435                    b.HasIndex("PublicId")
 10436                        .IsUnique()
 10437                        .HasDatabaseName("ix_role_public_id");
 10438
 10439                    b.ToTable("role", "heimdall");
 20440                });
 441
 10442            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Scope", b =>
 10443                {
 10444                    b.Property<long>("Id")
 10445                        .ValueGeneratedOnAdd()
 10446                        .HasColumnType("bigint")
 10447                        .HasColumnName("id")
 10448                        .HasColumnOrder(1);
 10449
 10450                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
 10451
 10452                    b.Property<DateTime>("CreatedAt")
 10453                        .ValueGeneratedOnAdd()
 10454                        .HasColumnType("timestamp with time zone")
 10455                        .HasColumnName("created_at")
 10456                        .HasDefaultValueSql("now()");
 10457
 10458                    b.Property<string>("Description")
 10459                        .HasMaxLength(500)
 10460                        .HasColumnType("character varying(500)")
 10461                        .HasColumnName("description");
 10462
 10463                    b.Property<bool>("GoogleSignInEnabled")
 10464                        .ValueGeneratedOnAdd()
 10465                        .HasColumnType("boolean")
 10466                        .HasDefaultValue(false)
 10467                        .HasColumnName("google_sign_in_enabled");
 10468
 10469                    b.Property<bool>("IsDeleted")
 10470                        .ValueGeneratedOnAdd()
 10471                        .HasColumnType("boolean")
 10472                        .HasDefaultValue(false)
 10473                        .HasColumnName("is_deleted");
 10474
 10475                    b.Property<string>("Name")
 10476                        .IsRequired()
 10477                        .HasMaxLength(200)
 10478                        .HasColumnType("character varying(200)")
 10479                        .HasColumnName("name");
 10480
 10481                    b.Property<Guid>("PublicId")
 10482                        .HasColumnType("uuid")
 10483                        .HasColumnName("public_id");
 10484
 10485                    b.Property<DateTime>("UpdatedAt")
 10486                        .ValueGeneratedOnAdd()
 10487                        .HasColumnType("timestamp with time zone")
 10488                        .HasColumnName("updated_at")
 10489                        .HasDefaultValueSql("now()");
 10490
 10491                    b.HasKey("Id")
 10492                        .HasName("pk_scope");
 10493
 10494                    b.HasIndex("Name")
 10495                        .IsUnique()
 10496                        .HasDatabaseName("ix_scope_name");
 10497
 10498                    b.HasIndex("PublicId")
 10499                        .IsUnique()
 10500                        .HasDatabaseName("ix_scope_public_id");
 10501
 10502                    b.ToTable("scope", "heimdall");
 20503                });
 504
 10505            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopeOwner", b =>
 10506                {
 10507                    b.Property<long>("ScopeId")
 10508                        .HasColumnType("bigint")
 10509                        .HasColumnName("scope_id");
 10510
 10511                    b.Property<long>("PersonId")
 10512                        .HasColumnType("bigint")
 10513                        .HasColumnName("person_id");
 10514
 10515                    b.HasKey("ScopeId", "PersonId")
 10516                        .HasName("pk_scope_owner");
 10517
 10518                    b.HasIndex("PersonId")
 10519                        .HasDatabaseName("ix_scope_owner_person_id");
 10520
 10521                    b.ToTable("scope_owner", "heimdall");
 20522                });
 523
 10524            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopePermission", b =>
 10525                {
 10526                    b.Property<long>("Id")
 10527                        .ValueGeneratedOnAdd()
 10528                        .HasColumnType("bigint")
 10529                        .HasColumnName("id")
 10530                        .HasColumnOrder(1);
 10531
 10532                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
 10533
 10534                    b.Property<DateTime>("CreatedAt")
 10535                        .ValueGeneratedOnAdd()
 10536                        .HasColumnType("timestamp with time zone")
 10537                        .HasColumnName("created_at")
 10538                        .HasDefaultValueSql("now()");
 10539
 10540                    b.Property<string>("Description")
 10541                        .HasMaxLength(500)
 10542                        .HasColumnType("character varying(500)")
 10543                        .HasColumnName("description");
 10544
 10545                    b.Property<bool>("IncludeAsJwtClaim")
 10546                        .ValueGeneratedOnAdd()
 10547                        .HasColumnType("boolean")
 10548                        .HasDefaultValue(false)
 10549                        .HasColumnName("include_as_jwt_claim");
 10550
 10551                    b.Property<bool>("IsDeleted")
 10552                        .ValueGeneratedOnAdd()
 10553                        .HasColumnType("boolean")
 10554                        .HasDefaultValue(false)
 10555                        .HasColumnName("is_deleted");
 10556
 10557                    b.Property<string>("Name")
 10558                        .IsRequired()
 10559                        .HasMaxLength(200)
 10560                        .HasColumnType("character varying(200)")
 10561                        .HasColumnName("name");
 10562
 10563                    b.Property<Guid>("PublicId")
 10564                        .HasColumnType("uuid")
 10565                        .HasColumnName("public_id");
 10566
 10567                    b.Property<long>("ScopeId")
 10568                        .HasColumnType("bigint")
 10569                        .HasColumnName("scope_id");
 10570
 10571                    b.Property<DateTime>("UpdatedAt")
 10572                        .ValueGeneratedOnAdd()
 10573                        .HasColumnType("timestamp with time zone")
 10574                        .HasColumnName("updated_at")
 10575                        .HasDefaultValueSql("now()");
 10576
 10577                    b.HasKey("Id")
 10578                        .HasName("pk_scope_permission");
 10579
 10580                    b.HasIndex("PublicId")
 10581                        .IsUnique()
 10582                        .HasDatabaseName("ix_scope_permission_public_id");
 10583
 10584                    b.HasIndex("ScopeId")
 10585                        .HasDatabaseName("ix_scope_permission_scope_id");
 10586
 10587                    b.ToTable("scope_permission", "heimdall");
 20588                });
 589
 10590            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopeUser", b =>
 10591                {
 10592                    b.Property<long>("ScopeId")
 10593                        .HasColumnType("bigint")
 10594                        .HasColumnName("scope_id");
 10595
 10596                    b.Property<long>("PersonId")
 10597                        .HasColumnType("bigint")
 10598                        .HasColumnName("person_id");
 10599
 10600                    b.HasKey("ScopeId", "PersonId")
 10601                        .HasName("pk_scope_user");
 10602
 10603                    b.HasIndex("PersonId")
 10604                        .IsUnique()
 10605                        .HasDatabaseName("ix_scope_user_person_id");
 10606
 10607                    b.ToTable("scope_user", "heimdall");
 20608                });
 609
 10610            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", b =>
 10611                {
 10612                    b.Property<long>("Id")
 10613                        .ValueGeneratedOnAdd()
 10614                        .HasColumnType("bigint")
 10615                        .HasColumnName("id")
 10616                        .HasColumnOrder(1);
 10617
 10618                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
 10619
 10620                    b.Property<bool>("AppEnabled")
 10621                        .ValueGeneratedOnAdd()
 10622                        .HasColumnType("boolean")
 10623                        .HasDefaultValue(false)
 10624                        .HasColumnName("app_enabled");
 10625
 10626                    b.Property<DateTime>("CreatedAt")
 10627                        .ValueGeneratedOnAdd()
 10628                        .HasColumnType("timestamp with time zone")
 10629                        .HasColumnName("created_at")
 10630                        .HasDefaultValueSql("now()");
 10631
 10632                    b.Property<bool>("EmailEnabled")
 10633                        .ValueGeneratedOnAdd()
 10634                        .HasColumnType("boolean")
 10635                        .HasDefaultValue(false)
 10636                        .HasColumnName("email_enabled");
 10637
 10638                    b.Property<bool>("IsActive")
 10639                        .ValueGeneratedOnAdd()
 10640                        .HasColumnType("boolean")
 10641                        .HasDefaultValue(false)
 10642                        .HasColumnName("is_active");
 10643
 10644                    b.Property<long?>("LastTotpTimeStepUsed")
 10645                        .HasColumnType("bigint")
 10646                        .HasColumnName("last_totp_time_step_used");
 10647
 10648                    b.Property<long>("PersonId")
 10649                        .HasColumnType("bigint")
 10650                        .HasColumnName("person_id");
 10651
 10652                    b.Property<byte[]>("TotpSecretEncrypted")
 10653                        .HasColumnType("bytea")
 10654                        .HasColumnName("totp_secret_encrypted");
 10655
 10656                    b.Property<DateTime>("UpdatedAt")
 10657                        .ValueGeneratedOnAdd()
 10658                        .HasColumnType("timestamp with time zone")
 10659                        .HasColumnName("updated_at")
 10660                        .HasDefaultValueSql("now()");
 10661
 10662                    b.HasKey("Id")
 10663                        .HasName("pk_two_factor_auth");
 10664
 10665                    b.HasIndex("PersonId")
 10666                        .IsUnique()
 10667                        .HasDatabaseName("ix_two_factor_auth_person_id");
 10668
 10669                    b.ToTable("two_factor_auth", "heimdall");
 20670                });
 671
 10672            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorEmailCode", b =>
 10673                {
 10674                    b.Property<long>("Id")
 10675                        .ValueGeneratedOnAdd()
 10676                        .HasColumnType("bigint")
 10677                        .HasColumnName("id")
 10678                        .HasColumnOrder(1);
 10679
 10680                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
 10681
 10682                    b.Property<byte[]>("CodeHash")
 10683                        .IsRequired()
 10684                        .HasColumnType("bytea")
 10685                        .HasColumnName("code_hash");
 10686
 10687                    b.Property<DateTime>("CreatedAt")
 10688                        .ValueGeneratedOnAdd()
 10689                        .HasColumnType("timestamp with time zone")
 10690                        .HasColumnName("created_at")
 10691                        .HasDefaultValueSql("now()");
 10692
 10693                    b.Property<DateTime>("ExpiresAt")
 10694                        .HasColumnType("timestamp with time zone")
 10695                        .HasColumnName("expires_at");
 10696
 10697                    b.Property<int>("FailedAttempts")
 10698                        .HasColumnType("integer")
 10699                        .HasColumnName("failed_attempts");
 10700
 10701                    b.Property<byte[]>("Salt")
 10702                        .IsRequired()
 10703                        .HasColumnType("bytea")
 10704                        .HasColumnName("salt");
 10705
 10706                    b.Property<long>("TwoFactorAuthId")
 10707                        .HasColumnType("bigint")
 10708                        .HasColumnName("two_factor_auth_id");
 10709
 10710                    b.Property<bool>("Used")
 10711                        .ValueGeneratedOnAdd()
 10712                        .HasColumnType("boolean")
 10713                        .HasDefaultValue(false)
 10714                        .HasColumnName("used");
 10715
 10716                    b.HasKey("Id")
 10717                        .HasName("pk_two_factor_email_code");
 10718
 10719                    b.HasIndex("TwoFactorAuthId")
 10720                        .HasDatabaseName("ix_two_factor_email_code_two_factor_auth_id");
 10721
 10722                    b.ToTable("two_factor_email_code", "heimdall");
 20723                });
 724
 10725            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorRecoveryCode", b =>
 10726                {
 10727                    b.Property<long>("Id")
 10728                        .ValueGeneratedOnAdd()
 10729                        .HasColumnType("bigint")
 10730                        .HasColumnName("id")
 10731                        .HasColumnOrder(1);
 10732
 10733                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));
 10734
 10735                    b.Property<byte[]>("CodeHash")
 10736                        .IsRequired()
 10737                        .HasColumnType("bytea")
 10738                        .HasColumnName("code_hash");
 10739
 10740                    b.Property<DateTime>("CreatedAt")
 10741                        .ValueGeneratedOnAdd()
 10742                        .HasColumnType("timestamp with time zone")
 10743                        .HasColumnName("created_at")
 10744                        .HasDefaultValueSql("now()");
 10745
 10746                    b.Property<long>("TwoFactorAuthId")
 10747                        .HasColumnType("bigint")
 10748                        .HasColumnName("two_factor_auth_id");
 10749
 10750                    b.Property<bool>("Used")
 10751                        .ValueGeneratedOnAdd()
 10752                        .HasColumnType("boolean")
 10753                        .HasDefaultValue(false)
 10754                        .HasColumnName("used");
 10755
 10756                    b.Property<DateTime?>("UsedAt")
 10757                        .HasColumnType("timestamp with time zone")
 10758                        .HasColumnName("used_at");
 10759
 10760                    b.HasKey("Id")
 10761                        .HasName("pk_two_factor_recovery_code");
 10762
 10763                    b.HasIndex("TwoFactorAuthId")
 10764                        .HasDatabaseName("ix_two_factor_recovery_code_two_factor_auth_id");
 10765
 10766                    b.ToTable("two_factor_recovery_code", "heimdall");
 20767                });
 768
 10769            modelBuilder.Entity("Microsoft.AspNetCore.DataProtection.EntityFrameworkCore.DataProtectionKey", b =>
 10770                {
 10771                    b.Property<int>("Id")
 10772                        .ValueGeneratedOnAdd()
 10773                        .HasColumnType("integer")
 10774                        .HasColumnName("id");
 10775
 10776                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
 10777
 10778                    b.Property<string>("FriendlyName")
 10779                        .HasColumnType("text")
 10780                        .HasColumnName("friendly_name");
 10781
 10782                    b.Property<string>("Xml")
 10783                        .HasColumnType("text")
 10784                        .HasColumnName("xml");
 10785
 10786                    b.HasKey("Id")
 10787                        .HasName("pk_data_protection_keys");
 10788
 10789                    b.ToTable("data_protection_keys", "heimdall");
 20790                });
 791
 10792            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Application", b =>
 10793                {
 10794                    b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Owner")
 10795                        .WithMany("OwnedApplications")
 10796                        .HasForeignKey("OwnerId")
 10797                        .OnDelete(DeleteBehavior.Cascade)
 10798                        .IsRequired()
 10799                        .HasConstraintName("fk_application_person_owner_id");
 10800
 10801                    b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")
 10802                        .WithMany("Applications")
 10803                        .HasForeignKey("ScopeId")
 10804                        .OnDelete(DeleteBehavior.Cascade)
 10805                        .IsRequired()
 10806                        .HasConstraintName("fk_application_scope_scope_id");
 10807
 10808                    b.Navigation("Owner");
 10809
 10810                    b.Navigation("Scope");
 20811                });
 812
 10813            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.EmailVerificationToken", b =>
 10814                {
 10815                    b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")
 10816                        .WithMany("EmailVerificationTokens")
 10817                        .HasForeignKey("PersonId")
 10818                        .OnDelete(DeleteBehavior.Cascade)
 10819                        .IsRequired()
 10820                        .HasConstraintName("fk_email_verification_token_person_person_id");
 10821
 10822                    b.Navigation("Person");
 20823                });
 824
 10825            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.GoogleUser", b =>
 10826                {
 10827                    b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")
 10828                        .WithMany("GoogleUsers")
 10829                        .HasForeignKey("ScopeId")
 10830                        .OnDelete(DeleteBehavior.Cascade)
 10831                        .IsRequired()
 10832                        .HasConstraintName("fk_google_user_scope_scope_id");
 10833
 10834                    b.Navigation("Scope");
 20835                });
 836
 10837            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.PasswordResetToken", b =>
 10838                {
 10839                    b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")
 10840                        .WithMany("PasswordResetTokens")
 10841                        .HasForeignKey("PersonId")
 10842                        .OnDelete(DeleteBehavior.Cascade)
 10843                        .IsRequired()
 10844                        .HasConstraintName("fk_password_reset_token_person_person_id");
 10845
 10846                    b.Navigation("Person");
 20847                });
 848
 10849            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Person", b =>
 10850                {
 10851                    b.HasOne("ArturRios.Heimdall.Domain.Entities.Role", "Role")
 10852                        .WithMany("Persons")
 10853                        .HasForeignKey("RoleId")
 10854                        .OnDelete(DeleteBehavior.Restrict)
 10855                        .IsRequired()
 10856                        .HasConstraintName("fk_person_roles_role_id");
 10857
 10858                    b.Navigation("Role");
 20859                });
 860
 10861            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopeOwner", b =>
 10862                {
 10863                    b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")
 10864                        .WithMany("ScopeOwnerships")
 10865                        .HasForeignKey("PersonId")
 10866                        .OnDelete(DeleteBehavior.Cascade)
 10867                        .IsRequired()
 10868                        .HasConstraintName("fk_scope_owner_person_person_id");
 10869
 10870                    b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")
 10871                        .WithMany("Owners")
 10872                        .HasForeignKey("ScopeId")
 10873                        .OnDelete(DeleteBehavior.Cascade)
 10874                        .IsRequired()
 10875                        .HasConstraintName("fk_scope_owner_scope_scope_id");
 10876
 10877                    b.Navigation("Person");
 10878
 10879                    b.Navigation("Scope");
 20880                });
 881
 10882            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopePermission", b =>
 10883                {
 10884                    b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")
 10885                        .WithMany("ScopePermissions")
 10886                        .HasForeignKey("ScopeId")
 10887                        .OnDelete(DeleteBehavior.Cascade)
 10888                        .IsRequired()
 10889                        .HasConstraintName("fk_scope_permission_scope_scope_id");
 10890
 10891                    b.Navigation("Scope");
 20892                });
 893
 10894            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopeUser", b =>
 10895                {
 10896                    b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")
 10897                        .WithOne("ScopeMembership")
 10898                        .HasForeignKey("ArturRios.Heimdall.Domain.Entities.ScopeUser", "PersonId")
 10899                        .OnDelete(DeleteBehavior.Cascade)
 10900                        .IsRequired()
 10901                        .HasConstraintName("fk_scope_user_person_person_id");
 10902
 10903                    b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")
 10904                        .WithMany("Users")
 10905                        .HasForeignKey("ScopeId")
 10906                        .OnDelete(DeleteBehavior.Cascade)
 10907                        .IsRequired()
 10908                        .HasConstraintName("fk_scope_user_scope_scope_id");
 10909
 10910                    b.Navigation("Person");
 10911
 10912                    b.Navigation("Scope");
 20913                });
 914
 10915            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", b =>
 10916                {
 10917                    b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")
 10918                        .WithOne("TwoFactorAuth")
 10919                        .HasForeignKey("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", "PersonId")
 10920                        .OnDelete(DeleteBehavior.Cascade)
 10921                        .IsRequired()
 10922                        .HasConstraintName("fk_two_factor_auth_person_person_id");
 10923
 10924                    b.Navigation("Person");
 20925                });
 926
 10927            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorEmailCode", b =>
 10928                {
 10929                    b.HasOne("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", "TwoFactorAuth")
 10930                        .WithMany("EmailCodes")
 10931                        .HasForeignKey("TwoFactorAuthId")
 10932                        .OnDelete(DeleteBehavior.Cascade)
 10933                        .IsRequired()
 10934                        .HasConstraintName("fk_two_factor_email_code_two_factor_auth_two_factor_auth_id");
 10935
 10936                    b.Navigation("TwoFactorAuth");
 20937                });
 938
 10939            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorRecoveryCode", b =>
 10940                {
 10941                    b.HasOne("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", "TwoFactorAuth")
 10942                        .WithMany("RecoveryCodes")
 10943                        .HasForeignKey("TwoFactorAuthId")
 10944                        .OnDelete(DeleteBehavior.Cascade)
 10945                        .IsRequired()
 10946                        .HasConstraintName("fk_two_factor_recovery_code_two_factor_auth_two_factor_auth_id");
 10947
 10948                    b.Navigation("TwoFactorAuth");
 20949                });
 950
 10951            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Person", b =>
 10952                {
 10953                    b.Navigation("EmailVerificationTokens");
 10954
 10955                    b.Navigation("OwnedApplications");
 10956
 10957                    b.Navigation("PasswordResetTokens");
 10958
 10959                    b.Navigation("ScopeMembership");
 10960
 10961                    b.Navigation("ScopeOwnerships");
 10962
 10963                    b.Navigation("TwoFactorAuth");
 20964                });
 965
 10966            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Role", b =>
 10967                {
 10968                    b.Navigation("Persons");
 20969                });
 970
 10971            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Scope", b =>
 10972                {
 10973                    b.Navigation("Applications");
 10974
 10975                    b.Navigation("GoogleUsers");
 10976
 10977                    b.Navigation("Owners");
 10978
 10979                    b.Navigation("ScopePermissions");
 10980
 10981                    b.Navigation("Users");
 20982                });
 983
 10984            modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", b =>
 10985                {
 10986                    b.Navigation("EmailCodes");
 10987
 10988                    b.Navigation("RecoveryCodes");
 20989                });
 990#pragma warning restore 612, 618
 10991        }
 992    }
 993}
Generated by: ReportGenerator 5.5.11.0
10/30/2026 - 04:24:15
GitHub | reportgenerator.io

Methods/Properties

Up(Microsoft.EntityFrameworkCore.Migrations.MigrationBuilder)
Down(Microsoft.EntityFrameworkCore.Migrations.MigrationBuilder)
BuildTargetModel(Microsoft.EntityFrameworkCore.ModelBuilder)