< Summary - Heimdall API

Information

Class:	ArturRios.Heimdall.Data.Migrations.AddPersonSecurityStamp
Assembly:	ArturRios.Heimdall.Data
File(s):	File 1: /home/runner/work/heimdall-api/heimdall-api/src/Infrastructure/ArturRios.Heimdall.Data/Migrations/20261015115923_AddPersonSecurityStamp.cs File 2: /home/runner/work/heimdall-api/heimdall-api/src/Infrastructure/ArturRios.Heimdall.Data/Migrations/20261015115923_AddPersonSecurityStamp.Designer.cs

Line coverage

99%

Covered lines:	1310
Uncovered lines:	5
Coverable lines:	1315
Total lines:	1412
Line coverage:	99.6%

Branch coverage

N/A

Covered branches:	0
Total branches:	0
Branch coverage:	N/A

Method coverage

66%

Covered methods:	2
Fully covered methods:	2
Total methods:	3
Method coverage:	66.6%
Full method coverage:	66.6%

Metrics

Method	Branch coverage	Crap Score	Cyclomatic complexity	Line coverage
File 1: Up(...)	100%	1	1	100%
File 1: Down(...)	100%	2	1	0%
File 2: BuildTargetModel(...)	100%	1	1	100%

File(s)

/home/runner/work/heimdall-api/heimdall-api/src/Infrastructure/ArturRios.Heimdall.Data/Migrations/20261015115923_AddPersonSecurityStamp.cs

#	Line	Line coverage
	`1`	`using System;`
	`2`	`using Microsoft.EntityFrameworkCore.Migrations;`
	`3`
	`4`	`#nullable disable`
	`5`
	`6`	`namespace ArturRios.Heimdall.Data.Migrations`
	`7`	`{`
	`8`	`/// <summary>`
	`9`	`/// Adds <c>security_stamp</c> to <c>heimdall.person</c>: the value every person token now`
	`10`	`/// carries, and which a credential change replaces to revoke the tokens issued before it`
	`11`	`/// (FR-AU-11, Threat Model TH-36).`
	`12`	`/// </summary>`
	`13`	`/// <remarks>`
	`14`	`/// <para>`
	`15`	`/// <c>gen_random_uuid()</c> is volatile, so PostgreSQL evaluates the default once per`
	`16`	`/// existing row while it adds the column: every person gets a stamp of their own, and no`
	`17`	`/// two share one. The default stays for any row inserted without a value; the application`
	`18`	`/// always supplies one.`
	`19`	`/// </para>`
	`20`	`/// <para>`
	`21`	`/// No token issued before this migration carries a stamp, so each is refused from the`
	`22`	`/// first request after deployment and every person signs in once more. The <c>person</c>`
	`23`	`/// table's triggers guard <c>public_id</c> alone (#199), so the column stays writable.`
	`24`	`/// </para>`
	`25`	`/// </remarks>`
	`26`	`public partial class AddPersonSecurityStamp : Migration`
	`27`	`{`
	`28`	`/// <inheritdoc />`
	`29`	`protected override void Up(MigrationBuilder migrationBuilder)`
	`30`	`{`
4	`31`	`migrationBuilder.AddColumn<Guid>(`
4	`32`	`name: "security_stamp",`
4	`33`	`schema: "heimdall",`
4	`34`	`table: "person",`
4	`35`	`type: "uuid",`
4	`36`	`nullable: false,`
4	`37`	`defaultValueSql: "gen_random_uuid()");`
4	`38`	`}`
	`39`
	`40`	`/// <inheritdoc />`
	`41`	`protected override void Down(MigrationBuilder migrationBuilder)`
	`42`	`{`
0	`43`	`migrationBuilder.DropColumn(`
0	`44`	`name: "security_stamp",`
0	`45`	`schema: "heimdall",`
0	`46`	`table: "person");`
0	`47`	`}`
	`48`	`}`
	`49`	`}`

/home/runner/work/heimdall-api/heimdall-api/src/Infrastructure/ArturRios.Heimdall.Data/Migrations/20261015115923_AddPersonSecurityStamp.Designer.cs

#	Line	Line coverage
	`1`	`// <auto-generated />`
	`2`	`using System;`
	`3`	`using ArturRios.Heimdall.Data.Configuration;`
	`4`	`using Microsoft.EntityFrameworkCore;`
	`5`	`using Microsoft.EntityFrameworkCore.Infrastructure;`
	`6`	`using Microsoft.EntityFrameworkCore.Migrations;`
	`7`	`using Microsoft.EntityFrameworkCore.Storage.ValueConversion;`
	`8`	`using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;`
	`9`
	`10`	`#nullable disable`
	`11`
	`12`	`namespace ArturRios.Heimdall.Data.Migrations`
	`13`	`{`
	`14`	`[DbContext(typeof(AppDbContext))]`
	`15`	`[Migration("20261015115923_AddPersonSecurityStamp")]`
	`16`	`partial class AddPersonSecurityStamp`
	`17`	`{`
	`18`	`/// <inheritdoc />`
	`19`	`protected override void BuildTargetModel(ModelBuilder modelBuilder)`
	`20`	`{`
	`21`	`#pragma warning disable 612, 618`
2	`22`	`modelBuilder`
2	`23`	`.HasDefaultSchema("heimdall")`
2	`24`	`.HasAnnotation("ProductVersion", "10.0.13")`
2	`25`	`.HasAnnotation("Relational:MaxIdentifierLength", 63);`
	`26`
2	`27`	`NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);`
	`28`
2	`29`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Application", b =>`
2	`30`	`{`
2	`31`	`b.Property<long>("Id")`
2	`32`	`.ValueGeneratedOnAdd()`
2	`33`	`.HasColumnType("bigint")`
2	`34`	`.HasColumnName("id")`
2	`35`	`.HasColumnOrder(1);`
2	`36`
2	`37`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`38`
2	`39`	`b.Property<DateTime>("CreatedAt")`
2	`40`	`.ValueGeneratedOnAdd()`
2	`41`	`.HasColumnType("timestamp with time zone")`
2	`42`	`.HasColumnName("created_at")`
2	`43`	`.HasDefaultValueSql("now()");`
2	`44`
2	`45`	`b.Property<bool>("IsDeleted")`
2	`46`	`.ValueGeneratedOnAdd()`
2	`47`	`.HasColumnType("boolean")`
2	`48`	`.HasDefaultValue(false)`
2	`49`	`.HasColumnName("is_deleted");`
2	`50`
2	`51`	`b.Property<string>("Name")`
2	`52`	`.IsRequired()`
2	`53`	`.HasMaxLength(200)`
2	`54`	`.HasColumnType("character varying(200)")`
2	`55`	`.HasColumnName("name");`
2	`56`
2	`57`	`b.Property<long>("OwnerId")`
2	`58`	`.HasColumnType("bigint")`
2	`59`	`.HasColumnName("owner_id");`
2	`60`
2	`61`	`b.Property<Guid>("PublicId")`
2	`62`	`.HasColumnType("uuid")`
2	`63`	`.HasColumnName("public_id");`
2	`64`
2	`65`	`b.Property<long>("ScopeId")`
2	`66`	`.HasColumnType("bigint")`
2	`67`	`.HasColumnName("scope_id");`
2	`68`
2	`69`	`b.Property<DateTime>("UpdatedAt")`
2	`70`	`.ValueGeneratedOnAdd()`
2	`71`	`.HasColumnType("timestamp with time zone")`
2	`72`	`.HasColumnName("updated_at")`
2	`73`	`.HasDefaultValueSql("now()");`
2	`74`
2	`75`	`b.HasKey("Id")`
2	`76`	`.HasName("pk_application");`
2	`77`
2	`78`	`b.HasIndex("OwnerId")`
2	`79`	`.HasDatabaseName("ix_application_owner_id");`
2	`80`
2	`81`	`b.HasIndex("PublicId")`
2	`82`	`.IsUnique()`
2	`83`	`.HasDatabaseName("ix_application_public_id");`
2	`84`
2	`85`	`b.HasIndex("ScopeId")`
2	`86`	`.HasDatabaseName("ix_application_scope_id");`
2	`87`
2	`88`	`b.ToTable("application", "heimdall");`
4	`89`	`});`
	`90`
2	`91`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ApplicationCredential", b =>`
2	`92`	`{`
2	`93`	`b.Property<long>("Id")`
2	`94`	`.ValueGeneratedOnAdd()`
2	`95`	`.HasColumnType("bigint")`
2	`96`	`.HasColumnName("id")`
2	`97`	`.HasColumnOrder(1);`
2	`98`
2	`99`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`100`
2	`101`	`b.Property<long>("ApplicationId")`
2	`102`	`.HasColumnType("bigint")`
2	`103`	`.HasColumnName("application_id");`
2	`104`
2	`105`	`b.Property<DateTime>("CreatedAt")`
2	`106`	`.HasColumnType("timestamp with time zone")`
2	`107`	`.HasColumnName("created_at");`
2	`108`
2	`109`	`b.Property<DateTime?>("ExpiresAt")`
2	`110`	`.HasColumnType("timestamp with time zone")`
2	`111`	`.HasColumnName("expires_at");`
2	`112`
2	`113`	`b.Property<DateTime?>("LastUsedAt")`
2	`114`	`.HasColumnType("timestamp with time zone")`
2	`115`	`.HasColumnName("last_used_at");`
2	`116`
2	`117`	`b.Property<Guid>("PublicId")`
2	`118`	`.HasColumnType("uuid")`
2	`119`	`.HasColumnName("public_id");`
2	`120`
2	`121`	`b.Property<DateTime?>("RevokedAt")`
2	`122`	`.HasColumnType("timestamp with time zone")`
2	`123`	`.HasColumnName("revoked_at");`
2	`124`
2	`125`	`b.Property<string>("SecretHash")`
2	`126`	`.IsRequired()`
2	`127`	`.HasMaxLength(64)`
2	`128`	`.HasColumnType("character varying(64)")`
2	`129`	`.HasColumnName("secret_hash");`
2	`130`
2	`131`	`b.HasKey("Id")`
2	`132`	`.HasName("pk_application_credential");`
2	`133`
2	`134`	`b.HasIndex("ApplicationId")`
2	`135`	`.HasDatabaseName("ix_application_credential_application_id");`
2	`136`
2	`137`	`b.HasIndex("PublicId")`
2	`138`	`.IsUnique()`
2	`139`	`.HasDatabaseName("ix_application_credential_public_id");`
2	`140`
2	`141`	`b.HasIndex("SecretHash")`
2	`142`	`.IsUnique()`
2	`143`	`.HasDatabaseName("ix_application_credential_secret_hash");`
2	`144`
2	`145`	`b.ToTable("application_credential", "heimdall");`
4	`146`	`});`
	`147`
2	`148`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.AuditLog", b =>`
2	`149`	`{`
2	`150`	`b.Property<long>("Id")`
2	`151`	`.ValueGeneratedOnAdd()`
2	`152`	`.HasColumnType("bigint")`
2	`153`	`.HasColumnName("id")`
2	`154`	`.HasColumnOrder(1);`
2	`155`
2	`156`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`157`
2	`158`	`b.Property<string>("Action")`
2	`159`	`.IsRequired()`
2	`160`	`.HasMaxLength(200)`
2	`161`	`.HasColumnType("character varying(200)")`
2	`162`	`.HasColumnName("action");`
2	`163`
2	`164`	`b.Property<Guid?>("ActorPersonId")`
2	`165`	`.HasColumnType("uuid")`
2	`166`	`.HasColumnName("actor_person_id");`
2	`167`
2	`168`	`b.Property<int?>("ActorRole")`
2	`169`	`.HasColumnType("integer")`
2	`170`	`.HasColumnName("actor_role");`
2	`171`
2	`172`	`b.Property<DateTime>("CreatedAt")`
2	`173`	`.ValueGeneratedOnAdd()`
2	`174`	`.HasColumnType("timestamp with time zone")`
2	`175`	`.HasColumnName("created_at")`
2	`176`	`.HasDefaultValueSql("now()");`
2	`177`
2	`178`	`b.Property<string>("FailureReason")`
2	`179`	`.HasMaxLength(500)`
2	`180`	`.HasColumnType("character varying(500)")`
2	`181`	`.HasColumnName("failure_reason");`
2	`182`
2	`183`	`b.Property<Guid>("PublicId")`
2	`184`	`.HasColumnType("uuid")`
2	`185`	`.HasColumnName("public_id");`
2	`186`
2	`187`	`b.Property<bool>("Succeeded")`
2	`188`	`.HasColumnType("boolean")`
2	`189`	`.HasColumnName("succeeded");`
2	`190`
2	`191`	`b.Property<Guid?>("TargetId")`
2	`192`	`.HasColumnType("uuid")`
2	`193`	`.HasColumnName("target_id");`
2	`194`
2	`195`	`b.HasKey("Id")`
2	`196`	`.HasName("pk_audit_log");`
2	`197`
2	`198`	`b.HasIndex("ActorPersonId")`
2	`199`	`.HasDatabaseName("ix_audit_log_actor_person_id");`
2	`200`
2	`201`	`b.HasIndex("CreatedAt")`
2	`202`	`.HasDatabaseName("ix_audit_log_created_at");`
2	`203`
2	`204`	`b.HasIndex("PublicId")`
2	`205`	`.IsUnique()`
2	`206`	`.HasDatabaseName("ix_audit_log_public_id");`
2	`207`
2	`208`	`b.HasIndex("TargetId")`
2	`209`	`.HasDatabaseName("ix_audit_log_target_id");`
2	`210`
2	`211`	`b.ToTable("audit_log", "heimdall");`
4	`212`	`});`
	`213`
2	`214`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.EmailVerificationToken", b =>`
2	`215`	`{`
2	`216`	`b.Property<long>("Id")`
2	`217`	`.ValueGeneratedOnAdd()`
2	`218`	`.HasColumnType("bigint")`
2	`219`	`.HasColumnName("id")`
2	`220`	`.HasColumnOrder(1);`
2	`221`
2	`222`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`223`
2	`224`	`b.Property<DateTime>("ExpiresAt")`
2	`225`	`.HasColumnType("timestamp with time zone")`
2	`226`	`.HasColumnName("expires_at");`
2	`227`
2	`228`	`b.Property<long>("PersonId")`
2	`229`	`.HasColumnType("bigint")`
2	`230`	`.HasColumnName("person_id");`
2	`231`
2	`232`	`b.Property<string>("TokenHash")`
2	`233`	`.IsRequired()`
2	`234`	`.HasMaxLength(64)`
2	`235`	`.HasColumnType("character varying(64)")`
2	`236`	`.HasColumnName("token_hash");`
2	`237`
2	`238`	`b.Property<bool>("Used")`
2	`239`	`.ValueGeneratedOnAdd()`
2	`240`	`.HasColumnType("boolean")`
2	`241`	`.HasDefaultValue(false)`
2	`242`	`.HasColumnName("used");`
2	`243`
2	`244`	`b.HasKey("Id")`
2	`245`	`.HasName("pk_email_verification_token");`
2	`246`
2	`247`	`b.HasIndex("PersonId")`
2	`248`	`.HasDatabaseName("ix_email_verification_token_person_id");`
2	`249`
2	`250`	`b.HasIndex("TokenHash")`
2	`251`	`.IsUnique()`
2	`252`	`.HasDatabaseName("ix_email_verification_token_token_hash");`
2	`253`
2	`254`	`b.ToTable("email_verification_token", "heimdall");`
4	`255`	`});`
	`256`
2	`257`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ErasedSubject", b =>`
2	`258`	`{`
2	`259`	`b.Property<Guid>("Id")`
2	`260`	`.HasColumnType("uuid")`
2	`261`	`.HasColumnName("public_id")`
2	`262`	`.HasColumnOrder(1);`
2	`263`
2	`264`	`b.Property<DateTime>("CreatedAt")`
2	`265`	`.ValueGeneratedOnAdd()`
2	`266`	`.HasColumnType("timestamp with time zone")`
2	`267`	`.HasColumnName("created_at")`
2	`268`	`.HasDefaultValueSql("now()");`
2	`269`
2	`270`	`b.Property<int>("Kind")`
2	`271`	`.HasColumnType("integer")`
2	`272`	`.HasColumnName("kind");`
2	`273`
2	`274`	`b.HasKey("Id")`
2	`275`	`.HasName("pk_erased_subject");`
2	`276`
2	`277`	`b.HasIndex("CreatedAt")`
2	`278`	`.HasDatabaseName("ix_erased_subject_created_at");`
2	`279`
2	`280`	`b.ToTable("erased_subject", "heimdall");`
4	`281`	`});`
	`282`
2	`283`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.GoogleUser", b =>`
2	`284`	`{`
2	`285`	`b.Property<long>("Id")`
2	`286`	`.ValueGeneratedOnAdd()`
2	`287`	`.HasColumnType("bigint")`
2	`288`	`.HasColumnName("id")`
2	`289`	`.HasColumnOrder(1);`
2	`290`
2	`291`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`292`
2	`293`	`b.Property<DateTime?>("AnonymisedAt")`
2	`294`	`.HasColumnType("timestamp with time zone")`
2	`295`	`.HasColumnName("anonymised_at");`
2	`296`
2	`297`	`b.Property<DateTime?>("BasisRecordedAt")`
2	`298`	`.HasColumnType("timestamp with time zone")`
2	`299`	`.HasColumnName("basis_recorded_at");`
2	`300`
2	`301`	`b.Property<DateTime>("CreatedAt")`
2	`302`	`.ValueGeneratedOnAdd()`
2	`303`	`.HasColumnType("timestamp with time zone")`
2	`304`	`.HasColumnName("created_at")`
2	`305`	`.HasDefaultValueSql("now()");`
2	`306`
2	`307`	`b.Property<DateTime?>("DeletedAt")`
2	`308`	`.HasColumnType("timestamp with time zone")`
2	`309`	`.HasColumnName("deleted_at");`
2	`310`
2	`311`	`b.Property<int?>("DeletionKind")`
2	`312`	`.HasColumnType("integer")`
2	`313`	`.HasColumnName("deletion_kind");`
2	`314`
2	`315`	`b.Property<string>("Email")`
2	`316`	`.IsRequired()`
2	`317`	`.HasMaxLength(256)`
2	`318`	`.HasColumnType("character varying(256)")`
2	`319`	`.HasColumnName("email");`
2	`320`
2	`321`	`b.Property<bool>("EmailVerified")`
2	`322`	`.ValueGeneratedOnAdd()`
2	`323`	`.HasColumnType("boolean")`
2	`324`	`.HasDefaultValue(false)`
2	`325`	`.HasColumnName("email_verified");`
2	`326`
2	`327`	`b.Property<string>("ErasureBlockedReason")`
2	`328`	`.HasMaxLength(500)`
2	`329`	`.HasColumnType("character varying(500)")`
2	`330`	`.HasColumnName("erasure_blocked_reason");`
2	`331`
2	`332`	`b.Property<DateTime?>("ErasureDueAt")`
2	`333`	`.HasColumnType("timestamp with time zone")`
2	`334`	`.HasColumnName("erasure_due_at");`
2	`335`
2	`336`	`b.Property<DateTime?>("ErasureRequestedAt")`
2	`337`	`.HasColumnType("timestamp with time zone")`
2	`338`	`.HasColumnName("erasure_requested_at");`
2	`339`
2	`340`	`b.Property<string>("GoogleId")`
2	`341`	`.IsRequired()`
2	`342`	`.HasMaxLength(255)`
2	`343`	`.HasColumnType("character varying(255)")`
2	`344`	`.HasColumnName("google_id");`
2	`345`
2	`346`	`b.Property<bool>("IsDeleted")`
2	`347`	`.ValueGeneratedOnAdd()`
2	`348`	`.HasColumnType("boolean")`
2	`349`	`.HasDefaultValue(false)`
2	`350`	`.HasColumnName("is_deleted");`
2	`351`
2	`352`	`b.Property<int>("LegalBasis")`
2	`353`	`.ValueGeneratedOnAdd()`
2	`354`	`.HasColumnType("integer")`
2	`355`	`.HasDefaultValue(0)`
2	`356`	`.HasColumnName("legal_basis");`
2	`357`
2	`358`	`b.Property<string>("Name")`
2	`359`	`.IsRequired()`
2	`360`	`.HasMaxLength(200)`
2	`361`	`.HasColumnType("character varying(200)")`
2	`362`	`.HasColumnName("name");`
2	`363`
2	`364`	`b.Property<string>("PrivacyNoticeVersion")`
2	`365`	`.HasMaxLength(50)`
2	`366`	`.HasColumnType("character varying(50)")`
2	`367`	`.HasColumnName("privacy_notice_version");`
2	`368`
2	`369`	`b.Property<DateTime?>("ProcessingRestrictedAt")`
2	`370`	`.HasColumnType("timestamp with time zone")`
2	`371`	`.HasColumnName("processing_restricted_at");`
2	`372`
2	`373`	`b.Property<string>("ProfilePictureUrl")`
2	`374`	`.HasMaxLength(2048)`
2	`375`	`.HasColumnType("character varying(2048)")`
2	`376`	`.HasColumnName("profile_picture_url");`
2	`377`
2	`378`	`b.Property<Guid>("PublicId")`
2	`379`	`.HasColumnType("uuid")`
2	`380`	`.HasColumnName("public_id");`
2	`381`
2	`382`	`b.Property<int?>("RestrictionGround")`
2	`383`	`.HasColumnType("integer")`
2	`384`	`.HasColumnName("restriction_ground");`
2	`385`
2	`386`	`b.Property<DateTime?>("RestrictionLiftNotifiedAt")`
2	`387`	`.HasColumnType("timestamp with time zone")`
2	`388`	`.HasColumnName("restriction_lift_notified_at");`
2	`389`
2	`390`	`b.Property<long>("ScopeId")`
2	`391`	`.HasColumnType("bigint")`
2	`392`	`.HasColumnName("scope_id");`
2	`393`
2	`394`	`b.Property<DateTime>("UpdatedAt")`
2	`395`	`.ValueGeneratedOnAdd()`
2	`396`	`.HasColumnType("timestamp with time zone")`
2	`397`	`.HasColumnName("updated_at")`
2	`398`	`.HasDefaultValueSql("now()");`
2	`399`
2	`400`	`b.HasKey("Id")`
2	`401`	`.HasName("pk_google_user");`
2	`402`
2	`403`	`b.HasIndex("DeletedAt")`
2	`404`	`.HasDatabaseName("ix_google_user_deleted_at")`
2	`405`	`.HasFilter("is_deleted = true AND anonymised_at IS NULL");`
2	`406`
2	`407`	`b.HasIndex("ProcessingRestrictedAt")`
2	`408`	`.HasDatabaseName("ix_google_user_processing_restricted_at")`
2	`409`	`.HasFilter("processing_restricted_at IS NOT NULL");`
2	`410`
2	`411`	`b.HasIndex("PublicId")`
2	`412`	`.IsUnique()`
2	`413`	`.HasDatabaseName("ix_google_user_public_id");`
2	`414`
2	`415`	`b.HasIndex("ScopeId", "Email")`
2	`416`	`.IsUnique()`
2	`417`	`.HasDatabaseName("ix_google_user_scope_id_email");`
2	`418`
2	`419`	`b.HasIndex("ScopeId", "GoogleId")`
2	`420`	`.IsUnique()`
2	`421`	`.HasDatabaseName("ix_google_user_scope_id_google_id");`
2	`422`
2	`423`	`b.ToTable("google_user", "heimdall");`
4	`424`	`});`
	`425`
2	`426`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.PasswordResetToken", b =>`
2	`427`	`{`
2	`428`	`b.Property<long>("Id")`
2	`429`	`.ValueGeneratedOnAdd()`
2	`430`	`.HasColumnType("bigint")`
2	`431`	`.HasColumnName("id")`
2	`432`	`.HasColumnOrder(1);`
2	`433`
2	`434`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`435`
2	`436`	`b.Property<DateTime>("ExpiresAt")`
2	`437`	`.HasColumnType("timestamp with time zone")`
2	`438`	`.HasColumnName("expires_at");`
2	`439`
2	`440`	`b.Property<long>("PersonId")`
2	`441`	`.HasColumnType("bigint")`
2	`442`	`.HasColumnName("person_id");`
2	`443`
2	`444`	`b.Property<string>("TokenHash")`
2	`445`	`.IsRequired()`
2	`446`	`.HasMaxLength(64)`
2	`447`	`.HasColumnType("character varying(64)")`
2	`448`	`.HasColumnName("token_hash");`
2	`449`
2	`450`	`b.Property<bool>("Used")`
2	`451`	`.ValueGeneratedOnAdd()`
2	`452`	`.HasColumnType("boolean")`
2	`453`	`.HasDefaultValue(false)`
2	`454`	`.HasColumnName("used");`
2	`455`
2	`456`	`b.HasKey("Id")`
2	`457`	`.HasName("pk_password_reset_token");`
2	`458`
2	`459`	`b.HasIndex("PersonId")`
2	`460`	`.HasDatabaseName("ix_password_reset_token_person_id");`
2	`461`
2	`462`	`b.HasIndex("TokenHash")`
2	`463`	`.IsUnique()`
2	`464`	`.HasDatabaseName("ix_password_reset_token_token_hash");`
2	`465`
2	`466`	`b.ToTable("password_reset_token", "heimdall");`
4	`467`	`});`
	`468`
2	`469`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.PendingRegistration", b =>`
2	`470`	`{`
2	`471`	`b.Property<long>("Id")`
2	`472`	`.ValueGeneratedOnAdd()`
2	`473`	`.HasColumnType("bigint")`
2	`474`	`.HasColumnName("id")`
2	`475`	`.HasColumnOrder(1);`
2	`476`
2	`477`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`478`
2	`479`	`b.Property<DateTime>("CreatedAt")`
2	`480`	`.ValueGeneratedOnAdd()`
2	`481`	`.HasColumnType("timestamp with time zone")`
2	`482`	`.HasColumnName("created_at")`
2	`483`	`.HasDefaultValueSql("now()");`
2	`484`
2	`485`	`b.Property<string>("Email")`
2	`486`	`.IsRequired()`
2	`487`	`.HasMaxLength(256)`
2	`488`	`.HasColumnType("character varying(256)")`
2	`489`	`.HasColumnName("email");`
2	`490`
2	`491`	`b.Property<DateTime>("ExpiresAt")`
2	`492`	`.HasColumnType("timestamp with time zone")`
2	`493`	`.HasColumnName("expires_at");`
2	`494`
2	`495`	`b.Property<int>("FailedAttempts")`
2	`496`	`.ValueGeneratedOnAdd()`
2	`497`	`.HasColumnType("integer")`
2	`498`	`.HasDefaultValue(0)`
2	`499`	`.HasColumnName("failed_attempts");`
2	`500`
2	`501`	`b.Property<string>("Name")`
2	`502`	`.IsRequired()`
2	`503`	`.HasMaxLength(200)`
2	`504`	`.HasColumnType("character varying(200)")`
2	`505`	`.HasColumnName("name");`
2	`506`
2	`507`	`b.Property<byte[]>("PasswordHash")`
2	`508`	`.IsRequired()`
2	`509`	`.HasColumnType("bytea")`
2	`510`	`.HasColumnName("password_hash");`
2	`511`
2	`512`	`b.Property<Guid>("PublicId")`
2	`513`	`.HasColumnType("uuid")`
2	`514`	`.HasColumnName("public_id");`
2	`515`
2	`516`	`b.Property<byte[]>("Salt")`
2	`517`	`.IsRequired()`
2	`518`	`.HasColumnType("bytea")`
2	`519`	`.HasColumnName("salt");`
2	`520`
2	`521`	`b.Property<long>("ScopeId")`
2	`522`	`.HasColumnType("bigint")`
2	`523`	`.HasColumnName("scope_id");`
2	`524`
2	`525`	`b.Property<string>("TokenHash")`
2	`526`	`.IsRequired()`
2	`527`	`.HasMaxLength(64)`
2	`528`	`.HasColumnType("character varying(64)")`
2	`529`	`.HasColumnName("token_hash");`
2	`530`
2	`531`	`b.HasKey("Id")`
2	`532`	`.HasName("pk_pending_registration");`
2	`533`
2	`534`	`b.HasIndex("PublicId")`
2	`535`	`.IsUnique()`
2	`536`	`.HasDatabaseName("ix_pending_registration_public_id");`
2	`537`
2	`538`	`b.HasIndex("ScopeId")`
2	`539`	`.HasDatabaseName("ix_pending_registration_scope_id");`
2	`540`
2	`541`	`b.HasIndex("TokenHash")`
2	`542`	`.IsUnique()`
2	`543`	`.HasDatabaseName("ix_pending_registration_token_hash");`
2	`544`
2	`545`	`b.ToTable("pending_registration", "heimdall");`
4	`546`	`});`
	`547`
2	`548`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Person", b =>`
2	`549`	`{`
2	`550`	`b.Property<long>("Id")`
2	`551`	`.ValueGeneratedOnAdd()`
2	`552`	`.HasColumnType("bigint")`
2	`553`	`.HasColumnName("id")`
2	`554`	`.HasColumnOrder(1);`
2	`555`
2	`556`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`557`
2	`558`	`b.Property<DateTime?>("AnonymisedAt")`
2	`559`	`.HasColumnType("timestamp with time zone")`
2	`560`	`.HasColumnName("anonymised_at");`
2	`561`
2	`562`	`b.Property<DateTime?>("BasisRecordedAt")`
2	`563`	`.HasColumnType("timestamp with time zone")`
2	`564`	`.HasColumnName("basis_recorded_at");`
2	`565`
2	`566`	`b.Property<DateTime>("CreatedAt")`
2	`567`	`.ValueGeneratedOnAdd()`
2	`568`	`.HasColumnType("timestamp with time zone")`
2	`569`	`.HasColumnName("created_at")`
2	`570`	`.HasDefaultValueSql("now()");`
2	`571`
2	`572`	`b.Property<DateTime?>("DeletedAt")`
2	`573`	`.HasColumnType("timestamp with time zone")`
2	`574`	`.HasColumnName("deleted_at");`
2	`575`
2	`576`	`b.Property<int?>("DeletionKind")`
2	`577`	`.HasColumnType("integer")`
2	`578`	`.HasColumnName("deletion_kind");`
2	`579`
2	`580`	`b.Property<string>("Email")`
2	`581`	`.IsRequired()`
2	`582`	`.HasMaxLength(256)`
2	`583`	`.HasColumnType("character varying(256)")`
2	`584`	`.HasColumnName("email");`
2	`585`
2	`586`	`b.Property<bool>("EmailVerified")`
2	`587`	`.ValueGeneratedOnAdd()`
2	`588`	`.HasColumnType("boolean")`
2	`589`	`.HasDefaultValue(false)`
2	`590`	`.HasColumnName("email_verified");`
2	`591`
2	`592`	`b.Property<string>("ErasureBlockedReason")`
2	`593`	`.HasMaxLength(500)`
2	`594`	`.HasColumnType("character varying(500)")`
2	`595`	`.HasColumnName("erasure_blocked_reason");`
2	`596`
2	`597`	`b.Property<DateTime?>("ErasureDueAt")`
2	`598`	`.HasColumnType("timestamp with time zone")`
2	`599`	`.HasColumnName("erasure_due_at");`
2	`600`
2	`601`	`b.Property<DateTime?>("ErasureRequestedAt")`
2	`602`	`.HasColumnType("timestamp with time zone")`
2	`603`	`.HasColumnName("erasure_requested_at");`
2	`604`
2	`605`	`b.Property<int>("FailedLoginAttempts")`
2	`606`	`.HasColumnType("integer")`
2	`607`	`.HasColumnName("failed_login_attempts");`
2	`608`
2	`609`	`b.Property<bool>("IsDeleted")`
2	`610`	`.ValueGeneratedOnAdd()`
2	`611`	`.HasColumnType("boolean")`
2	`612`	`.HasDefaultValue(false)`
2	`613`	`.HasColumnName("is_deleted");`
2	`614`
2	`615`	`b.Property<int>("LegalBasis")`
2	`616`	`.ValueGeneratedOnAdd()`
2	`617`	`.HasColumnType("integer")`
2	`618`	`.HasDefaultValue(0)`
2	`619`	`.HasColumnName("legal_basis");`
2	`620`
2	`621`	`b.Property<DateTime?>("LockedOutUntil")`
2	`622`	`.HasColumnType("timestamp with time zone")`
2	`623`	`.HasColumnName("locked_out_until");`
2	`624`
2	`625`	`b.Property<string>("Name")`
2	`626`	`.IsRequired()`
2	`627`	`.HasMaxLength(200)`
2	`628`	`.HasColumnType("character varying(200)")`
2	`629`	`.HasColumnName("name");`
2	`630`
2	`631`	`b.Property<byte[]>("PasswordHash")`
2	`632`	`.IsRequired()`
2	`633`	`.HasColumnType("bytea")`
2	`634`	`.HasColumnName("password_hash");`
2	`635`
2	`636`	`b.Property<string>("PrivacyNoticeVersion")`
2	`637`	`.HasMaxLength(50)`
2	`638`	`.HasColumnType("character varying(50)")`
2	`639`	`.HasColumnName("privacy_notice_version");`
2	`640`
2	`641`	`b.Property<DateTime?>("ProcessingRestrictedAt")`
2	`642`	`.HasColumnType("timestamp with time zone")`
2	`643`	`.HasColumnName("processing_restricted_at");`
2	`644`
2	`645`	`b.Property<Guid>("PublicId")`
2	`646`	`.HasColumnType("uuid")`
2	`647`	`.HasColumnName("public_id");`
2	`648`
2	`649`	`b.Property<int?>("RestrictionGround")`
2	`650`	`.HasColumnType("integer")`
2	`651`	`.HasColumnName("restriction_ground");`
2	`652`
2	`653`	`b.Property<DateTime?>("RestrictionLiftNotifiedAt")`
2	`654`	`.HasColumnType("timestamp with time zone")`
2	`655`	`.HasColumnName("restriction_lift_notified_at");`
2	`656`
2	`657`	`b.Property<long>("RoleId")`
2	`658`	`.HasColumnType("bigint")`
2	`659`	`.HasColumnName("role_id");`
2	`660`
2	`661`	`b.Property<byte[]>("Salt")`
2	`662`	`.IsRequired()`
2	`663`	`.HasColumnType("bytea")`
2	`664`	`.HasColumnName("salt");`
2	`665`
2	`666`	`b.Property<long?>("ScopeId")`
2	`667`	`.HasColumnType("bigint")`
2	`668`	`.HasColumnName("scope_id");`
2	`669`
2	`670`	`b.Property<Guid>("SecurityStamp")`
2	`671`	`.ValueGeneratedOnAdd()`
2	`672`	`.HasColumnType("uuid")`
2	`673`	`.HasColumnName("security_stamp")`
2	`674`	`.HasDefaultValueSql("gen_random_uuid()");`
2	`675`
2	`676`	`b.Property<DateTime>("UpdatedAt")`
2	`677`	`.ValueGeneratedOnAdd()`
2	`678`	`.HasColumnType("timestamp with time zone")`
2	`679`	`.HasColumnName("updated_at")`
2	`680`	`.HasDefaultValueSql("now()");`
2	`681`
2	`682`	`b.HasKey("Id")`
2	`683`	`.HasName("pk_person");`
2	`684`
2	`685`	`b.HasIndex("DeletedAt")`
2	`686`	`.HasDatabaseName("ix_person_deleted_at")`
2	`687`	`.HasFilter("is_deleted = true AND anonymised_at IS NULL");`
2	`688`
2	`689`	`b.HasIndex("Email")`
2	`690`	`.HasDatabaseName("ix_person_email");`
2	`691`
2	`692`	`b.HasIndex("ProcessingRestrictedAt")`
2	`693`	`.HasDatabaseName("ix_person_processing_restricted_at")`
2	`694`	`.HasFilter("processing_restricted_at IS NOT NULL");`
2	`695`
2	`696`	`b.HasIndex("PublicId")`
2	`697`	`.IsUnique()`
2	`698`	`.HasDatabaseName("ix_person_public_id");`
2	`699`
2	`700`	`b.HasIndex("RoleId")`
2	`701`	`.HasDatabaseName("ix_person_role_id");`
2	`702`
2	`703`	`b.ToTable("person", "heimdall");`
4	`704`	`});`
	`705`
2	`706`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Role", b =>`
2	`707`	`{`
2	`708`	`b.Property<long>("Id")`
2	`709`	`.HasColumnType("bigint")`
2	`710`	`.HasColumnName("id")`
2	`711`	`.HasColumnOrder(1);`
2	`712`
2	`713`	`b.Property<string>("Description")`
2	`714`	`.HasMaxLength(500)`
2	`715`	`.HasColumnType("character varying(500)")`
2	`716`	`.HasColumnName("description");`
2	`717`
2	`718`	`b.Property<string>("Name")`
2	`719`	`.IsRequired()`
2	`720`	`.HasMaxLength(200)`
2	`721`	`.HasColumnType("character varying(200)")`
2	`722`	`.HasColumnName("name");`
2	`723`
2	`724`	`b.Property<Guid>("PublicId")`
2	`725`	`.HasColumnType("uuid")`
2	`726`	`.HasColumnName("public_id");`
2	`727`
2	`728`	`b.HasKey("Id")`
2	`729`	`.HasName("pk_role");`
2	`730`
2	`731`	`b.HasIndex("Name")`
2	`732`	`.IsUnique()`
2	`733`	`.HasDatabaseName("ix_role_name");`
2	`734`
2	`735`	`b.HasIndex("PublicId")`
2	`736`	`.IsUnique()`
2	`737`	`.HasDatabaseName("ix_role_public_id");`
2	`738`
2	`739`	`b.ToTable("role", "heimdall");`
4	`740`	`});`
	`741`
2	`742`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Scope", b =>`
2	`743`	`{`
2	`744`	`b.Property<long>("Id")`
2	`745`	`.ValueGeneratedOnAdd()`
2	`746`	`.HasColumnType("bigint")`
2	`747`	`.HasColumnName("id")`
2	`748`	`.HasColumnOrder(1);`
2	`749`
2	`750`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`751`
2	`752`	`b.Property<DateTime>("CreatedAt")`
2	`753`	`.ValueGeneratedOnAdd()`
2	`754`	`.HasColumnType("timestamp with time zone")`
2	`755`	`.HasColumnName("created_at")`
2	`756`	`.HasDefaultValueSql("now()");`
2	`757`
2	`758`	`b.Property<int?>("DefaultLegalBasis")`
2	`759`	`.HasColumnType("integer")`
2	`760`	`.HasColumnName("default_legal_basis");`
2	`761`
2	`762`	`b.Property<string>("Description")`
2	`763`	`.HasMaxLength(500)`
2	`764`	`.HasColumnType("character varying(500)")`
2	`765`	`.HasColumnName("description");`
2	`766`
2	`767`	`b.Property<string>("EmailVerificationUrl")`
2	`768`	`.HasMaxLength(2048)`
2	`769`	`.HasColumnType("character varying(2048)")`
2	`770`	`.HasColumnName("email_verification_url");`
2	`771`
2	`772`	`b.Property<bool>("GoogleSignInEnabled")`
2	`773`	`.ValueGeneratedOnAdd()`
2	`774`	`.HasColumnType("boolean")`
2	`775`	`.HasDefaultValue(false)`
2	`776`	`.HasColumnName("google_sign_in_enabled");`
2	`777`
2	`778`	`b.Property<bool>("IsDeleted")`
2	`779`	`.ValueGeneratedOnAdd()`
2	`780`	`.HasColumnType("boolean")`
2	`781`	`.HasDefaultValue(false)`
2	`782`	`.HasColumnName("is_deleted");`
2	`783`
2	`784`	`b.Property<string>("Name")`
2	`785`	`.IsRequired()`
2	`786`	`.HasMaxLength(200)`
2	`787`	`.HasColumnType("character varying(200)")`
2	`788`	`.HasColumnName("name");`
2	`789`
2	`790`	`b.Property<string>("PasswordResetUrl")`
2	`791`	`.HasMaxLength(2048)`
2	`792`	`.HasColumnType("character varying(2048)")`
2	`793`	`.HasColumnName("password_reset_url");`
2	`794`
2	`795`	`b.Property<string>("PrivacyNoticeUri")`
2	`796`	`.HasMaxLength(2048)`
2	`797`	`.HasColumnType("character varying(2048)")`
2	`798`	`.HasColumnName("privacy_notice_uri");`
2	`799`
2	`800`	`b.Property<Guid>("PublicId")`
2	`801`	`.HasColumnType("uuid")`
2	`802`	`.HasColumnName("public_id");`
2	`803`
2	`804`	`b.Property<bool>("SelfRegistrationEnabled")`
2	`805`	`.ValueGeneratedOnAdd()`
2	`806`	`.HasColumnType("boolean")`
2	`807`	`.HasDefaultValue(false)`
2	`808`	`.HasColumnName("self_registration_enabled");`
2	`809`
2	`810`	`b.Property<DateTime>("UpdatedAt")`
2	`811`	`.ValueGeneratedOnAdd()`
2	`812`	`.HasColumnType("timestamp with time zone")`
2	`813`	`.HasColumnName("updated_at")`
2	`814`	`.HasDefaultValueSql("now()");`
2	`815`
2	`816`	`b.HasKey("Id")`
2	`817`	`.HasName("pk_scope");`
2	`818`
2	`819`	`b.HasIndex("Name")`
2	`820`	`.IsUnique()`
2	`821`	`.HasDatabaseName("ix_scope_name");`
2	`822`
2	`823`	`b.HasIndex("PublicId")`
2	`824`	`.IsUnique()`
2	`825`	`.HasDatabaseName("ix_scope_public_id");`
2	`826`
2	`827`	`b.ToTable("scope", "heimdall");`
4	`828`	`});`
	`829`
2	`830`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopeOwner", b =>`
2	`831`	`{`
2	`832`	`b.Property<long>("ScopeId")`
2	`833`	`.HasColumnType("bigint")`
2	`834`	`.HasColumnName("scope_id");`
2	`835`
2	`836`	`b.Property<long>("PersonId")`
2	`837`	`.HasColumnType("bigint")`
2	`838`	`.HasColumnName("person_id");`
2	`839`
2	`840`	`b.HasKey("ScopeId", "PersonId")`
2	`841`	`.HasName("pk_scope_owner");`
2	`842`
2	`843`	`b.HasIndex("PersonId")`
2	`844`	`.HasDatabaseName("ix_scope_owner_person_id");`
2	`845`
2	`846`	`b.ToTable("scope_owner", "heimdall");`
4	`847`	`});`
	`848`
2	`849`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopePermission", b =>`
2	`850`	`{`
2	`851`	`b.Property<long>("Id")`
2	`852`	`.ValueGeneratedOnAdd()`
2	`853`	`.HasColumnType("bigint")`
2	`854`	`.HasColumnName("id")`
2	`855`	`.HasColumnOrder(1);`
2	`856`
2	`857`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`858`
2	`859`	`b.Property<DateTime>("CreatedAt")`
2	`860`	`.ValueGeneratedOnAdd()`
2	`861`	`.HasColumnType("timestamp with time zone")`
2	`862`	`.HasColumnName("created_at")`
2	`863`	`.HasDefaultValueSql("now()");`
2	`864`
2	`865`	`b.Property<string>("Description")`
2	`866`	`.HasMaxLength(500)`
2	`867`	`.HasColumnType("character varying(500)")`
2	`868`	`.HasColumnName("description");`
2	`869`
2	`870`	`b.Property<bool>("IncludeAsJwtClaim")`
2	`871`	`.ValueGeneratedOnAdd()`
2	`872`	`.HasColumnType("boolean")`
2	`873`	`.HasDefaultValue(false)`
2	`874`	`.HasColumnName("include_as_jwt_claim");`
2	`875`
2	`876`	`b.Property<bool>("IsDeleted")`
2	`877`	`.ValueGeneratedOnAdd()`
2	`878`	`.HasColumnType("boolean")`
2	`879`	`.HasDefaultValue(false)`
2	`880`	`.HasColumnName("is_deleted");`
2	`881`
2	`882`	`b.Property<string>("Name")`
2	`883`	`.IsRequired()`
2	`884`	`.HasMaxLength(200)`
2	`885`	`.HasColumnType("character varying(200)")`
2	`886`	`.HasColumnName("name");`
2	`887`
2	`888`	`b.Property<Guid>("PublicId")`
2	`889`	`.HasColumnType("uuid")`
2	`890`	`.HasColumnName("public_id");`
2	`891`
2	`892`	`b.Property<long>("ScopeId")`
2	`893`	`.HasColumnType("bigint")`
2	`894`	`.HasColumnName("scope_id");`
2	`895`
2	`896`	`b.Property<DateTime>("UpdatedAt")`
2	`897`	`.ValueGeneratedOnAdd()`
2	`898`	`.HasColumnType("timestamp with time zone")`
2	`899`	`.HasColumnName("updated_at")`
2	`900`	`.HasDefaultValueSql("now()");`
2	`901`
2	`902`	`b.HasKey("Id")`
2	`903`	`.HasName("pk_scope_permission");`
2	`904`
2	`905`	`b.HasIndex("PublicId")`
2	`906`	`.IsUnique()`
2	`907`	`.HasDatabaseName("ix_scope_permission_public_id");`
2	`908`
2	`909`	`b.HasIndex("ScopeId")`
2	`910`	`.HasDatabaseName("ix_scope_permission_scope_id");`
2	`911`
2	`912`	`b.ToTable("scope_permission", "heimdall");`
4	`913`	`});`
	`914`
2	`915`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopeUser", b =>`
2	`916`	`{`
2	`917`	`b.Property<long>("ScopeId")`
2	`918`	`.HasColumnType("bigint")`
2	`919`	`.HasColumnName("scope_id");`
2	`920`
2	`921`	`b.Property<long>("PersonId")`
2	`922`	`.HasColumnType("bigint")`
2	`923`	`.HasColumnName("person_id");`
2	`924`
2	`925`	`b.HasKey("ScopeId", "PersonId")`
2	`926`	`.HasName("pk_scope_user");`
2	`927`
2	`928`	`b.HasIndex("PersonId")`
2	`929`	`.IsUnique()`
2	`930`	`.HasDatabaseName("ix_scope_user_person_id");`
2	`931`
2	`932`	`b.ToTable("scope_user", "heimdall");`
4	`933`	`});`
	`934`
2	`935`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", b =>`
2	`936`	`{`
2	`937`	`b.Property<long>("Id")`
2	`938`	`.ValueGeneratedOnAdd()`
2	`939`	`.HasColumnType("bigint")`
2	`940`	`.HasColumnName("id")`
2	`941`	`.HasColumnOrder(1);`
2	`942`
2	`943`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`944`
2	`945`	`b.Property<bool>("AppEnabled")`
2	`946`	`.ValueGeneratedOnAdd()`
2	`947`	`.HasColumnType("boolean")`
2	`948`	`.HasDefaultValue(false)`
2	`949`	`.HasColumnName("app_enabled");`
2	`950`
2	`951`	`b.Property<int>("ChallengeAttempts")`
2	`952`	`.ValueGeneratedOnAdd()`
2	`953`	`.HasColumnType("integer")`
2	`954`	`.HasDefaultValue(0)`
2	`955`	`.HasColumnName("challenge_attempts");`
2	`956`
2	`957`	`b.Property<Guid?>("ChallengeId")`
2	`958`	`.HasColumnType("uuid")`
2	`959`	`.HasColumnName("challenge_id");`
2	`960`
2	`961`	`b.Property<DateTime>("CreatedAt")`
2	`962`	`.ValueGeneratedOnAdd()`
2	`963`	`.HasColumnType("timestamp with time zone")`
2	`964`	`.HasColumnName("created_at")`
2	`965`	`.HasDefaultValueSql("now()");`
2	`966`
2	`967`	`b.Property<int>("EmailCodeReissueCount")`
2	`968`	`.ValueGeneratedOnAdd()`
2	`969`	`.HasColumnType("integer")`
2	`970`	`.HasDefaultValue(0)`
2	`971`	`.HasColumnName("email_code_reissue_count");`
2	`972`
2	`973`	`b.Property<bool>("EmailEnabled")`
2	`974`	`.ValueGeneratedOnAdd()`
2	`975`	`.HasColumnType("boolean")`
2	`976`	`.HasDefaultValue(false)`
2	`977`	`.HasColumnName("email_enabled");`
2	`978`
2	`979`	`b.Property<bool>("IsActive")`
2	`980`	`.ValueGeneratedOnAdd()`
2	`981`	`.HasColumnType("boolean")`
2	`982`	`.HasDefaultValue(false)`
2	`983`	`.HasColumnName("is_active");`
2	`984`
2	`985`	`b.Property<long?>("LastTotpTimeStepUsed")`
2	`986`	`.HasColumnType("bigint")`
2	`987`	`.HasColumnName("last_totp_time_step_used");`
2	`988`
2	`989`	`b.Property<long>("PersonId")`
2	`990`	`.HasColumnType("bigint")`
2	`991`	`.HasColumnName("person_id");`
2	`992`
2	`993`	`b.Property<byte[]>("TotpSecretEncrypted")`
2	`994`	`.HasColumnType("bytea")`
2	`995`	`.HasColumnName("totp_secret_encrypted");`
2	`996`
2	`997`	`b.Property<DateTime>("UpdatedAt")`
2	`998`	`.ValueGeneratedOnAdd()`
2	`999`	`.HasColumnType("timestamp with time zone")`
2	`1000`	`.HasColumnName("updated_at")`
2	`1001`	`.HasDefaultValueSql("now()");`
2	`1002`
2	`1003`	`b.HasKey("Id")`
2	`1004`	`.HasName("pk_two_factor_auth");`
2	`1005`
2	`1006`	`b.HasIndex("PersonId")`
2	`1007`	`.IsUnique()`
2	`1008`	`.HasDatabaseName("ix_two_factor_auth_person_id");`
2	`1009`
2	`1010`	`b.ToTable("two_factor_auth", "heimdall");`
4	`1011`	`});`
	`1012`
2	`1013`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorEmailCode", b =>`
2	`1014`	`{`
2	`1015`	`b.Property<long>("Id")`
2	`1016`	`.ValueGeneratedOnAdd()`
2	`1017`	`.HasColumnType("bigint")`
2	`1018`	`.HasColumnName("id")`
2	`1019`	`.HasColumnOrder(1);`
2	`1020`
2	`1021`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`1022`
2	`1023`	`b.Property<byte[]>("CodeHash")`
2	`1024`	`.IsRequired()`
2	`1025`	`.HasColumnType("bytea")`
2	`1026`	`.HasColumnName("code_hash");`
2	`1027`
2	`1028`	`b.Property<DateTime>("CreatedAt")`
2	`1029`	`.ValueGeneratedOnAdd()`
2	`1030`	`.HasColumnType("timestamp with time zone")`
2	`1031`	`.HasColumnName("created_at")`
2	`1032`	`.HasDefaultValueSql("now()");`
2	`1033`
2	`1034`	`b.Property<DateTime>("ExpiresAt")`
2	`1035`	`.HasColumnType("timestamp with time zone")`
2	`1036`	`.HasColumnName("expires_at");`
2	`1037`
2	`1038`	`b.Property<int>("FailedAttempts")`
2	`1039`	`.HasColumnType("integer")`
2	`1040`	`.HasColumnName("failed_attempts");`
2	`1041`
2	`1042`	`b.Property<byte[]>("Salt")`
2	`1043`	`.IsRequired()`
2	`1044`	`.HasColumnType("bytea")`
2	`1045`	`.HasColumnName("salt");`
2	`1046`
2	`1047`	`b.Property<long>("TwoFactorAuthId")`
2	`1048`	`.HasColumnType("bigint")`
2	`1049`	`.HasColumnName("two_factor_auth_id");`
2	`1050`
2	`1051`	`b.Property<bool>("Used")`
2	`1052`	`.ValueGeneratedOnAdd()`
2	`1053`	`.HasColumnType("boolean")`
2	`1054`	`.HasDefaultValue(false)`
2	`1055`	`.HasColumnName("used");`
2	`1056`
2	`1057`	`b.HasKey("Id")`
2	`1058`	`.HasName("pk_two_factor_email_code");`
2	`1059`
2	`1060`	`b.HasIndex("TwoFactorAuthId")`
2	`1061`	`.HasDatabaseName("ix_two_factor_email_code_two_factor_auth_id");`
2	`1062`
2	`1063`	`b.ToTable("two_factor_email_code", "heimdall");`
4	`1064`	`});`
	`1065`
2	`1066`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorRecoveryCode", b =>`
2	`1067`	`{`
2	`1068`	`b.Property<long>("Id")`
2	`1069`	`.ValueGeneratedOnAdd()`
2	`1070`	`.HasColumnType("bigint")`
2	`1071`	`.HasColumnName("id")`
2	`1072`	`.HasColumnOrder(1);`
2	`1073`
2	`1074`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`1075`
2	`1076`	`b.Property<byte[]>("CodeHash")`
2	`1077`	`.IsRequired()`
2	`1078`	`.HasColumnType("bytea")`
2	`1079`	`.HasColumnName("code_hash");`
2	`1080`
2	`1081`	`b.Property<DateTime>("CreatedAt")`
2	`1082`	`.ValueGeneratedOnAdd()`
2	`1083`	`.HasColumnType("timestamp with time zone")`
2	`1084`	`.HasColumnName("created_at")`
2	`1085`	`.HasDefaultValueSql("now()");`
2	`1086`
2	`1087`	`b.Property<long>("TwoFactorAuthId")`
2	`1088`	`.HasColumnType("bigint")`
2	`1089`	`.HasColumnName("two_factor_auth_id");`
2	`1090`
2	`1091`	`b.Property<bool>("Used")`
2	`1092`	`.ValueGeneratedOnAdd()`
2	`1093`	`.HasColumnType("boolean")`
2	`1094`	`.HasDefaultValue(false)`
2	`1095`	`.HasColumnName("used");`
2	`1096`
2	`1097`	`b.Property<DateTime?>("UsedAt")`
2	`1098`	`.HasColumnType("timestamp with time zone")`
2	`1099`	`.HasColumnName("used_at");`
2	`1100`
2	`1101`	`b.HasKey("Id")`
2	`1102`	`.HasName("pk_two_factor_recovery_code");`
2	`1103`
2	`1104`	`b.HasIndex("TwoFactorAuthId")`
2	`1105`	`.HasDatabaseName("ix_two_factor_recovery_code_two_factor_auth_id");`
2	`1106`
2	`1107`	`b.ToTable("two_factor_recovery_code", "heimdall");`
4	`1108`	`});`
	`1109`
2	`1110`	`modelBuilder.Entity("Microsoft.AspNetCore.DataProtection.EntityFrameworkCore.DataProtectionKey", b =>`
2	`1111`	`{`
2	`1112`	`b.Property<int>("Id")`
2	`1113`	`.ValueGeneratedOnAdd()`
2	`1114`	`.HasColumnType("integer")`
2	`1115`	`.HasColumnName("id");`
2	`1116`
2	`1117`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));`
2	`1118`
2	`1119`	`b.Property<string>("FriendlyName")`
2	`1120`	`.HasColumnType("text")`
2	`1121`	`.HasColumnName("friendly_name");`
2	`1122`
2	`1123`	`b.Property<string>("Xml")`
2	`1124`	`.HasColumnType("text")`
2	`1125`	`.HasColumnName("xml");`
2	`1126`
2	`1127`	`b.HasKey("Id")`
2	`1128`	`.HasName("pk_data_protection_keys");`
2	`1129`
2	`1130`	`b.ToTable("data_protection_keys", "heimdall");`
4	`1131`	`});`
	`1132`
2	`1133`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Application", b =>`
2	`1134`	`{`
2	`1135`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Owner")`
2	`1136`	`.WithMany("OwnedApplications")`
2	`1137`	`.HasForeignKey("OwnerId")`
2	`1138`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1139`	`.IsRequired()`
2	`1140`	`.HasConstraintName("fk_application_person_owner_id");`
2	`1141`
2	`1142`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")`
2	`1143`	`.WithMany("Applications")`
2	`1144`	`.HasForeignKey("ScopeId")`
2	`1145`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1146`	`.IsRequired()`
2	`1147`	`.HasConstraintName("fk_application_scope_scope_id");`
2	`1148`
2	`1149`	`b.Navigation("Owner");`
2	`1150`
2	`1151`	`b.Navigation("Scope");`
4	`1152`	`});`
	`1153`
2	`1154`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ApplicationCredential", b =>`
2	`1155`	`{`
2	`1156`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Application", "Application")`
2	`1157`	`.WithMany("Credentials")`
2	`1158`	`.HasForeignKey("ApplicationId")`
2	`1159`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1160`	`.IsRequired()`
2	`1161`	`.HasConstraintName("fk_application_credential_application_application_id");`
2	`1162`
2	`1163`	`b.Navigation("Application");`
4	`1164`	`});`
	`1165`
2	`1166`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.EmailVerificationToken", b =>`
2	`1167`	`{`
2	`1168`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")`
2	`1169`	`.WithMany("EmailVerificationTokens")`
2	`1170`	`.HasForeignKey("PersonId")`
2	`1171`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1172`	`.IsRequired()`
2	`1173`	`.HasConstraintName("fk_email_verification_token_person_person_id");`
2	`1174`
2	`1175`	`b.Navigation("Person");`
4	`1176`	`});`
	`1177`
2	`1178`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.GoogleUser", b =>`
2	`1179`	`{`
2	`1180`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")`
2	`1181`	`.WithMany("GoogleUsers")`
2	`1182`	`.HasForeignKey("ScopeId")`
2	`1183`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1184`	`.IsRequired()`
2	`1185`	`.HasConstraintName("fk_google_user_scope_scope_id");`
2	`1186`
2	`1187`	`b.Navigation("Scope");`
4	`1188`	`});`
	`1189`
2	`1190`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.PasswordResetToken", b =>`
2	`1191`	`{`
2	`1192`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")`
2	`1193`	`.WithMany("PasswordResetTokens")`
2	`1194`	`.HasForeignKey("PersonId")`
2	`1195`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1196`	`.IsRequired()`
2	`1197`	`.HasConstraintName("fk_password_reset_token_person_person_id");`
2	`1198`
2	`1199`	`b.Navigation("Person");`
4	`1200`	`});`
	`1201`
2	`1202`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.PendingRegistration", b =>`
2	`1203`	`{`
2	`1204`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")`
2	`1205`	`.WithMany()`
2	`1206`	`.HasForeignKey("ScopeId")`
2	`1207`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1208`	`.IsRequired()`
2	`1209`	`.HasConstraintName("fk_pending_registration_scope_scope_id");`
2	`1210`
2	`1211`	`b.Navigation("Scope");`
4	`1212`	`});`
	`1213`
2	`1214`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Person", b =>`
2	`1215`	`{`
2	`1216`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Role", "Role")`
2	`1217`	`.WithMany("Persons")`
2	`1218`	`.HasForeignKey("RoleId")`
2	`1219`	`.OnDelete(DeleteBehavior.Restrict)`
2	`1220`	`.IsRequired()`
2	`1221`	`.HasConstraintName("fk_person_roles_role_id");`
2	`1222`
2	`1223`	`b.Navigation("Role");`
4	`1224`	`});`
	`1225`
2	`1226`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopeOwner", b =>`
2	`1227`	`{`
2	`1228`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")`
2	`1229`	`.WithMany("ScopeOwnerships")`
2	`1230`	`.HasForeignKey("PersonId")`
2	`1231`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1232`	`.IsRequired()`
2	`1233`	`.HasConstraintName("fk_scope_owner_person_person_id");`
2	`1234`
2	`1235`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")`
2	`1236`	`.WithMany("Owners")`
2	`1237`	`.HasForeignKey("ScopeId")`
2	`1238`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1239`	`.IsRequired()`
2	`1240`	`.HasConstraintName("fk_scope_owner_scope_scope_id");`
2	`1241`
2	`1242`	`b.Navigation("Person");`
2	`1243`
2	`1244`	`b.Navigation("Scope");`
4	`1245`	`});`
	`1246`
2	`1247`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopePermission", b =>`
2	`1248`	`{`
2	`1249`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")`
2	`1250`	`.WithMany("ScopePermissions")`
2	`1251`	`.HasForeignKey("ScopeId")`
2	`1252`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1253`	`.IsRequired()`
2	`1254`	`.HasConstraintName("fk_scope_permission_scope_scope_id");`
2	`1255`
2	`1256`	`b.Navigation("Scope");`
4	`1257`	`});`
	`1258`
2	`1259`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopeUser", b =>`
2	`1260`	`{`
2	`1261`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")`
2	`1262`	`.WithOne("ScopeMembership")`
2	`1263`	`.HasForeignKey("ArturRios.Heimdall.Domain.Entities.ScopeUser", "PersonId")`
2	`1264`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1265`	`.IsRequired()`
2	`1266`	`.HasConstraintName("fk_scope_user_person_person_id");`
2	`1267`
2	`1268`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")`
2	`1269`	`.WithMany("Users")`
2	`1270`	`.HasForeignKey("ScopeId")`
2	`1271`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1272`	`.IsRequired()`
2	`1273`	`.HasConstraintName("fk_scope_user_scope_scope_id");`
2	`1274`
2	`1275`	`b.Navigation("Person");`
2	`1276`
2	`1277`	`b.Navigation("Scope");`
4	`1278`	`});`
	`1279`
2	`1280`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", b =>`
2	`1281`	`{`
2	`1282`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")`
2	`1283`	`.WithOne("TwoFactorAuth")`
2	`1284`	`.HasForeignKey("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", "PersonId")`
2	`1285`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1286`	`.IsRequired()`
2	`1287`	`.HasConstraintName("fk_two_factor_auth_person_person_id");`
2	`1288`
2	`1289`	`b.Navigation("Person");`
4	`1290`	`});`
	`1291`
2	`1292`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorEmailCode", b =>`
2	`1293`	`{`
2	`1294`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", "TwoFactorAuth")`
2	`1295`	`.WithMany("EmailCodes")`
2	`1296`	`.HasForeignKey("TwoFactorAuthId")`
2	`1297`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1298`	`.IsRequired()`
2	`1299`	`.HasConstraintName("fk_two_factor_email_code_two_factor_auth_two_factor_auth_id");`
2	`1300`
2	`1301`	`b.Navigation("TwoFactorAuth");`
4	`1302`	`});`
	`1303`
2	`1304`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorRecoveryCode", b =>`
2	`1305`	`{`
2	`1306`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", "TwoFactorAuth")`
2	`1307`	`.WithMany("RecoveryCodes")`
2	`1308`	`.HasForeignKey("TwoFactorAuthId")`
2	`1309`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1310`	`.IsRequired()`
2	`1311`	`.HasConstraintName("fk_two_factor_recovery_code_two_factor_auth_two_factor_auth_id");`
2	`1312`
2	`1313`	`b.Navigation("TwoFactorAuth");`
4	`1314`	`});`
	`1315`
2	`1316`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Application", b =>`
2	`1317`	`{`
2	`1318`	`b.Navigation("Credentials");`
4	`1319`	`});`
	`1320`
2	`1321`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Person", b =>`
2	`1322`	`{`
2	`1323`	`b.Navigation("EmailVerificationTokens");`
2	`1324`
2	`1325`	`b.Navigation("OwnedApplications");`
2	`1326`
2	`1327`	`b.Navigation("PasswordResetTokens");`
2	`1328`
2	`1329`	`b.Navigation("ScopeMembership");`
2	`1330`
2	`1331`	`b.Navigation("ScopeOwnerships");`
2	`1332`
2	`1333`	`b.Navigation("TwoFactorAuth");`
4	`1334`	`});`
	`1335`
2	`1336`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Role", b =>`
2	`1337`	`{`
2	`1338`	`b.Navigation("Persons");`
4	`1339`	`});`
	`1340`
2	`1341`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Scope", b =>`
2	`1342`	`{`
2	`1343`	`b.Navigation("Applications");`
2	`1344`
2	`1345`	`b.Navigation("GoogleUsers");`
2	`1346`
2	`1347`	`b.Navigation("Owners");`
2	`1348`
2	`1349`	`b.Navigation("ScopePermissions");`
2	`1350`
2	`1351`	`b.Navigation("Users");`
4	`1352`	`});`
	`1353`
2	`1354`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", b =>`
2	`1355`	`{`
2	`1356`	`b.Navigation("EmailCodes");`
2	`1357`
2	`1358`	`b.Navigation("RecoveryCodes");`
4	`1359`	`});`
	`1360`	`#pragma warning restore 612, 618`
2	`1361`	`}`
	`1362`	`}`
	`1363`	`}`

< Summary - Heimdall API

Metrics

File(s)

/home/runner/work/heimdall-api/heimdall-api/src/Infrastructure/ArturRios.Heimdall.Data/Migrations/20261015115923_AddPersonSecurityStamp.cs

/home/runner/work/heimdall-api/heimdall-api/src/Infrastructure/ArturRios.Heimdall.Data/Migrations/20261015115923_AddPersonSecurityStamp.Designer.cs

Methods/Properties