Refactor db

1 files changed, 27 insertions, 0 deletions

diff --git a/api/WhatApi/Database/Tables/User.cs b/api/WhatApi/Database/Tables/User.cs
new file mode 100644
index 0000000..bfcdb50
--- /dev/null
+++ b/api/WhatApi/Database/Tables/User.cs
@@ -0,0 +1,27 @@
+namespace WhatApi.Database.Tables;
+
+public class User : BaseAuditableEntity
+{
+    public Guid Id { get; set; }
+    public required string Name { get; set; }
+    public required string Email { get; set; }
+    public required string PasswordHash { get; set; }
+    public DateTimeOffset? LastSeen { get; set; }
+    public IEnumerable<Place> Places { get; set; } = null!;
+
+    public void SetLastSeen() {
+        LastSeen = DateTimeOffset.UtcNow;
+    }
+}
+
+public class UserConfiguration : IEntityTypeConfiguration<User>
+{
+    public void Configure(EntityTypeBuilder<User> builder) {
+        builder.HasKey(x => x.Id);
+        builder.Property(x => x.Name).HasMaxLength(50);
+        builder.Property(x => x.Email).HasMaxLength(100);
+        builder.Property(x => x.PasswordHash).HasMaxLength(100);
+        builder.HasMany(x => x.Places);
+        builder.ToTable("user");
+    }
+}
\ No newline at end of file