Max lenghts on db schema

Use latest temporal from cdn
Implement majority of translation functionality
Major refinements/bugs

7 files changed, 689 insertions, 63 deletions

diff --git a/code/api/Migrations/20221221214429_InitialYay.Designer.cs b/code/api/Migrations/20221221214429_InitialYay.Designer.cs
index e368363..a773078 100644
--- a/code/api/Migrations/20221221214429_InitialYay.Designer.cs
+++ b/code/api/Migrations/20221221214429_InitialYay.Designer.cs
@@ -1,15 +1,11 @@
 // <auto-generated />
-using System;
-using I2R.Storage.Api.Database;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
 
 #nullable disable
 
-namespace I2R.Storage.Api.Migrations
+using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Migrations;
+
+namespace Quality.Storage.Api.Migrations
 {
     [DbContext(typeof(AppDatabase))]
     [Migration("20221221214429_InitialYay")]
diff --git a/code/api/Migrations/20221221214429_InitialYay.cs b/code/api/Migrations/20221221214429_InitialYay.cs
index 122e3d9..e66d8ff 100644
--- a/code/api/Migrations/20221221214429_InitialYay.cs
+++ b/code/api/Migrations/20221221214429_InitialYay.cs
@@ -1,9 +1,8 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
+#nullable disable
 
-#nullable disable
+using Microsoft.EntityFrameworkCore.Migrations;
 
-namespace I2R.Storage.Api.Migrations
+namespace Quality.Storage.Api.Migrations
 {
     /// <inheritdoc />
     public partial class InitialYay : Migration
diff --git a/code/api/Migrations/20221222153132_FolderParent.Designer.cs b/code/api/Migrations/20221222153132_FolderParent.Designer.cs
index 0ad7936..d670c93 100644
--- a/code/api/Migrations/20221222153132_FolderParent.Designer.cs
+++ b/code/api/Migrations/20221222153132_FolderParent.Designer.cs
@@ -1,15 +1,11 @@
 // <auto-generated />
-using System;
-using I2R.Storage.Api.Database;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
 
 #nullable disable
 
-namespace I2R.Storage.Api.Migrations
+using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Migrations;
+
+namespace Quality.Storage.Api.Migrations
 {
     [DbContext(typeof(AppDatabase))]
     [Migration("20221222153132_FolderParent")]
@@ -25,7 +21,7 @@ namespace I2R.Storage.Api.Migrations
 
             NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
 
-            modelBuilder.Entity("I2R.Storage.Api.Database.Models.File", b =>
+            modelBuilder.Entity("Quality.Storage.Api.Database.Models.File", b =>
                 {
                     b.Property<Guid>("Id")
                         .ValueGeneratedOnAdd()
@@ -93,7 +89,7 @@ namespace I2R.Storage.Api.Migrations
                     b.ToTable("files", (string)null);
                 });
 
-            modelBuilder.Entity("I2R.Storage.Api.Database.Models.Folder", b =>
+            modelBuilder.Entity("Quality.Storage.Api.Database.Models.Folder", b =>
                 {
                     b.Property<Guid>("Id")
                         .ValueGeneratedOnAdd()
@@ -153,7 +149,7 @@ namespace I2R.Storage.Api.Migrations
                     b.ToTable("folders", (string)null);
                 });
 
-            modelBuilder.Entity("I2R.Storage.Api.Database.Models.Permission", b =>
+            modelBuilder.Entity("Quality.Storage.Api.Database.Models.Permission", b =>
                 {
                     b.Property<Guid>("Id")
                         .ValueGeneratedOnAdd()
@@ -231,7 +227,7 @@ namespace I2R.Storage.Api.Migrations
                     b.ToTable("permissions", (string)null);
                 });
 
-            modelBuilder.Entity("I2R.Storage.Api.Database.Models.PermissionGroup", b =>
+            modelBuilder.Entity("Quality.Storage.Api.Database.Models.PermissionGroup", b =>
                 {
                     b.Property<Guid>("Id")
                         .ValueGeneratedOnAdd()
@@ -280,7 +276,7 @@ namespace I2R.Storage.Api.Migrations
                     b.ToTable("permission_groups", (string)null);
                 });
 
-            modelBuilder.Entity("I2R.Storage.Api.Database.Models.User", b =>
+            modelBuilder.Entity("Quality.Storage.Api.Database.Models.User", b =>
                 {
                     b.Property<Guid>("Id")
                         .ValueGeneratedOnAdd()
@@ -352,9 +348,9 @@ namespace I2R.Storage.Api.Migrations
                     b.ToTable("users", (string)null);
                 });
 
-            modelBuilder.Entity("I2R.Storage.Api.Database.Models.File", b =>
+            modelBuilder.Entity("Quality.Storage.Api.Database.Models.File", b =>
                 {
-                    b.HasOne("I2R.Storage.Api.Database.Models.Folder", "Folder")
+                    b.HasOne("Quality.Storage.Api.Database.Models.Folder", "Folder")
                         .WithMany("Files")
                         .HasForeignKey("FolderId")
                         .OnDelete(DeleteBehavior.Cascade)
@@ -364,9 +360,9 @@ namespace I2R.Storage.Api.Migrations
                     b.Navigation("Folder");
                 });
 
-            modelBuilder.Entity("I2R.Storage.Api.Database.Models.Folder", b =>
+            modelBuilder.Entity("Quality.Storage.Api.Database.Models.Folder", b =>
                 {
-                    b.HasOne("I2R.Storage.Api.Database.Models.Folder", "Parent")
+                    b.HasOne("Quality.Storage.Api.Database.Models.Folder", "Parent")
                         .WithMany()
                         .HasForeignKey("ParentId")
                         .HasConstraintName("fk_folders_folders_parent_id");
@@ -374,19 +370,19 @@ namespace I2R.Storage.Api.Migrations
                     b.Navigation("Parent");
                 });
 
-            modelBuilder.Entity("I2R.Storage.Api.Database.Models.Permission", b =>
+            modelBuilder.Entity("Quality.Storage.Api.Database.Models.Permission", b =>
                 {
-                    b.HasOne("I2R.Storage.Api.Database.Models.File", null)
+                    b.HasOne("Quality.Storage.Api.Database.Models.File", null)
                         .WithMany("Permissions")
                         .HasForeignKey("FileId")
                         .HasConstraintName("fk_permissions_files_file_id");
 
-                    b.HasOne("I2R.Storage.Api.Database.Models.Folder", null)
+                    b.HasOne("Quality.Storage.Api.Database.Models.Folder", null)
                         .WithMany("Permissions")
                         .HasForeignKey("FolderId")
                         .HasConstraintName("fk_permissions_folders_folder_id");
 
-                    b.HasOne("I2R.Storage.Api.Database.Models.PermissionGroup", "Group")
+                    b.HasOne("Quality.Storage.Api.Database.Models.PermissionGroup", "Group")
                         .WithMany()
                         .HasForeignKey("GroupId")
                         .OnDelete(DeleteBehavior.Cascade)
@@ -396,27 +392,27 @@ namespace I2R.Storage.Api.Migrations
                     b.Navigation("Group");
                 });
 
-            modelBuilder.Entity("I2R.Storage.Api.Database.Models.User", b =>
+            modelBuilder.Entity("Quality.Storage.Api.Database.Models.User", b =>
                 {
-                    b.HasOne("I2R.Storage.Api.Database.Models.PermissionGroup", null)
+                    b.HasOne("Quality.Storage.Api.Database.Models.PermissionGroup", null)
                         .WithMany("Users")
                         .HasForeignKey("PermissionGroupId")
                         .HasConstraintName("fk_users_permission_groups_permission_group_id");
                 });
 
-            modelBuilder.Entity("I2R.Storage.Api.Database.Models.File", b =>
+            modelBuilder.Entity("Quality.Storage.Api.Database.Models.File", b =>
                 {
                     b.Navigation("Permissions");
                 });
 
-            modelBuilder.Entity("I2R.Storage.Api.Database.Models.Folder", b =>
+            modelBuilder.Entity("Quality.Storage.Api.Database.Models.Folder", b =>
                 {
                     b.Navigation("Files");
 
                     b.Navigation("Permissions");
                 });
 
-            modelBuilder.Entity("I2R.Storage.Api.Database.Models.PermissionGroup", b =>
+            modelBuilder.Entity("Quality.Storage.Api.Database.Models.PermissionGroup", b =>
                 {
                     b.Navigation("Users");
                 });
diff --git a/code/api/Migrations/20221222153132_FolderParent.cs b/code/api/Migrations/20221222153132_FolderParent.cs
index c88bd81..baa85d7 100644
--- a/code/api/Migrations/20221222153132_FolderParent.cs
+++ b/code/api/Migrations/20221222153132_FolderParent.cs
@@ -1,9 +1,8 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
 #nullable disable
 
-namespace I2R.Storage.Api.Migrations
+using Microsoft.EntityFrameworkCore.Migrations;
+
+namespace Quality.Storage.Api.Migrations
 {
     /// <inheritdoc />
     public partial class FolderParent : Migration
diff --git a/code/api/Migrations/20240224160817_UpdateFeb2024.Designer.cs b/code/api/Migrations/20240224160817_UpdateFeb2024.Designer.cs
new file mode 100644
index 0000000..7544195
--- /dev/null
+++ b/code/api/Migrations/20240224160817_UpdateFeb2024.Designer.cs
@@ -0,0 +1,427 @@
+// <auto-generated />
+
+#nullable disable
+
+using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Migrations;
+
+namespace Quality.Storage.Api.Migrations
+{
+    [DbContext(typeof(AppDatabase))]
+    [Migration("20240224160817_UpdateFeb2024")]
+    partial class UpdateFeb2024
+    {
+        /// <inheritdoc />
+        protected override void BuildTargetModel(ModelBuilder modelBuilder)
+        {
+#pragma warning disable 612, 618
+            modelBuilder
+                .HasAnnotation("ProductVersion", "8.0.2")
+                .HasAnnotation("Relational:MaxIdentifierLength", 63);
+
+            NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
+
+            modelBuilder.Entity("I2R.Storage.Api.Database.Models.File", b =>
+                {
+                    b.Property<Guid>("Id")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("uuid")
+                        .HasColumnName("id");
+
+                    b.Property<DateTime>("CreatedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("created_at");
+
+                    b.Property<Guid?>("CreatedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("created_by");
+
+                    b.Property<Guid>("FolderId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("folder_id");
+
+                    b.Property<bool>("IsBinned")
+                        .HasColumnType("boolean")
+                        .HasColumnName("is_binned");
+
+                    b.Property<bool>("IsEncrypted")
+                        .HasColumnType("boolean")
+                        .HasColumnName("is_encrypted");
+
+                    b.Property<DateTime?>("LastDeletedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("last_deleted_at");
+
+                    b.Property<Guid?>("LastDeletedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("last_deleted_by");
+
+                    b.Property<DateTime?>("LastModifiedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("last_modified_at");
+
+                    b.Property<Guid?>("LastModifiedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("last_modified_by");
+
+                    b.Property<string>("MimeType")
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
+                        .HasColumnName("mime_type");
+
+                    b.Property<string>("Name")
+                        .HasMaxLength(200)
+                        .HasColumnType("character varying(200)")
+                        .HasColumnName("name");
+
+                    b.Property<Guid?>("OwningUserId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("owning_user_id");
+
+                    b.Property<long>("SizeInBytes")
+                        .HasColumnType("bigint")
+                        .HasColumnName("size_in_bytes");
+
+                    b.HasKey("Id")
+                        .HasName("pk_files");
+
+                    b.HasIndex("FolderId")
+                        .HasDatabaseName("ix_files_folder_id");
+
+                    b.ToTable("files", (string)null);
+                });
+
+            modelBuilder.Entity("I2R.Storage.Api.Database.Models.Folder", b =>
+                {
+                    b.Property<Guid>("Id")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("uuid")
+                        .HasColumnName("id");
+
+                    b.Property<DateTime>("CreatedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("created_at");
+
+                    b.Property<Guid?>("CreatedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("created_by");
+
+                    b.Property<bool>("IsBinned")
+                        .HasColumnType("boolean")
+                        .HasColumnName("is_binned");
+
+                    b.Property<bool>("IsEncrypted")
+                        .HasColumnType("boolean")
+                        .HasColumnName("is_encrypted");
+
+                    b.Property<DateTime?>("LastDeletedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("last_deleted_at");
+
+                    b.Property<Guid?>("LastDeletedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("last_deleted_by");
+
+                    b.Property<DateTime?>("LastModifiedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("last_modified_at");
+
+                    b.Property<Guid?>("LastModifiedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("last_modified_by");
+
+                    b.Property<string>("Name")
+                        .HasMaxLength(200)
+                        .HasColumnType("character varying(200)")
+                        .HasColumnName("name");
+
+                    b.Property<Guid?>("OwningUserId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("owning_user_id");
+
+                    b.Property<Guid?>("ParentId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("parent_id");
+
+                    b.HasKey("Id")
+                        .HasName("pk_folders");
+
+                    b.HasIndex("ParentId")
+                        .HasDatabaseName("ix_folders_parent_id");
+
+                    b.ToTable("folders", (string)null);
+                });
+
+            modelBuilder.Entity("I2R.Storage.Api.Database.Models.Permission", b =>
+                {
+                    b.Property<Guid>("Id")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("uuid")
+                        .HasColumnName("id");
+
+                    b.Property<bool>("CanRead")
+                        .HasColumnType("boolean")
+                        .HasColumnName("can_read");
+
+                    b.Property<bool>("CanWrite")
+                        .HasColumnType("boolean")
+                        .HasColumnName("can_write");
+
+                    b.Property<Guid>("ContentId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("content_id");
+
+                    b.Property<DateTime>("CreatedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("created_at");
+
+                    b.Property<Guid?>("CreatedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("created_by");
+
+                    b.Property<Guid?>("FileId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("file_id");
+
+                    b.Property<Guid?>("FolderId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("folder_id");
+
+                    b.Property<Guid>("GroupId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("group_id");
+
+                    b.Property<bool>("IsFile")
+                        .HasColumnType("boolean")
+                        .HasColumnName("is_file");
+
+                    b.Property<DateTime?>("LastDeletedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("last_deleted_at");
+
+                    b.Property<Guid?>("LastDeletedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("last_deleted_by");
+
+                    b.Property<DateTime?>("LastModifiedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("last_modified_at");
+
+                    b.Property<Guid?>("LastModifiedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("last_modified_by");
+
+                    b.Property<Guid?>("OwningUserId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("owning_user_id");
+
+                    b.HasKey("Id")
+                        .HasName("pk_permissions");
+
+                    b.HasIndex("FileId")
+                        .HasDatabaseName("ix_permissions_file_id");
+
+                    b.HasIndex("FolderId")
+                        .HasDatabaseName("ix_permissions_folder_id");
+
+                    b.HasIndex("GroupId")
+                        .HasDatabaseName("ix_permissions_group_id");
+
+                    b.ToTable("permissions", (string)null);
+                });
+
+            modelBuilder.Entity("I2R.Storage.Api.Database.Models.PermissionGroup", b =>
+                {
+                    b.Property<Guid>("Id")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("uuid")
+                        .HasColumnName("id");
+
+                    b.Property<DateTime>("CreatedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("created_at");
+
+                    b.Property<Guid?>("CreatedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("created_by");
+
+                    b.Property<string>("Description")
+                        .HasMaxLength(450)
+                        .HasColumnType("character varying(450)")
+                        .HasColumnName("description");
+
+                    b.Property<DateTime?>("LastDeletedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("last_deleted_at");
+
+                    b.Property<Guid?>("LastDeletedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("last_deleted_by");
+
+                    b.Property<DateTime?>("LastModifiedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("last_modified_at");
+
+                    b.Property<Guid?>("LastModifiedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("last_modified_by");
+
+                    b.Property<string>("Name")
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
+                        .HasColumnName("name");
+
+                    b.Property<Guid?>("OwningUserId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("owning_user_id");
+
+                    b.HasKey("Id")
+                        .HasName("pk_permission_groups");
+
+                    b.ToTable("permission_groups", (string)null);
+                });
+
+            modelBuilder.Entity("I2R.Storage.Api.Database.Models.User", b =>
+                {
+                    b.Property<Guid>("Id")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("uuid")
+                        .HasColumnName("id");
+
+                    b.Property<DateTime>("CreatedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("created_at");
+
+                    b.Property<Guid?>("CreatedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("created_by");
+
+                    b.Property<string>("FirstName")
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
+                        .HasColumnName("first_name");
+
+                    b.Property<DateTime?>("LastDeletedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("last_deleted_at");
+
+                    b.Property<Guid?>("LastDeletedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("last_deleted_by");
+
+                    b.Property<DateTime?>("LastLoggedOn")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("last_logged_on");
+
+                    b.Property<DateTime?>("LastModifiedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("last_modified_at");
+
+                    b.Property<Guid?>("LastModifiedBy")
+                        .HasColumnType("uuid")
+                        .HasColumnName("last_modified_by");
+
+                    b.Property<string>("LastName")
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
+                        .HasColumnName("last_name");
+
+                    b.Property<string>("Password")
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
+                        .HasColumnName("password");
+
+                    b.Property<Guid?>("PermissionGroupId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("permission_group_id");
+
+                    b.Property<int>("Role")
+                        .HasColumnType("integer")
+                        .HasColumnName("role");
+
+                    b.Property<string>("Username")
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
+                        .HasColumnName("username");
+
+                    b.HasKey("Id")
+                        .HasName("pk_users");
+
+                    b.HasIndex("PermissionGroupId")
+                        .HasDatabaseName("ix_users_permission_group_id");
+
+                    b.ToTable("users", (string)null);
+                });
+
+            modelBuilder.Entity("I2R.Storage.Api.Database.Models.File", b =>
+                {
+                    b.HasOne("I2R.Storage.Api.Database.Models.Folder", "Folder")
+                        .WithMany("Files")
+                        .HasForeignKey("FolderId")
+                        .OnDelete(DeleteBehavior.Cascade)
+                        .IsRequired()
+                        .HasConstraintName("fk_files_folders_folder_id");
+
+                    b.Navigation("Folder");
+                });
+
+            modelBuilder.Entity("I2R.Storage.Api.Database.Models.Folder", b =>
+                {
+                    b.HasOne("I2R.Storage.Api.Database.Models.Folder", "Parent")
+                        .WithMany()
+                        .HasForeignKey("ParentId")
+                        .HasConstraintName("fk_folders_folders_parent_id");
+
+                    b.Navigation("Parent");
+                });
+
+            modelBuilder.Entity("I2R.Storage.Api.Database.Models.Permission", b =>
+                {
+                    b.HasOne("I2R.Storage.Api.Database.Models.File", null)
+                        .WithMany("Permissions")
+                        .HasForeignKey("FileId")
+                        .HasConstraintName("fk_permissions_files_file_id");
+
+                    b.HasOne("I2R.Storage.Api.Database.Models.Folder", null)
+                        .WithMany("Permissions")
+                        .HasForeignKey("FolderId")
+                        .HasConstraintName("fk_permissions_folders_folder_id");
+
+                    b.HasOne("I2R.Storage.Api.Database.Models.PermissionGroup", "Group")
+                        .WithMany()
+                        .HasForeignKey("GroupId")
+                        .OnDelete(DeleteBehavior.Cascade)
+                        .IsRequired()
+                        .HasConstraintName("fk_permissions_permission_groups_group_id");
+
+                    b.Navigation("Group");
+                });
+
+            modelBuilder.Entity("I2R.Storage.Api.Database.Models.User", b =>
+                {
+                    b.HasOne("I2R.Storage.Api.Database.Models.PermissionGroup", null)
+                        .WithMany("Users")
+                        .HasForeignKey("PermissionGroupId")
+                        .HasConstraintName("fk_users_permission_groups_permission_group_id");
+                });
+
+            modelBuilder.Entity("I2R.Storage.Api.Database.Models.File", b =>
+                {
+                    b.Navigation("Permissions");
+                });
+
+            modelBuilder.Entity("I2R.Storage.Api.Database.Models.Folder", b =>
+                {
+                    b.Navigation("Files");
+
+                    b.Navigation("Permissions");
+                });
+
+            modelBuilder.Entity("I2R.Storage.Api.Database.Models.PermissionGroup", b =>
+                {
+                    b.Navigation("Users");
+                });
+#pragma warning restore 612, 618
+        }
+    }
+}
diff --git a/code/api/Migrations/20240224160817_UpdateFeb2024.cs b/code/api/Migrations/20240224160817_UpdateFeb2024.cs
new file mode 100644
index 0000000..71432c5
--- /dev/null
+++ b/code/api/Migrations/20240224160817_UpdateFeb2024.cs
@@ -0,0 +1,208 @@
+#nullable disable
+
+using Microsoft.EntityFrameworkCore.Migrations;
+
+namespace Quality.Storage.Api.Migrations
+{
+    /// <inheritdoc />
+    public partial class UpdateFeb2024 : Migration
+    {
+        /// <inheritdoc />
+        protected override void Up(MigrationBuilder migrationBuilder)
+        {
+            migrationBuilder.DropColumn(
+                name: "owning_user_id",
+                table: "users");
+
+            migrationBuilder.AlterColumn<string>(
+                name: "username",
+                table: "users",
+                type: "character varying(100)",
+                maxLength: 100,
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "text",
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "password",
+                table: "users",
+                type: "character varying(100)",
+                maxLength: 100,
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "text",
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "last_name",
+                table: "users",
+                type: "character varying(100)",
+                maxLength: 100,
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "text",
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "first_name",
+                table: "users",
+                type: "character varying(100)",
+                maxLength: 100,
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "text",
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "name",
+                table: "permission_groups",
+                type: "character varying(100)",
+                maxLength: 100,
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "text",
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "description",
+                table: "permission_groups",
+                type: "character varying(450)",
+                maxLength: 450,
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "text",
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "name",
+                table: "folders",
+                type: "character varying(200)",
+                maxLength: 200,
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "text",
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "name",
+                table: "files",
+                type: "character varying(200)",
+                maxLength: 200,
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "text",
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "mime_type",
+                table: "files",
+                type: "character varying(100)",
+                maxLength: 100,
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "text",
+                oldNullable: true);
+        }
+
+        /// <inheritdoc />
+        protected override void Down(MigrationBuilder migrationBuilder)
+        {
+            migrationBuilder.AlterColumn<string>(
+                name: "username",
+                table: "users",
+                type: "text",
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "character varying(100)",
+                oldMaxLength: 100,
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "password",
+                table: "users",
+                type: "text",
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "character varying(100)",
+                oldMaxLength: 100,
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "last_name",
+                table: "users",
+                type: "text",
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "character varying(100)",
+                oldMaxLength: 100,
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "first_name",
+                table: "users",
+                type: "text",
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "character varying(100)",
+                oldMaxLength: 100,
+                oldNullable: true);
+
+            migrationBuilder.AddColumn<Guid>(
+                name: "owning_user_id",
+                table: "users",
+                type: "uuid",
+                nullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "name",
+                table: "permission_groups",
+                type: "text",
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "character varying(100)",
+                oldMaxLength: 100,
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "description",
+                table: "permission_groups",
+                type: "text",
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "character varying(450)",
+                oldMaxLength: 450,
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "name",
+                table: "folders",
+                type: "text",
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "character varying(200)",
+                oldMaxLength: 200,
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "name",
+                table: "files",
+                type: "text",
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "character varying(200)",
+                oldMaxLength: 200,
+                oldNullable: true);
+
+            migrationBuilder.AlterColumn<string>(
+                name: "mime_type",
+                table: "files",
+                type: "text",
+                nullable: true,
+                oldClrType: typeof(string),
+                oldType: "character varying(100)",
+                oldMaxLength: 100,
+                oldNullable: true);
+        }
+    }
+}
diff --git a/code/api/Migrations/AppDatabaseModelSnapshot.cs b/code/api/Migrations/AppDatabaseModelSnapshot.cs
index 4d471ce..c159966 100644
--- a/code/api/Migrations/AppDatabaseModelSnapshot.cs
+++ b/code/api/Migrations/AppDatabaseModelSnapshot.cs
@@ -1,14 +1,10 @@
 // <auto-generated />
-using System;
-using I2R.Storage.Api.Database;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
 
 #nullable disable
 
-namespace I2R.Storage.Api.Migrations
+using Microsoft.EntityFrameworkCore.Infrastructure;
+
+namespace Quality.Storage.Api.Migrations
 {
     [DbContext(typeof(AppDatabase))]
     partial class AppDatabaseModelSnapshot : ModelSnapshot
@@ -17,7 +13,7 @@ namespace I2R.Storage.Api.Migrations
         {
 #pragma warning disable 612, 618
             modelBuilder
-                .HasAnnotation("ProductVersion", "7.0.1")
+                .HasAnnotation("ProductVersion", "8.0.2")
                 .HasAnnotation("Relational:MaxIdentifierLength", 63);
 
             NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
@@ -66,11 +62,13 @@ namespace I2R.Storage.Api.Migrations
                         .HasColumnName("last_modified_by");
 
                     b.Property<string>("MimeType")
-                        .HasColumnType("text")
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
                         .HasColumnName("mime_type");
 
                     b.Property<string>("Name")
-                        .HasColumnType("text")
+                        .HasMaxLength(200)
+                        .HasColumnType("character varying(200)")
                         .HasColumnName("name");
 
                     b.Property<Guid?>("OwningUserId")
@@ -130,7 +128,8 @@ namespace I2R.Storage.Api.Migrations
                         .HasColumnName("last_modified_by");
 
                     b.Property<string>("Name")
-                        .HasColumnType("text")
+                        .HasMaxLength(200)
+                        .HasColumnType("character varying(200)")
                         .HasColumnName("name");
 
                     b.Property<Guid?>("OwningUserId")
@@ -244,7 +243,8 @@ namespace I2R.Storage.Api.Migrations
                         .HasColumnName("created_by");
 
                     b.Property<string>("Description")
-                        .HasColumnType("text")
+                        .HasMaxLength(450)
+                        .HasColumnType("character varying(450)")
                         .HasColumnName("description");
 
                     b.Property<DateTime?>("LastDeletedAt")
@@ -264,7 +264,8 @@ namespace I2R.Storage.Api.Migrations
                         .HasColumnName("last_modified_by");
 
                     b.Property<string>("Name")
-                        .HasColumnType("text")
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
                         .HasColumnName("name");
 
                     b.Property<Guid?>("OwningUserId")
@@ -293,7 +294,8 @@ namespace I2R.Storage.Api.Migrations
                         .HasColumnName("created_by");
 
                     b.Property<string>("FirstName")
-                        .HasColumnType("text")
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
                         .HasColumnName("first_name");
 
                     b.Property<DateTime?>("LastDeletedAt")
@@ -317,15 +319,13 @@ namespace I2R.Storage.Api.Migrations
                         .HasColumnName("last_modified_by");
 
                     b.Property<string>("LastName")
-                        .HasColumnType("text")
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
                         .HasColumnName("last_name");
 
-                    b.Property<Guid?>("OwningUserId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("owning_user_id");
-
                     b.Property<string>("Password")
-                        .HasColumnType("text")
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
                         .HasColumnName("password");
 
                     b.Property<Guid?>("PermissionGroupId")
@@ -337,7 +337,8 @@ namespace I2R.Storage.Api.Migrations
                         .HasColumnName("role");
 
                     b.Property<string>("Username")
-                        .HasColumnType("text")
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
                         .HasColumnName("username");
 
                     b.HasKey("Id")