From 842502e82c4ddfea05a5f77c361aaa27f75afc42 Mon Sep 17 00:00:00 2001
From: ivar <i@oiee.no>
Date: Sun, 26 Oct 2025 22:57:28 +0100
Subject: Refactor db schema and add audits

---
 api/WhatApi/Tables/AuditTrail.cs | 39 +++++++++++++++++++++++++++++++++++++++
 1 file changed, 39 insertions(+)
 create mode 100644 api/WhatApi/Tables/AuditTrail.cs

(limited to 'api/WhatApi/Tables/AuditTrail.cs')

diff --git a/api/WhatApi/Tables/AuditTrail.cs b/api/WhatApi/Tables/AuditTrail.cs
new file mode 100644
index 0000000..9613af4
--- /dev/null
+++ b/api/WhatApi/Tables/AuditTrail.cs
@@ -0,0 +1,39 @@
+namespace WhatApi.Tables;
+
+public class AuditTrail
+{
+    public Guid Id { get; init; }
+    public Guid? UserId { get; init; }
+    public required string EntityName { get; init; }
+    public string? PrimaryKey { get; set; }
+    public TrailType TrailType { get; set; }
+    public DateTimeOffset DateUtc { get; init; }
+
+    public Dictionary<string, object?> OldValues { get; init; } = [];
+    public Dictionary<string, object?> NewValues { get; init; } = [];
+    public List<string> ChangedColumns { get; init; } = [];
+}
+
+public class AuditTrailConfiguration : IEntityTypeConfiguration<AuditTrail>
+{
+    public void Configure(EntityTypeBuilder<AuditTrail> builder)
+    {
+        builder.ToTable("audit_trails");
+        builder.HasIndex(e => e.EntityName);
+        builder.Property(e => e.EntityName).HasMaxLength(100).IsRequired();
+        builder.Property(e => e.PrimaryKey).HasMaxLength(100);
+        builder.Property(e => e.DateUtc).IsRequired();
+        builder.Property(e => e.TrailType).HasConversion<string>();
+        builder.Property(e => e.OldValues).HasColumnType("jsonb");
+        builder.Property(e => e.NewValues).HasColumnType("jsonb");
+        builder.Property(e => e.ChangedColumns).HasColumnType("jsonb");
+    }
+}
+
+public enum TrailType : byte
+{
+    None = 0,
+    Create = 1,
+    Update = 2,
+    Delete = 3
+}
\ No newline at end of file
-- 
cgit v1.3