< Summary - Heimdall API

Information

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

Line coverage

98%

Covered lines:	1065
Uncovered lines:	11
Coverable lines:	1076
Total lines:	1182
Line coverage:	98.9%

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/20260909182313_AllowClearingAuditActor.cs

#	Line	Line coverage
	`1`	`using Microsoft.EntityFrameworkCore.Migrations;`
	`2`
	`3`	`#nullable disable`
	`4`
	`5`	`namespace ArturRios.Heimdall.Data.Migrations`
	`6`	`{`
	`7`	`/// <summary>`
	`8`	`/// Narrows the audit log's append-only rule by exactly one permitted change: the actor`
	`9`	`/// attribution may be cleared once it is due (NFR-21).`
	`10`	`/// </summary>`
	`11`	`/// <remarks>`
	`12`	`/// <para>`
	`13`	/// `MakeAuditLogAppendOnly` refused every UPDATE, DELETE and TRUNCATE, which closed
	`14`	/// Threat Model TH-18 and also made erasure impossible: `actor_person_id` holds a
	`15`	/// person's `PublicId`, so an indefinitely retained, unalterable row naming an erased
	`16`	`/// person is personal data processed with no remaining basis.`
	`17`	`/// </para>`
	`18`	`/// <para>`
	`19`	`/// Rather than dropping the guarantee, this narrows it. DELETE and TRUNCATE stay refused`
	`20`	`/// outright. UPDATE becomes row-level and is permitted only when every column except`
	`21`	/// `actor_person_id` and `actor_role` is unchanged, the attribution is being set to
	`22`	`/// NULL rather than to somebody else, and the clearing is due. The resulting rule is`
	`23`	`/// precise: <b>an action can never be denied, and who took it can never be reassigned —`
	`24`	`/// only forgotten, on schedule or on erasure.</b>`
	`25`	`/// </para>`
	`26`	`/// <para>`
	`27`	`/// "Due" means the entry is older than a thirty-day floor, or the identity it names has`
	`28`	`/// been anonymised. The floor is an anti-tamper backstop rather than a retention policy:`
	`29`	`/// the retention period is configuration and is far longer, and the floor exists so that`
	`30`	`/// somebody who has just acted cannot immediately erase their own attribution. The`
	`31`	`/// erasure branch carries no age condition, because a subject-requested erasure completes`
	`32`	`/// thirty days after the request and their most recent entries must go with them.`
	`33`	`/// </para>`
	`34`	`/// </remarks>`
	`35`	`public partial class AllowClearingAuditActor : Migration`
	`36`	`{`
	`37`	`/// <inheritdoc />`
	`38`	`protected override void Up(MigrationBuilder migrationBuilder)`
	`39`	`{`
4	`40`	`migrationBuilder.Sql(`
4	`41`	`"""`
4	`42`	`CREATE OR REPLACE FUNCTION heimdall.audit_log_actor_clear_only()`
4	`43`	`RETURNS TRIGGER AS $$`
4	`44`	`DECLARE`
4	`45`	`actor_erased boolean;`
4	`46`	`BEGIN`
4	`47`	`-- Everything but the attribution is immutable. Checked first, so an attempt to`
4	`48`	`-- rewrite what happened is refused with that reason rather than a later one.`
4	`49`	`IF NEW.public_id IS DISTINCT FROM OLD.public_id`
4	`50`	`OR NEW.action IS DISTINCT FROM OLD.action`
4	`51`	`OR NEW.target_id IS DISTINCT FROM OLD.target_id`
4	`52`	`OR NEW.succeeded IS DISTINCT FROM OLD.succeeded`
4	`53`	`OR NEW.failure_reason IS DISTINCT FROM OLD.failure_reason`
4	`54`	`OR NEW.created_at IS DISTINCT FROM OLD.created_at`
4	`55`	`THEN`
4	`56`	`RAISE EXCEPTION`
4	`57`	`'heimdall.audit_log is append-only: only the actor attribution may be cleared'`
4	`58`	`USING ERRCODE = 'restrict_violation';`
4	`59`	`END IF;`
4	`60`
4	`61`	`-- Cleared, never reassigned. Without this the trail could be made to say that`
4	`62`	`-- somebody else took the action, which is worse than it not saying who did.`
4	`63`	`IF NEW.actor_person_id IS NOT NULL OR NEW.actor_role IS NOT NULL THEN`
4	`64`	`RAISE EXCEPTION`
4	`65`	`'heimdall.audit_log actor attribution may be cleared but not reassigned'`
4	`66`	`USING ERRCODE = 'restrict_violation';`
4	`67`	`END IF;`
4	`68`
4	`69`	`-- Already clear: a no-op write, permitted so a re-run is not an error.`
4	`70`	`IF OLD.actor_person_id IS NULL AND OLD.actor_role IS NULL THEN`
4	`71`	`RETURN NEW;`
4	`72`	`END IF;`
4	`73`
4	`74`	`SELECT EXISTS (`
4	`75`	`SELECT 1 FROM heimdall.person p`
4	`76`	`WHERE p.public_id = OLD.actor_person_id AND p.anonymised_at IS NOT NULL`
4	`77`	`UNION ALL`
4	`78`	`SELECT 1 FROM heimdall.google_user g`
4	`79`	`WHERE g.public_id = OLD.actor_person_id AND g.anonymised_at IS NOT NULL`
4	`80`	`) INTO actor_erased;`
4	`81`
4	`82`	`IF actor_erased OR OLD.created_at <= now() - interval '30 days' THEN`
4	`83`	`RETURN NEW;`
4	`84`	`END IF;`
4	`85`
4	`86`	`RAISE EXCEPTION`
4	`87`	`'heimdall.audit_log actor attribution is not yet due to be cleared'`
4	`88`	`USING ERRCODE = 'restrict_violation';`
4	`89`	`END;`
4	`90`	`$$ LANGUAGE plpgsql;`
4	`91`	`""");`
	`92`
	`93`	`// The statement-level UPDATE trigger goes: the rule is now about which row-level change`
	`94`	`// is being made, which a statement-level trigger cannot see.`
4	`95`	`migrationBuilder.Sql("DROP TRIGGER IF EXISTS audit_log_no_update ON heimdall.audit_log;");`
	`96`
4	`97`	`migrationBuilder.Sql(`
4	`98`	`"""`
4	`99`	`CREATE TRIGGER audit_log_actor_clear_only`
4	`100`	`BEFORE UPDATE ON heimdall.audit_log`
4	`101`	`FOR EACH ROW EXECUTE FUNCTION heimdall.audit_log_actor_clear_only();`
4	`102`	`""");`
4	`103`	`}`
	`104`
	`105`	`/// <inheritdoc />`
	`106`	`protected override void Down(MigrationBuilder migrationBuilder)`
	`107`	`{`
0	`108`	`migrationBuilder.Sql(`
0	`109`	`"DROP TRIGGER IF EXISTS audit_log_actor_clear_only ON heimdall.audit_log;");`
0	`110`	`migrationBuilder.Sql(`
0	`111`	`"DROP FUNCTION IF EXISTS heimdall.audit_log_actor_clear_only();");`
	`112`
	`113`	`// Back to refusing every UPDATE.`
0	`114`	`migrationBuilder.Sql(`
0	`115`	`"""`
0	`116`	`CREATE TRIGGER audit_log_no_update`
0	`117`	`BEFORE UPDATE ON heimdall.audit_log`
0	`118`	`FOR EACH STATEMENT EXECUTE FUNCTION heimdall.audit_log_is_append_only();`
0	`119`	`""");`
0	`120`	`}`
	`121`	`}`
	`122`	`}`

/home/runner/work/heimdall-api/heimdall-api/src/Infrastructure/ArturRios.Heimdall.Data/Migrations/20260909182313_AllowClearingAuditActor.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("20260909182313_AllowClearingAuditActor")]`
	`16`	`partial class AllowClearingAuditActor`
	`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.11")`
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.AuditLog", 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<string>("Action")`
2	`102`	`.IsRequired()`
2	`103`	`.HasMaxLength(200)`
2	`104`	`.HasColumnType("character varying(200)")`
2	`105`	`.HasColumnName("action");`
2	`106`
2	`107`	`b.Property<Guid?>("ActorPersonId")`
2	`108`	`.HasColumnType("uuid")`
2	`109`	`.HasColumnName("actor_person_id");`
2	`110`
2	`111`	`b.Property<int?>("ActorRole")`
2	`112`	`.HasColumnType("integer")`
2	`113`	`.HasColumnName("actor_role");`
2	`114`
2	`115`	`b.Property<DateTime>("CreatedAt")`
2	`116`	`.ValueGeneratedOnAdd()`
2	`117`	`.HasColumnType("timestamp with time zone")`
2	`118`	`.HasColumnName("created_at")`
2	`119`	`.HasDefaultValueSql("now()");`
2	`120`
2	`121`	`b.Property<string>("FailureReason")`
2	`122`	`.HasMaxLength(500)`
2	`123`	`.HasColumnType("character varying(500)")`
2	`124`	`.HasColumnName("failure_reason");`
2	`125`
2	`126`	`b.Property<Guid>("PublicId")`
2	`127`	`.HasColumnType("uuid")`
2	`128`	`.HasColumnName("public_id");`
2	`129`
2	`130`	`b.Property<bool>("Succeeded")`
2	`131`	`.HasColumnType("boolean")`
2	`132`	`.HasColumnName("succeeded");`
2	`133`
2	`134`	`b.Property<Guid?>("TargetId")`
2	`135`	`.HasColumnType("uuid")`
2	`136`	`.HasColumnName("target_id");`
2	`137`
2	`138`	`b.HasKey("Id")`
2	`139`	`.HasName("pk_audit_log");`
2	`140`
2	`141`	`b.HasIndex("ActorPersonId")`
2	`142`	`.HasDatabaseName("ix_audit_log_actor_person_id");`
2	`143`
2	`144`	`b.HasIndex("CreatedAt")`
2	`145`	`.HasDatabaseName("ix_audit_log_created_at");`
2	`146`
2	`147`	`b.HasIndex("PublicId")`
2	`148`	`.IsUnique()`
2	`149`	`.HasDatabaseName("ix_audit_log_public_id");`
2	`150`
2	`151`	`b.ToTable("audit_log", "heimdall");`
4	`152`	`});`
	`153`
2	`154`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.EmailVerificationToken", b =>`
2	`155`	`{`
2	`156`	`b.Property<long>("Id")`
2	`157`	`.ValueGeneratedOnAdd()`
2	`158`	`.HasColumnType("bigint")`
2	`159`	`.HasColumnName("id")`
2	`160`	`.HasColumnOrder(1);`
2	`161`
2	`162`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`163`
2	`164`	`b.Property<DateTime>("ExpiresAt")`
2	`165`	`.HasColumnType("timestamp with time zone")`
2	`166`	`.HasColumnName("expires_at");`
2	`167`
2	`168`	`b.Property<long>("PersonId")`
2	`169`	`.HasColumnType("bigint")`
2	`170`	`.HasColumnName("person_id");`
2	`171`
2	`172`	`b.Property<string>("TokenHash")`
2	`173`	`.IsRequired()`
2	`174`	`.HasMaxLength(64)`
2	`175`	`.HasColumnType("character varying(64)")`
2	`176`	`.HasColumnName("token_hash");`
2	`177`
2	`178`	`b.Property<bool>("Used")`
2	`179`	`.ValueGeneratedOnAdd()`
2	`180`	`.HasColumnType("boolean")`
2	`181`	`.HasDefaultValue(false)`
2	`182`	`.HasColumnName("used");`
2	`183`
2	`184`	`b.HasKey("Id")`
2	`185`	`.HasName("pk_email_verification_token");`
2	`186`
2	`187`	`b.HasIndex("PersonId")`
2	`188`	`.HasDatabaseName("ix_email_verification_token_person_id");`
2	`189`
2	`190`	`b.HasIndex("TokenHash")`
2	`191`	`.IsUnique()`
2	`192`	`.HasDatabaseName("ix_email_verification_token_token_hash");`
2	`193`
2	`194`	`b.ToTable("email_verification_token", "heimdall");`
4	`195`	`});`
	`196`
2	`197`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.GoogleUser", b =>`
2	`198`	`{`
2	`199`	`b.Property<long>("Id")`
2	`200`	`.ValueGeneratedOnAdd()`
2	`201`	`.HasColumnType("bigint")`
2	`202`	`.HasColumnName("id")`
2	`203`	`.HasColumnOrder(1);`
2	`204`
2	`205`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`206`
2	`207`	`b.Property<DateTime?>("AnonymisedAt")`
2	`208`	`.HasColumnType("timestamp with time zone")`
2	`209`	`.HasColumnName("anonymised_at");`
2	`210`
2	`211`	`b.Property<DateTime>("CreatedAt")`
2	`212`	`.ValueGeneratedOnAdd()`
2	`213`	`.HasColumnType("timestamp with time zone")`
2	`214`	`.HasColumnName("created_at")`
2	`215`	`.HasDefaultValueSql("now()");`
2	`216`
2	`217`	`b.Property<DateTime?>("DeletedAt")`
2	`218`	`.HasColumnType("timestamp with time zone")`
2	`219`	`.HasColumnName("deleted_at");`
2	`220`
2	`221`	`b.Property<int?>("DeletionKind")`
2	`222`	`.HasColumnType("integer")`
2	`223`	`.HasColumnName("deletion_kind");`
2	`224`
2	`225`	`b.Property<string>("Email")`
2	`226`	`.IsRequired()`
2	`227`	`.HasMaxLength(256)`
2	`228`	`.HasColumnType("character varying(256)")`
2	`229`	`.HasColumnName("email");`
2	`230`
2	`231`	`b.Property<bool>("EmailVerified")`
2	`232`	`.ValueGeneratedOnAdd()`
2	`233`	`.HasColumnType("boolean")`
2	`234`	`.HasDefaultValue(false)`
2	`235`	`.HasColumnName("email_verified");`
2	`236`
2	`237`	`b.Property<string>("ErasureBlockedReason")`
2	`238`	`.HasMaxLength(500)`
2	`239`	`.HasColumnType("character varying(500)")`
2	`240`	`.HasColumnName("erasure_blocked_reason");`
2	`241`
2	`242`	`b.Property<DateTime?>("ErasureDueAt")`
2	`243`	`.HasColumnType("timestamp with time zone")`
2	`244`	`.HasColumnName("erasure_due_at");`
2	`245`
2	`246`	`b.Property<DateTime?>("ErasureRequestedAt")`
2	`247`	`.HasColumnType("timestamp with time zone")`
2	`248`	`.HasColumnName("erasure_requested_at");`
2	`249`
2	`250`	`b.Property<string>("GoogleId")`
2	`251`	`.IsRequired()`
2	`252`	`.HasMaxLength(255)`
2	`253`	`.HasColumnType("character varying(255)")`
2	`254`	`.HasColumnName("google_id");`
2	`255`
2	`256`	`b.Property<bool>("IsDeleted")`
2	`257`	`.ValueGeneratedOnAdd()`
2	`258`	`.HasColumnType("boolean")`
2	`259`	`.HasDefaultValue(false)`
2	`260`	`.HasColumnName("is_deleted");`
2	`261`
2	`262`	`b.Property<string>("Name")`
2	`263`	`.IsRequired()`
2	`264`	`.HasMaxLength(200)`
2	`265`	`.HasColumnType("character varying(200)")`
2	`266`	`.HasColumnName("name");`
2	`267`
2	`268`	`b.Property<string>("ProfilePictureUrl")`
2	`269`	`.HasMaxLength(2048)`
2	`270`	`.HasColumnType("character varying(2048)")`
2	`271`	`.HasColumnName("profile_picture_url");`
2	`272`
2	`273`	`b.Property<Guid>("PublicId")`
2	`274`	`.HasColumnType("uuid")`
2	`275`	`.HasColumnName("public_id");`
2	`276`
2	`277`	`b.Property<long>("ScopeId")`
2	`278`	`.HasColumnType("bigint")`
2	`279`	`.HasColumnName("scope_id");`
2	`280`
2	`281`	`b.Property<DateTime>("UpdatedAt")`
2	`282`	`.ValueGeneratedOnAdd()`
2	`283`	`.HasColumnType("timestamp with time zone")`
2	`284`	`.HasColumnName("updated_at")`
2	`285`	`.HasDefaultValueSql("now()");`
2	`286`
2	`287`	`b.HasKey("Id")`
2	`288`	`.HasName("pk_google_user");`
2	`289`
2	`290`	`b.HasIndex("DeletedAt")`
2	`291`	`.HasDatabaseName("ix_google_user_deleted_at")`
2	`292`	`.HasFilter("is_deleted = true AND anonymised_at IS NULL");`
2	`293`
2	`294`	`b.HasIndex("PublicId")`
2	`295`	`.IsUnique()`
2	`296`	`.HasDatabaseName("ix_google_user_public_id");`
2	`297`
2	`298`	`b.HasIndex("ScopeId", "Email")`
2	`299`	`.IsUnique()`
2	`300`	`.HasDatabaseName("ix_google_user_scope_id_email");`
2	`301`
2	`302`	`b.HasIndex("ScopeId", "GoogleId")`
2	`303`	`.IsUnique()`
2	`304`	`.HasDatabaseName("ix_google_user_scope_id_google_id");`
2	`305`
2	`306`	`b.ToTable("google_user", "heimdall");`
4	`307`	`});`
	`308`
2	`309`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.PasswordResetToken", b =>`
2	`310`	`{`
2	`311`	`b.Property<long>("Id")`
2	`312`	`.ValueGeneratedOnAdd()`
2	`313`	`.HasColumnType("bigint")`
2	`314`	`.HasColumnName("id")`
2	`315`	`.HasColumnOrder(1);`
2	`316`
2	`317`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`318`
2	`319`	`b.Property<DateTime>("ExpiresAt")`
2	`320`	`.HasColumnType("timestamp with time zone")`
2	`321`	`.HasColumnName("expires_at");`
2	`322`
2	`323`	`b.Property<long>("PersonId")`
2	`324`	`.HasColumnType("bigint")`
2	`325`	`.HasColumnName("person_id");`
2	`326`
2	`327`	`b.Property<string>("TokenHash")`
2	`328`	`.IsRequired()`
2	`329`	`.HasMaxLength(64)`
2	`330`	`.HasColumnType("character varying(64)")`
2	`331`	`.HasColumnName("token_hash");`
2	`332`
2	`333`	`b.Property<bool>("Used")`
2	`334`	`.ValueGeneratedOnAdd()`
2	`335`	`.HasColumnType("boolean")`
2	`336`	`.HasDefaultValue(false)`
2	`337`	`.HasColumnName("used");`
2	`338`
2	`339`	`b.HasKey("Id")`
2	`340`	`.HasName("pk_password_reset_token");`
2	`341`
2	`342`	`b.HasIndex("PersonId")`
2	`343`	`.HasDatabaseName("ix_password_reset_token_person_id");`
2	`344`
2	`345`	`b.HasIndex("TokenHash")`
2	`346`	`.IsUnique()`
2	`347`	`.HasDatabaseName("ix_password_reset_token_token_hash");`
2	`348`
2	`349`	`b.ToTable("password_reset_token", "heimdall");`
4	`350`	`});`
	`351`
2	`352`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Person", b =>`
2	`353`	`{`
2	`354`	`b.Property<long>("Id")`
2	`355`	`.ValueGeneratedOnAdd()`
2	`356`	`.HasColumnType("bigint")`
2	`357`	`.HasColumnName("id")`
2	`358`	`.HasColumnOrder(1);`
2	`359`
2	`360`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`361`
2	`362`	`b.Property<DateTime?>("AnonymisedAt")`
2	`363`	`.HasColumnType("timestamp with time zone")`
2	`364`	`.HasColumnName("anonymised_at");`
2	`365`
2	`366`	`b.Property<DateTime>("CreatedAt")`
2	`367`	`.ValueGeneratedOnAdd()`
2	`368`	`.HasColumnType("timestamp with time zone")`
2	`369`	`.HasColumnName("created_at")`
2	`370`	`.HasDefaultValueSql("now()");`
2	`371`
2	`372`	`b.Property<DateTime?>("DeletedAt")`
2	`373`	`.HasColumnType("timestamp with time zone")`
2	`374`	`.HasColumnName("deleted_at");`
2	`375`
2	`376`	`b.Property<int?>("DeletionKind")`
2	`377`	`.HasColumnType("integer")`
2	`378`	`.HasColumnName("deletion_kind");`
2	`379`
2	`380`	`b.Property<string>("Email")`
2	`381`	`.IsRequired()`
2	`382`	`.HasMaxLength(256)`
2	`383`	`.HasColumnType("character varying(256)")`
2	`384`	`.HasColumnName("email");`
2	`385`
2	`386`	`b.Property<bool>("EmailVerified")`
2	`387`	`.ValueGeneratedOnAdd()`
2	`388`	`.HasColumnType("boolean")`
2	`389`	`.HasDefaultValue(false)`
2	`390`	`.HasColumnName("email_verified");`
2	`391`
2	`392`	`b.Property<string>("ErasureBlockedReason")`
2	`393`	`.HasMaxLength(500)`
2	`394`	`.HasColumnType("character varying(500)")`
2	`395`	`.HasColumnName("erasure_blocked_reason");`
2	`396`
2	`397`	`b.Property<DateTime?>("ErasureDueAt")`
2	`398`	`.HasColumnType("timestamp with time zone")`
2	`399`	`.HasColumnName("erasure_due_at");`
2	`400`
2	`401`	`b.Property<DateTime?>("ErasureRequestedAt")`
2	`402`	`.HasColumnType("timestamp with time zone")`
2	`403`	`.HasColumnName("erasure_requested_at");`
2	`404`
2	`405`	`b.Property<int>("FailedLoginAttempts")`
2	`406`	`.HasColumnType("integer")`
2	`407`	`.HasColumnName("failed_login_attempts");`
2	`408`
2	`409`	`b.Property<bool>("IsDeleted")`
2	`410`	`.ValueGeneratedOnAdd()`
2	`411`	`.HasColumnType("boolean")`
2	`412`	`.HasDefaultValue(false)`
2	`413`	`.HasColumnName("is_deleted");`
2	`414`
2	`415`	`b.Property<DateTime?>("LockedOutUntil")`
2	`416`	`.HasColumnType("timestamp with time zone")`
2	`417`	`.HasColumnName("locked_out_until");`
2	`418`
2	`419`	`b.Property<string>("Name")`
2	`420`	`.IsRequired()`
2	`421`	`.HasMaxLength(200)`
2	`422`	`.HasColumnType("character varying(200)")`
2	`423`	`.HasColumnName("name");`
2	`424`
2	`425`	`b.Property<byte[]>("PasswordHash")`
2	`426`	`.IsRequired()`
2	`427`	`.HasColumnType("bytea")`
2	`428`	`.HasColumnName("password_hash");`
2	`429`
2	`430`	`b.Property<Guid>("PublicId")`
2	`431`	`.HasColumnType("uuid")`
2	`432`	`.HasColumnName("public_id");`
2	`433`
2	`434`	`b.Property<long>("RoleId")`
2	`435`	`.HasColumnType("bigint")`
2	`436`	`.HasColumnName("role_id");`
2	`437`
2	`438`	`b.Property<byte[]>("Salt")`
2	`439`	`.IsRequired()`
2	`440`	`.HasColumnType("bytea")`
2	`441`	`.HasColumnName("salt");`
2	`442`
2	`443`	`b.Property<long?>("ScopeId")`
2	`444`	`.HasColumnType("bigint")`
2	`445`	`.HasColumnName("scope_id");`
2	`446`
2	`447`	`b.Property<DateTime>("UpdatedAt")`
2	`448`	`.ValueGeneratedOnAdd()`
2	`449`	`.HasColumnType("timestamp with time zone")`
2	`450`	`.HasColumnName("updated_at")`
2	`451`	`.HasDefaultValueSql("now()");`
2	`452`
2	`453`	`b.HasKey("Id")`
2	`454`	`.HasName("pk_person");`
2	`455`
2	`456`	`b.HasIndex("DeletedAt")`
2	`457`	`.HasDatabaseName("ix_person_deleted_at")`
2	`458`	`.HasFilter("is_deleted = true AND anonymised_at IS NULL");`
2	`459`
2	`460`	`b.HasIndex("Email")`
2	`461`	`.HasDatabaseName("ix_person_email");`
2	`462`
2	`463`	`b.HasIndex("PublicId")`
2	`464`	`.IsUnique()`
2	`465`	`.HasDatabaseName("ix_person_public_id");`
2	`466`
2	`467`	`b.HasIndex("RoleId")`
2	`468`	`.HasDatabaseName("ix_person_role_id");`
2	`469`
2	`470`	`b.ToTable("person", "heimdall");`
4	`471`	`});`
	`472`
2	`473`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Role", b =>`
2	`474`	`{`
2	`475`	`b.Property<long>("Id")`
2	`476`	`.HasColumnType("bigint")`
2	`477`	`.HasColumnName("id")`
2	`478`	`.HasColumnOrder(1);`
2	`479`
2	`480`	`b.Property<string>("Description")`
2	`481`	`.HasMaxLength(500)`
2	`482`	`.HasColumnType("character varying(500)")`
2	`483`	`.HasColumnName("description");`
2	`484`
2	`485`	`b.Property<string>("Name")`
2	`486`	`.IsRequired()`
2	`487`	`.HasMaxLength(200)`
2	`488`	`.HasColumnType("character varying(200)")`
2	`489`	`.HasColumnName("name");`
2	`490`
2	`491`	`b.Property<Guid>("PublicId")`
2	`492`	`.HasColumnType("uuid")`
2	`493`	`.HasColumnName("public_id");`
2	`494`
2	`495`	`b.HasKey("Id")`
2	`496`	`.HasName("pk_role");`
2	`497`
2	`498`	`b.HasIndex("Name")`
2	`499`	`.IsUnique()`
2	`500`	`.HasDatabaseName("ix_role_name");`
2	`501`
2	`502`	`b.HasIndex("PublicId")`
2	`503`	`.IsUnique()`
2	`504`	`.HasDatabaseName("ix_role_public_id");`
2	`505`
2	`506`	`b.ToTable("role", "heimdall");`
4	`507`	`});`
	`508`
2	`509`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Scope", b =>`
2	`510`	`{`
2	`511`	`b.Property<long>("Id")`
2	`512`	`.ValueGeneratedOnAdd()`
2	`513`	`.HasColumnType("bigint")`
2	`514`	`.HasColumnName("id")`
2	`515`	`.HasColumnOrder(1);`
2	`516`
2	`517`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`518`
2	`519`	`b.Property<DateTime>("CreatedAt")`
2	`520`	`.ValueGeneratedOnAdd()`
2	`521`	`.HasColumnType("timestamp with time zone")`
2	`522`	`.HasColumnName("created_at")`
2	`523`	`.HasDefaultValueSql("now()");`
2	`524`
2	`525`	`b.Property<string>("Description")`
2	`526`	`.HasMaxLength(500)`
2	`527`	`.HasColumnType("character varying(500)")`
2	`528`	`.HasColumnName("description");`
2	`529`
2	`530`	`b.Property<bool>("GoogleSignInEnabled")`
2	`531`	`.ValueGeneratedOnAdd()`
2	`532`	`.HasColumnType("boolean")`
2	`533`	`.HasDefaultValue(false)`
2	`534`	`.HasColumnName("google_sign_in_enabled");`
2	`535`
2	`536`	`b.Property<bool>("IsDeleted")`
2	`537`	`.ValueGeneratedOnAdd()`
2	`538`	`.HasColumnType("boolean")`
2	`539`	`.HasDefaultValue(false)`
2	`540`	`.HasColumnName("is_deleted");`
2	`541`
2	`542`	`b.Property<string>("Name")`
2	`543`	`.IsRequired()`
2	`544`	`.HasMaxLength(200)`
2	`545`	`.HasColumnType("character varying(200)")`
2	`546`	`.HasColumnName("name");`
2	`547`
2	`548`	`b.Property<Guid>("PublicId")`
2	`549`	`.HasColumnType("uuid")`
2	`550`	`.HasColumnName("public_id");`
2	`551`
2	`552`	`b.Property<DateTime>("UpdatedAt")`
2	`553`	`.ValueGeneratedOnAdd()`
2	`554`	`.HasColumnType("timestamp with time zone")`
2	`555`	`.HasColumnName("updated_at")`
2	`556`	`.HasDefaultValueSql("now()");`
2	`557`
2	`558`	`b.HasKey("Id")`
2	`559`	`.HasName("pk_scope");`
2	`560`
2	`561`	`b.HasIndex("Name")`
2	`562`	`.IsUnique()`
2	`563`	`.HasDatabaseName("ix_scope_name");`
2	`564`
2	`565`	`b.HasIndex("PublicId")`
2	`566`	`.IsUnique()`
2	`567`	`.HasDatabaseName("ix_scope_public_id");`
2	`568`
2	`569`	`b.ToTable("scope", "heimdall");`
4	`570`	`});`
	`571`
2	`572`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopeOwner", b =>`
2	`573`	`{`
2	`574`	`b.Property<long>("ScopeId")`
2	`575`	`.HasColumnType("bigint")`
2	`576`	`.HasColumnName("scope_id");`
2	`577`
2	`578`	`b.Property<long>("PersonId")`
2	`579`	`.HasColumnType("bigint")`
2	`580`	`.HasColumnName("person_id");`
2	`581`
2	`582`	`b.HasKey("ScopeId", "PersonId")`
2	`583`	`.HasName("pk_scope_owner");`
2	`584`
2	`585`	`b.HasIndex("PersonId")`
2	`586`	`.HasDatabaseName("ix_scope_owner_person_id");`
2	`587`
2	`588`	`b.ToTable("scope_owner", "heimdall");`
4	`589`	`});`
	`590`
2	`591`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopePermission", b =>`
2	`592`	`{`
2	`593`	`b.Property<long>("Id")`
2	`594`	`.ValueGeneratedOnAdd()`
2	`595`	`.HasColumnType("bigint")`
2	`596`	`.HasColumnName("id")`
2	`597`	`.HasColumnOrder(1);`
2	`598`
2	`599`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`600`
2	`601`	`b.Property<DateTime>("CreatedAt")`
2	`602`	`.ValueGeneratedOnAdd()`
2	`603`	`.HasColumnType("timestamp with time zone")`
2	`604`	`.HasColumnName("created_at")`
2	`605`	`.HasDefaultValueSql("now()");`
2	`606`
2	`607`	`b.Property<string>("Description")`
2	`608`	`.HasMaxLength(500)`
2	`609`	`.HasColumnType("character varying(500)")`
2	`610`	`.HasColumnName("description");`
2	`611`
2	`612`	`b.Property<bool>("IncludeAsJwtClaim")`
2	`613`	`.ValueGeneratedOnAdd()`
2	`614`	`.HasColumnType("boolean")`
2	`615`	`.HasDefaultValue(false)`
2	`616`	`.HasColumnName("include_as_jwt_claim");`
2	`617`
2	`618`	`b.Property<bool>("IsDeleted")`
2	`619`	`.ValueGeneratedOnAdd()`
2	`620`	`.HasColumnType("boolean")`
2	`621`	`.HasDefaultValue(false)`
2	`622`	`.HasColumnName("is_deleted");`
2	`623`
2	`624`	`b.Property<string>("Name")`
2	`625`	`.IsRequired()`
2	`626`	`.HasMaxLength(200)`
2	`627`	`.HasColumnType("character varying(200)")`
2	`628`	`.HasColumnName("name");`
2	`629`
2	`630`	`b.Property<Guid>("PublicId")`
2	`631`	`.HasColumnType("uuid")`
2	`632`	`.HasColumnName("public_id");`
2	`633`
2	`634`	`b.Property<long>("ScopeId")`
2	`635`	`.HasColumnType("bigint")`
2	`636`	`.HasColumnName("scope_id");`
2	`637`
2	`638`	`b.Property<DateTime>("UpdatedAt")`
2	`639`	`.ValueGeneratedOnAdd()`
2	`640`	`.HasColumnType("timestamp with time zone")`
2	`641`	`.HasColumnName("updated_at")`
2	`642`	`.HasDefaultValueSql("now()");`
2	`643`
2	`644`	`b.HasKey("Id")`
2	`645`	`.HasName("pk_scope_permission");`
2	`646`
2	`647`	`b.HasIndex("PublicId")`
2	`648`	`.IsUnique()`
2	`649`	`.HasDatabaseName("ix_scope_permission_public_id");`
2	`650`
2	`651`	`b.HasIndex("ScopeId")`
2	`652`	`.HasDatabaseName("ix_scope_permission_scope_id");`
2	`653`
2	`654`	`b.ToTable("scope_permission", "heimdall");`
4	`655`	`});`
	`656`
2	`657`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopeUser", b =>`
2	`658`	`{`
2	`659`	`b.Property<long>("ScopeId")`
2	`660`	`.HasColumnType("bigint")`
2	`661`	`.HasColumnName("scope_id");`
2	`662`
2	`663`	`b.Property<long>("PersonId")`
2	`664`	`.HasColumnType("bigint")`
2	`665`	`.HasColumnName("person_id");`
2	`666`
2	`667`	`b.HasKey("ScopeId", "PersonId")`
2	`668`	`.HasName("pk_scope_user");`
2	`669`
2	`670`	`b.HasIndex("PersonId")`
2	`671`	`.IsUnique()`
2	`672`	`.HasDatabaseName("ix_scope_user_person_id");`
2	`673`
2	`674`	`b.ToTable("scope_user", "heimdall");`
4	`675`	`});`
	`676`
2	`677`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", b =>`
2	`678`	`{`
2	`679`	`b.Property<long>("Id")`
2	`680`	`.ValueGeneratedOnAdd()`
2	`681`	`.HasColumnType("bigint")`
2	`682`	`.HasColumnName("id")`
2	`683`	`.HasColumnOrder(1);`
2	`684`
2	`685`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`686`
2	`687`	`b.Property<bool>("AppEnabled")`
2	`688`	`.ValueGeneratedOnAdd()`
2	`689`	`.HasColumnType("boolean")`
2	`690`	`.HasDefaultValue(false)`
2	`691`	`.HasColumnName("app_enabled");`
2	`692`
2	`693`	`b.Property<DateTime>("CreatedAt")`
2	`694`	`.ValueGeneratedOnAdd()`
2	`695`	`.HasColumnType("timestamp with time zone")`
2	`696`	`.HasColumnName("created_at")`
2	`697`	`.HasDefaultValueSql("now()");`
2	`698`
2	`699`	`b.Property<bool>("EmailEnabled")`
2	`700`	`.ValueGeneratedOnAdd()`
2	`701`	`.HasColumnType("boolean")`
2	`702`	`.HasDefaultValue(false)`
2	`703`	`.HasColumnName("email_enabled");`
2	`704`
2	`705`	`b.Property<bool>("IsActive")`
2	`706`	`.ValueGeneratedOnAdd()`
2	`707`	`.HasColumnType("boolean")`
2	`708`	`.HasDefaultValue(false)`
2	`709`	`.HasColumnName("is_active");`
2	`710`
2	`711`	`b.Property<long?>("LastTotpTimeStepUsed")`
2	`712`	`.HasColumnType("bigint")`
2	`713`	`.HasColumnName("last_totp_time_step_used");`
2	`714`
2	`715`	`b.Property<long>("PersonId")`
2	`716`	`.HasColumnType("bigint")`
2	`717`	`.HasColumnName("person_id");`
2	`718`
2	`719`	`b.Property<byte[]>("TotpSecretEncrypted")`
2	`720`	`.HasColumnType("bytea")`
2	`721`	`.HasColumnName("totp_secret_encrypted");`
2	`722`
2	`723`	`b.Property<DateTime>("UpdatedAt")`
2	`724`	`.ValueGeneratedOnAdd()`
2	`725`	`.HasColumnType("timestamp with time zone")`
2	`726`	`.HasColumnName("updated_at")`
2	`727`	`.HasDefaultValueSql("now()");`
2	`728`
2	`729`	`b.HasKey("Id")`
2	`730`	`.HasName("pk_two_factor_auth");`
2	`731`
2	`732`	`b.HasIndex("PersonId")`
2	`733`	`.IsUnique()`
2	`734`	`.HasDatabaseName("ix_two_factor_auth_person_id");`
2	`735`
2	`736`	`b.ToTable("two_factor_auth", "heimdall");`
4	`737`	`});`
	`738`
2	`739`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorEmailCode", b =>`
2	`740`	`{`
2	`741`	`b.Property<long>("Id")`
2	`742`	`.ValueGeneratedOnAdd()`
2	`743`	`.HasColumnType("bigint")`
2	`744`	`.HasColumnName("id")`
2	`745`	`.HasColumnOrder(1);`
2	`746`
2	`747`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`748`
2	`749`	`b.Property<byte[]>("CodeHash")`
2	`750`	`.IsRequired()`
2	`751`	`.HasColumnType("bytea")`
2	`752`	`.HasColumnName("code_hash");`
2	`753`
2	`754`	`b.Property<DateTime>("CreatedAt")`
2	`755`	`.ValueGeneratedOnAdd()`
2	`756`	`.HasColumnType("timestamp with time zone")`
2	`757`	`.HasColumnName("created_at")`
2	`758`	`.HasDefaultValueSql("now()");`
2	`759`
2	`760`	`b.Property<DateTime>("ExpiresAt")`
2	`761`	`.HasColumnType("timestamp with time zone")`
2	`762`	`.HasColumnName("expires_at");`
2	`763`
2	`764`	`b.Property<int>("FailedAttempts")`
2	`765`	`.HasColumnType("integer")`
2	`766`	`.HasColumnName("failed_attempts");`
2	`767`
2	`768`	`b.Property<byte[]>("Salt")`
2	`769`	`.IsRequired()`
2	`770`	`.HasColumnType("bytea")`
2	`771`	`.HasColumnName("salt");`
2	`772`
2	`773`	`b.Property<long>("TwoFactorAuthId")`
2	`774`	`.HasColumnType("bigint")`
2	`775`	`.HasColumnName("two_factor_auth_id");`
2	`776`
2	`777`	`b.Property<bool>("Used")`
2	`778`	`.ValueGeneratedOnAdd()`
2	`779`	`.HasColumnType("boolean")`
2	`780`	`.HasDefaultValue(false)`
2	`781`	`.HasColumnName("used");`
2	`782`
2	`783`	`b.HasKey("Id")`
2	`784`	`.HasName("pk_two_factor_email_code");`
2	`785`
2	`786`	`b.HasIndex("TwoFactorAuthId")`
2	`787`	`.HasDatabaseName("ix_two_factor_email_code_two_factor_auth_id");`
2	`788`
2	`789`	`b.ToTable("two_factor_email_code", "heimdall");`
4	`790`	`});`
	`791`
2	`792`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorRecoveryCode", b =>`
2	`793`	`{`
2	`794`	`b.Property<long>("Id")`
2	`795`	`.ValueGeneratedOnAdd()`
2	`796`	`.HasColumnType("bigint")`
2	`797`	`.HasColumnName("id")`
2	`798`	`.HasColumnOrder(1);`
2	`799`
2	`800`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));`
2	`801`
2	`802`	`b.Property<byte[]>("CodeHash")`
2	`803`	`.IsRequired()`
2	`804`	`.HasColumnType("bytea")`
2	`805`	`.HasColumnName("code_hash");`
2	`806`
2	`807`	`b.Property<DateTime>("CreatedAt")`
2	`808`	`.ValueGeneratedOnAdd()`
2	`809`	`.HasColumnType("timestamp with time zone")`
2	`810`	`.HasColumnName("created_at")`
2	`811`	`.HasDefaultValueSql("now()");`
2	`812`
2	`813`	`b.Property<long>("TwoFactorAuthId")`
2	`814`	`.HasColumnType("bigint")`
2	`815`	`.HasColumnName("two_factor_auth_id");`
2	`816`
2	`817`	`b.Property<bool>("Used")`
2	`818`	`.ValueGeneratedOnAdd()`
2	`819`	`.HasColumnType("boolean")`
2	`820`	`.HasDefaultValue(false)`
2	`821`	`.HasColumnName("used");`
2	`822`
2	`823`	`b.Property<DateTime?>("UsedAt")`
2	`824`	`.HasColumnType("timestamp with time zone")`
2	`825`	`.HasColumnName("used_at");`
2	`826`
2	`827`	`b.HasKey("Id")`
2	`828`	`.HasName("pk_two_factor_recovery_code");`
2	`829`
2	`830`	`b.HasIndex("TwoFactorAuthId")`
2	`831`	`.HasDatabaseName("ix_two_factor_recovery_code_two_factor_auth_id");`
2	`832`
2	`833`	`b.ToTable("two_factor_recovery_code", "heimdall");`
4	`834`	`});`
	`835`
2	`836`	`modelBuilder.Entity("Microsoft.AspNetCore.DataProtection.EntityFrameworkCore.DataProtectionKey", b =>`
2	`837`	`{`
2	`838`	`b.Property<int>("Id")`
2	`839`	`.ValueGeneratedOnAdd()`
2	`840`	`.HasColumnType("integer")`
2	`841`	`.HasColumnName("id");`
2	`842`
2	`843`	`NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));`
2	`844`
2	`845`	`b.Property<string>("FriendlyName")`
2	`846`	`.HasColumnType("text")`
2	`847`	`.HasColumnName("friendly_name");`
2	`848`
2	`849`	`b.Property<string>("Xml")`
2	`850`	`.HasColumnType("text")`
2	`851`	`.HasColumnName("xml");`
2	`852`
2	`853`	`b.HasKey("Id")`
2	`854`	`.HasName("pk_data_protection_keys");`
2	`855`
2	`856`	`b.ToTable("data_protection_keys", "heimdall");`
4	`857`	`});`
	`858`
2	`859`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Application", b =>`
2	`860`	`{`
2	`861`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Owner")`
2	`862`	`.WithMany("OwnedApplications")`
2	`863`	`.HasForeignKey("OwnerId")`
2	`864`	`.OnDelete(DeleteBehavior.Cascade)`
2	`865`	`.IsRequired()`
2	`866`	`.HasConstraintName("fk_application_person_owner_id");`
2	`867`
2	`868`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")`
2	`869`	`.WithMany("Applications")`
2	`870`	`.HasForeignKey("ScopeId")`
2	`871`	`.OnDelete(DeleteBehavior.Cascade)`
2	`872`	`.IsRequired()`
2	`873`	`.HasConstraintName("fk_application_scope_scope_id");`
2	`874`
2	`875`	`b.Navigation("Owner");`
2	`876`
2	`877`	`b.Navigation("Scope");`
4	`878`	`});`
	`879`
2	`880`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.EmailVerificationToken", b =>`
2	`881`	`{`
2	`882`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")`
2	`883`	`.WithMany("EmailVerificationTokens")`
2	`884`	`.HasForeignKey("PersonId")`
2	`885`	`.OnDelete(DeleteBehavior.Cascade)`
2	`886`	`.IsRequired()`
2	`887`	`.HasConstraintName("fk_email_verification_token_person_person_id");`
2	`888`
2	`889`	`b.Navigation("Person");`
4	`890`	`});`
	`891`
2	`892`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.GoogleUser", b =>`
2	`893`	`{`
2	`894`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")`
2	`895`	`.WithMany("GoogleUsers")`
2	`896`	`.HasForeignKey("ScopeId")`
2	`897`	`.OnDelete(DeleteBehavior.Cascade)`
2	`898`	`.IsRequired()`
2	`899`	`.HasConstraintName("fk_google_user_scope_scope_id");`
2	`900`
2	`901`	`b.Navigation("Scope");`
4	`902`	`});`
	`903`
2	`904`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.PasswordResetToken", b =>`
2	`905`	`{`
2	`906`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")`
2	`907`	`.WithMany("PasswordResetTokens")`
2	`908`	`.HasForeignKey("PersonId")`
2	`909`	`.OnDelete(DeleteBehavior.Cascade)`
2	`910`	`.IsRequired()`
2	`911`	`.HasConstraintName("fk_password_reset_token_person_person_id");`
2	`912`
2	`913`	`b.Navigation("Person");`
4	`914`	`});`
	`915`
2	`916`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Person", b =>`
2	`917`	`{`
2	`918`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Role", "Role")`
2	`919`	`.WithMany("Persons")`
2	`920`	`.HasForeignKey("RoleId")`
2	`921`	`.OnDelete(DeleteBehavior.Restrict)`
2	`922`	`.IsRequired()`
2	`923`	`.HasConstraintName("fk_person_roles_role_id");`
2	`924`
2	`925`	`b.Navigation("Role");`
4	`926`	`});`
	`927`
2	`928`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopeOwner", b =>`
2	`929`	`{`
2	`930`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")`
2	`931`	`.WithMany("ScopeOwnerships")`
2	`932`	`.HasForeignKey("PersonId")`
2	`933`	`.OnDelete(DeleteBehavior.Cascade)`
2	`934`	`.IsRequired()`
2	`935`	`.HasConstraintName("fk_scope_owner_person_person_id");`
2	`936`
2	`937`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")`
2	`938`	`.WithMany("Owners")`
2	`939`	`.HasForeignKey("ScopeId")`
2	`940`	`.OnDelete(DeleteBehavior.Cascade)`
2	`941`	`.IsRequired()`
2	`942`	`.HasConstraintName("fk_scope_owner_scope_scope_id");`
2	`943`
2	`944`	`b.Navigation("Person");`
2	`945`
2	`946`	`b.Navigation("Scope");`
4	`947`	`});`
	`948`
2	`949`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopePermission", b =>`
2	`950`	`{`
2	`951`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")`
2	`952`	`.WithMany("ScopePermissions")`
2	`953`	`.HasForeignKey("ScopeId")`
2	`954`	`.OnDelete(DeleteBehavior.Cascade)`
2	`955`	`.IsRequired()`
2	`956`	`.HasConstraintName("fk_scope_permission_scope_scope_id");`
2	`957`
2	`958`	`b.Navigation("Scope");`
4	`959`	`});`
	`960`
2	`961`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.ScopeUser", b =>`
2	`962`	`{`
2	`963`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")`
2	`964`	`.WithOne("ScopeMembership")`
2	`965`	`.HasForeignKey("ArturRios.Heimdall.Domain.Entities.ScopeUser", "PersonId")`
2	`966`	`.OnDelete(DeleteBehavior.Cascade)`
2	`967`	`.IsRequired()`
2	`968`	`.HasConstraintName("fk_scope_user_person_person_id");`
2	`969`
2	`970`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Scope", "Scope")`
2	`971`	`.WithMany("Users")`
2	`972`	`.HasForeignKey("ScopeId")`
2	`973`	`.OnDelete(DeleteBehavior.Cascade)`
2	`974`	`.IsRequired()`
2	`975`	`.HasConstraintName("fk_scope_user_scope_scope_id");`
2	`976`
2	`977`	`b.Navigation("Person");`
2	`978`
2	`979`	`b.Navigation("Scope");`
4	`980`	`});`
	`981`
2	`982`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", b =>`
2	`983`	`{`
2	`984`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.Person", "Person")`
2	`985`	`.WithOne("TwoFactorAuth")`
2	`986`	`.HasForeignKey("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", "PersonId")`
2	`987`	`.OnDelete(DeleteBehavior.Cascade)`
2	`988`	`.IsRequired()`
2	`989`	`.HasConstraintName("fk_two_factor_auth_person_person_id");`
2	`990`
2	`991`	`b.Navigation("Person");`
4	`992`	`});`
	`993`
2	`994`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorEmailCode", b =>`
2	`995`	`{`
2	`996`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", "TwoFactorAuth")`
2	`997`	`.WithMany("EmailCodes")`
2	`998`	`.HasForeignKey("TwoFactorAuthId")`
2	`999`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1000`	`.IsRequired()`
2	`1001`	`.HasConstraintName("fk_two_factor_email_code_two_factor_auth_two_factor_auth_id");`
2	`1002`
2	`1003`	`b.Navigation("TwoFactorAuth");`
4	`1004`	`});`
	`1005`
2	`1006`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorRecoveryCode", b =>`
2	`1007`	`{`
2	`1008`	`b.HasOne("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", "TwoFactorAuth")`
2	`1009`	`.WithMany("RecoveryCodes")`
2	`1010`	`.HasForeignKey("TwoFactorAuthId")`
2	`1011`	`.OnDelete(DeleteBehavior.Cascade)`
2	`1012`	`.IsRequired()`
2	`1013`	`.HasConstraintName("fk_two_factor_recovery_code_two_factor_auth_two_factor_auth_id");`
2	`1014`
2	`1015`	`b.Navigation("TwoFactorAuth");`
4	`1016`	`});`
	`1017`
2	`1018`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Person", b =>`
2	`1019`	`{`
2	`1020`	`b.Navigation("EmailVerificationTokens");`
2	`1021`
2	`1022`	`b.Navigation("OwnedApplications");`
2	`1023`
2	`1024`	`b.Navigation("PasswordResetTokens");`
2	`1025`
2	`1026`	`b.Navigation("ScopeMembership");`
2	`1027`
2	`1028`	`b.Navigation("ScopeOwnerships");`
2	`1029`
2	`1030`	`b.Navigation("TwoFactorAuth");`
4	`1031`	`});`
	`1032`
2	`1033`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Role", b =>`
2	`1034`	`{`
2	`1035`	`b.Navigation("Persons");`
4	`1036`	`});`
	`1037`
2	`1038`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.Scope", b =>`
2	`1039`	`{`
2	`1040`	`b.Navigation("Applications");`
2	`1041`
2	`1042`	`b.Navigation("GoogleUsers");`
2	`1043`
2	`1044`	`b.Navigation("Owners");`
2	`1045`
2	`1046`	`b.Navigation("ScopePermissions");`
2	`1047`
2	`1048`	`b.Navigation("Users");`
4	`1049`	`});`
	`1050`
2	`1051`	`modelBuilder.Entity("ArturRios.Heimdall.Domain.Entities.TwoFactorAuth", b =>`
2	`1052`	`{`
2	`1053`	`b.Navigation("EmailCodes");`
2	`1054`
2	`1055`	`b.Navigation("RecoveryCodes");`
4	`1056`	`});`
	`1057`	`#pragma warning restore 612, 618`
2	`1058`	`}`
	`1059`	`}`
	`1060`	`}`

< Summary - Heimdall API

Metrics

File(s)

/home/runner/work/heimdall-api/heimdall-api/src/Infrastructure/ArturRios.Heimdall.Data/Migrations/20260909182313_AllowClearingAuditActor.cs

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

Methods/Properties