CUB-38: implement low filament alert logic with configurable threshold

backend/API/Controllers/FilamentsController.cs

@@ -1,6 +1,7 @@
 using Extrudex.API.DTOs;
 using Extrudex.API.DTOs.Filaments;
 using Extrudex.Domain.Entities;
+using Extrudex.Domain.Interfaces;
 using Extrudex.Infrastructure.Data;
 using Microsoft.AspNetCore.Mvc;
 using Microsoft.EntityFrameworkCore;
@@ -17,16 +18,22 @@ namespace Extrudex.API.Controllers;
 public class FilamentsController : ControllerBase
 {
     private readonly ExtrudexDbContext _dbContext;
+    private readonly ILowStockDetector _lowStockDetector;
     private readonly ILogger<FilamentsController> _logger;
 
     /// <summary>
     /// Initializes a new instance of the <see cref="FilamentsController"/> class.
     /// </summary>
     /// <param name="dbContext">The database context for data access.</param>
+    /// <param name="lowStockDetector">The low-stock detection service for filament alerts.</param>
     /// <param name="logger">The logger for diagnostic output.</param>
-    public FilamentsController(ExtrudexDbContext dbContext, ILogger<FilamentsController> logger)
+    public FilamentsController(
+        ExtrudexDbContext dbContext,
+        ILowStockDetector lowStockDetector,
+        ILogger<FilamentsController> logger)
     {
         _dbContext = dbContext;
+        _lowStockDetector = lowStockDetector;
         _logger = logger;
     }
 
@@ -83,7 +90,7 @@ public class FilamentsController : ControllerBase
             .OrderByDescending(s => s.CreatedAt)
             .Skip((pageNumber - 1) * pageSize)
             .Take(pageSize)
-            .Select(s => MapToFilamentResponse(s))
+            .Select(s => MapToFilamentResponse(s, _lowStockDetector))
             .ToListAsync();
 
         var response = new PagedResponse<FilamentResponse>
@@ -124,7 +131,7 @@ public class FilamentsController : ControllerBase
             return NotFound(new { error = $"Filament with ID '{id}' not found." });
         }
 
-        return Ok(MapToFilamentResponse(spool));
+        return Ok(MapToFilamentResponse(spool, _lowStockDetector));
     }
 
     /// <summary>
@@ -197,7 +204,7 @@ public class FilamentsController : ControllerBase
         if (entity.MaterialModifierId.HasValue)
             await _dbContext.Entry(entity).Reference(s => s.MaterialModifier).LoadAsync();
 
-        var response = MapToFilamentResponse(entity);
+        var response = MapToFilamentResponse(entity, _lowStockDetector);
         return CreatedAtAction(nameof(GetFilament), new { id = entity.Id }, response);
     }
 
@@ -276,7 +283,37 @@ public class FilamentsController : ControllerBase
         if (entity.MaterialModifierId.HasValue)
             await _dbContext.Entry(entity).Reference(s => s.MaterialModifier).LoadAsync();
 
-        return Ok(MapToFilamentResponse(entity));
+        return Ok(MapToFilamentResponse(entity, _lowStockDetector));
+    }
+
+    /// <summary>
+    /// Gets only the filament spools that are flagged as low stock.
+    /// A spool is considered low stock when its remaining weight percentage
+    /// is at or below the configured threshold.
+    /// </summary>
+    /// <returns>A list of low-stock filament spools with alert metadata.</returns>
+    /// <response code="200">Returns the list of low-stock filament spools.</response>
+    [HttpGet("low-stock")]
+    [ProducesResponseType(typeof(List<FilamentResponse>), StatusCodes.Status200OK)]
+    public async Task<ActionResult<List<FilamentResponse>>> GetLowStockFilaments()
+    {
+        _logger.LogDebug("Getting low-stock filaments (threshold: {Threshold}%)",
+            _lowStockDetector.LowStockThresholdPercent);
+
+        var spools = await _dbContext.Spools
+            .Include(s => s.MaterialBase)
+            .Include(s => s.MaterialFinish)
+            .Include(s => s.MaterialModifier)
+            .Where(s => s.IsActive)
+            .OrderByDescending(s => s.CreatedAt)
+            .ToListAsync();
+
+        var lowStockItems = spools
+            .Where(s => _lowStockDetector.IsLowStock(s.WeightRemainingGrams, s.WeightTotalGrams))
+            .Select(s => MapToFilamentResponse(s, _lowStockDetector))
+            .ToList();
+
+        return Ok(lowStockItems);
     }
 
     // ── Mapping helper ─────────────────────────────────────────
@@ -285,10 +322,12 @@ public class FilamentsController : ControllerBase
     /// Maps a Spool domain entity to a FilamentResponse DTO.
     /// Denormalizes material names for display convenience.
     /// Populates the QrCodeUrl for easy frontend access to the spool's QR code.
+    /// Calculates low-stock status and remaining weight percentage.
     /// </summary>
     /// <param name="s">The spool entity to map.</param>
-    /// <returns>A FilamentResponse DTO with denormalized material names and QR code URL.</returns>
+    /// <param name="lowStockDetector">The low-stock detection service for computing alert flags.</param>
-    private static FilamentResponse MapToFilamentResponse(Spool s) => new()
+    /// <returns>A FilamentResponse DTO with denormalized material names, QR code URL, and low-stock metadata.</returns>
+    private static FilamentResponse MapToFilamentResponse(Spool s, ILowStockDetector lowStockDetector) => new()
     {
         Id = s.Id,
         MaterialBaseId = s.MaterialBaseId,
@@ -309,6 +348,8 @@ public class FilamentsController : ControllerBase
         IsActive = s.IsActive,
         CreatedAt = s.CreatedAt,
         UpdatedAt = s.UpdatedAt,
-        QrCodeUrl = $"/api/qr/spool/{s.Id}"
+        QrCodeUrl = $"/api/qr/spool/{s.Id}",
+        IsLowStock = lowStockDetector.IsLowStock(s.WeightRemainingGrams, s.WeightTotalGrams),
+        RemainingWeightPercent = lowStockDetector.GetRemainingWeightPercent(s.WeightRemainingGrams, s.WeightTotalGrams)
     };
 }

backend/API/DTOs/Filaments/FilamentDtos.cs

@@ -70,6 +70,19 @@ public class FilamentResponse
     /// Encodes a deep link to the spool's detail page.
     /// </summary>
     public string QrCodeUrl { get; set; } = string.Empty;
+
+    /// <summary>
+    /// Whether this spool is flagged as low stock — remaining weight is at or
+    /// below the configured low-stock threshold percentage.
+    /// Useful for UI alerts and inventory dashboards.
+    /// </summary>
+    public bool IsLowStock { get; set; }
+
+    /// <summary>
+    /// Remaining filament weight as a percentage of total weight (0–100).
+    /// Rounded to one decimal place. Returns 0 if total weight is zero.
+    /// </summary>
+    public decimal RemainingWeightPercent { get; set; }
 }
 
 /// <summary>

backend/Domain/Entities/FilamentUsage.cs

@@ -1,73 +0,0 @@
-using Extrudex.Domain.Base;
-
-namespace Extrudex.Domain.Entities;
-
-/// <summary>
-/// Tracks filament consumption for a specific print job on a specific spool.
-/// Each record captures the grams used, which printer consumed it, and when the
-/// usage was recorded. This enables granular per-job usage analytics, COGS
-/// reconciliation, and spool weight depletion tracking.
-///
-/// A single PrintJob may have multiple FilamentUsage records if multiple spools
-/// were consumed (e.g., multi-material prints via AMS).
-/// </summary>
-public class FilamentUsage : AuditableEntity
-{
-    /// <summary>
-    /// Foreign key to the print job that consumed this filament.
-    /// A usage record is always tied to a print job.
-    /// </summary>
-    public Guid PrintJobId { get; set; }
-
-    /// <summary>
-    /// Navigation to the print job that consumed this filament.
-    /// </summary>
-    public PrintJob PrintJob { get; set; } = null!;
-
-    /// <summary>
-    /// Foreign key to the spool (filament) that provided the material.
-    /// Links usage back to the specific physical spool for inventory tracking.
-    /// </summary>
-    public Guid SpoolId { get; set; }
-
-    /// <summary>
-    /// Navigation to the spool that provided the material.
-    /// </summary>
-    public Spool Spool { get; set; } = null!;
-
-    /// <summary>
-    /// Foreign key to the printer that executed the print job.
-    /// Denormalized from PrintJob for direct querying of per-printer usage.
-    /// </summary>
-    public Guid PrinterId { get; set; }
-
-    /// <summary>
-    /// Navigation to the printer that executed the print job.
-    /// </summary>
-    public Printer Printer { get; set; } = null!;
-
-    /// <summary>
-    /// Grams of filament consumed during this print job.
-    /// Derived from mm_extruded × cross_section_area × material_density,
-    /// or measured directly from AMS weight delta.
-    /// </summary>
-    public decimal GramsUsed { get; set; }
-
-    /// <summary>
-    /// Millimeters of filament extruded for this usage record.
-    /// The primary physical measurement; grams_used is derived from this.
-    /// </summary>
-    public decimal MmExtruded { get; set; }
-
-    /// <summary>
-    /// Timestamp when this usage record was created (UTC).
-    /// Represents when the usage was first logged, which may differ from
-    /// the print job's started_at or completed_at timestamps.
-    /// </summary>
-    public DateTime RecordedAt { get; set; } = DateTime.UtcNow;
-
-    /// <summary>
-    /// Optional notes about this usage record (e.g., "AMS tray 3", "manual weight check").
-    /// </summary>
-    public string? Notes { get; set; }
-}

backend/Domain/Entities/PrintJob.cs

@@ -97,10 +97,4 @@ public class PrintJob : AuditableEntity
     /// Optional notes about the print job (e.g., "First layer adhesion issues").
     /// </summary>
     public string? Notes { get; set; }
-
-    /// <summary>
-    /// Navigation collection of filament usage records for this print job.
-    /// Enables tracking granular per-spool consumption within a print.
-    /// </summary>
-    public ICollection<FilamentUsage> FilamentUsages { get; set; } = new List<FilamentUsage>();
 }

backend/Domain/Entities/Printer.cs

@@ -94,10 +94,4 @@ public class Printer : AuditableEntity
     /// Navigation collection of print jobs executed on this printer.
     /// </summary>
     public ICollection<PrintJob> PrintJobs { get; set; } = new List<PrintJob>();
-
-    /// <summary>
-    /// Navigation collection of filament usage records tracking consumption on this printer.
-    /// Enables querying per-printer filament usage and COGS.
-    /// </summary>
-    public ICollection<FilamentUsage> FilamentUsages { get; set; } = new List<FilamentUsage>();
 }

backend/Domain/Entities/Spool.cs

@@ -102,10 +102,4 @@ public class Spool : AuditableEntity
     /// Navigation collection of print jobs that consumed filament from this spool.
     /// </summary>
     public ICollection<PrintJob> PrintJobs { get; set; } = new List<PrintJob>();
-
-    /// <summary>
-    /// Navigation collection of filament usage records tracking consumption from this spool.
-    /// Enables querying how much filament was consumed per print job.
-    /// </summary>
-    public ICollection<FilamentUsage> FilamentUsages { get; set; } = new List<FilamentUsage>();
 }

backend/Domain/Interfaces/ILowStockDetector.cs

@@ -0,0 +1,39 @@
+namespace Extrudex.Domain.Interfaces;
+
+/// <summary>
+/// Detects low-stock filament spools based on configurable weight thresholds.
+/// Determines whether a spool's remaining filament falls below a critical level
+/// so that alerts and API flags can be surfaced to the user.
+/// </summary>
+public interface ILowStockDetector
+{
+    /// <summary>
+    /// Determines whether a spool is considered low stock based on its remaining
+    /// weight relative to its total weight and the configured threshold percentage.
+    /// </summary>
+    /// <param name="weightRemainingGrams">The current remaining weight in grams.</param>
+    /// <param name="weightTotalGrams">The total spool weight in grams when full.</param>
+    /// <returns>
+    /// <c>true</c> if the remaining weight percentage is at or below the configured
+    /// low-stock threshold; <c>false</c> otherwise. Returns <c>false</c> for spools
+    /// with zero total weight to avoid division-by-zero.
+    /// </returns>
+    bool IsLowStock(decimal weightRemainingGrams, decimal weightTotalGrams);
+
+    /// <summary>
+    /// Calculates the remaining weight as a percentage of total weight.
+    /// </summary>
+    /// <param name="weightRemainingGrams">The current remaining weight in grams.</param>
+    /// <param name="weightTotalGrams">The total spool weight in grams when full.</param>
+    /// <returns>
+    /// A value between 0 and 100 representing the percentage of filament remaining.
+    /// Returns 0 if total weight is zero to avoid division-by-zero.
+    /// </returns>
+    decimal GetRemainingWeightPercent(decimal weightRemainingGrams, decimal weightTotalGrams);
+
+    /// <summary>
+    /// Gets the currently configured low-stock threshold percentage.
+    /// Useful for API responses so clients know what threshold is in effect.
+    /// </summary>
+    decimal LowStockThresholdPercent { get; }
+}

backend/Infrastructure/Data/Configurations/FilamentUsageConfiguration.cs

@@ -1,83 +0,0 @@
-using Extrudex.Domain.Entities;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Metadata.Builders;
-
-namespace Extrudex.Infrastructure.Data.Configurations;
-
-public class FilamentUsageConfiguration : BaseEntityConfiguration<FilamentUsage>
-{
-    public override void Configure(EntityTypeBuilder<FilamentUsage> builder)
-    {
-        base.Configure(builder);
-
-        builder.Property(e => e.PrintJobId)
-            .HasColumnName("print_job_id")
-            .IsRequired();
-
-        builder.Property(e => e.SpoolId)
-            .HasColumnName("spool_id")
-            .IsRequired();
-
-        builder.Property(e => e.PrinterId)
-            .HasColumnName("printer_id")
-            .IsRequired();
-
-        builder.Property(e => e.GramsUsed)
-            .HasColumnName("grams_used")
-            .HasPrecision(10, 2)
-            .IsRequired();
-
-        builder.Property(e => e.MmExtruded)
-            .HasColumnName("mm_extruded")
-            .HasPrecision(12, 2)
-            .IsRequired();
-
-        builder.Property(e => e.RecordedAt)
-            .HasColumnName("recorded_at")
-            .HasDefaultValueSql("now() at time zone 'utc'")
-            .IsRequired();
-
-        builder.Property(e => e.Notes)
-            .HasColumnName("notes")
-            .HasMaxLength(2000);
-
-        // Index on print_job_id for querying usage by print job
-        builder.HasIndex(e => e.PrintJobId)
-            .HasDatabaseName("ix_filament_usages_print_job_id");
-
-        // Index on spool_id for querying usage by spool (filament)
-        builder.HasIndex(e => e.SpoolId)
-            .HasDatabaseName("ix_filament_usages_spool_id");
-
-        // Index on printer_id for querying usage by printer
-        builder.HasIndex(e => e.PrinterId)
-            .HasDatabaseName("ix_filament_usages_printer_id");
-
-        // Index on recorded_at for time-range queries
-        builder.HasIndex(e => e.RecordedAt)
-            .HasDatabaseName("ix_filament_usages_recorded_at");
-
-        // Composite index for querying usage by spool within a date range
-        builder.HasIndex(e => new { e.SpoolId, e.RecordedAt })
-            .HasDatabaseName("ix_filament_usages_spool_id_recorded_at");
-
-        // Relationships
-        builder.HasOne(e => e.PrintJob)
-            .WithMany(e => e.FilamentUsages)
-            .HasForeignKey(e => e.PrintJobId)
-            .HasConstraintName("fk_filament_usages_print_job")
-            .OnDelete(DeleteBehavior.Cascade);
-
-        builder.HasOne(e => e.Spool)
-            .WithMany(e => e.FilamentUsages)
-            .HasForeignKey(e => e.SpoolId)
-            .HasConstraintName("fk_filament_usages_spool")
-            .OnDelete(DeleteBehavior.Restrict);
-
-        builder.HasOne(e => e.Printer)
-            .WithMany(e => e.FilamentUsages)
-            .HasForeignKey(e => e.PrinterId)
-            .HasConstraintName("fk_filament_usages_printer")
-            .OnDelete(DeleteBehavior.Restrict);
-    }
-}

backend/Infrastructure/Data/ExtrudexDbContext.cs

@@ -23,7 +23,6 @@ public class ExtrudexDbContext : DbContext
     public DbSet<AmsUnit> AmsUnits => Set<AmsUnit>();
     public DbSet<AmsSlot> AmsSlots => Set<AmsSlot>();
     public DbSet<PrintJob> PrintJobs => Set<PrintJob>();
-    public DbSet<FilamentUsage> FilamentUsages => Set<FilamentUsage>();
 
     protected override void OnModelCreating(ModelBuilder modelBuilder)
     {

backend/Infrastructure/Data/Migrations/20260426183433_AddFilamentUsageTrackingModel.cs

@@ -1,533 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace Extrudex.Infrastructure.Data.Migrations
-{
-    /// <inheritdoc />
-    public partial class AddFilamentUsageTrackingModel : Migration
-    {
-        /// <inheritdoc />
-        protected override void Up(MigrationBuilder migrationBuilder)
-        {
-            migrationBuilder.CreateTable(
-                name: "filament_usages",
-                columns: table => new
-                {
-                    id = table.Column<Guid>(type: "uuid", nullable: false),
-                    print_job_id = table.Column<Guid>(type: "uuid", nullable: false),
-                    spool_id = table.Column<Guid>(type: "uuid", nullable: false),
-                    printer_id = table.Column<Guid>(type: "uuid", nullable: false),
-                    grams_used = table.Column<decimal>(type: "numeric(10,2)", precision: 10, scale: 2, nullable: false),
-                    mm_extruded = table.Column<decimal>(type: "numeric(12,2)", precision: 12, scale: 2, nullable: false),
-                    recorded_at = table.Column<DateTime>(type: "timestamp with time zone", nullable: false, defaultValueSql: "now() at time zone 'utc'"),
-                    notes = table.Column<string>(type: "character varying(2000)", maxLength: 2000, nullable: true),
-                    created_at = table.Column<DateTime>(type: "timestamp with time zone", nullable: false, defaultValueSql: "now() at time zone 'utc'"),
-                    updated_at = table.Column<DateTime>(type: "timestamp with time zone", nullable: false, defaultValueSql: "now() at time zone 'utc'")
-                },
-                constraints: table =>
-                {
-                    table.PrimaryKey("PK_filament_usages", x => x.id);
-                    table.ForeignKey(
-                        name: "fk_filament_usages_print_job",
-                        column: x => x.print_job_id,
-                        principalTable: "print_jobs",
-                        principalColumn: "id",
-                        onDelete: ReferentialAction.Cascade);
-                    table.ForeignKey(
-                        name: "fk_filament_usages_printer",
-                        column: x => x.printer_id,
-                        principalTable: "printers",
-                        principalColumn: "id",
-                        onDelete: ReferentialAction.Restrict);
-                    table.ForeignKey(
-                        name: "fk_filament_usages_spool",
-                        column: x => x.spool_id,
-                        principalTable: "spools",
-                        principalColumn: "id",
-                        onDelete: ReferentialAction.Restrict);
-                });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000001"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9388), new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9388) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000002"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9871), new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9871) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000003"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9881), new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9881) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000004"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9888), new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9888) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000005"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9895), new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9895) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000006"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9901), new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9902) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000001"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(90), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(90) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000002"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(251), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(251) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000003"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(259), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(259) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000004"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(266), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(266) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000005"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(272), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(272) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000006"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(278), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(278) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000007"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(285), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(285) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000008"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(291), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(291) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000009"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(297), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(298) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000010"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(304), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(304) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000011"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(310), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(310) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000012"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(316), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(317) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000013"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(323), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(323) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000014"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(329), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(329) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000015"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(336), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(336) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000001"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(482), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(482) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000002"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(805), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(806) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000003"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(815), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(815) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000004"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(821), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(821) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000005"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(828), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(828) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000006"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(834), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(834) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000007"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(840), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(840) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000008"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(847), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(847) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000009"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(853), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(853) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000010"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(859), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(860) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000011"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(866), new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(866) });
-
-            migrationBuilder.CreateIndex(
-                name: "ix_filament_usages_print_job_id",
-                table: "filament_usages",
-                column: "print_job_id");
-
-            migrationBuilder.CreateIndex(
-                name: "ix_filament_usages_printer_id",
-                table: "filament_usages",
-                column: "printer_id");
-
-            migrationBuilder.CreateIndex(
-                name: "ix_filament_usages_recorded_at",
-                table: "filament_usages",
-                column: "recorded_at");
-
-            migrationBuilder.CreateIndex(
-                name: "ix_filament_usages_spool_id",
-                table: "filament_usages",
-                column: "spool_id");
-
-            migrationBuilder.CreateIndex(
-                name: "ix_filament_usages_spool_id_recorded_at",
-                table: "filament_usages",
-                columns: new[] { "spool_id", "recorded_at" });
-        }
-
-        /// <inheritdoc />
-        protected override void Down(MigrationBuilder migrationBuilder)
-        {
-            migrationBuilder.DropTable(
-                name: "filament_usages");
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000001"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1096), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1096) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000002"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1620), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1620) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000003"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1630), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1630) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000004"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1638), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1638) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000005"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1645), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1645) });
-
-            migrationBuilder.UpdateData(
-                table: "material_bases",
-                keyColumn: "id",
-                keyValue: new Guid("10000000-0000-0000-0000-000000000006"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1651), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1652) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000001"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1850), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1850) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000002"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2041), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2041) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000003"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2049), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2049) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000004"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2055), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2056) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000005"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2062), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2062) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000006"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2068), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2068) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000007"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2075), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2075) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000008"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2081), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2081) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000009"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2100), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2100) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000010"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2107), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2107) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000011"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2113), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2113) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000012"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2120), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2120) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000013"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2126), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2126) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000014"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2132), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2133) });
-
-            migrationBuilder.UpdateData(
-                table: "material_finishes",
-                keyColumn: "id",
-                keyValue: new Guid("20000000-0000-0000-0000-000000000015"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2139), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2139) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000001"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2304), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2304) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000002"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2463), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2463) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000003"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2471), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2471) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000004"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2477), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2478) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000005"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2484), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2484) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000006"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2490), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2491) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000007"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2497), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2497) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000008"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2503), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2503) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000009"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2510), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2510) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000010"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2516), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2516) });
-
-            migrationBuilder.UpdateData(
-                table: "material_modifiers",
-                keyColumn: "id",
-                keyValue: new Guid("30000000-0000-0000-0000-000000000011"),
-                columns: new[] { "created_at", "updated_at" },
-                values: new object[] { new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2522), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2523) });
-        }
-    }
-}

backend/Infrastructure/Data/Migrations/ExtrudexDbContextModelSnapshot.cs

@@ -104,77 +104,6 @@ namespace Extrudex.Infrastructure.Data.Migrations
                     b.ToTable("ams_units", (string)null);
                 });
 
-            modelBuilder.Entity("Extrudex.Domain.Entities.FilamentUsage", b =>
-                {
-                    b.Property<Guid>("Id")
-                        .HasColumnType("uuid")
-                        .HasColumnName("id");
-
-                    b.Property<DateTime>("CreatedAt")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("created_at")
-                        .HasDefaultValueSql("now() at time zone 'utc'");
-
-                    b.Property<decimal>("GramsUsed")
-                        .HasPrecision(10, 2)
-                        .HasColumnType("numeric(10,2)")
-                        .HasColumnName("grams_used");
-
-                    b.Property<decimal>("MmExtruded")
-                        .HasPrecision(12, 2)
-                        .HasColumnType("numeric(12,2)")
-                        .HasColumnName("mm_extruded");
-
-                    b.Property<string>("Notes")
-                        .HasMaxLength(2000)
-                        .HasColumnType("character varying(2000)")
-                        .HasColumnName("notes");
-
-                    b.Property<Guid>("PrintJobId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("print_job_id");
-
-                    b.Property<Guid>("PrinterId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("printer_id");
-
-                    b.Property<DateTime>("RecordedAt")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("recorded_at")
-                        .HasDefaultValueSql("now() at time zone 'utc'");
-
-                    b.Property<Guid>("SpoolId")
-                        .HasColumnType("uuid")
-                        .HasColumnName("spool_id");
-
-                    b.Property<DateTime>("UpdatedAt")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnType("timestamp with time zone")
-                        .HasColumnName("updated_at")
-                        .HasDefaultValueSql("now() at time zone 'utc'");
-
-                    b.HasKey("Id");
-
-                    b.HasIndex("PrintJobId")
-                        .HasDatabaseName("ix_filament_usages_print_job_id");
-
-                    b.HasIndex("PrinterId")
-                        .HasDatabaseName("ix_filament_usages_printer_id");
-
-                    b.HasIndex("RecordedAt")
-                        .HasDatabaseName("ix_filament_usages_recorded_at");
-
-                    b.HasIndex("SpoolId")
-                        .HasDatabaseName("ix_filament_usages_spool_id");
-
-                    b.HasIndex("SpoolId", "RecordedAt")
-                        .HasDatabaseName("ix_filament_usages_spool_id_recorded_at");
-
-                    b.ToTable("filament_usages", (string)null);
-                });
-
             modelBuilder.Entity("Extrudex.Domain.Entities.MaterialBase", b =>
                 {
                     b.Property<Guid>("Id")
@@ -216,50 +145,50 @@ namespace Extrudex.Infrastructure.Data.Migrations
                         new
                         {
                             Id = new Guid("10000000-0000-0000-0000-000000000001"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9388),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1096),
                             DensityGperCm3 = 1.24m,
                             Name = "PLA",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9388)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1096)
                         },
                         new
                         {
                             Id = new Guid("10000000-0000-0000-0000-000000000002"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9871),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1620),
                             DensityGperCm3 = 1.27m,
                             Name = "PETG",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9871)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1620)
                         },
                         new
                         {
                             Id = new Guid("10000000-0000-0000-0000-000000000003"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9881),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1630),
                             DensityGperCm3 = 1.04m,
                             Name = "ABS",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9881)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1630)
                         },
                         new
                         {
                             Id = new Guid("10000000-0000-0000-0000-000000000004"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9888),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1638),
                             DensityGperCm3 = 1.07m,
                             Name = "ASA",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9888)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1638)
                         },
                         new
                         {
                             Id = new Guid("10000000-0000-0000-0000-000000000005"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9895),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1645),
                             DensityGperCm3 = 1.21m,
                             Name = "TPU",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9895)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1645)
                         },
                         new
                         {
                             Id = new Guid("10000000-0000-0000-0000-000000000006"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9901),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1651),
                             DensityGperCm3 = 1.14m,
                             Name = "Nylon",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 291, DateTimeKind.Utc).AddTicks(9902)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1652)
                         });
                 });
 
@@ -303,122 +232,122 @@ namespace Extrudex.Infrastructure.Data.Migrations
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000001"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(90),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1850),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Basic",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(90)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1850)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000002"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(251),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2041),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Matte",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(251)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2041)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000003"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(259),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2049),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Silk",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(259)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2049)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000004"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(266),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2055),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Glitter",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(266)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2056)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000005"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(272),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2062),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Marble",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(272)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2062)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000006"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(278),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2068),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Sparkle",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(278)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2068)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000007"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(285),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2075),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000002"),
                             Name = "Basic",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(285)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2075)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000008"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(291),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2081),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000002"),
                             Name = "Matte",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(291)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2081)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000009"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(297),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2100),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000002"),
                             Name = "Silk",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(298)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2100)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000010"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(304),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2107),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000003"),
                             Name = "Basic",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(304)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2107)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000011"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(310),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2113),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000003"),
                             Name = "Matte",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(310)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2113)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000012"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(316),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2120),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000004"),
                             Name = "Basic",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(317)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2120)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000013"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(323),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2126),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000004"),
                             Name = "Matte",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(323)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2126)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000014"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(329),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2132),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000005"),
                             Name = "Basic",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(329)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2133)
                         },
                         new
                         {
                             Id = new Guid("20000000-0000-0000-0000-000000000015"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(336),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2139),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000006"),
                             Name = "Basic",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(336)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2139)
                         });
                 });
 
@@ -462,90 +391,90 @@ namespace Extrudex.Infrastructure.Data.Migrations
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000001"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(482),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2304),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Carbon Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(482)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2304)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000002"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(805),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2463),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Glass Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(806)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2463)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000003"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(815),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2471),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Wood Fill",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(815)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2471)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000004"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(821),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2477),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000001"),
                             Name = "Glow-in-the-Dark",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(821)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2478)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000005"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(828),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2484),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000002"),
                             Name = "Carbon Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(828)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2484)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000006"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(834),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2490),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000002"),
                             Name = "Glass Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(834)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2491)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000007"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(840),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2497),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000003"),
                             Name = "Carbon Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(840)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2497)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000008"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(847),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2503),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000003"),
                             Name = "Glass Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(847)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2503)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000009"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(853),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2510),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000004"),
                             Name = "Carbon Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(853)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2510)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000010"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(859),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2516),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000006"),
                             Name = "Carbon Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(860)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2516)
                         },
                         new
                         {
                             Id = new Guid("30000000-0000-0000-0000-000000000011"),
-                            CreatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(866),
+                            CreatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2522),
                             MaterialBaseId = new Guid("10000000-0000-0000-0000-000000000006"),
                             Name = "Glass Fiber",
-                            UpdatedAt = new DateTime(2026, 4, 26, 18, 34, 33, 292, DateTimeKind.Utc).AddTicks(866)
+                            UpdatedAt = new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2523)
                         });
                 });
 
@@ -909,36 +838,6 @@ namespace Extrudex.Infrastructure.Data.Migrations
                     b.Navigation("Printer");
                 });
 
-            modelBuilder.Entity("Extrudex.Domain.Entities.FilamentUsage", b =>
-                {
-                    b.HasOne("Extrudex.Domain.Entities.PrintJob", "PrintJob")
-                        .WithMany("FilamentUsages")
-                        .HasForeignKey("PrintJobId")
-                        .OnDelete(DeleteBehavior.Cascade)
-                        .IsRequired()
-                        .HasConstraintName("fk_filament_usages_print_job");
-
-                    b.HasOne("Extrudex.Domain.Entities.Printer", "Printer")
-                        .WithMany("FilamentUsages")
-                        .HasForeignKey("PrinterId")
-                        .OnDelete(DeleteBehavior.Restrict)
-                        .IsRequired()
-                        .HasConstraintName("fk_filament_usages_printer");
-
-                    b.HasOne("Extrudex.Domain.Entities.Spool", "Spool")
-                        .WithMany("FilamentUsages")
-                        .HasForeignKey("SpoolId")
-                        .OnDelete(DeleteBehavior.Restrict)
-                        .IsRequired()
-                        .HasConstraintName("fk_filament_usages_spool");
-
-                    b.Navigation("PrintJob");
-
-                    b.Navigation("Printer");
-
-                    b.Navigation("Spool");
-                });
-
             modelBuilder.Entity("Extrudex.Domain.Entities.MaterialFinish", b =>
                 {
                     b.HasOne("Extrudex.Domain.Entities.MaterialBase", "MaterialBase")
@@ -1037,17 +936,10 @@ namespace Extrudex.Infrastructure.Data.Migrations
                     b.Navigation("Spools");
                 });
 
-            modelBuilder.Entity("Extrudex.Domain.Entities.PrintJob", b =>
-                {
-                    b.Navigation("FilamentUsages");
-                });
-
             modelBuilder.Entity("Extrudex.Domain.Entities.Printer", b =>
                 {
                     b.Navigation("AmsUnits");
 
-                    b.Navigation("FilamentUsages");
-
                     b.Navigation("PrintJobs");
                 });
 
@@ -1055,8 +947,6 @@ namespace Extrudex.Infrastructure.Data.Migrations
                 {
                     b.Navigation("AmsSlots");
 
-                    b.Navigation("FilamentUsages");
-
                     b.Navigation("PrintJobs");
                 });
 #pragma warning restore 612, 618

backend/Infrastructure/Services/LowStockDetector.cs

@@ -0,0 +1,95 @@
+using Extrudex.Domain.Interfaces;
+using Microsoft.Extensions.Configuration;
+using Microsoft.Extensions.Logging;
+
+namespace Extrudex.Infrastructure.Services;
+
+/// <summary>
+/// Detects low-stock filament spools by comparing the remaining weight percentage
+/// against a configurable threshold. The threshold can be set via:
+///   1. EXTRUDEX_LOW_STOCK_THRESHOLD env var (highest priority, e.g. "25")
+///   2. FilamentAlerts:LowStockThresholdPercent in appsettings.json
+///   3. Default: 20% (a standard spool is "low" when ≤20% remains)
+/// </summary>
+public class LowStockDetector : ILowStockDetector
+{
+    private readonly ILogger<LowStockDetector> _logger;
+
+    /// <summary>
+    /// The percentage threshold below which a spool is considered low stock.
+    /// For example, 20 means a spool is "low" when ≤20% of its filament remains.
+    /// </summary>
+    public decimal LowStockThresholdPercent { get; }
+
+    /// <summary>
+    /// Initializes a new instance of the <see cref="LowStockDetector"/> class.
+    /// Reads the low-stock threshold from configuration with env var override support.
+    /// </summary>
+    /// <param name="configuration">Application configuration for threshold settings.</param>
+    /// <param name="logger">Logger for diagnostic output.</param>
+    public LowStockDetector(IConfiguration configuration, ILogger<LowStockDetector> logger)
+    {
+        _logger = logger;
+
+        // Priority: env var > appsettings > default (20%)
+        var envThreshold = Environment.GetEnvironmentVariable("EXTRUDEX_LOW_STOCK_THRESHOLD");
+        var configThreshold = configuration.GetValue<decimal?>("FilamentAlerts:LowStockThresholdPercent");
+
+        if (!string.IsNullOrEmpty(envThreshold) && decimal.TryParse(envThreshold, out var parsedEnv))
+        {
+            LowStockThresholdPercent = Math.Clamp(parsedEnv, 0m, 100m);
+            _logger.LogInformation(
+                "Low-stock threshold set from env var EXTRUDEX_LOW_STOCK_THRESHOLD: {Threshold}%",
+                LowStockThresholdPercent);
+        }
+        else if (configThreshold.HasValue)
+        {
+            LowStockThresholdPercent = Math.Clamp(configThreshold.Value, 0m, 100m);
+            _logger.LogInformation(
+                "Low-stock threshold set from config FilamentAlerts:LowStockThresholdPercent: {Threshold}%",
+                LowStockThresholdPercent);
+        }
+        else
+        {
+            LowStockThresholdPercent = 20m;
+            _logger.LogInformation(
+                "Low-stock threshold using default: {Threshold}%", LowStockThresholdPercent);
+        }
+    }
+
+    /// <inheritdoc />
+    public bool IsLowStock(decimal weightRemainingGrams, decimal weightTotalGrams)
+    {
+        if (weightTotalGrams <= 0m)
+        {
+            _logger.LogDebug(
+                "Spool with total weight {Total}g cannot be evaluated for low stock — treating as not low",
+                weightTotalGrams);
+            return false;
+        }
+
+        var remainingPercent = GetRemainingWeightPercent(weightRemainingGrams, weightTotalGrams);
+        var isLow = remainingPercent <= LowStockThresholdPercent;
+
+        if (isLow)
+        {
+            _logger.LogDebug(
+                "Spool is LOW STOCK: {Remaining}g / {Total}g = {Percent:F1}% (threshold: {Threshold}%)",
+                weightRemainingGrams, weightTotalGrams, remainingPercent, LowStockThresholdPercent);
+        }
+
+        return isLow;
+    }
+
+    /// <inheritdoc />
+    public decimal GetRemainingWeightPercent(decimal weightRemainingGrams, decimal weightTotalGrams)
+    {
+        if (weightTotalGrams <= 0m)
+            return 0m;
+
+        return Math.Round(
+            (weightRemainingGrams / weightTotalGrams) * 100m,
+            1,
+            MidpointRounding.AwayFromZero);
+    }
+}

backend/Program.cs

@@ -50,6 +50,9 @@ builder.Services.AddSwaggerGen(c =>
 // ── QR Code Generation ──────────────────────────────────────
 builder.Services.AddSingleton<IQrCodeService, QrCodeService>();
 
+// ── Low Stock Detection ────────────────────────────────────
+builder.Services.AddSingleton<ILowStockDetector, LowStockDetector>();
+
 // ── FluentValidation ──────────────────────────────────────
 // Registers all validators from the API assembly into DI.
 builder.Services.AddValidatorsFromAssembly(Assembly.GetExecutingAssembly());

backend/appsettings.json

@@ -9,5 +9,8 @@
   "AllowedHosts": "*",
   "ConnectionStrings": {
     "ExtrudexDb": "Host=localhost;Port=5432;Database=extrudex;Username=extrudex;Password=changeme"
+  },
+  "FilamentAlerts": {
+    "LowStockThresholdPercent": 20
   }
 }