merge(dev): Re-apply changes after conflict resolution

# Conflicts:
#	backend/Program.cs

.gitea/workflows/dev.yml

@@ -0,0 +1,77 @@
+name: Dev Build
+
+on:
+  pull_request:
+    branches: [dev]
+  push:
+    branches: [dev]
+
+jobs:
+  build-test:
+    runs-on: ubuntu-latest
+
+    steps:
+      - uses: actions/checkout@v4
+
+      - name: Setup .NET
+        uses: actions/setup-dotnet@v4
+        with:
+          dotnet-version: '9.0.x'
+
+      - name: Restore backend
+        run: dotnet restore
+
+      - name: Build backend
+        run: dotnet build --no-restore --configuration Release
+
+      - name: Test backend
+        run: dotnet test --no-build --configuration Release
+
+      - name: Setup Node
+        uses: actions/setup-node@v4
+        with:
+          node-version: "24"
+
+      - name: Install frontend deps
+        run: npm ci
+        working-directory: ./frontend
+
+      - name: Build frontend
+        run: npm run build
+        working-directory: ./frontend
+
+  deploy-dev:
+    needs: build-test
+    if: gitea.event_name == 'push'
+    runs-on: ubuntu-latest
+
+    steps:
+      - name: Deploy dev
+        run: |
+          echo "${{ secrets.DEV_DEPLOY_SSH_KEY }}" > /tmp/dev_key
+          chmod 600 /tmp/dev_key
+          ssh -i /tmp/dev_key -o StrictHostKeyChecking=no \
+            ${{ secrets.DEV_DEPLOY_USER }}@${{ secrets.DEV_DEPLOY_HOST }} \
+            "${{ secrets.DEV_DEPLOY_PATH }}/deploy.sh"
+
+  notify-success:
+    needs: [build-test, deploy-dev]
+    if: success() && gitea.event_name == 'push'
+    runs-on: ubuntu-latest
+    steps:
+      - name: Notify Slack success
+        run: |
+          curl -X POST -H 'Content-type: application/json' \
+            --data "{\"text\":\"✅ Extrudex dev deployed successfully from dev branch.\"}" \
+            "${{ secrets.SLACK_WEBHOOK_URL }}"
+
+  notify-failure:
+    needs: [build-test, deploy-dev]
+    if: failure()
+    runs-on: ubuntu-latest
+    steps:
+      - name: Notify Slack failure
+        run: |
+          curl -X POST -H 'Content-type: application/json' \
+            --data "{\"text\":\"🚨 Extrudex dev pipeline failed. Check Gitea Actions for details.\"}" \
+            "${{ secrets.SLACK_WEBHOOK_URL }}"

.gitignore

@@ -4,8 +4,7 @@ obj/
 *.suo
 .vs/
 
-# Frontend (Angular)
-frontend/node_modules/
+# Frontend build artifacts
 frontend/dist/
-frontend/.angular/
-frontend/*.log
+frontend/node_modules/
+frontend/.angular/

backend/.dockerignore

@@ -0,0 +1,27 @@
+# Build artifacts
+bin/
+obj/
+
+# IDE / editor
+.vs/
+.vscode/
+*.user
+*.suo
+.idea/
+
+# Environment & secrets
+appsettings.Development.json
+.env
+.env.*
+
+# Docker
+Dockerfile
+.dockerignore
+
+# OS
+.DS_Store
+Thumbs.db
+
+# Misc
+*.md
+*.log

backend/API/Controllers/PrintJobsController.cs

@@ -413,6 +413,92 @@ public class PrintJobsController : ControllerBase
         return NoContent();
     }
 
+    // ── GET /api/printjobs/{id}/cost-summary ──────────────────────────
+
+    /// <summary>
+    /// Gets the material cost summary for a specific print job.
+    /// Calculates total material cost from filament usage (grams derived)
+    /// and the spool's purchase price. Returns warnings instead of errors
+    /// when cost data is unavailable.
+    /// </summary>
+    /// <param name="id">The unique identifier of the print job.</param>
+    /// <returns>A cost summary with breakdown and any warnings about missing data.</returns>
+    /// <response code="200">Returns the cost summary. Warnings field lists any missing data.</response>
+    /// <response code="404">If the print job with the given ID is not found.</response>
+    [HttpGet("{id:guid}/cost-summary")]
+    [ProducesResponseType(typeof(CostSummaryResponse), StatusCodes.Status200OK)]
+    [ProducesResponseType(StatusCodes.Status404NotFound)]
+    public async Task<ActionResult<CostSummaryResponse>> GetCostSummary(Guid id)
+    {
+        _logger.LogDebug("Getting cost summary for print job {Id}", id);
+
+        var job = await _dbContext.PrintJobs
+            .Include(j => j.Spool)
+                .ThenInclude(s => s!.MaterialBase)
+            .FirstOrDefaultAsync(j => j.Id == id);
+
+        if (job is null)
+        {
+            _logger.LogWarning("Print job {Id} not found for cost summary", id);
+            return NotFound(new { error = $"Print job with ID '{id}' not found." });
+        }
+
+        var warnings = new List<string>();
+        var spool = job.Spool;
+
+        // Build response with what we have
+        var response = new CostSummaryResponse
+        {
+            PrintJobId = job.Id,
+            PrintName = job.PrintName,
+            SpoolId = job.SpoolId,
+            SpoolSerial = spool?.SpoolSerial ?? string.Empty,
+            SpoolBrand = spool?.Brand ?? string.Empty,
+            SpoolColorName = spool?.ColorName ?? string.Empty,
+            MmExtruded = job.MmExtruded,
+            GramsDerived = job.GramsDerived,
+            SpoolPurchasePrice = spool?.PurchasePrice,
+            SpoolWeightTotalGrams = spool?.WeightTotalGrams,
+            StoredCostPerPrint = job.CostPerPrint
+        };
+
+        // Validate spool data availability
+        if (spool is null)
+        {
+            warnings.Add("Spool data is not available for this print job. Cost cannot be calculated.");
+            response.Warnings = warnings;
+            return Ok(response);
+        }
+
+        // Check if we can calculate cost
+        if (!spool.PurchasePrice.HasValue)
+        {
+            warnings.Add("Spool purchase price is not set. Cost per gram and total material cost cannot be calculated.");
+        }
+
+        if (spool.WeightTotalGrams <= 0)
+        {
+            warnings.Add("Spool total weight is zero or invalid. Cost per gram and total material cost cannot be calculated.");
+        }
+
+        // If we have enough data, calculate the cost
+        if (spool.PurchasePrice.HasValue && spool.WeightTotalGrams > 0)
+        {
+            var pricePerGram = spool.PurchasePrice.Value / spool.WeightTotalGrams;
+            response.PricePerGram = Math.Round(pricePerGram, 4);
+            response.TotalMaterialCost = Math.Round(job.GramsDerived * pricePerGram, 4);
+        }
+
+        // Warn if grams derived is zero but mm extruded is non-zero
+        if (job.GramsDerived == 0 && job.MmExtruded > 0)
+        {
+            warnings.Add("GramsDerived is zero despite MmExtruded being non-zero. Cost may be inaccurate. Consider re-deriving grams from filament parameters.");
+        }
+
+        response.Warnings = warnings;
+        return Ok(response);
+    }
+
     // ── Gram Derivation Formula ────────────────────────────────────
 
     /// <summary>

backend/API/Controllers/UsageLogsController.cs

@@ -0,0 +1,117 @@
+using Extrudex.API.DTOs.UsageLogs;
+using Extrudex.Domain.Enums;
+using Extrudex.Domain.Interfaces;
+using Microsoft.AspNetCore.Mvc;
+
+namespace Extrudex.API.Controllers;
+
+/// <summary>
+/// API controller for recording and querying filament usage logs.
+/// Usage logs provide a fine-grained audit trail of filament consumption
+/// from printer integrations or manual input.
+/// </summary>
+[ApiController]
+[Route("api/[controller]")]
+[Produces("application/json")]
+public class UsageLogsController : ControllerBase
+{
+    private readonly IUsageLogService _usageLogService;
+
+    /// <summary>
+    /// Initializes a new instance of the <see cref="UsageLogsController"/> class.
+    /// </summary>
+    /// <param name="usageLogService">The usage log service for recording and querying usage.</param>
+    public UsageLogsController(IUsageLogService usageLogService)
+    {
+        _usageLogService = usageLogService;
+    }
+
+    /// <summary>
+    /// Records a new filament usage entry.
+    /// </summary>
+    /// <param name="request">The usage entry details.</param>
+    /// <returns>The created usage log entry.</returns>
+    [HttpPost]
+    [ProducesResponseType(typeof(UsageLogResponse), StatusCodes.Status201Created)]
+    [ProducesResponseType(StatusCodes.Status400BadRequest)]
+    public async Task<ActionResult<UsageLogResponse>> Create([FromBody] CreateUsageLogRequest request)
+    {
+        if (!Enum.TryParse<DataSource>(request.DataSource, ignoreCase: true, out var dataSource))
+        {
+            return BadRequest($"Invalid data source: '{request.DataSource}'. Valid values: Mqtt, Moonraker, Manual.");
+        }
+
+        var entry = await _usageLogService.RecordUsageAsync(
+            spoolId: request.SpoolId,
+            gramsUsed: request.GramsUsed,
+            dataSource: dataSource,
+            printerId: request.PrinterId,
+            printJobId: request.PrintJobId,
+            mmExtruded: request.MmExtruded,
+            usageTimestamp: request.UsageTimestamp,
+            notes: request.Notes
+        );
+
+        return CreatedAtAction(
+            nameof(GetBySpool),
+            new { spoolId = entry.SpoolId },
+            MapToResponse(entry));
+    }
+
+    /// <summary>
+    /// Gets usage logs for a specific spool, ordered by most recent first.
+    /// </summary>
+    /// <param name="spoolId">The spool ID to filter by.</param>
+    /// <returns>A collection of usage log entries for the spool.</returns>
+    [HttpGet("spool/{spoolId:guid}")]
+    [ProducesResponseType(typeof(IEnumerable<UsageLogResponse>), StatusCodes.Status200OK)]
+    public async Task<ActionResult<IEnumerable<UsageLogResponse>>> GetBySpool(Guid spoolId)
+    {
+        var logs = await _usageLogService.GetBySpoolAsync(spoolId);
+        return Ok(logs.Select(MapToResponse));
+    }
+
+    /// <summary>
+    /// Gets usage logs for a specific printer, ordered by most recent first.
+    /// </summary>
+    /// <param name="printerId">The printer ID to filter by.</param>
+    /// <returns>A collection of usage log entries for the printer.</returns>
+    [HttpGet("printer/{printerId:guid}")]
+    [ProducesResponseType(typeof(IEnumerable<UsageLogResponse>), StatusCodes.Status200OK)]
+    public async Task<ActionResult<IEnumerable<UsageLogResponse>>> GetByPrinter(Guid printerId)
+    {
+        var logs = await _usageLogService.GetByPrinterAsync(printerId);
+        return Ok(logs.Select(MapToResponse));
+    }
+
+    /// <summary>
+    /// Gets usage logs for a specific print job, ordered by most recent first.
+    /// </summary>
+    /// <param name="printJobId">The print job ID to filter by.</param>
+    /// <returns>A collection of usage log entries for the print job.</returns>
+    [HttpGet("print-job/{printJobId:guid}")]
+    [ProducesResponseType(typeof(IEnumerable<UsageLogResponse>), StatusCodes.Status200OK)]
+    public async Task<ActionResult<IEnumerable<UsageLogResponse>>> GetByPrintJob(Guid printJobId)
+    {
+        var logs = await _usageLogService.GetByPrintJobAsync(printJobId);
+        return Ok(logs.Select(MapToResponse));
+    }
+
+    /// <summary>
+    /// Maps a UsageLog domain entity to a UsageLogResponse DTO.
+    /// </summary>
+    private static UsageLogResponse MapToResponse(Domain.Entities.UsageLog log) => new()
+    {
+        Id = log.Id,
+        SpoolId = log.SpoolId,
+        PrinterId = log.PrinterId,
+        PrintJobId = log.PrintJobId,
+        GramsUsed = log.GramsUsed,
+        MmExtruded = log.MmExtruded,
+        UsageTimestamp = log.UsageTimestamp,
+        DataSource = log.DataSource.ToString(),
+        Notes = log.Notes,
+        CreatedAt = log.CreatedAt,
+        UpdatedAt = log.UpdatedAt
+    };
+}

backend/API/DTOs/PrintJobs/CostSummaryResponse.cs

@@ -0,0 +1,55 @@
+namespace Extrudex.API.DTOs.PrintJobs;
+
+/// <summary>
+/// Response DTO for the cost summary of a print job.
+/// Provides a breakdown of material cost based on filament usage
+/// and spool pricing data. If cost data is incomplete, warnings
+/// are returned instead of throwing an error.
+/// </summary>
+public class CostSummaryResponse
+{
+    /// <summary>Unique identifier of the print job.</summary>
+    public Guid PrintJobId { get; set; }
+
+    /// <summary>Human-readable name of the print job.</summary>
+    public string PrintName { get; set; } = string.Empty;
+
+    /// <summary>Foreign key to the spool used for this print job.</summary>
+    public Guid SpoolId { get; set; }
+
+    /// <summary>Serial number of the spool.</summary>
+    public string SpoolSerial { get; set; } = string.Empty;
+
+    /// <summary>Brand of the spool.</summary>
+    public string SpoolBrand { get; set; } = string.Empty;
+
+    /// <summary>Color name of the spool.</summary>
+    public string SpoolColorName { get; set; } = string.Empty;
+
+    /// <summary>Total millimeters of filament extruded during this print.</summary>
+    public decimal MmExtruded { get; set; }
+
+    /// <summary>Derived grams consumed for this print job.</summary>
+    public decimal GramsDerived { get; set; }
+
+    /// <summary>Purchase price of the full spool, if available.</summary>
+    public decimal? SpoolPurchasePrice { get; set; }
+
+    /// <summary>Total weight of the spool in grams when full.</summary>
+    public decimal? SpoolWeightTotalGrams { get; set; }
+
+    /// <summary>Calculated price per gram (purchase price / total weight), if available.</summary>
+    public decimal? PricePerGram { get; set; }
+
+    /// <summary>Calculated total material cost for this print job, if available.</summary>
+    public decimal? TotalMaterialCost { get; set; }
+
+    /// <summary>The CostPerPrint stored on the print job entity, if set.</summary>
+    public decimal? StoredCostPerPrint { get; set; }
+
+    /// <summary>
+    /// Warnings about missing data that prevent cost calculation.
+    /// Empty if all data is available and cost was calculated successfully.
+    /// </summary>
+    public List<string> Warnings { get; set; } = new();
+}

backend/API/DTOs/UsageLogs/UsageLogDtos.cs

@@ -0,0 +1,115 @@
+using System.ComponentModel.DataAnnotations;
+
+namespace Extrudex.API.DTOs.UsageLogs;
+
+/// <summary>
+/// Request DTO for recording a filament usage entry.
+/// </summary>
+public class CreateUsageLogRequest
+{
+    /// <summary>
+    /// The ID of the spool that provided the filament.
+    /// </summary>
+    [Required]
+    public Guid SpoolId { get; set; }
+
+    /// <summary>
+    /// The number of grams of filament consumed.
+    /// </summary>
+    [Required]
+    [Range(0.01, double.MaxValue, ErrorMessage = "GramsUsed must be a positive value.")]
+    public decimal GramsUsed { get; set; }
+
+    /// <summary>
+    /// The source of the usage data (Mqtt, Moonraker, Manual).
+    /// </summary>
+    [Required]
+    public string DataSource { get; set; } = string.Empty;
+
+    /// <summary>
+    /// The ID of the printer that consumed the filament. Optional.
+    /// </summary>
+    public Guid? PrinterId { get; set; }
+
+    /// <summary>
+    /// The ID of the print job associated with this usage. Optional.
+    /// </summary>
+    public Guid? PrintJobId { get; set; }
+
+    /// <summary>
+    /// The number of millimeters of filament extruded. Optional.
+    /// </summary>
+    public decimal? MmExtruded { get; set; }
+
+    /// <summary>
+    /// When the usage occurred (UTC). Defaults to now if not specified.
+    /// </summary>
+    public DateTime? UsageTimestamp { get; set; }
+
+    /// <summary>
+    /// Optional notes about this usage entry.
+    /// </summary>
+    [MaxLength(2000)]
+    public string? Notes { get; set; }
+}
+
+/// <summary>
+/// Response DTO for a usage log entry.
+/// </summary>
+public class UsageLogResponse
+{
+    /// <summary>
+    /// Unique identifier for the usage log entry.
+    /// </summary>
+    public Guid Id { get; set; }
+
+    /// <summary>
+    /// The spool that provided the filament.
+    /// </summary>
+    public Guid SpoolId { get; set; }
+
+    /// <summary>
+    /// The printer that consumed the filament, if applicable.
+    /// </summary>
+    public Guid? PrinterId { get; set; }
+
+    /// <summary>
+    /// The print job associated with this usage, if applicable.
+    /// </summary>
+    public Guid? PrintJobId { get; set; }
+
+    /// <summary>
+    /// Grams of filament consumed.
+    /// </summary>
+    public decimal GramsUsed { get; set; }
+
+    /// <summary>
+    /// Millimeters of filament extruded, if available.
+    /// </summary>
+    public decimal? MmExtruded { get; set; }
+
+    /// <summary>
+    /// When the usage occurred (UTC).
+    /// </summary>
+    public DateTime UsageTimestamp { get; set; }
+
+    /// <summary>
+    /// Source of the usage data (Mqtt, Moonraker, Manual).
+    /// </summary>
+    public string DataSource { get; set; } = string.Empty;
+
+    /// <summary>
+    /// Optional notes about this usage entry.
+    /// </summary>
+    public string? Notes { get; set; }
+
+    /// <summary>
+    /// When the record was created (UTC).
+    /// </summary>
+    public DateTime CreatedAt { get; set; }
+
+    /// <summary>
+    /// When the record was last updated (UTC).
+    /// </summary>
+    public DateTime UpdatedAt { get; set; }
+}

backend/API/Filters/FluentValidationFilter.cs

@@ -0,0 +1,69 @@
+using FluentValidation;
+using Microsoft.AspNetCore.Mvc;
+using Microsoft.AspNetCore.Mvc.Filters;
+
+namespace Extrudex.API.Filters;
+
+/// <summary>
+/// Action filter that automatically validates request DTOs using FluentValidation
+/// validators registered in DI. Runs before the controller action executes.
+/// Returns 400 Bad Request with validation errors if validation fails.
+/// </summary>
+public class FluentValidationFilter : IAsyncActionFilter
+{
+    private readonly IServiceProvider _serviceProvider;
+    private readonly ILogger<FluentValidationFilter> _logger;
+
+    public FluentValidationFilter(IServiceProvider serviceProvider, ILogger<FluentValidationFilter> logger)
+    {
+        _serviceProvider = serviceProvider;
+        _logger = logger;
+    }
+
+    public async Task OnActionExecutionAsync(ActionExecutingContext context, ActionExecutionDelegate next)
+    {
+        foreach (var argument in context.ActionArguments.Values)
+        {
+            if (argument is null) continue;
+
+            var argumentType = argument.GetType();
+            var validatorType = typeof(IValidator<>).MakeGenericType(argumentType);
+
+            // Try to resolve a validator for this argument type
+            var validator = _serviceProvider.GetService(validatorType) as IValidator;
+            if (validator is null) continue;
+
+            _logger.LogDebug("Validating {Type} with {Validator}", argumentType.Name, validator.GetType().Name);
+
+            var validationResult = await validator.ValidateAsync(
+                new ValidationContext<object>(argument), context.HttpContext.RequestAborted);
+
+            if (!validationResult.IsValid)
+            {
+                foreach (var error in validationResult.Errors)
+                {
+                    context.ModelState.AddModelError(error.PropertyName, error.ErrorMessage);
+                }
+            }
+        }
+
+        if (!context.ModelState.IsValid)
+        {
+            var errors = context.ModelState
+                .Where(kvp => kvp.Value?.Errors.Count > 0)
+                .ToDictionary(
+                    kvp => kvp.Key,
+                    kvp => kvp.Value!.Errors.Select(e => e.ErrorMessage).ToArray());
+
+            context.Result = new BadRequestObjectResult(new
+            {
+                title = "Validation failed",
+                status = 400,
+                errors
+            });
+            return;
+        }
+
+        await next();
+    }
+}

backend/API/Validators/FilamentValidators.cs

@@ -0,0 +1,108 @@
+using Extrudex.API.DTOs.Filaments;
+using FluentValidation;
+
+namespace Extrudex.API.Validators;
+
+/// <summary>
+/// Validation rules for creating a Filament (Spool) via the /filaments route.
+/// Mirrors the domain rules enforced in the controller and ensures consistent
+/// validation regardless of the request pipeline entry point.
+/// </summary>
+public class CreateFilamentRequestValidator : AbstractValidator<CreateFilamentRequest>
+{
+    public CreateFilamentRequestValidator()
+    {
+        RuleFor(x => x.MaterialBaseId)
+            .NotEmpty().WithMessage("MaterialBaseId is required.");
+
+        RuleFor(x => x.MaterialFinishId)
+            .NotEmpty().WithMessage("MaterialFinishId is required.");
+
+        RuleFor(x => x.Brand)
+            .NotEmpty().WithMessage("Brand is required.")
+            .MaximumLength(200).WithMessage("Brand must not exceed 200 characters.");
+
+        RuleFor(x => x.ColorName)
+            .NotEmpty().WithMessage("ColorName is required.")
+            .MaximumLength(200).WithMessage("ColorName must not exceed 200 characters.");
+
+        RuleFor(x => x.ColorHex)
+            .NotEmpty().WithMessage("ColorHex is required.")
+            .Matches(@"^#[0-9A-Fa-f]{6}$").WithMessage("ColorHex must be a valid hex color code (e.g., #FF0000).");
+
+        RuleFor(x => x.WeightTotalGrams)
+            .GreaterThan(0).WithMessage("Total weight must be greater than zero.");
+
+        RuleFor(x => x.WeightRemainingGrams)
+            .GreaterThanOrEqualTo(0).WithMessage("Remaining weight must be non-negative.");
+
+        RuleFor(x => x.WeightRemainingGrams)
+            .LessThanOrEqualTo(x => x.WeightTotalGrams)
+            .WithMessage("WeightRemainingGrams cannot exceed WeightTotalGrams.");
+
+        RuleFor(x => x.FilamentDiameterMm)
+            .GreaterThan(0).WithMessage("Filament diameter must be greater than zero.");
+
+        RuleFor(x => x.SpoolSerial)
+            .NotEmpty().WithMessage("SpoolSerial is required.")
+            .MaximumLength(200).WithMessage("SpoolSerial must not exceed 200 characters.");
+
+        When(x => x.PurchasePrice.HasValue, () =>
+        {
+            RuleFor(x => x.PurchasePrice!.Value)
+                .GreaterThanOrEqualTo(0).WithMessage("Purchase price must be non-negative.");
+        });
+    }
+}
+
+/// <summary>
+/// Validation rules for updating a Filament (Spool) via the /filaments route.
+/// Enforces the same domain rules as creation, plus ensures the updated
+/// WeightRemainingGrams does not exceed the updated WeightTotalGrams.
+/// </summary>
+public class UpdateFilamentRequestValidator : AbstractValidator<UpdateFilamentRequest>
+{
+    public UpdateFilamentRequestValidator()
+    {
+        RuleFor(x => x.MaterialBaseId)
+            .NotEmpty().WithMessage("MaterialBaseId is required.");
+
+        RuleFor(x => x.MaterialFinishId)
+            .NotEmpty().WithMessage("MaterialFinishId is required.");
+
+        RuleFor(x => x.Brand)
+            .NotEmpty().WithMessage("Brand is required.")
+            .MaximumLength(200).WithMessage("Brand must not exceed 200 characters.");
+
+        RuleFor(x => x.ColorName)
+            .NotEmpty().WithMessage("ColorName is required.")
+            .MaximumLength(200).WithMessage("ColorName must not exceed 200 characters.");
+
+        RuleFor(x => x.ColorHex)
+            .NotEmpty().WithMessage("ColorHex is required.")
+            .Matches(@"^#[0-9A-Fa-f]{6}$").WithMessage("ColorHex must be a valid hex color code (e.g., #FF0000).");
+
+        RuleFor(x => x.WeightTotalGrams)
+            .GreaterThan(0).WithMessage("Total weight must be greater than zero.");
+
+        RuleFor(x => x.WeightRemainingGrams)
+            .GreaterThanOrEqualTo(0).WithMessage("Remaining weight must be non-negative.");
+
+        RuleFor(x => x.WeightRemainingGrams)
+            .LessThanOrEqualTo(x => x.WeightTotalGrams)
+            .WithMessage("WeightRemainingGrams cannot exceed WeightTotalGrams.");
+
+        RuleFor(x => x.FilamentDiameterMm)
+            .GreaterThan(0).WithMessage("Filament diameter must be greater than zero.");
+
+        RuleFor(x => x.SpoolSerial)
+            .NotEmpty().WithMessage("SpoolSerial is required.")
+            .MaximumLength(200).WithMessage("SpoolSerial must not exceed 200 characters.");
+
+        When(x => x.PurchasePrice.HasValue, () =>
+        {
+            RuleFor(x => x.PurchasePrice!.Value)
+                .GreaterThanOrEqualTo(0).WithMessage("Purchase price must be non-negative.");
+        });
+    }
+}

backend/Dockerfile

@@ -0,0 +1,34 @@
+# ── Stage 1: Build ──────────────────────────────────────────
+FROM mcr.microsoft.com/dotnet/sdk:9.0 AS build
+WORKDIR /src
+
+# Copy csproj first for layer caching — restores before copying source
+COPY Extrudex.csproj .
+RUN dotnet restore
+
+# Copy the rest of the source
+COPY . .
+RUN dotnet publish Extrudex.csproj \
+    -c Release \
+    -o /app/publish \
+    --no-restore
+
+# ── Stage 2: Runtime ────────────────────────────────────────
+FROM mcr.microsoft.com/dotnet/aspnet:9.0 AS runtime
+WORKDIR /app
+
+# Non-root user for security
+RUN adduser --disabled-password --gecos "" appuser
+USER appuser
+
+# Copy published output from build stage
+COPY --from=build /app/publish .
+
+# ASP.NET Core listens on 8080 by default in .NET 8+
+EXPOSE 8080
+
+# Health check against /health endpoint
+HEALTHCHECK --interval=30s --timeout=5s --start-period=10s --retries=3 \
+    CMD curl --fail http://localhost:8080/health || exit 1
+
+ENTRYPOINT ["dotnet", "Extrudex.dll"]

backend/Domain/Entities/FilamentUsage.cs

@@ -0,0 +1,73 @@
+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,4 +97,10 @@ 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,4 +94,10 @@ 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,4 +102,10 @@ 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/Entities/UsageLog.cs

@@ -0,0 +1,72 @@
+using Extrudex.Domain.Base;
+using Extrudex.Domain.Enums;
+
+namespace Extrudex.Domain.Entities;
+
+/// <summary>
+/// Represents a single filament usage log entry. Records how much filament
+/// was consumed, by which printer, at what time, and optionally linked to
+/// a print job. This provides a fine-grained audit trail of filament consumption
+/// independent of print job lifecycle.
+/// </summary>
+public class UsageLog : AuditableEntity
+{
+    /// <summary>
+    /// Foreign key to the spool that provided the filament.
+    /// </summary>
+    public Guid SpoolId { get; set; }
+
+    /// <summary>
+    /// Navigation to the spool that provided the filament.
+    /// </summary>
+    public Spool Spool { get; set; } = null!;
+
+    /// <summary>
+    /// Foreign key to the printer that consumed the filament.
+    /// Nullable to support manual entries without a specific printer.
+    /// </summary>
+    public Guid? PrinterId { get; set; }
+
+    /// <summary>
+    /// Navigation to the printer that consumed the filament.
+    /// </summary>
+    public Printer? Printer { get; set; }
+
+    /// <summary>
+    /// Foreign key to the print job associated with this usage entry.
+    /// Nullable because usage can be logged before or without a print job.
+    /// </summary>
+    public Guid? PrintJobId { get; set; }
+
+    /// <summary>
+    /// Navigation to the print job associated with this usage entry.
+    /// </summary>
+    public PrintJob? PrintJob { get; set; }
+
+    /// <summary>
+    /// The number of grams of filament consumed in this usage event.
+    /// </summary>
+    public decimal GramsUsed { get; set; }
+
+    /// <summary>
+    /// The number of millimeters of filament extruded in this usage event.
+    /// Optional — may not be available for all data sources.
+    /// </summary>
+    public decimal? MmExtruded { get; set; }
+
+    /// <summary>
+    /// Timestamp when the usage occurred (UTC). This is the actual time of
+    /// consumption, which may differ from CreatedAt if the entry was recorded later.
+    /// </summary>
+    public DateTime UsageTimestamp { get; set; } = DateTime.UtcNow;
+
+    /// <summary>
+    /// The source of the usage data (which integration path provided it).
+    /// </summary>
+    public DataSource DataSource { get; set; } = DataSource.Manual;
+
+    /// <summary>
+    /// Optional notes about this usage entry.
+    /// </summary>
+    public string? Notes { get; set; }
+}

backend/Domain/Interfaces/IUsageLogService.cs

@@ -0,0 +1,57 @@
+using Extrudex.Domain.Entities;
+using Extrudex.Domain.Enums;
+
+namespace Extrudex.Domain.Interfaces;
+
+/// <summary>
+/// Service for recording filament usage entries. Writes to the usage_logs table
+/// and provides query capabilities for usage history.
+/// </summary>
+public interface IUsageLogService
+{
+    /// <summary>
+    /// Records a filament usage entry.
+    /// </summary>
+    /// <param name="spoolId">The spool that provided the filament.</param>
+    /// <param name="gramsUsed">Grams of filament consumed.</param>
+    /// <param name="dataSource">Where the data came from.</param>
+    /// <param name="printerId">Optional printer ID.</param>
+    /// <param name="printJobId">Optional print job ID.</param>
+    /// <param name="mmExtruded">Optional mm extruded.</param>
+    /// <param name="usageTimestamp">When the usage occurred (defaults to UTC now).</param>
+    /// <param name="notes">Optional notes.</param>
+    /// <returns>The created UsageLog entity.</returns>
+    Task<UsageLog> RecordUsageAsync(
+        Guid spoolId,
+        decimal gramsUsed,
+        DataSource dataSource,
+        Guid? printerId = null,
+        Guid? printJobId = null,
+        decimal? mmExtruded = null,
+        DateTime? usageTimestamp = null,
+        string? notes = null);
+
+    /// <summary>
+    /// Retrieves usage logs for a specific spool, ordered by usage timestamp descending.
+    /// </summary>
+    /// <param name="spoolId">The spool ID to filter by.</param>
+    /// <param name="cancellationToken">Cancellation token.</param>
+    /// <returns>A collection of usage logs for the spool.</returns>
+    Task<IEnumerable<UsageLog>> GetBySpoolAsync(Guid spoolId, CancellationToken cancellationToken = default);
+
+    /// <summary>
+    /// Retrieves usage logs for a specific printer, ordered by usage timestamp descending.
+    /// </summary>
+    /// <param name="printerId">The printer ID to filter by.</param>
+    /// <param name="cancellationToken">Cancellation token.</param>
+    /// <returns>A collection of usage logs for the printer.</returns>
+    Task<IEnumerable<UsageLog>> GetByPrinterAsync(Guid printerId, CancellationToken cancellationToken = default);
+
+    /// <summary>
+    /// Retrieves usage logs for a specific print job, ordered by usage timestamp descending.
+    /// </summary>
+    /// <param name="printJobId">The print job ID to filter by.</param>
+    /// <param name="cancellationToken">Cancellation token.</param>
+    /// <returns>A collection of usage logs for the print job.</returns>
+    Task<IEnumerable<UsageLog>> GetByPrintJobAsync(Guid printJobId, CancellationToken cancellationToken = default);
+}

backend/Extrudex.csproj

@@ -9,6 +9,7 @@
   </PropertyGroup>
 
   <ItemGroup>
+    <PackageReference Include="AspNetCore.HealthChecks.NpgSql" Version="9.0.0" />
     <PackageReference Include="FluentValidation.DependencyInjectionExtensions" Version="12.1.1" />
     <PackageReference Include="Microsoft.EntityFrameworkCore" Version="9.0.3" />
     <PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="9.0.3" />

backend/Infrastructure/Data/Configurations/BaseEntityConfiguration.cs

@@ -49,15 +49,26 @@ public abstract class BaseEntityConfiguration<TEntity> : IEntityTypeConfiguratio
     }
 
     /// <summary>
-    /// Converts PascalCase or camelCase to snake_case.
+    /// Converts PascalCase or camelCase entity name to plural snake_case table name.
+    /// e.g. MaterialBase → material_bases, AmsSlot → ams_slots
     /// </summary>
     protected static string ToSnakeCase(string name)
     {
-        return string.Concat(
+        var snake = string.Concat(
                 name.Select((ch, i) =>
                     i > 0 && char.IsUpper(ch) && (char.IsLower(name[i - 1]) || (i + 1 < name.Length && char.IsLower(name[i + 1])))
                         ? "_" + ch
                         : ch.ToString()))
             .ToLowerInvariant();
+
+        // Pluralize: add 's' (handles most cases; irregular plurals handled explicitly if needed)
+        // Special cases: already_plural stays, 'y' → 'ies', 's'/'x'/'ch'/'sh' → 'es'
+        if (snake.EndsWith("s"))
+            return snake; // Already plural or ambiguous — leave as-is
+        if (snake.EndsWith("y") && !snake.EndsWith("ay") && !snake.EndsWith("ey") && !snake.EndsWith("oy") && !snake.EndsWith("uy"))
+            return snake[..^1] + "ies";
+        if (snake.EndsWith("x") || snake.EndsWith("ch") || snake.EndsWith("sh"))
+            return snake + "es";
+        return snake + "s";
     }
 }

backend/Infrastructure/Data/Configurations/FilamentUsageConfiguration.cs

@@ -0,0 +1,83 @@
+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/Configurations/SpoolConfiguration.cs

@@ -77,6 +77,14 @@ public class SpoolConfiguration : BaseEntityConfiguration<Spool>
         builder.HasIndex(e => e.MaterialBaseId)
             .HasDatabaseName("ix_spools_material_base_id");
 
+        // Index on material_finish_id for spool filtering
+        builder.HasIndex(e => e.MaterialFinishId)
+            .HasDatabaseName("ix_spools_material_finish_id");
+
+        // Index on material_modifier_id for spool filtering
+        builder.HasIndex(e => e.MaterialModifierId)
+            .HasDatabaseName("ix_spools_material_modifier_id");
+
         // Index on is_active for active spool queries
         builder.HasIndex(e => e.IsActive)
             .HasDatabaseName("ix_spools_is_active");

backend/Infrastructure/Data/Configurations/UsageLogConfiguration.cs

@@ -0,0 +1,91 @@
+using Extrudex.Domain.Entities;
+using Extrudex.Domain.Enums;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.EntityFrameworkCore.Metadata.Builders;
+
+namespace Extrudex.Infrastructure.Data.Configurations;
+
+/// <summary>
+/// EF Core configuration for the UsageLog entity.
+/// Maps to the usage_logs table with snake_case columns and appropriate indexes.
+/// </summary>
+public class UsageLogConfiguration : BaseEntityConfiguration<UsageLog>
+{
+    /// <inheritdoc/>
+    public override void Configure(EntityTypeBuilder<UsageLog> builder)
+    {
+        base.Configure(builder);
+
+        builder.Property(e => e.SpoolId)
+            .HasColumnName("spool_id")
+            .IsRequired();
+
+        builder.Property(e => e.PrinterId)
+            .HasColumnName("printer_id");
+
+        builder.Property(e => e.PrintJobId)
+            .HasColumnName("print_job_id");
+
+        builder.Property(e => e.GramsUsed)
+            .HasColumnName("grams_used")
+            .HasPrecision(10, 2)
+            .IsRequired();
+
+        builder.Property(e => e.MmExtruded)
+            .HasColumnName("mm_extruded")
+            .HasPrecision(12, 2);
+
+        builder.Property(e => e.UsageTimestamp)
+            .HasColumnName("usage_timestamp")
+            .IsRequired();
+
+        builder.Property(e => e.DataSource)
+            .HasColumnName("data_source")
+            .HasConversion<string>()
+            .HasMaxLength(50)
+            .IsRequired();
+
+        builder.Property(e => e.Notes)
+            .HasColumnName("notes")
+            .HasMaxLength(2000);
+
+        // Index on spool_id for querying usage by spool
+        builder.HasIndex(e => e.SpoolId)
+            .HasDatabaseName("ix_usage_logs_spool_id");
+
+        // Index on printer_id for querying usage by printer
+        builder.HasIndex(e => e.PrinterId)
+            .HasDatabaseName("ix_usage_logs_printer_id");
+
+        // Index on print_job_id for querying usage by print job
+        builder.HasIndex(e => e.PrintJobId)
+            .HasDatabaseName("ix_usage_logs_print_job_id");
+
+        // Index on usage_timestamp for chronological queries
+        builder.HasIndex(e => e.UsageTimestamp)
+            .HasDatabaseName("ix_usage_logs_usage_timestamp");
+
+        // Index on data_source for filtering by integration path
+        builder.HasIndex(e => e.DataSource)
+            .HasDatabaseName("ix_usage_logs_data_source");
+
+        // Relationships
+        builder.HasOne(e => e.Spool)
+            .WithMany()
+            .HasForeignKey(e => e.SpoolId)
+            .HasConstraintName("fk_usage_logs_spool")
+            .OnDelete(DeleteBehavior.Restrict);
+
+        builder.HasOne(e => e.Printer)
+            .WithMany()
+            .HasForeignKey(e => e.PrinterId)
+            .HasConstraintName("fk_usage_logs_printer")
+            .OnDelete(DeleteBehavior.SetNull);
+
+        builder.HasOne(e => e.PrintJob)
+            .WithMany()
+            .HasForeignKey(e => e.PrintJobId)
+            .HasConstraintName("fk_usage_logs_print_job")
+            .OnDelete(DeleteBehavior.SetNull);
+    }
+}

backend/Infrastructure/Data/ExtrudexDbContext.cs

@@ -1,78 +1 @@
-using Extrudex.Domain.Base;
-using Extrudex.Domain.Entities;
-using Microsoft.EntityFrameworkCore;
 
-namespace Extrudex.Infrastructure.Data;
-
-/// <summary>
-/// Main EF Core database context for the Extrudex system.
-/// Handles entity registration, snake_case naming, and automatic timestamp management.
-/// </summary>
-public class ExtrudexDbContext : DbContext
-{
-    public ExtrudexDbContext(DbContextOptions<ExtrudexDbContext> options) : base(options) { }
-
-    // Lookup tables
-    public DbSet<MaterialBase> MaterialBases => Set<MaterialBase>();
-    public DbSet<MaterialFinish> MaterialFinishes => Set<MaterialFinish>();
-    public DbSet<MaterialModifier> MaterialModifiers => Set<MaterialModifier>();
-
-    // Core entities
-    public DbSet<Spool> Spools => Set<Spool>();
-    public DbSet<Printer> Printers => Set<Printer>();
-    public DbSet<AmsUnit> AmsUnits => Set<AmsUnit>();
-    public DbSet<AmsSlot> AmsSlots => Set<AmsSlot>();
-    public DbSet<PrintJob> PrintJobs => Set<PrintJob>();
-
-    protected override void OnModelCreating(ModelBuilder modelBuilder)
-    {
-        base.OnModelCreating(modelBuilder);
-
-        // Apply all entity type configurations from the assembly
-        modelBuilder.ApplyConfigurationsFromAssembly(typeof(ExtrudexDbContext).Assembly);
-
-        // Apply seed data
-        modelBuilder.Entity<MaterialBase>().HasData(SeedData.MaterialBases);
-        modelBuilder.Entity<MaterialFinish>().HasData(SeedData.MaterialFinishes);
-        modelBuilder.Entity<MaterialModifier>().HasData(SeedData.MaterialModifiers);
-    }
-
-    /// <summary>
-    /// Automatically set UpdatedAt on auditable entities during SaveChanges.
-    /// </summary>
-    public override int SaveChanges(bool acceptAllChangesOnSuccess)
-    {
-        SetAuditTimestamps();
-        return base.SaveChanges(acceptAllChangesOnSuccess);
-    }
-
-    public override async Task<int> SaveChangesAsync(
-        bool acceptAllChangesOnSuccess,
-        CancellationToken cancellationToken = default)
-    {
-        SetAuditTimestamps();
-        return await base.SaveChangesAsync(acceptAllChangesOnSuccess, cancellationToken);
-    }
-
-    /// <summary>
-    /// Sets UpdatedAt on all auditable entities that have been modified.
-    /// Sets CreatedAt on all auditable entities that are being added.
-    /// </summary>
-    private void SetAuditTimestamps()
-    {
-        var entries = ChangeTracker.Entries<AuditableEntity>();
-
-        foreach (var entry in entries)
-        {
-            if (entry.State == EntityState.Added)
-            {
-                entry.Entity.CreatedAt = DateTime.UtcNow;
-                entry.Entity.UpdatedAt = DateTime.UtcNow;
-            }
-            else if (entry.State == EntityState.Modified)
-            {
-                entry.Entity.UpdatedAt = DateTime.UtcNow;
-            }
-        }
-    }
-}

backend/Infrastructure/Data/Migrations/20260426131419_InitialCreate.Designer.cs

@@ -0,0 +1,958 @@
+// <auto-generated />
+using System;
+using Extrudex.Infrastructure.Data;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Migrations;
+using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
+using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
+
+#nullable disable
+
+namespace Extrudex.Infrastructure.Data.Migrations
+{
+    [DbContext(typeof(ExtrudexDbContext))]
+    [Migration("20260426131419_InitialCreate")]
+    partial class InitialCreate
+    {
+        /// <inheritdoc />
+        protected override void BuildTargetModel(ModelBuilder modelBuilder)
+        {
+#pragma warning disable 612, 618
+            modelBuilder
+                .HasAnnotation("ProductVersion", "9.0.3")
+                .HasAnnotation("Relational:MaxIdentifierLength", 63);
+
+            NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.AmsSlot", b =>
+                {
+                    b.Property<Guid>("Id")
+                        .HasColumnType("uuid")
+                        .HasColumnName("id");
+
+                    b.Property<Guid>("AmsUnitId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("ams_unit_id");
+
+                    b.Property<DateTime>("CreatedAt")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("created_at")
+                        .HasDefaultValueSql("now() at time zone 'utc'");
+
+                    b.Property<decimal?>("RemainingWeightG")
+                        .HasPrecision(10, 2)
+                        .HasColumnType("numeric(10,2)")
+                        .HasColumnName("remaining_weight_g");
+
+                    b.Property<Guid?>("SpoolId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("spool_id");
+
+                    b.Property<int>("TrayIndex")
+                        .HasColumnType("integer")
+                        .HasColumnName("tray_index");
+
+                    b.Property<DateTime>("UpdatedAt")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("updated_at")
+                        .HasDefaultValueSql("now() at time zone 'utc'");
+
+                    b.HasKey("Id");
+
+                    b.HasIndex("SpoolId")
+                        .HasDatabaseName("ix_ams_slots_spool_id");
+
+                    b.HasIndex("AmsUnitId", "TrayIndex")
+                        .IsUnique()
+                        .HasDatabaseName("ix_ams_slots_ams_unit_id_tray_index");
+
+                    b.ToTable("ams_slots", (string)null);
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.AmsUnit", 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<Guid>("PrinterId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("printer_id");
+
+                    b.Property<int>("UnitIndex")
+                        .HasColumnType("integer")
+                        .HasColumnName("unit_index");
+
+                    b.Property<DateTime>("UpdatedAt")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("updated_at")
+                        .HasDefaultValueSql("now() at time zone 'utc'");
+
+                    b.HasKey("Id");
+
+                    b.HasIndex("PrinterId", "UnitIndex")
+                        .IsUnique()
+                        .HasDatabaseName("ix_ams_units_printer_id_unit_index");
+
+                    b.ToTable("ams_units", (string)null);
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.MaterialBase", 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>("DensityGperCm3")
+                        .HasPrecision(10, 4)
+                        .HasColumnType("numeric(10,4)")
+                        .HasColumnName("density_g_per_cm3");
+
+                    b.Property<string>("Name")
+                        .IsRequired()
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
+                        .HasColumnName("name");
+
+                    b.Property<DateTime>("UpdatedAt")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("updated_at")
+                        .HasDefaultValueSql("now() at time zone 'utc'");
+
+                    b.HasKey("Id");
+
+                    b.HasIndex("Name")
+                        .IsUnique()
+                        .HasDatabaseName("ix_material_bases_name");
+
+                    b.ToTable("material_bases", (string)null);
+
+                    b.HasData(
+                        new
+                        {
+                            Id = new Guid("10000000-0000-0000-0000-000000000001"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1096)
+                        },
+                        new
+                        {
+                            Id = new Guid("10000000-0000-0000-0000-000000000002"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1620)
+                        },
+                        new
+                        {
+                            Id = new Guid("10000000-0000-0000-0000-000000000003"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1630)
+                        },
+                        new
+                        {
+                            Id = new Guid("10000000-0000-0000-0000-000000000004"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1638)
+                        },
+                        new
+                        {
+                            Id = new Guid("10000000-0000-0000-0000-000000000005"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1645)
+                        },
+                        new
+                        {
+                            Id = new Guid("10000000-0000-0000-0000-000000000006"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1652)
+                        });
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.MaterialFinish", 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<Guid>("MaterialBaseId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("material_base_id");
+
+                    b.Property<string>("Name")
+                        .IsRequired()
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
+                        .HasColumnName("name");
+
+                    b.Property<DateTime>("UpdatedAt")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("updated_at")
+                        .HasDefaultValueSql("now() at time zone 'utc'");
+
+                    b.HasKey("Id");
+
+                    b.HasIndex("MaterialBaseId", "Name")
+                        .IsUnique()
+                        .HasDatabaseName("ix_material_finishes_material_base_id_name");
+
+                    b.ToTable("material_finishes", (string)null);
+
+                    b.HasData(
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000001"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1850)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000002"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2041)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000003"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2049)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000004"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2056)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000005"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2062)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000006"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2068)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000007"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2075)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000008"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2081)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000009"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2100)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000010"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2107)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000011"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2113)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000012"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2120)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000013"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2126)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000014"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2133)
+                        },
+                        new
+                        {
+                            Id = new Guid("20000000-0000-0000-0000-000000000015"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2139)
+                        });
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.MaterialModifier", 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<Guid>("MaterialBaseId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("material_base_id");
+
+                    b.Property<string>("Name")
+                        .IsRequired()
+                        .HasMaxLength(100)
+                        .HasColumnType("character varying(100)")
+                        .HasColumnName("name");
+
+                    b.Property<DateTime>("UpdatedAt")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("updated_at")
+                        .HasDefaultValueSql("now() at time zone 'utc'");
+
+                    b.HasKey("Id");
+
+                    b.HasIndex("MaterialBaseId", "Name")
+                        .IsUnique()
+                        .HasDatabaseName("ix_material_modifiers_material_base_id_name");
+
+                    b.ToTable("material_modifiers", (string)null);
+
+                    b.HasData(
+                        new
+                        {
+                            Id = new Guid("30000000-0000-0000-0000-000000000001"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2304)
+                        },
+                        new
+                        {
+                            Id = new Guid("30000000-0000-0000-0000-000000000002"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2463)
+                        },
+                        new
+                        {
+                            Id = new Guid("30000000-0000-0000-0000-000000000003"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2471)
+                        },
+                        new
+                        {
+                            Id = new Guid("30000000-0000-0000-0000-000000000004"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2478)
+                        },
+                        new
+                        {
+                            Id = new Guid("30000000-0000-0000-0000-000000000005"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2484)
+                        },
+                        new
+                        {
+                            Id = new Guid("30000000-0000-0000-0000-000000000006"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2491)
+                        },
+                        new
+                        {
+                            Id = new Guid("30000000-0000-0000-0000-000000000007"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2497)
+                        },
+                        new
+                        {
+                            Id = new Guid("30000000-0000-0000-0000-000000000008"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2503)
+                        },
+                        new
+                        {
+                            Id = new Guid("30000000-0000-0000-0000-000000000009"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2510)
+                        },
+                        new
+                        {
+                            Id = new Guid("30000000-0000-0000-0000-000000000010"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2516)
+                        },
+                        new
+                        {
+                            Id = new Guid("30000000-0000-0000-0000-000000000011"),
+                            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, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2523)
+                        });
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.PrintJob", b =>
+                {
+                    b.Property<Guid>("Id")
+                        .HasColumnType("uuid")
+                        .HasColumnName("id");
+
+                    b.Property<DateTime?>("CompletedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("completed_at");
+
+                    b.Property<decimal?>("CostPerPrint")
+                        .HasPrecision(10, 4)
+                        .HasColumnType("numeric(10,4)")
+                        .HasColumnName("cost_per_print");
+
+                    b.Property<DateTime>("CreatedAt")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("created_at")
+                        .HasDefaultValueSql("now() at time zone 'utc'");
+
+                    b.Property<string>("DataSource")
+                        .IsRequired()
+                        .HasMaxLength(50)
+                        .HasColumnType("character varying(50)")
+                        .HasColumnName("data_source");
+
+                    b.Property<decimal>("FilamentDiameterAtPrintMm")
+                        .HasPrecision(6, 3)
+                        .HasColumnType("numeric(6,3)")
+                        .HasColumnName("filament_diameter_at_print_mm");
+
+                    b.Property<string>("GcodeFilePath")
+                        .HasMaxLength(1000)
+                        .HasColumnType("character varying(1000)")
+                        .HasColumnName("gcode_file_path");
+
+                    b.Property<decimal>("GramsDerived")
+                        .HasPrecision(10, 2)
+                        .HasColumnType("numeric(10,2)")
+                        .HasColumnName("grams_derived");
+
+                    b.Property<decimal>("MaterialDensityAtPrint")
+                        .HasPrecision(10, 4)
+                        .HasColumnType("numeric(10,4)")
+                        .HasColumnName("material_density_at_print");
+
+                    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<string>("PrintName")
+                        .IsRequired()
+                        .HasMaxLength(500)
+                        .HasColumnType("character varying(500)")
+                        .HasColumnName("print_name");
+
+                    b.Property<Guid>("PrinterId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("printer_id");
+
+                    b.Property<Guid>("SpoolId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("spool_id");
+
+                    b.Property<DateTime?>("StartedAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("started_at");
+
+                    b.Property<string>("Status")
+                        .IsRequired()
+                        .ValueGeneratedOnAdd()
+                        .HasMaxLength(50)
+                        .HasColumnType("character varying(50)")
+                        .HasDefaultValue("Queued")
+                        .HasColumnName("status");
+
+                    b.Property<DateTime>("UpdatedAt")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("updated_at")
+                        .HasDefaultValueSql("now() at time zone 'utc'");
+
+                    b.HasKey("Id");
+
+                    b.HasIndex("DataSource")
+                        .HasDatabaseName("ix_print_jobs_data_source");
+
+                    b.HasIndex("PrinterId")
+                        .HasDatabaseName("ix_print_jobs_printer_id");
+
+                    b.HasIndex("SpoolId")
+                        .HasDatabaseName("ix_print_jobs_spool_id");
+
+                    b.HasIndex("Status")
+                        .HasDatabaseName("ix_print_jobs_status");
+
+                    b.ToTable("print_jobs", (string)null);
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.Printer", b =>
+                {
+                    b.Property<Guid>("Id")
+                        .HasColumnType("uuid")
+                        .HasColumnName("id");
+
+                    b.Property<string>("ApiKey")
+                        .IsRequired()
+                        .HasMaxLength(500)
+                        .HasColumnType("character varying(500)")
+                        .HasColumnName("api_key");
+
+                    b.Property<string>("ConnectionType")
+                        .IsRequired()
+                        .HasMaxLength(50)
+                        .HasColumnType("character varying(50)")
+                        .HasColumnName("connection_type");
+
+                    b.Property<DateTime>("CreatedAt")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("created_at")
+                        .HasDefaultValueSql("now() at time zone 'utc'");
+
+                    b.Property<string>("HostnameOrIp")
+                        .IsRequired()
+                        .HasMaxLength(255)
+                        .HasColumnType("character varying(255)")
+                        .HasColumnName("hostname_or_ip");
+
+                    b.Property<bool>("IsActive")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("boolean")
+                        .HasDefaultValue(true)
+                        .HasColumnName("is_active");
+
+                    b.Property<DateTime?>("LastSeenAt")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("last_seen_at");
+
+                    b.Property<string>("Manufacturer")
+                        .IsRequired()
+                        .HasMaxLength(200)
+                        .HasColumnType("character varying(200)")
+                        .HasColumnName("manufacturer");
+
+                    b.Property<string>("Model")
+                        .IsRequired()
+                        .HasMaxLength(200)
+                        .HasColumnType("character varying(200)")
+                        .HasColumnName("model");
+
+                    b.Property<string>("MqttPassword")
+                        .IsRequired()
+                        .HasMaxLength(500)
+                        .HasColumnType("character varying(500)")
+                        .HasColumnName("mqtt_password");
+
+                    b.Property<bool>("MqttUseTls")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("boolean")
+                        .HasDefaultValue(false)
+                        .HasColumnName("mqtt_use_tls");
+
+                    b.Property<string>("MqttUsername")
+                        .IsRequired()
+                        .HasMaxLength(200)
+                        .HasColumnType("character varying(200)")
+                        .HasColumnName("mqtt_username");
+
+                    b.Property<string>("Name")
+                        .IsRequired()
+                        .HasMaxLength(200)
+                        .HasColumnType("character varying(200)")
+                        .HasColumnName("name");
+
+                    b.Property<int>("Port")
+                        .HasColumnType("integer")
+                        .HasColumnName("port");
+
+                    b.Property<string>("PrinterType")
+                        .IsRequired()
+                        .HasMaxLength(50)
+                        .HasColumnType("character varying(50)")
+                        .HasColumnName("printer_type");
+
+                    b.Property<string>("Status")
+                        .IsRequired()
+                        .ValueGeneratedOnAdd()
+                        .HasMaxLength(50)
+                        .HasColumnType("character varying(50)")
+                        .HasDefaultValue("Offline")
+                        .HasColumnName("status");
+
+                    b.Property<DateTime>("UpdatedAt")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("updated_at")
+                        .HasDefaultValueSql("now() at time zone 'utc'");
+
+                    b.HasKey("Id");
+
+                    b.HasIndex("ConnectionType")
+                        .HasDatabaseName("ix_printers_connection_type");
+
+                    b.HasIndex("IsActive")
+                        .HasDatabaseName("ix_printers_is_active");
+
+                    b.HasIndex("PrinterType")
+                        .HasDatabaseName("ix_printers_printer_type");
+
+                    b.HasIndex("Status")
+                        .HasDatabaseName("ix_printers_status");
+
+                    b.ToTable("printers", (string)null);
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.Spool", b =>
+                {
+                    b.Property<Guid>("Id")
+                        .HasColumnType("uuid")
+                        .HasColumnName("id");
+
+                    b.Property<string>("Brand")
+                        .IsRequired()
+                        .HasMaxLength(200)
+                        .HasColumnType("character varying(200)")
+                        .HasColumnName("brand");
+
+                    b.Property<string>("ColorHex")
+                        .IsRequired()
+                        .HasMaxLength(7)
+                        .HasColumnType("character varying(7)")
+                        .HasColumnName("color_hex");
+
+                    b.Property<string>("ColorName")
+                        .IsRequired()
+                        .HasMaxLength(200)
+                        .HasColumnType("character varying(200)")
+                        .HasColumnName("color_name");
+
+                    b.Property<DateTime>("CreatedAt")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("created_at")
+                        .HasDefaultValueSql("now() at time zone 'utc'");
+
+                    b.Property<decimal>("FilamentDiameterMm")
+                        .HasPrecision(6, 3)
+                        .HasColumnType("numeric(6,3)")
+                        .HasColumnName("filament_diameter_mm");
+
+                    b.Property<bool>("IsActive")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("boolean")
+                        .HasDefaultValue(true)
+                        .HasColumnName("is_active");
+
+                    b.Property<Guid>("MaterialBaseId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("material_base_id");
+
+                    b.Property<Guid>("MaterialFinishId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("material_finish_id");
+
+                    b.Property<Guid?>("MaterialModifierId")
+                        .HasColumnType("uuid")
+                        .HasColumnName("material_modifier_id");
+
+                    b.Property<DateTime?>("PurchaseDate")
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("purchase_date");
+
+                    b.Property<decimal?>("PurchasePrice")
+                        .HasPrecision(10, 2)
+                        .HasColumnType("numeric(10,2)")
+                        .HasColumnName("purchase_price");
+
+                    b.Property<string>("SpoolSerial")
+                        .IsRequired()
+                        .HasMaxLength(200)
+                        .HasColumnType("character varying(200)")
+                        .HasColumnName("spool_serial");
+
+                    b.Property<DateTime>("UpdatedAt")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("timestamp with time zone")
+                        .HasColumnName("updated_at")
+                        .HasDefaultValueSql("now() at time zone 'utc'");
+
+                    b.Property<decimal>("WeightRemainingGrams")
+                        .HasPrecision(10, 2)
+                        .HasColumnType("numeric(10,2)")
+                        .HasColumnName("weight_remaining_grams");
+
+                    b.Property<decimal>("WeightTotalGrams")
+                        .HasPrecision(10, 2)
+                        .HasColumnType("numeric(10,2)")
+                        .HasColumnName("weight_total_grams");
+
+                    b.HasKey("Id");
+
+                    b.HasIndex("IsActive")
+                        .HasDatabaseName("ix_spools_is_active");
+
+                    b.HasIndex("MaterialBaseId")
+                        .HasDatabaseName("ix_spools_material_base_id");
+
+                    b.HasIndex("MaterialFinishId")
+                        .HasDatabaseName("ix_spools_material_finish_id");
+
+                    b.HasIndex("MaterialModifierId")
+                        .HasDatabaseName("ix_spools_material_modifier_id");
+
+                    b.HasIndex("SpoolSerial")
+                        .IsUnique()
+                        .HasDatabaseName("ix_spools_spool_serial");
+
+                    b.ToTable("spools", (string)null);
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.AmsSlot", b =>
+                {
+                    b.HasOne("Extrudex.Domain.Entities.AmsUnit", "AmsUnit")
+                        .WithMany("Slots")
+                        .HasForeignKey("AmsUnitId")
+                        .OnDelete(DeleteBehavior.Cascade)
+                        .IsRequired()
+                        .HasConstraintName("fk_ams_slots_ams_unit");
+
+                    b.HasOne("Extrudex.Domain.Entities.Spool", "Spool")
+                        .WithMany("AmsSlots")
+                        .HasForeignKey("SpoolId")
+                        .OnDelete(DeleteBehavior.SetNull)
+                        .HasConstraintName("fk_ams_slots_spool");
+
+                    b.Navigation("AmsUnit");
+
+                    b.Navigation("Spool");
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.AmsUnit", b =>
+                {
+                    b.HasOne("Extrudex.Domain.Entities.Printer", "Printer")
+                        .WithMany("AmsUnits")
+                        .HasForeignKey("PrinterId")
+                        .OnDelete(DeleteBehavior.Cascade)
+                        .IsRequired()
+                        .HasConstraintName("fk_ams_units_printer");
+
+                    b.Navigation("Printer");
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.MaterialFinish", b =>
+                {
+                    b.HasOne("Extrudex.Domain.Entities.MaterialBase", "MaterialBase")
+                        .WithMany("Finishes")
+                        .HasForeignKey("MaterialBaseId")
+                        .OnDelete(DeleteBehavior.Restrict)
+                        .IsRequired()
+                        .HasConstraintName("fk_material_finishes_material_base");
+
+                    b.Navigation("MaterialBase");
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.MaterialModifier", b =>
+                {
+                    b.HasOne("Extrudex.Domain.Entities.MaterialBase", "MaterialBase")
+                        .WithMany("Modifiers")
+                        .HasForeignKey("MaterialBaseId")
+                        .OnDelete(DeleteBehavior.Restrict)
+                        .IsRequired()
+                        .HasConstraintName("fk_material_modifiers_material_base");
+
+                    b.Navigation("MaterialBase");
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.PrintJob", b =>
+                {
+                    b.HasOne("Extrudex.Domain.Entities.Printer", "Printer")
+                        .WithMany("PrintJobs")
+                        .HasForeignKey("PrinterId")
+                        .OnDelete(DeleteBehavior.Restrict)
+                        .IsRequired()
+                        .HasConstraintName("fk_print_jobs_printer");
+
+                    b.HasOne("Extrudex.Domain.Entities.Spool", "Spool")
+                        .WithMany("PrintJobs")
+                        .HasForeignKey("SpoolId")
+                        .OnDelete(DeleteBehavior.Restrict)
+                        .IsRequired()
+                        .HasConstraintName("fk_print_jobs_spool");
+
+                    b.Navigation("Printer");
+
+                    b.Navigation("Spool");
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.Spool", b =>
+                {
+                    b.HasOne("Extrudex.Domain.Entities.MaterialBase", "MaterialBase")
+                        .WithMany("Spools")
+                        .HasForeignKey("MaterialBaseId")
+                        .OnDelete(DeleteBehavior.Restrict)
+                        .IsRequired()
+                        .HasConstraintName("fk_spools_material_base");
+
+                    b.HasOne("Extrudex.Domain.Entities.MaterialFinish", "MaterialFinish")
+                        .WithMany("Spools")
+                        .HasForeignKey("MaterialFinishId")
+                        .OnDelete(DeleteBehavior.Restrict)
+                        .IsRequired()
+                        .HasConstraintName("fk_spools_material_finish");
+
+                    b.HasOne("Extrudex.Domain.Entities.MaterialModifier", "MaterialModifier")
+                        .WithMany("Spools")
+                        .HasForeignKey("MaterialModifierId")
+                        .OnDelete(DeleteBehavior.SetNull)
+                        .HasConstraintName("fk_spools_material_modifier");
+
+                    b.Navigation("MaterialBase");
+
+                    b.Navigation("MaterialFinish");
+
+                    b.Navigation("MaterialModifier");
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.AmsUnit", b =>
+                {
+                    b.Navigation("Slots");
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.MaterialBase", b =>
+                {
+                    b.Navigation("Finishes");
+
+                    b.Navigation("Modifiers");
+
+                    b.Navigation("Spools");
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.MaterialFinish", b =>
+                {
+                    b.Navigation("Spools");
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.MaterialModifier", b =>
+                {
+                    b.Navigation("Spools");
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.Printer", b =>
+                {
+                    b.Navigation("AmsUnits");
+
+                    b.Navigation("PrintJobs");
+                });
+
+            modelBuilder.Entity("Extrudex.Domain.Entities.Spool", b =>
+                {
+                    b.Navigation("AmsSlots");
+
+                    b.Navigation("PrintJobs");
+                });
+#pragma warning restore 612, 618
+        }
+    }
+}

backend/Infrastructure/Data/Migrations/20260426131419_InitialCreate.cs

@@ -0,0 +1,416 @@
+using System;
+using Microsoft.EntityFrameworkCore.Migrations;
+
+#nullable disable
+
+#pragma warning disable CA1814 // Prefer jagged arrays over multidimensional
+
+namespace Extrudex.Infrastructure.Data.Migrations
+{
+    /// <inheritdoc />
+    public partial class InitialCreate : Migration
+    {
+        /// <inheritdoc />
+        protected override void Up(MigrationBuilder migrationBuilder)
+        {
+            migrationBuilder.CreateTable(
+                name: "material_bases",
+                columns: table => new
+                {
+                    id = table.Column<Guid>(type: "uuid", nullable: false),
+                    name = table.Column<string>(type: "character varying(100)", maxLength: 100, nullable: false),
+                    density_g_per_cm3 = table.Column<decimal>(type: "numeric(10,4)", precision: 10, scale: 4, nullable: false),
+                    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_material_bases", x => x.id);
+                });
+
+            migrationBuilder.CreateTable(
+                name: "printers",
+                columns: table => new
+                {
+                    id = table.Column<Guid>(type: "uuid", nullable: false),
+                    status = table.Column<string>(type: "character varying(50)", maxLength: 50, nullable: false, defaultValue: "Offline"),
+                    name = table.Column<string>(type: "character varying(200)", maxLength: 200, nullable: false),
+                    manufacturer = table.Column<string>(type: "character varying(200)", maxLength: 200, nullable: false),
+                    model = table.Column<string>(type: "character varying(200)", maxLength: 200, nullable: false),
+                    printer_type = table.Column<string>(type: "character varying(50)", maxLength: 50, nullable: false),
+                    connection_type = table.Column<string>(type: "character varying(50)", maxLength: 50, nullable: false),
+                    hostname_or_ip = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false),
+                    port = table.Column<int>(type: "integer", nullable: false),
+                    mqtt_username = table.Column<string>(type: "character varying(200)", maxLength: 200, nullable: false),
+                    mqtt_password = table.Column<string>(type: "character varying(500)", maxLength: 500, nullable: false),
+                    mqtt_use_tls = table.Column<bool>(type: "boolean", nullable: false, defaultValue: false),
+                    api_key = table.Column<string>(type: "character varying(500)", maxLength: 500, nullable: false),
+                    is_active = table.Column<bool>(type: "boolean", nullable: false, defaultValue: true),
+                    last_seen_at = table.Column<DateTime>(type: "timestamp with time zone", 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_printers", x => x.id);
+                });
+
+            migrationBuilder.CreateTable(
+                name: "material_finishes",
+                columns: table => new
+                {
+                    id = table.Column<Guid>(type: "uuid", nullable: false),
+                    name = table.Column<string>(type: "character varying(100)", maxLength: 100, nullable: false),
+                    material_base_id = table.Column<Guid>(type: "uuid", nullable: false),
+                    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_material_finishes", x => x.id);
+                    table.ForeignKey(
+                        name: "fk_material_finishes_material_base",
+                        column: x => x.material_base_id,
+                        principalTable: "material_bases",
+                        principalColumn: "id",
+                        onDelete: ReferentialAction.Restrict);
+                });
+
+            migrationBuilder.CreateTable(
+                name: "material_modifiers",
+                columns: table => new
+                {
+                    id = table.Column<Guid>(type: "uuid", nullable: false),
+                    name = table.Column<string>(type: "character varying(100)", maxLength: 100, nullable: false),
+                    material_base_id = table.Column<Guid>(type: "uuid", nullable: false),
+                    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_material_modifiers", x => x.id);
+                    table.ForeignKey(
+                        name: "fk_material_modifiers_material_base",
+                        column: x => x.material_base_id,
+                        principalTable: "material_bases",
+                        principalColumn: "id",
+                        onDelete: ReferentialAction.Restrict);
+                });
+
+            migrationBuilder.CreateTable(
+                name: "ams_units",
+                columns: table => new
+                {
+                    id = table.Column<Guid>(type: "uuid", nullable: false),
+                    unit_index = table.Column<int>(type: "integer", nullable: false),
+                    printer_id = table.Column<Guid>(type: "uuid", nullable: false),
+                    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_ams_units", x => x.id);
+                    table.ForeignKey(
+                        name: "fk_ams_units_printer",
+                        column: x => x.printer_id,
+                        principalTable: "printers",
+                        principalColumn: "id",
+                        onDelete: ReferentialAction.Cascade);
+                });
+
+            migrationBuilder.CreateTable(
+                name: "spools",
+                columns: table => new
+                {
+                    id = table.Column<Guid>(type: "uuid", nullable: false),
+                    material_base_id = table.Column<Guid>(type: "uuid", nullable: false),
+                    material_finish_id = table.Column<Guid>(type: "uuid", nullable: false),
+                    material_modifier_id = table.Column<Guid>(type: "uuid", nullable: true),
+                    brand = table.Column<string>(type: "character varying(200)", maxLength: 200, nullable: false),
+                    color_name = table.Column<string>(type: "character varying(200)", maxLength: 200, nullable: false),
+                    color_hex = table.Column<string>(type: "character varying(7)", maxLength: 7, nullable: false),
+                    weight_total_grams = table.Column<decimal>(type: "numeric(10,2)", precision: 10, scale: 2, nullable: false),
+                    weight_remaining_grams = table.Column<decimal>(type: "numeric(10,2)", precision: 10, scale: 2, nullable: false),
+                    filament_diameter_mm = table.Column<decimal>(type: "numeric(6,3)", precision: 6, scale: 3, nullable: false),
+                    spool_serial = table.Column<string>(type: "character varying(200)", maxLength: 200, nullable: false),
+                    purchase_price = table.Column<decimal>(type: "numeric(10,2)", precision: 10, scale: 2, nullable: true),
+                    purchase_date = table.Column<DateTime>(type: "timestamp with time zone", nullable: true),
+                    is_active = table.Column<bool>(type: "boolean", nullable: false, defaultValue: 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_spools", x => x.id);
+                    table.ForeignKey(
+                        name: "fk_spools_material_base",
+                        column: x => x.material_base_id,
+                        principalTable: "material_bases",
+                        principalColumn: "id",
+                        onDelete: ReferentialAction.Restrict);
+                    table.ForeignKey(
+                        name: "fk_spools_material_finish",
+                        column: x => x.material_finish_id,
+                        principalTable: "material_finishes",
+                        principalColumn: "id",
+                        onDelete: ReferentialAction.Restrict);
+                    table.ForeignKey(
+                        name: "fk_spools_material_modifier",
+                        column: x => x.material_modifier_id,
+                        principalTable: "material_modifiers",
+                        principalColumn: "id",
+                        onDelete: ReferentialAction.SetNull);
+                });
+
+            migrationBuilder.CreateTable(
+                name: "ams_slots",
+                columns: table => new
+                {
+                    id = table.Column<Guid>(type: "uuid", nullable: false),
+                    tray_index = table.Column<int>(type: "integer", nullable: false),
+                    ams_unit_id = table.Column<Guid>(type: "uuid", nullable: false),
+                    spool_id = table.Column<Guid>(type: "uuid", nullable: true),
+                    remaining_weight_g = table.Column<decimal>(type: "numeric(10,2)", precision: 10, scale: 2, 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_ams_slots", x => x.id);
+                    table.ForeignKey(
+                        name: "fk_ams_slots_ams_unit",
+                        column: x => x.ams_unit_id,
+                        principalTable: "ams_units",
+                        principalColumn: "id",
+                        onDelete: ReferentialAction.Cascade);
+                    table.ForeignKey(
+                        name: "fk_ams_slots_spool",
+                        column: x => x.spool_id,
+                        principalTable: "spools",
+                        principalColumn: "id",
+                        onDelete: ReferentialAction.SetNull);
+                });
+
+            migrationBuilder.CreateTable(
+                name: "print_jobs",
+                columns: table => new
+                {
+                    id = table.Column<Guid>(type: "uuid", nullable: false),
+                    printer_id = table.Column<Guid>(type: "uuid", nullable: false),
+                    spool_id = table.Column<Guid>(type: "uuid", nullable: false),
+                    print_name = table.Column<string>(type: "character varying(500)", maxLength: 500, nullable: false),
+                    gcode_file_path = table.Column<string>(type: "character varying(1000)", maxLength: 1000, nullable: true),
+                    mm_extruded = table.Column<decimal>(type: "numeric(12,2)", precision: 12, scale: 2, nullable: false),
+                    grams_derived = table.Column<decimal>(type: "numeric(10,2)", precision: 10, scale: 2, nullable: false),
+                    cost_per_print = table.Column<decimal>(type: "numeric(10,4)", precision: 10, scale: 4, nullable: true),
+                    started_at = table.Column<DateTime>(type: "timestamp with time zone", nullable: true),
+                    completed_at = table.Column<DateTime>(type: "timestamp with time zone", nullable: true),
+                    status = table.Column<string>(type: "character varying(50)", maxLength: 50, nullable: false, defaultValue: "Queued"),
+                    data_source = table.Column<string>(type: "character varying(50)", maxLength: 50, nullable: false),
+                    filament_diameter_at_print_mm = table.Column<decimal>(type: "numeric(6,3)", precision: 6, scale: 3, nullable: false),
+                    material_density_at_print = table.Column<decimal>(type: "numeric(10,4)", precision: 10, scale: 4, nullable: false),
+                    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_print_jobs", x => x.id);
+                    table.ForeignKey(
+                        name: "fk_print_jobs_printer",
+                        column: x => x.printer_id,
+                        principalTable: "printers",
+                        principalColumn: "id",
+                        onDelete: ReferentialAction.Restrict);
+                    table.ForeignKey(
+                        name: "fk_print_jobs_spool",
+                        column: x => x.spool_id,
+                        principalTable: "spools",
+                        principalColumn: "id",
+                        onDelete: ReferentialAction.Restrict);
+                });
+
+            migrationBuilder.InsertData(
+                table: "material_bases",
+                columns: new[] { "id", "created_at", "density_g_per_cm3", "name", "updated_at" },
+                values: new object[,]
+                {
+                    { new Guid("10000000-0000-0000-0000-000000000001"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1096), 1.24m, "PLA", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1096) },
+                    { new Guid("10000000-0000-0000-0000-000000000002"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1620), 1.27m, "PETG", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1620) },
+                    { new Guid("10000000-0000-0000-0000-000000000003"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1630), 1.04m, "ABS", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1630) },
+                    { new Guid("10000000-0000-0000-0000-000000000004"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1638), 1.07m, "ASA", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1638) },
+                    { new Guid("10000000-0000-0000-0000-000000000005"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1645), 1.21m, "TPU", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1645) },
+                    { new Guid("10000000-0000-0000-0000-000000000006"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1651), 1.14m, "Nylon", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1652) }
+                });
+
+            migrationBuilder.InsertData(
+                table: "material_finishes",
+                columns: new[] { "id", "created_at", "material_base_id", "name", "updated_at" },
+                values: new object[,]
+                {
+                    { new Guid("20000000-0000-0000-0000-000000000001"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1850), new Guid("10000000-0000-0000-0000-000000000001"), "Basic", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(1850) },
+                    { new Guid("20000000-0000-0000-0000-000000000002"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2041), new Guid("10000000-0000-0000-0000-000000000001"), "Matte", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2041) },
+                    { new Guid("20000000-0000-0000-0000-000000000003"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2049), new Guid("10000000-0000-0000-0000-000000000001"), "Silk", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2049) },
+                    { new Guid("20000000-0000-0000-0000-000000000004"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2055), new Guid("10000000-0000-0000-0000-000000000001"), "Glitter", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2056) },
+                    { new Guid("20000000-0000-0000-0000-000000000005"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2062), new Guid("10000000-0000-0000-0000-000000000001"), "Marble", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2062) },
+                    { new Guid("20000000-0000-0000-0000-000000000006"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2068), new Guid("10000000-0000-0000-0000-000000000001"), "Sparkle", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2068) },
+                    { new Guid("20000000-0000-0000-0000-000000000007"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2075), new Guid("10000000-0000-0000-0000-000000000002"), "Basic", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2075) },
+                    { new Guid("20000000-0000-0000-0000-000000000008"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2081), new Guid("10000000-0000-0000-0000-000000000002"), "Matte", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2081) },
+                    { new Guid("20000000-0000-0000-0000-000000000009"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2100), new Guid("10000000-0000-0000-0000-000000000002"), "Silk", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2100) },
+                    { new Guid("20000000-0000-0000-0000-000000000010"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2107), new Guid("10000000-0000-0000-0000-000000000003"), "Basic", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2107) },
+                    { new Guid("20000000-0000-0000-0000-000000000011"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2113), new Guid("10000000-0000-0000-0000-000000000003"), "Matte", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2113) },
+                    { new Guid("20000000-0000-0000-0000-000000000012"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2120), new Guid("10000000-0000-0000-0000-000000000004"), "Basic", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2120) },
+                    { new Guid("20000000-0000-0000-0000-000000000013"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2126), new Guid("10000000-0000-0000-0000-000000000004"), "Matte", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2126) },
+                    { new Guid("20000000-0000-0000-0000-000000000014"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2132), new Guid("10000000-0000-0000-0000-000000000005"), "Basic", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2133) },
+                    { new Guid("20000000-0000-0000-0000-000000000015"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2139), new Guid("10000000-0000-0000-0000-000000000006"), "Basic", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2139) }
+                });
+
+            migrationBuilder.InsertData(
+                table: "material_modifiers",
+                columns: new[] { "id", "created_at", "material_base_id", "name", "updated_at" },
+                values: new object[,]
+                {
+                    { new Guid("30000000-0000-0000-0000-000000000001"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2304), new Guid("10000000-0000-0000-0000-000000000001"), "Carbon Fiber", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2304) },
+                    { new Guid("30000000-0000-0000-0000-000000000002"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2463), new Guid("10000000-0000-0000-0000-000000000001"), "Glass Fiber", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2463) },
+                    { new Guid("30000000-0000-0000-0000-000000000003"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2471), new Guid("10000000-0000-0000-0000-000000000001"), "Wood Fill", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2471) },
+                    { new Guid("30000000-0000-0000-0000-000000000004"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2477), new Guid("10000000-0000-0000-0000-000000000001"), "Glow-in-the-Dark", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2478) },
+                    { new Guid("30000000-0000-0000-0000-000000000005"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2484), new Guid("10000000-0000-0000-0000-000000000002"), "Carbon Fiber", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2484) },
+                    { new Guid("30000000-0000-0000-0000-000000000006"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2490), new Guid("10000000-0000-0000-0000-000000000002"), "Glass Fiber", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2491) },
+                    { new Guid("30000000-0000-0000-0000-000000000007"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2497), new Guid("10000000-0000-0000-0000-000000000003"), "Carbon Fiber", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2497) },
+                    { new Guid("30000000-0000-0000-0000-000000000008"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2503), new Guid("10000000-0000-0000-0000-000000000003"), "Glass Fiber", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2503) },
+                    { new Guid("30000000-0000-0000-0000-000000000009"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2510), new Guid("10000000-0000-0000-0000-000000000004"), "Carbon Fiber", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2510) },
+                    { new Guid("30000000-0000-0000-0000-000000000010"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2516), new Guid("10000000-0000-0000-0000-000000000006"), "Carbon Fiber", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2516) },
+                    { new Guid("30000000-0000-0000-0000-000000000011"), new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2522), new Guid("10000000-0000-0000-0000-000000000006"), "Glass Fiber", new DateTime(2026, 4, 26, 13, 14, 18, 745, DateTimeKind.Utc).AddTicks(2523) }
+                });
+
+            migrationBuilder.CreateIndex(
+                name: "ix_ams_slots_ams_unit_id_tray_index",
+                table: "ams_slots",
+                columns: new[] { "ams_unit_id", "tray_index" },
+                unique: true);
+
+            migrationBuilder.CreateIndex(
+                name: "ix_ams_slots_spool_id",
+                table: "ams_slots",
+                column: "spool_id");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_ams_units_printer_id_unit_index",
+                table: "ams_units",
+                columns: new[] { "printer_id", "unit_index" },
+                unique: true);
+
+            migrationBuilder.CreateIndex(
+                name: "ix_material_bases_name",
+                table: "material_bases",
+                column: "name",
+                unique: true);
+
+            migrationBuilder.CreateIndex(
+                name: "ix_material_finishes_material_base_id_name",
+                table: "material_finishes",
+                columns: new[] { "material_base_id", "name" },
+                unique: true);
+
+            migrationBuilder.CreateIndex(
+                name: "ix_material_modifiers_material_base_id_name",
+                table: "material_modifiers",
+                columns: new[] { "material_base_id", "name" },
+                unique: true);
+
+            migrationBuilder.CreateIndex(
+                name: "ix_print_jobs_data_source",
+                table: "print_jobs",
+                column: "data_source");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_print_jobs_printer_id",
+                table: "print_jobs",
+                column: "printer_id");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_print_jobs_spool_id",
+                table: "print_jobs",
+                column: "spool_id");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_print_jobs_status",
+                table: "print_jobs",
+                column: "status");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_printers_connection_type",
+                table: "printers",
+                column: "connection_type");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_printers_is_active",
+                table: "printers",
+                column: "is_active");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_printers_printer_type",
+                table: "printers",
+                column: "printer_type");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_printers_status",
+                table: "printers",
+                column: "status");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_spools_is_active",
+                table: "spools",
+                column: "is_active");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_spools_material_base_id",
+                table: "spools",
+                column: "material_base_id");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_spools_material_finish_id",
+                table: "spools",
+                column: "material_finish_id");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_spools_material_modifier_id",
+                table: "spools",
+                column: "material_modifier_id");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_spools_spool_serial",
+                table: "spools",
+                column: "spool_serial",
+                unique: true);
+        }
+
+        /// <inheritdoc />
+        protected override void Down(MigrationBuilder migrationBuilder)
+        {
+            migrationBuilder.DropTable(
+                name: "ams_slots");
+
+            migrationBuilder.DropTable(
+                name: "print_jobs");
+
+            migrationBuilder.DropTable(
+                name: "ams_units");
+
+            migrationBuilder.DropTable(
+                name: "spools");
+
+            migrationBuilder.DropTable(
+                name: "printers");
+
+            migrationBuilder.DropTable(
+                name: "material_finishes");
+
+            migrationBuilder.DropTable(
+                name: "material_modifiers");
+
+            migrationBuilder.DropTable(
+                name: "material_bases");
+        }
+    }
+}

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

@@ -0,0 +1,533 @@
+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/20260426184329_AddUsageLogTable.cs

@@ -0,0 +1,534 @@
+using System;
+using Microsoft.EntityFrameworkCore.Migrations;
+
+#nullable disable
+
+namespace Extrudex.Infrastructure.Data.Migrations
+{
+    /// <inheritdoc />
+    public partial class AddUsageLogTable : Migration
+    {
+        /// <inheritdoc />
+        protected override void Up(MigrationBuilder migrationBuilder)
+        {
+            migrationBuilder.CreateTable(
+                name: "usage_logs",
+                columns: table => new
+                {
+                    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: true),
+                    print_job_id = table.Column<Guid>(type: "uuid", nullable: true),
+                    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: true),
+                    usage_timestamp = table.Column<DateTime>(type: "timestamp with time zone", nullable: false),
+                    data_source = table.Column<string>(type: "character varying(50)", maxLength: 50, nullable: false),
+                    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_usage_logs", x => x.id);
+                    table.ForeignKey(
+                        name: "fk_usage_logs_print_job",
+                        column: x => x.print_job_id,
+                        principalTable: "print_jobs",
+                        principalColumn: "id",
+                        onDelete: ReferentialAction.SetNull);
+                    table.ForeignKey(
+                        name: "fk_usage_logs_printer",
+                        column: x => x.printer_id,
+                        principalTable: "printers",
+                        principalColumn: "id",
+                        onDelete: ReferentialAction.SetNull);
+                    table.ForeignKey(
+                        name: "fk_usage_logs_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, 43, 28, 895, DateTimeKind.Utc).AddTicks(6535), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(6535) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7016), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7016) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7027), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7028) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7034), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7035) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7042), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7042) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7049), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7049) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7291), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7292) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7453), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7453) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7461), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7461) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7468), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7468) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7474), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7474) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7480), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7481) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7487), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7487) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7493), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7493) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7500), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7500) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7507), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7507) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7513), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7513) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7519), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7520) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7526), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7526) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7532), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7532) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7538), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7539) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7690), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7690) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7838), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7838) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7846), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7846) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7853), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7853) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7859), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7859) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7865), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7866) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7872), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7872) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7878), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7879) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7885), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7885) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7891), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7891) });
+
+            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, 43, 28, 895, DateTimeKind.Utc).AddTicks(7898), new DateTime(2026, 4, 26, 18, 43, 28, 895, DateTimeKind.Utc).AddTicks(7898) });
+
+            migrationBuilder.CreateIndex(
+                name: "ix_usage_logs_data_source",
+                table: "usage_logs",
+                column: "data_source");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_usage_logs_print_job_id",
+                table: "usage_logs",
+                column: "print_job_id");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_usage_logs_printer_id",
+                table: "usage_logs",
+                column: "printer_id");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_usage_logs_spool_id",
+                table: "usage_logs",
+                column: "spool_id");
+
+            migrationBuilder.CreateIndex(
+                name: "ix_usage_logs_usage_timestamp",
+                table: "usage_logs",
+                column: "usage_timestamp");
+        }
+
+        /// <inheritdoc />
+        protected override void Down(MigrationBuilder migrationBuilder)
+        {
+            migrationBuilder.DropTable(
+                name: "usage_logs");
+
+            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/Services/UsageLogService.cs

@@ -0,0 +1,81 @@
+using Extrudex.Domain.Entities;
+using Extrudex.Domain.Enums;
+using Extrudex.Domain.Interfaces;
+using Extrudex.Infrastructure.Data;
+using Microsoft.EntityFrameworkCore;
+
+namespace Extrudex.Infrastructure.Services;
+
+/// <summary>
+/// Implementation of <see cref="IUsageLogService"/> that persists usage entries
+/// to the usage_logs table via EF Core.
+/// </summary>
+public class UsageLogService : IUsageLogService
+{
+    private readonly ExtrudexDbContext _dbContext;
+
+    /// <summary>
+    /// Initializes a new instance of the <see cref="UsageLogService"/> class.
+    /// </summary>
+    /// <param name="dbContext">The EF Core database context for data persistence.</param>
+    public UsageLogService(ExtrudexDbContext dbContext)
+    {
+        _dbContext = dbContext;
+    }
+
+    /// <inheritdoc/>
+    public async Task<UsageLog> RecordUsageAsync(
+        Guid spoolId,
+        decimal gramsUsed,
+        DataSource dataSource,
+        Guid? printerId = null,
+        Guid? printJobId = null,
+        decimal? mmExtruded = null,
+        DateTime? usageTimestamp = null,
+        string? notes = null)
+    {
+        var entry = new UsageLog
+        {
+            SpoolId = spoolId,
+            GramsUsed = gramsUsed,
+            DataSource = dataSource,
+            PrinterId = printerId,
+            PrintJobId = printJobId,
+            MmExtruded = mmExtruded,
+            UsageTimestamp = usageTimestamp ?? DateTime.UtcNow,
+            Notes = notes
+        };
+
+        _dbContext.UsageLogs.Add(entry);
+        await _dbContext.SaveChangesAsync();
+
+        return entry;
+    }
+
+    /// <inheritdoc/>
+    public async Task<IEnumerable<UsageLog>> GetBySpoolAsync(Guid spoolId, CancellationToken cancellationToken = default)
+    {
+        return await _dbContext.UsageLogs
+            .Where(u => u.SpoolId == spoolId)
+            .OrderByDescending(u => u.UsageTimestamp)
+            .ToListAsync(cancellationToken);
+    }
+
+    /// <inheritdoc/>
+    public async Task<IEnumerable<UsageLog>> GetByPrinterAsync(Guid printerId, CancellationToken cancellationToken = default)
+    {
+        return await _dbContext.UsageLogs
+            .Where(u => u.PrinterId == printerId)
+            .OrderByDescending(u => u.UsageTimestamp)
+            .ToListAsync(cancellationToken);
+    }
+
+    /// <inheritdoc/>
+    public async Task<IEnumerable<UsageLog>> GetByPrintJobAsync(Guid printJobId, CancellationToken cancellationToken = default)
+    {
+        return await _dbContext.UsageLogs
+            .Where(u => u.PrintJobId == printJobId)
+            .OrderByDescending(u => u.UsageTimestamp)
+            .ToListAsync(cancellationToken);
+    }
+}

backend/Program.cs

@@ -1,4 +1,5 @@
 using System.Reflection;
+using Extrudex.API.Filters;
 using Extrudex.API.Hubs;
 using Extrudex.Domain.Interfaces;
 using Extrudex.Infrastructure.Data;
@@ -23,7 +24,10 @@ builder.Services.AddDbContext<ExtrudexDbContext>(options =>
     options.UseNpgsql(connectionString));
 
 // ── API Services ───────────────────────────────────────────
-builder.Services.AddControllers();
+builder.Services.AddControllers(options =>
+{
+    options.Filters.AddService<FluentValidationFilter>();
+});
 builder.Services.AddEndpointsApiExplorer();
 builder.Services.AddSwaggerGen(c =>
 {
@@ -46,10 +50,17 @@ builder.Services.AddSwaggerGen(c =>
 // ── QR Code Generation ──────────────────────────────────────
 builder.Services.AddSingleton<IQrCodeService, QrCodeService>();
 
+// ── Usage Logging ───────────────────────────────────────────
+builder.Services.AddScoped<IUsageLogService, UsageLogService>();
+
 // ── FluentValidation ──────────────────────────────────────
 // Registers all validators from the API assembly into DI.
 builder.Services.AddValidatorsFromAssembly(Assembly.GetExecutingAssembly());
 
+// Register the FluentValidation action filter so validators run automatically
+// on all API controller actions before the action executes.
+builder.Services.AddScoped<FluentValidationFilter>();
+
 // ── CORS (kiosk + remote browser) ─────────────────────────
 // AllowAnyOrigin disallows credentials by spec; this is fine for
 // REST API calls. SignalR WebSockets negotiate without credentials
@@ -69,6 +80,10 @@ builder.Services.AddCors(options =>
 // ── SignalR (real-time printer updates) ────────────────────
 builder.Services.AddSignalR();
 
+// ── Health Checks ───────────────────────────────────────────
+builder.Services.AddHealthChecks()
+    .AddNpgSql(connectionString);
+
 var app = builder.Build();
 
 // ── Middleware ──────────────────────────────────────────────
@@ -85,6 +100,9 @@ app.MapControllers();
 // ── Hub Endpoints ───────────────────────────────────────────
 app.MapHub<PrinterHub>("/hubs/printer");
 
+// ── Health Check Endpoint ──────────────────────────────────
+app.MapHealthChecks("/health");
+
 app.Run();
 
 // Helper: builds a connection string from individual env vars.

deploy.sh

@@ -0,0 +1,33 @@
+#!/bin/bash
+set -e
+
+echo "🔧 Deploying Extrudex Docker runtime..."
+
+# Check if Docker Compose is available
+if ! command -v docker-compose &> /dev/null && ! docker compose version &> /dev/null; then
+    echo "❌ Docker Compose is not installed"
+    exit 1
+fi
+
+COMPOSE_CMD="docker compose"
+if command -v docker-compose &> /dev/null; then
+    COMPOSE_CMD="docker-compose"
+fi
+
+echo "📦 Building and starting services..."
+$COMPOSE_CMD -f docker-compose.dev.yml up -d --build
+
+echo "⏳ Waiting for services to become healthy..."
+sleep 10
+
+echo "✅ Deployment complete!"
+echo ""
+echo "Services running:"
+echo "  • Extrudex API: http://localhost:5080"
+echo "  • Control Center Web: http://localhost:5081"
+echo ""
+echo "To view logs:"
+echo "  $COMPOSE_CMD -f docker-compose.dev.yml logs -f"
+echo ""
+echo "To stop:"
+echo "  $COMPOSE_CMD -f docker-compose.dev.yml down"

docker-compose.dev.yml

@@ -0,0 +1,40 @@
+version: '3.8'
+
+services:
+  extrudex-api:
+    build:
+      context: ./backend
+      dockerfile: Dockerfile
+    container_name: extrudex-api
+    ports:
+      - "5080:8080"
+    environment:
+      - ASPNETCORE_ENVIRONMENT=Development
+      - ASPNETCORE_URLS=http://+:8080
+    restart: unless-stopped
+    healthcheck:
+      test: ["CMD", "curl", "-f", "http://localhost:8080/health"]
+      interval: 30s
+      timeout: 10s
+      retries: 3
+      start_period: 40s
+    networks:
+      - extrudex-network
+
+  control-center-web:
+    build:
+      context: ../Control-Center/frontend
+      dockerfile: Dockerfile
+    container_name: control-center-web
+    ports:
+      - "5081:80"
+    depends_on:
+      extrudex-api:
+        condition: service_healthy
+    restart: unless-stopped
+    networks:
+      - extrudex-network
+
+networks:
+  extrudex-network:
+    driver: bridge

frontend/.dockerignore

@@ -0,0 +1,11 @@
+node_modules
+dist
+.git
+.gitignore
+.angular
+.vscode
+*.md
+.editorconfig
+.prettierrc
+src/test.ts
+**/*.spec.ts

frontend/.editorconfig

@@ -10,6 +10,7 @@ trim_trailing_whitespace = true
 
 [*.ts]
 quote_type = single
+ij_typescript_use_double_quotes = false
 
 [*.md]
 max_line_length = off

frontend/.gitignore

@@ -26,6 +26,7 @@ yarn-error.log
 !.vscode/tasks.json
 !.vscode/launch.json
 !.vscode/extensions.json
+!.vscode/mcp.json
 .history/*
 
 # Miscellaneous
@@ -36,6 +37,7 @@ yarn-error.log
 /libpeerconnection.log
 testem.log
 /typings
+__screenshots__/
 
 # System files
 .DS_Store

frontend/.prettierrc

@@ -0,0 +1,12 @@
+{
+  "printWidth": 100,
+  "singleQuote": true,
+  "overrides": [
+    {
+      "files": "*.html",
+      "options": {
+        "parser": "angular"
+      }
+    }
+  ]
+}

frontend/.vscode/mcp.json

@@ -0,0 +1,9 @@
+{
+  // For more information, visit: https://angular.dev/ai/mcp
+  "servers": {
+    "angular-cli": {
+      "command": "npx",
+      "args": ["-y", "@angular/cli", "mcp"]
+    }
+  }
+}

frontend/.vscode/tasks.json

@@ -12,10 +12,10 @@
         "background": {
           "activeOnStart": true,
           "beginsPattern": {
-            "regexp": "(.*?)"
+            "regexp": "Changes detected"
           },
           "endsPattern": {
-            "regexp": "bundle generation complete"
+            "regexp": "bundle generation (complete|failed)"
           }
         }
       }
@@ -30,10 +30,10 @@
         "background": {
           "activeOnStart": true,
           "beginsPattern": {
-            "regexp": "(.*?)"
+            "regexp": "Changes detected"
           },
           "endsPattern": {
-            "regexp": "bundle generation complete"
+            "regexp": "bundle generation (complete|failed)"
           }
         }
       }

frontend/Dockerfile

@@ -0,0 +1,28 @@
+# Stage 1: Build the Angular application
+FROM node:22-alpine AS build
+
+WORKDIR /app
+
+# Copy package files first for better layer caching
+COPY package.json package-lock.json ./
+RUN npm ci
+
+# Copy source and build
+COPY . .
+RUN npx ng build --configuration production
+
+# Stage 2: Serve static files with nginx
+FROM nginx:alpine
+
+# Remove default nginx config
+RUN rm /etc/nginx/conf.d/default.conf
+
+# Copy custom nginx config
+COPY nginx.conf /etc/nginx/conf.d/default.conf
+
+# Copy built Angular artifacts from build stage
+COPY --from=build /app/dist/frontend/browser /usr/share/nginx/html
+
+EXPOSE 80
+
+CMD ["nginx", "-g", "daemon off;"]

frontend/README.md

@@ -1,27 +1,59 @@
 # Frontend
 
-This project was generated with [Angular CLI](https://github.com/angular/angular-cli) version 17.3.17.
+This project was generated using [Angular CLI](https://github.com/angular/angular-cli) version 21.2.8.
 
 ## Development server
 
-Run `ng serve` for a dev server. Navigate to `http://localhost:4200/`. The application will automatically reload if you change any of the source files.
+To start a local development server, run:
+
+```bash
+ng serve
+```
+
+Once the server is running, open your browser and navigate to `http://localhost:4200/`. The application will automatically reload whenever you modify any of the source files.
 
 ## Code scaffolding
 
-Run `ng generate component component-name` to generate a new component. You can also use `ng generate directive|pipe|service|class|guard|interface|enum|module`.
+Angular CLI includes powerful code scaffolding tools. To generate a new component, run:
 
-## Build
+```bash
+ng generate component component-name
+```
 
-Run `ng build` to build the project. The build artifacts will be stored in the `dist/` directory.
+For a complete list of available schematics (such as `components`, `directives`, or `pipes`), run:
+
+```bash
+ng generate --help
+```
+
+## Building
+
+To build the project run:
+
+```bash
+ng build
+```
+
+This will compile your project and store the build artifacts in the `dist/` directory. By default, the production build optimizes your application for performance and speed.
 
 ## Running unit tests
 
-Run `ng test` to execute the unit tests via [Karma](https://karma-runner.github.io).
+To execute unit tests with the [Vitest](https://vitest.dev/) test runner, use the following command:
+
+```bash
+ng test
+```
 
 ## Running end-to-end tests
 
-Run `ng e2e` to execute the end-to-end tests via a platform of your choice. To use this command, you need to first add a package that implements end-to-end testing capabilities.
+For end-to-end (e2e) testing, run:
 
-## Further help
+```bash
+ng e2e
+```
 
-To get more help on the Angular CLI use `ng help` or go check out the [Angular CLI Overview and Command Reference](https://angular.io/cli) page.
+Angular CLI does not come with an end-to-end testing framework by default. You can choose one that suits your needs.
+
+## Additional Resources
+
+For more information on using the Angular CLI, including detailed command references, visit the [Angular CLI Overview and Command Reference](https://angular.dev/tools/cli) page.

frontend/angular.json

@@ -1,35 +1,16 @@
 {
   "$schema": "./node_modules/@angular/cli/lib/config/schema.json",
   "version": 1,
+  "cli": {
+    "packageManager": "npm"
+  },
   "newProjectRoot": "projects",
   "projects": {
     "frontend": {
       "projectType": "application",
       "schematics": {
         "@schematics/angular:component": {
-          "style": "scss",
-          "skipTests": true
-        },
-        "@schematics/angular:class": {
-          "skipTests": true
-        },
-        "@schematics/angular:directive": {
-          "skipTests": true
-        },
-        "@schematics/angular:guard": {
-          "skipTests": true
-        },
-        "@schematics/angular:interceptor": {
-          "skipTests": true
-        },
-        "@schematics/angular:pipe": {
-          "skipTests": true
-        },
-        "@schematics/angular:resolver": {
-          "skipTests": true
-        },
-        "@schematics/angular:service": {
-          "skipTests": true
+          "style": "scss"
         }
       },
       "root": "",
@@ -37,37 +18,33 @@
       "prefix": "app",
       "architect": {
         "build": {
-          "builder": "@angular-devkit/build-angular:application",
+          "builder": "@angular/build:application",
           "options": {
-            "outputPath": "dist/frontend",
-            "index": "src/index.html",
             "browser": "src/main.ts",
-            "polyfills": [
-              "zone.js"
-            ],
             "tsConfig": "tsconfig.app.json",
             "inlineStyleLanguage": "scss",
             "assets": [
-              "src/favicon.ico",
-              "src/assets"
+              {
+                "glob": "**/*",
+                "input": "public"
+              }
             ],
             "styles": [
               "src/styles.scss"
-            ],
-            "scripts": []
+            ]
           },
           "configurations": {
             "production": {
               "budgets": [
                 {
                   "type": "initial",
-                  "maximumWarning": "500kb",
-                  "maximumError": "1mb"
+                  "maximumWarning": "500kB",
+                  "maximumError": "1MB"
                 },
                 {
                   "type": "anyComponentStyle",
-                  "maximumWarning": "2kb",
-                  "maximumError": "4kb"
+                  "maximumWarning": "4kB",
+                  "maximumError": "8kB"
                 }
               ],
               "outputHashing": "all"
@@ -81,7 +58,7 @@
           "defaultConfiguration": "production"
         },
         "serve": {
-          "builder": "@angular-devkit/build-angular:dev-server",
+          "builder": "@angular/build:dev-server",
           "configurations": {
             "production": {
               "buildTarget": "frontend:build:production"
@@ -92,30 +69,8 @@
           },
           "defaultConfiguration": "development"
         },
-        "extract-i18n": {
-          "builder": "@angular-devkit/build-angular:extract-i18n",
-          "options": {
-            "buildTarget": "frontend:build"
-          }
-        },
         "test": {
-          "builder": "@angular-devkit/build-angular:karma",
-          "options": {
-            "polyfills": [
-              "zone.js",
-              "zone.js/testing"
-            ],
-            "tsConfig": "tsconfig.spec.json",
-            "inlineStyleLanguage": "scss",
-            "assets": [
-              "src/favicon.ico",
-              "src/assets"
-            ],
-            "styles": [
-              "src/styles.scss"
-            ],
-            "scripts": []
-          }
+          "builder": "@angular/build:unit-test"
         }
       }
     }

frontend/nginx.conf

@@ -0,0 +1,42 @@
+server {
+    listen 80;
+    server_name _;
+    root /usr/share/nginx/html;
+    index index.html;
+
+    # Gzip compression
+    gzip on;
+    gzip_types text/plain text/css application/json application/javascript text/xml application/xml text/javascript;
+    gzip_min_length 256;
+
+    # Angular SPA — fallback to index.html for client-side routing
+    location / {
+        try_files $uri $uri/ /index.html;
+    }
+
+    # Cache static assets aggressively
+    location ~* \.(js|css|png|jpg|jpeg|gif|ico|svg|woff2?|ttf|eot)$ {
+        expires 1y;
+        add_header Cache-Control "public, immutable";
+    }
+
+    # Proxy API requests to backend
+    # Uses resolver so nginx doesn't crash if backend isn't available at startup
+    resolver 127.0.0.11 valid=30s ipv6=off;
+    set $backend "extrudex-api:8080";
+
+    location /api/ {
+        proxy_pass http://$backend;
+        proxy_set_header Host $host;
+        proxy_set_header X-Real-IP $remote_addr;
+        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
+        proxy_set_header X-Forwarded-Proto $scheme;
+    }
+
+    # Health check endpoint
+    location /health {
+        access_log off;
+        return 200 "ok";
+        add_header Content-Type text/plain;
+    }
+}

frontend/package.json

@@ -9,32 +9,27 @@
     "test": "ng test"
   },
   "private": true,
+  "packageManager": "npm@11.11.0",
   "dependencies": {
-    "@angular/animations": "^17.3.0",
-    "@angular/common": "^17.3.0",
-    "@angular/compiler": "^17.3.0",
-    "@angular/core": "^17.3.0",
-    "@angular/forms": "^17.3.0",
-    "@angular/material": "^17.3.10",
-    "@angular/platform-browser": "^17.3.0",
-    "@angular/platform-browser-dynamic": "^17.3.0",
-    "@angular/router": "^17.3.0",
-    "@microsoft/signalr": "^10.0.0",
+    "@angular/cdk": "^21.2.8",
+    "@angular/common": "^21.2.0",
+    "@angular/compiler": "^21.2.0",
+    "@angular/core": "^21.2.0",
+    "@angular/forms": "^21.2.0",
+    "@angular/material": "^21.2.8",
+    "@angular/platform-browser": "^21.2.0",
+    "@angular/router": "^21.2.0",
     "rxjs": "~7.8.0",
-    "tslib": "^2.3.0",
-    "zone.js": "~0.14.3"
+    "tslib": "^2.3.0"
   },
   "devDependencies": {
-    "@angular-devkit/build-angular": "^17.3.17",
-    "@angular/cli": "^17.3.17",
-    "@angular/compiler-cli": "^17.3.0",
-    "@types/jasmine": "~5.1.0",
-    "jasmine-core": "~5.1.0",
-    "karma": "~6.4.0",
-    "karma-chrome-launcher": "~3.2.0",
-    "karma-coverage": "~2.2.0",
-    "karma-jasmine": "~5.1.0",
-    "karma-jasmine-html-reporter": "~2.1.0",
-    "typescript": "~5.4.2"
+    "@angular/build": "^21.2.8",
+    "@angular/cli": "^21.2.8",
+    "@angular/compiler-cli": "^21.2.0",
+    "@vitest/browser-playwright": "^4.1.5",
+    "jsdom": "^28.0.0",
+    "prettier": "^3.8.1",
+    "typescript": "~5.9.2",
+    "vitest": "^4.0.8"
   }
 }

frontend/src/app/app.component.html

@@ -1,336 +0,0 @@
-<!-- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * -->
-<!-- * * * * * * * * * * * The content below * * * * * * * * * * * -->
-<!-- * * * * * * * * * * is only a placeholder * * * * * * * * * * -->
-<!-- * * * * * * * * * * and can be replaced.  * * * * * * * * * * -->
-<!-- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * -->
-<!-- * * * * * * * * * Delete the template below * * * * * * * * * -->
-<!-- * * * * * * * to get started with your project! * * * * * * * -->
-<!-- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * -->
-
-<style>
-  :host {
-    --bright-blue: oklch(51.01% 0.274 263.83);
-    --electric-violet: oklch(53.18% 0.28 296.97);
-    --french-violet: oklch(47.66% 0.246 305.88);
-    --vivid-pink: oklch(69.02% 0.277 332.77);
-    --hot-red: oklch(61.42% 0.238 15.34);
-    --orange-red: oklch(63.32% 0.24 31.68);
-
-    --gray-900: oklch(19.37% 0.006 300.98);
-    --gray-700: oklch(36.98% 0.014 302.71);
-    --gray-400: oklch(70.9% 0.015 304.04);
-
-    --red-to-pink-to-purple-vertical-gradient: linear-gradient(
-      180deg,
-      var(--orange-red) 0%,
-      var(--vivid-pink) 50%,
-      var(--electric-violet) 100%
-    );
-
-    --red-to-pink-to-purple-horizontal-gradient: linear-gradient(
-      90deg,
-      var(--orange-red) 0%,
-      var(--vivid-pink) 50%,
-      var(--electric-violet) 100%
-    );
-
-    --pill-accent: var(--bright-blue);
-
-    font-family: "Inter", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto,
-      Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji",
-      "Segoe UI Symbol";
-    box-sizing: border-box;
-    -webkit-font-smoothing: antialiased;
-    -moz-osx-font-smoothing: grayscale;
-  }
-
-  h1 {
-    font-size: 3.125rem;
-    color: var(--gray-900);
-    font-weight: 500;
-    line-height: 100%;
-    letter-spacing: -0.125rem;
-    margin: 0;
-    font-family: "Inter Tight", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto,
-      Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji",
-      "Segoe UI Symbol";
-  }
-
-  p {
-    margin: 0;
-    color: var(--gray-700);
-  }
-
-  main {
-    width: 100%;
-    min-height: 100%;
-    display: flex;
-    justify-content: center;
-    align-items: center;
-    padding: 1rem;
-    box-sizing: inherit;
-    position: relative;
-  }
-
-  .angular-logo {
-    max-width: 9.2rem;
-  }
-
-  .content {
-    display: flex;
-    justify-content: space-around;
-    width: 100%;
-    max-width: 700px;
-    margin-bottom: 3rem;
-  }
-
-  .content h1 {
-    margin-top: 1.75rem;
-  }
-
-  .content p {
-    margin-top: 1.5rem;
-  }
-
-  .divider {
-    width: 1px;
-    background: var(--red-to-pink-to-purple-vertical-gradient);
-    margin-inline: 0.5rem;
-  }
-
-  .pill-group {
-    display: flex;
-    flex-direction: column;
-    align-items: start;
-    flex-wrap: wrap;
-    gap: 1.25rem;
-  }
-
-  .pill {
-    display: flex;
-    align-items: center;
-    --pill-accent: var(--bright-blue);
-    background: color-mix(in srgb, var(--pill-accent) 5%, transparent);
-    color: var(--pill-accent);
-    padding-inline: 0.75rem;
-    padding-block: 0.375rem;
-    border-radius: 2.75rem;
-    border: 0;
-    transition: background 0.3s ease;
-    font-family: var(--inter-font);
-    font-size: 0.875rem;
-    font-style: normal;
-    font-weight: 500;
-    line-height: 1.4rem;
-    letter-spacing: -0.00875rem;
-    text-decoration: none;
-  }
-
-  .pill:hover {
-    background: color-mix(in srgb, var(--pill-accent) 15%, transparent);
-  }
-
-  .pill-group .pill:nth-child(6n + 1) {
-    --pill-accent: var(--bright-blue);
-  }
-  .pill-group .pill:nth-child(6n + 2) {
-    --pill-accent: var(--french-violet);
-  }
-  .pill-group .pill:nth-child(6n + 3),
-  .pill-group .pill:nth-child(6n + 4),
-  .pill-group .pill:nth-child(6n + 5) {
-    --pill-accent: var(--hot-red);
-  }
-
-  .pill-group svg {
-    margin-inline-start: 0.25rem;
-  }
-
-  .social-links {
-    display: flex;
-    align-items: center;
-    gap: 0.73rem;
-    margin-top: 1.5rem;
-  }
-
-  .social-links path {
-    transition: fill 0.3s ease;
-    fill: var(--gray-400);
-  }
-
-  .social-links a:hover svg path {
-    fill: var(--gray-900);
-  }
-
-  @media screen and (max-width: 650px) {
-    .content {
-      flex-direction: column;
-      width: max-content;
-    }
-
-    .divider {
-      height: 1px;
-      width: 100%;
-      background: var(--red-to-pink-to-purple-horizontal-gradient);
-      margin-block: 1.5rem;
-    }
-  }
-</style>
-
-<main class="main">
-  <div class="content">
-    <div class="left-side">
-      <svg
-        xmlns="http://www.w3.org/2000/svg"
-        viewBox="0 0 982 239"
-        fill="none"
-        class="angular-logo"
-      >
-        <g clip-path="url(#a)">
-          <path
-            fill="url(#b)"
-            d="M388.676 191.625h30.849L363.31 31.828h-35.758l-56.215 159.797h30.848l13.174-39.356h60.061l13.256 39.356Zm-65.461-62.675 21.602-64.311h1.227l21.602 64.311h-44.431Zm126.831-7.527v70.202h-28.23V71.839h27.002v20.374h1.392c2.782-6.71 7.2-12.028 13.255-15.956 6.056-3.927 13.584-5.89 22.503-5.89 8.264 0 15.465 1.8 21.684 5.318 6.137 3.518 10.964 8.673 14.319 15.382 3.437 6.71 5.074 14.81 4.992 24.383v76.175h-28.23v-71.92c0-8.019-2.046-14.237-6.219-18.819-4.173-4.5-9.819-6.791-17.102-6.791-4.91 0-9.328 1.063-13.174 3.272-3.846 2.128-6.792 5.237-9.001 9.328-2.046 4.009-3.191 8.918-3.191 14.728ZM589.233 239c-10.147 0-18.82-1.391-26.103-4.091-7.282-2.7-13.092-6.382-17.511-10.964-4.418-4.582-7.528-9.655-9.164-15.219l25.448-6.136c1.145 2.372 2.782 4.663 4.991 6.954 2.209 2.291 5.155 4.255 8.837 5.81 3.683 1.554 8.428 2.291 14.074 2.291 8.019 0 14.647-1.964 19.884-5.81 5.237-3.845 7.856-10.227 7.856-19.064v-22.665h-1.391c-1.473 2.946-3.601 5.892-6.383 9.001-2.782 3.109-6.464 5.645-10.965 7.691-4.582 2.046-10.228 3.109-17.101 3.109-9.165 0-17.511-2.209-25.039-6.545-7.446-4.337-13.42-10.883-17.757-19.474-4.418-8.673-6.628-19.473-6.628-32.565 0-13.091 2.21-24.301 6.628-33.383 4.419-9.082 10.311-15.955 17.839-20.7 7.528-4.746 15.874-7.037 25.039-7.037 7.037 0 12.846 1.145 17.347 3.518 4.582 2.373 8.182 5.236 10.883 8.51 2.7 3.272 4.746 6.382 6.137 9.327h1.554v-19.8h27.821v121.749c0 10.228-2.454 18.737-7.364 25.447-4.91 6.709-11.538 11.7-20.048 15.055-8.509 3.355-18.165 4.991-28.884 4.991Zm.245-71.266c5.974 0 11.047-1.473 15.302-4.337 4.173-2.945 7.446-7.118 9.573-12.519 2.21-5.482 3.274-12.027 3.274-19.637 0-7.609-1.064-14.155-3.274-19.8-2.127-5.646-5.318-10.064-9.491-13.255-4.174-3.11-9.329-4.746-15.384-4.746s-11.537 1.636-15.792 4.91c-4.173 3.272-7.365 7.772-9.492 13.418-2.128 5.727-3.191 12.191-3.191 19.392 0 7.2 1.063 13.745 3.273 19.228 2.127 5.482 5.318 9.736 9.573 12.764 4.174 3.027 9.41 4.582 15.629 4.582Zm141.56-26.51V71.839h28.23v119.786h-27.412v-21.273h-1.227c-2.7 6.709-7.119 12.191-13.338 16.446-6.137 4.255-13.747 6.382-22.748 6.382-7.855 0-14.81-1.718-20.783-5.237-5.974-3.518-10.72-8.591-14.075-15.382-3.355-6.709-5.073-14.891-5.073-24.464V71.839h28.312v71.921c0 7.609 2.046 13.664 6.219 18.083 4.173 4.5 9.655 6.709 16.365 6.709 4.173 0 8.183-.982 12.111-3.028 3.927-2.045 7.118-5.072 9.655-9.082 2.537-4.091 3.764-9.164 3.764-15.218Zm65.707-109.395v159.796h-28.23V31.828h28.23Zm44.841 162.169c-7.61 0-14.402-1.391-20.457-4.091-6.055-2.7-10.883-6.791-14.32-12.109-3.518-5.319-5.237-11.946-5.237-19.801 0-6.791 1.228-12.355 3.765-16.773 2.536-4.419 5.891-7.937 10.228-10.637 4.337-2.618 9.164-4.664 14.647-6.055 5.4-1.391 11.046-2.373 16.856-3.027 7.037-.737 12.683-1.391 17.102-1.964 4.337-.573 7.528-1.555 9.574-2.782 1.963-1.309 3.027-3.273 3.027-5.973v-.491c0-5.891-1.718-10.391-5.237-13.664-3.518-3.191-8.51-4.828-15.056-4.828-6.955 0-12.356 1.473-16.447 4.5-4.009 3.028-6.71 6.546-8.183 10.719l-26.348-3.764c2.046-7.282 5.483-13.336 10.31-18.328 4.746-4.909 10.638-8.59 17.511-11.045 6.955-2.455 14.565-3.682 22.912-3.682 5.809 0 11.537.654 17.265 2.045s10.965 3.6 15.711 6.71c4.746 3.109 8.51 7.282 11.455 12.6 2.864 5.318 4.337 11.946 4.337 19.883v80.184h-27.166v-16.446h-.9c-1.719 3.355-4.092 6.464-7.201 9.328-3.109 2.864-6.955 5.237-11.619 6.955-4.828 1.718-10.229 2.536-16.529 2.536Zm7.364-20.701c5.646 0 10.556-1.145 14.729-3.354 4.173-2.291 7.364-5.237 9.655-9.001 2.292-3.763 3.355-7.854 3.355-12.273v-14.155c-.9.737-2.373 1.391-4.5 2.046-2.128.654-4.419 1.145-7.037 1.636-2.619.491-5.155.9-7.692 1.227-2.537.328-4.746.655-6.628.901-4.173.572-8.019 1.472-11.292 2.781-3.355 1.31-5.973 3.11-7.855 5.401-1.964 2.291-2.864 5.318-2.864 8.918 0 5.237 1.882 9.164 5.728 11.782 3.682 2.782 8.51 4.091 14.401 4.091Zm64.643 18.328V71.839h27.412v19.965h1.227c2.21-6.955 5.974-12.274 11.292-16.038 5.319-3.763 11.456-5.645 18.329-5.645 1.555 0 3.355.082 5.237.163 1.964.164 3.601.328 4.91.573v25.938c-1.227-.41-3.109-.819-5.646-1.146a58.814 58.814 0 0 0-7.446-.49c-5.155 0-9.738 1.145-13.829 3.354-4.091 2.209-7.282 5.236-9.655 9.164-2.373 3.927-3.519 8.427-3.519 13.5v70.448h-28.312ZM222.077 39.192l-8.019 125.923L137.387 0l84.69 39.192Zm-53.105 162.825-57.933 33.056-57.934-33.056 11.783-28.556h92.301l11.783 28.556ZM111.039 62.675l30.357 73.803H80.681l30.358-73.803ZM7.937 165.115 0 39.192 84.69 0 7.937 165.115Z"
-          />
-          <path
-            fill="url(#c)"
-            d="M388.676 191.625h30.849L363.31 31.828h-35.758l-56.215 159.797h30.848l13.174-39.356h60.061l13.256 39.356Zm-65.461-62.675 21.602-64.311h1.227l21.602 64.311h-44.431Zm126.831-7.527v70.202h-28.23V71.839h27.002v20.374h1.392c2.782-6.71 7.2-12.028 13.255-15.956 6.056-3.927 13.584-5.89 22.503-5.89 8.264 0 15.465 1.8 21.684 5.318 6.137 3.518 10.964 8.673 14.319 15.382 3.437 6.71 5.074 14.81 4.992 24.383v76.175h-28.23v-71.92c0-8.019-2.046-14.237-6.219-18.819-4.173-4.5-9.819-6.791-17.102-6.791-4.91 0-9.328 1.063-13.174 3.272-3.846 2.128-6.792 5.237-9.001 9.328-2.046 4.009-3.191 8.918-3.191 14.728ZM589.233 239c-10.147 0-18.82-1.391-26.103-4.091-7.282-2.7-13.092-6.382-17.511-10.964-4.418-4.582-7.528-9.655-9.164-15.219l25.448-6.136c1.145 2.372 2.782 4.663 4.991 6.954 2.209 2.291 5.155 4.255 8.837 5.81 3.683 1.554 8.428 2.291 14.074 2.291 8.019 0 14.647-1.964 19.884-5.81 5.237-3.845 7.856-10.227 7.856-19.064v-22.665h-1.391c-1.473 2.946-3.601 5.892-6.383 9.001-2.782 3.109-6.464 5.645-10.965 7.691-4.582 2.046-10.228 3.109-17.101 3.109-9.165 0-17.511-2.209-25.039-6.545-7.446-4.337-13.42-10.883-17.757-19.474-4.418-8.673-6.628-19.473-6.628-32.565 0-13.091 2.21-24.301 6.628-33.383 4.419-9.082 10.311-15.955 17.839-20.7 7.528-4.746 15.874-7.037 25.039-7.037 7.037 0 12.846 1.145 17.347 3.518 4.582 2.373 8.182 5.236 10.883 8.51 2.7 3.272 4.746 6.382 6.137 9.327h1.554v-19.8h27.821v121.749c0 10.228-2.454 18.737-7.364 25.447-4.91 6.709-11.538 11.7-20.048 15.055-8.509 3.355-18.165 4.991-28.884 4.991Zm.245-71.266c5.974 0 11.047-1.473 15.302-4.337 4.173-2.945 7.446-7.118 9.573-12.519 2.21-5.482 3.274-12.027 3.274-19.637 0-7.609-1.064-14.155-3.274-19.8-2.127-5.646-5.318-10.064-9.491-13.255-4.174-3.11-9.329-4.746-15.384-4.746s-11.537 1.636-15.792 4.91c-4.173 3.272-7.365 7.772-9.492 13.418-2.128 5.727-3.191 12.191-3.191 19.392 0 7.2 1.063 13.745 3.273 19.228 2.127 5.482 5.318 9.736 9.573 12.764 4.174 3.027 9.41 4.582 15.629 4.582Zm141.56-26.51V71.839h28.23v119.786h-27.412v-21.273h-1.227c-2.7 6.709-7.119 12.191-13.338 16.446-6.137 4.255-13.747 6.382-22.748 6.382-7.855 0-14.81-1.718-20.783-5.237-5.974-3.518-10.72-8.591-14.075-15.382-3.355-6.709-5.073-14.891-5.073-24.464V71.839h28.312v71.921c0 7.609 2.046 13.664 6.219 18.083 4.173 4.5 9.655 6.709 16.365 6.709 4.173 0 8.183-.982 12.111-3.028 3.927-2.045 7.118-5.072 9.655-9.082 2.537-4.091 3.764-9.164 3.764-15.218Zm65.707-109.395v159.796h-28.23V31.828h28.23Zm44.841 162.169c-7.61 0-14.402-1.391-20.457-4.091-6.055-2.7-10.883-6.791-14.32-12.109-3.518-5.319-5.237-11.946-5.237-19.801 0-6.791 1.228-12.355 3.765-16.773 2.536-4.419 5.891-7.937 10.228-10.637 4.337-2.618 9.164-4.664 14.647-6.055 5.4-1.391 11.046-2.373 16.856-3.027 7.037-.737 12.683-1.391 17.102-1.964 4.337-.573 7.528-1.555 9.574-2.782 1.963-1.309 3.027-3.273 3.027-5.973v-.491c0-5.891-1.718-10.391-5.237-13.664-3.518-3.191-8.51-4.828-15.056-4.828-6.955 0-12.356 1.473-16.447 4.5-4.009 3.028-6.71 6.546-8.183 10.719l-26.348-3.764c2.046-7.282 5.483-13.336 10.31-18.328 4.746-4.909 10.638-8.59 17.511-11.045 6.955-2.455 14.565-3.682 22.912-3.682 5.809 0 11.537.654 17.265 2.045s10.965 3.6 15.711 6.71c4.746 3.109 8.51 7.282 11.455 12.6 2.864 5.318 4.337 11.946 4.337 19.883v80.184h-27.166v-16.446h-.9c-1.719 3.355-4.092 6.464-7.201 9.328-3.109 2.864-6.955 5.237-11.619 6.955-4.828 1.718-10.229 2.536-16.529 2.536Zm7.364-20.701c5.646 0 10.556-1.145 14.729-3.354 4.173-2.291 7.364-5.237 9.655-9.001 2.292-3.763 3.355-7.854 3.355-12.273v-14.155c-.9.737-2.373 1.391-4.5 2.046-2.128.654-4.419 1.145-7.037 1.636-2.619.491-5.155.9-7.692 1.227-2.537.328-4.746.655-6.628.901-4.173.572-8.019 1.472-11.292 2.781-3.355 1.31-5.973 3.11-7.855 5.401-1.964 2.291-2.864 5.318-2.864 8.918 0 5.237 1.882 9.164 5.728 11.782 3.682 2.782 8.51 4.091 14.401 4.091Zm64.643 18.328V71.839h27.412v19.965h1.227c2.21-6.955 5.974-12.274 11.292-16.038 5.319-3.763 11.456-5.645 18.329-5.645 1.555 0 3.355.082 5.237.163 1.964.164 3.601.328 4.91.573v25.938c-1.227-.41-3.109-.819-5.646-1.146a58.814 58.814 0 0 0-7.446-.49c-5.155 0-9.738 1.145-13.829 3.354-4.091 2.209-7.282 5.236-9.655 9.164-2.373 3.927-3.519 8.427-3.519 13.5v70.448h-28.312ZM222.077 39.192l-8.019 125.923L137.387 0l84.69 39.192Zm-53.105 162.825-57.933 33.056-57.934-33.056 11.783-28.556h92.301l11.783 28.556ZM111.039 62.675l30.357 73.803H80.681l30.358-73.803ZM7.937 165.115 0 39.192 84.69 0 7.937 165.115Z"
-          />
-        </g>
-        <defs>
-          <radialGradient
-            id="c"
-            cx="0"
-            cy="0"
-            r="1"
-            gradientTransform="rotate(118.122 171.182 60.81) scale(205.794)"
-            gradientUnits="userSpaceOnUse"
-          >
-            <stop stop-color="#FF41F8" />
-            <stop offset=".707" stop-color="#FF41F8" stop-opacity=".5" />
-            <stop offset="1" stop-color="#FF41F8" stop-opacity="0" />
-          </radialGradient>
-          <linearGradient
-            id="b"
-            x1="0"
-            x2="982"
-            y1="192"
-            y2="192"
-            gradientUnits="userSpaceOnUse"
-          >
-            <stop stop-color="#F0060B" />
-            <stop offset="0" stop-color="#F0070C" />
-            <stop offset=".526" stop-color="#CC26D5" />
-            <stop offset="1" stop-color="#7702FF" />
-          </linearGradient>
-          <clipPath id="a"><path fill="#fff" d="M0 0h982v239H0z" /></clipPath>
-        </defs>
-      </svg>
-      <h1>Hello, {{ title }}</h1>
-      <p>Congratulations! Your app is running. 🎉</p>
-    </div>
-    <div class="divider" role="separator" aria-label="Divider"></div>
-    <div class="right-side">
-      <div class="pill-group">
-        @for (item of [
-          { title: 'Explore the Docs', link: 'https://angular.dev' },
-          { title: 'Learn with Tutorials', link: 'https://angular.dev/tutorials' },
-          { title: 'CLI Docs', link: 'https://angular.dev/tools/cli' },
-          { title: 'Angular Language Service', link: 'https://angular.dev/tools/language-service' },
-          { title: 'Angular DevTools', link: 'https://angular.dev/tools/devtools' },
-        ]; track item.title) {
-          <a
-            class="pill"
-            [href]="item.link"
-            target="_blank"
-            rel="noopener"
-          >
-            <span>{{ item.title }}</span>
-            <svg
-              xmlns="http://www.w3.org/2000/svg"
-              height="14"
-              viewBox="0 -960 960 960"
-              width="14"
-              fill="currentColor"
-            >
-              <path
-                d="M200-120q-33 0-56.5-23.5T120-200v-560q0-33 23.5-56.5T200-840h280v80H200v560h560v-280h80v280q0 33-23.5 56.5T760-120H200Zm188-212-56-56 372-372H560v-80h280v280h-80v-144L388-332Z"
-              />
-            </svg>
-          </a>
-        }
-      </div>
-      <div class="social-links">
-        <a
-          href="https://github.com/angular/angular"
-          aria-label="Github"
-          target="_blank"
-          rel="noopener"
-        >
-          <svg
-            width="25"
-            height="24"
-            viewBox="0 0 25 24"
-            fill="none"
-            xmlns="http://www.w3.org/2000/svg"
-            alt="Github"
-          >
-            <path
-              d="M12.3047 0C5.50634 0 0 5.50942 0 12.3047C0 17.7423 3.52529 22.3535 8.41332 23.9787C9.02856 24.0946 9.25414 23.7142 9.25414 23.3871C9.25414 23.0949 9.24389 22.3207 9.23876 21.2953C5.81601 22.0377 5.09414 19.6444 5.09414 19.6444C4.53427 18.2243 3.72524 17.8449 3.72524 17.8449C2.61064 17.082 3.81137 17.0973 3.81137 17.0973C5.04697 17.1835 5.69604 18.3647 5.69604 18.3647C6.79321 20.2463 8.57636 19.7029 9.27978 19.3881C9.39052 18.5924 9.70736 18.0499 10.0591 17.7423C7.32641 17.4347 4.45429 16.3765 4.45429 11.6618C4.45429 10.3185 4.9311 9.22133 5.72065 8.36C5.58222 8.04931 5.16694 6.79833 5.82831 5.10337C5.82831 5.10337 6.85883 4.77319 9.2121 6.36459C10.1965 6.09082 11.2424 5.95546 12.2883 5.94931C13.3342 5.95546 14.3801 6.09082 15.3644 6.36459C17.7023 4.77319 18.7328 5.10337 18.7328 5.10337C19.3942 6.79833 18.9789 8.04931 18.8559 8.36C19.6403 9.22133 20.1171 10.3185 20.1171 11.6618C20.1171 16.3888 17.2409 17.4296 14.5031 17.7321C14.9338 18.1012 15.3337 18.8559 15.3337 20.0084C15.3337 21.6552 15.3183 22.978 15.3183 23.3779C15.3183 23.7009 15.5336 24.0854 16.1642 23.9623C21.0871 22.3484 24.6094 17.7341 24.6094 12.3047C24.6094 5.50942 19.0999 0 12.3047 0Z"
-            />
-          </svg>
-        </a>
-        <a
-          href="https://twitter.com/angular"
-          aria-label="Twitter"
-          target="_blank"
-          rel="noopener"
-        >
-          <svg
-            width="24"
-            height="24"
-            viewBox="0 0 24 24"
-            fill="none"
-            xmlns="http://www.w3.org/2000/svg"
-            alt="Twitter"
-          >
-            <path
-              d="M18.244 2.25h3.308l-7.227 8.26 8.502 11.24H16.17l-5.214-6.817L4.99 21.75H1.68l7.73-8.835L1.254 2.25H8.08l4.713 6.231zm-1.161 17.52h1.833L7.084 4.126H5.117z"
-            />
-          </svg>
-        </a>
-        <a
-          href="https://www.youtube.com/channel/UCbn1OgGei-DV7aSRo_HaAiw"
-          aria-label="Youtube"
-          target="_blank"
-          rel="noopener"
-        >
-          <svg
-            width="29"
-            height="20"
-            viewBox="0 0 29 20"
-            fill="none"
-            xmlns="http://www.w3.org/2000/svg"
-            alt="Youtube"
-          >
-            <path
-              fill-rule="evenodd"
-              clip-rule="evenodd"
-              d="M27.4896 1.52422C27.9301 1.96749 28.2463 2.51866 28.4068 3.12258C29.0004 5.35161 29.0004 10 29.0004 10C29.0004 10 29.0004 14.6484 28.4068 16.8774C28.2463 17.4813 27.9301 18.0325 27.4896 18.4758C27.0492 18.9191 26.5 19.2389 25.8972 19.4032C23.6778 20 14.8068 20 14.8068 20C14.8068 20 5.93586 20 3.71651 19.4032C3.11363 19.2389 2.56449 18.9191 2.12405 18.4758C1.68361 18.0325 1.36732 17.4813 1.20683 16.8774C0.613281 14.6484 0.613281 10 0.613281 10C0.613281 10 0.613281 5.35161 1.20683 3.12258C1.36732 2.51866 1.68361 1.96749 2.12405 1.52422C2.56449 1.08095 3.11363 0.76113 3.71651 0.596774C5.93586 0 14.8068 0 14.8068 0C14.8068 0 23.6778 0 25.8972 0.596774C26.5 0.76113 27.0492 1.08095 27.4896 1.52422ZM19.3229 10L11.9036 5.77905V14.221L19.3229 10Z"
-            />
-          </svg>
-        </a>
-      </div>
-    </div>
-  </div>
-</main>
-
-<!-- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * -->
-<!-- * * * * * * * * * * * The content above * * * * * * * * * * * * -->
-<!-- * * * * * * * * * * is only a placeholder * * * * * * * * * * * -->
-<!-- * * * * * * * * * * and can be replaced.  * * * * * * * * * * * -->
-<!-- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * -->
-<!-- * * * * * * * * * * End of Placeholder  * * * * * * * * * * * * -->
-<!-- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * -->
-
-
-<router-outlet />

frontend/src/app/app.component.ts

@@ -1,13 +0,0 @@
-import { Component } from '@angular/core';
-import { RouterOutlet } from '@angular/router';
-
-@Component({
-  selector: 'app-root',
-  standalone: true,
-  imports: [RouterOutlet],
-  templateUrl: './app.component.html',
-  styleUrl: './app.component.scss'
-})
-export class AppComponent {
-  title = 'frontend';
-}

frontend/src/app/app.config.ts

@@ -1,12 +1,11 @@
-import { ApplicationConfig } from '@angular/core';
+import { ApplicationConfig, provideBrowserGlobalErrorListeners } from '@angular/core';
 import { provideRouter } from '@angular/router';
 
 import { routes } from './app.routes';
-import { provideAgentStatusInitializer } from './services/agent-status-initializer';
 
 export const appConfig: ApplicationConfig = {
   providers: [
-    provideRouter(routes),
-    ...provideAgentStatusInitializer(),
+    provideBrowserGlobalErrorListeners(),
+    provideRouter(routes)
   ]
 };

frontend/src/app/app.html

@@ -0,0 +1,10 @@
+<!-- Extrudex — Homepage (Main Hub) -->
+<main class="main-content">
+  <h1 class="sr-only">Extrudex Dashboard</h1>
+
+  <!-- Status Summary Bar — fleet-wide health at a glance -->
+  <app-dashboard-summary></app-dashboard-summary>
+
+  <!-- Filament Inventory — routed view -->
+  <router-outlet />
+</main>

frontend/src/app/app.routes.ts

@@ -1,3 +1,9 @@
 import { Routes } from '@angular/router';
+import { FilamentTableComponent } from './components/filament-table/filament-table.component';
 
-export const routes: Routes = [];
+export const routes: Routes = [
+  {
+    path: '',
+    component: FilamentTableComponent,
+  },
+];

frontend/src/app/app.scss

@@ -0,0 +1,27 @@
+:host {
+  display: block;
+  min-height: 100vh;
+  background: #1a1a2e;
+  color: #e0e0e0;
+  font-family: 'Inter', 'Segoe UI', Roboto, sans-serif;
+}
+
+.main-content {
+  padding: 16px;
+
+  @media (min-width: 800px) {
+    padding: 24px;
+  }
+}
+
+.sr-only {
+  position: absolute;
+  width: 1px;
+  height: 1px;
+  padding: 0;
+  margin: -1px;
+  overflow: hidden;
+  clip: rect(0, 0, 0, 0);
+  white-space: nowrap;
+  border: 0;
+}

frontend/src/app/app.spec.ts

@@ -0,0 +1,23 @@
+import { TestBed } from '@angular/core/testing';
+import { App } from './app';
+
+describe('App', () => {
+  beforeEach(async () => {
+    await TestBed.configureTestingModule({
+      imports: [App],
+    }).compileComponents();
+  });
+
+  it('should create the app', () => {
+    const fixture = TestBed.createComponent(App);
+    const app = fixture.componentInstance;
+    expect(app).toBeTruthy();
+  });
+
+  it('should render title', async () => {
+    const fixture = TestBed.createComponent(App);
+    await fixture.whenStable();
+    const compiled = fixture.nativeElement as HTMLElement;
+    expect(compiled.querySelector('h1')?.textContent).toContain('Extrudex Dashboard');
+  });
+});

frontend/src/app/app.ts

@@ -0,0 +1,28 @@
+import { Component, ViewChild } from '@angular/core';
+import { RouterOutlet } from '@angular/router';
+import { DashboardSummaryComponent } from './components/dashboard-summary/dashboard-summary.component';
+import { AgentSummary, SystemHealth } from './models/agent.model';
+
+@Component({
+  selector: 'app-root',
+  imports: [RouterOutlet, DashboardSummaryComponent],
+  templateUrl: './app.html',
+  styleUrl: './app.scss'
+})
+export class App {
+  @ViewChild(DashboardSummaryComponent) summaryComponent!: DashboardSummaryComponent;
+
+  /** Sample data for development — will be replaced by real service data */
+  readonly sampleSummary: AgentSummary = {
+    total: 7,
+    active: 4,
+    idle: 1,
+    thinking: 1,
+    error: 1,
+  };
+
+  readonly sampleHealth: SystemHealth = {
+    connected: true,
+    status: 'healthy',
+  };
+}

frontend/src/app/components/dashboard-summary/dashboard-summary.component.html

@@ -0,0 +1,63 @@
+<!-- Dashboard Summary Bar — Fleet-wide health at a glance -->
+<section class="dashboard-summary" role="status" aria-label="Dashboard summary">
+
+  <!-- System Health Indicator -->
+  <div class="summary-item health-indicator"
+       [class.healthy]="health().status === 'healthy'"
+       [class.degraded]="isDegraded()"
+       [class.down]="isDown()"
+       [matTooltip]="statusLabel()"
+       matTooltipPosition="below">
+    <span class="connection-dot" [class.connected]="health().connected"></span>
+    <span class="health-label">{{ statusLabel() }}</span>
+  </div>
+
+  <!-- Total Active Agents -->
+  <div class="summary-item" matTooltip="Total active agents" matTooltipPosition="below">
+    <mat-icon aria-hidden="true">smart_toy</mat-icon>
+    <span class="metric-value">{{ summary().active }} / {{ summary().total }}</span>
+    <span class="metric-label">Active</span>
+  </div>
+
+  <!-- Status Breakdown -->
+  <div class="summary-item status-breakdown">
+    <mat-chip-set aria-label="Agent status breakdown">
+      <mat-chip
+        class="status-chip chip-active"
+        [class.has-count]="summary().active > 0"
+        matTooltip="Active agents">
+        <mat-icon matChipStart>check_circle</mat-icon>
+        <span class="chip-count">{{ summary().active }}</span>
+        <span class="chip-label">Active</span>
+      </mat-chip>
+
+      <mat-chip
+        class="status-chip chip-idle"
+        [class.has-count]="summary().idle > 0"
+        matTooltip="Idle agents">
+        <mat-icon matChipStart>pause_circle</mat-icon>
+        <span class="chip-count">{{ summary().idle }}</span>
+        <span class="chip-label">Idle</span>
+      </mat-chip>
+
+      <mat-chip
+        class="status-chip chip-thinking"
+        [class.has-count]="summary().thinking > 0"
+        matTooltip="Thinking agents">
+        <mat-icon matChipStart>psychology</mat-icon>
+        <span class="chip-count">{{ summary().thinking }}</span>
+        <span class="chip-label">Thinking</span>
+      </mat-chip>
+
+      <mat-chip
+        class="status-chip chip-error"
+        [class.has-count]="hasErrors()"
+        matTooltip="Agents in error">
+        <mat-icon matChipStart>error</mat-icon>
+        <span class="chip-count">{{ summary().error }}</span>
+        <span class="chip-label">Error</span>
+      </mat-chip>
+    </mat-chip-set>
+  </div>
+
+</section>

frontend/src/app/components/dashboard-summary/dashboard-summary.component.scss

@@ -0,0 +1,174 @@
+/**
+ * Dashboard Summary Component Styles
+ * Touch-optimized for kiosk (Raspberry Pi 5) and mobile PWA
+ * Uses Angular Material utility classes where possible
+ */
+
+// Touch-optimized sizing
+$touch-target-min: 48px;
+$kiosk-font-primary: 20px;
+$mobile-font-primary: 16px;
+$spacing-unit: 8px;
+
+// Status colors — high contrast for workshop/bright environments
+$color-active: #4ade70;    // Green — printing/active
+$color-idle: #94a3b8;      // Gray — idle/offline
+$color-thinking: #60a5fa;  // Blue — thinking/processing
+$color-error: #f87171;     // Red — error/failed
+$color-connected: #4ade70; // Green — SignalR connected
+$color-disconnected: #f87171; // Red — disconnected
+
+.dashboard-summary {
+  display: flex;
+  align-items: center;
+  gap: $spacing-unit * 2;
+  padding: $spacing-unit * 2;
+  overflow-x: auto;
+  -webkit-overflow-scrolling: touch;
+
+  // Responsive: on mobile, allow horizontal scroll
+  @media (max-width: 480px) {
+    padding: $spacing-unit;
+    gap: $spacing-unit;
+  }
+}
+
+.summary-item {
+  display: flex;
+  align-items: center;
+  gap: $spacing-unit;
+  min-height: $touch-target-min;
+  white-space: nowrap;
+
+  .metric-value {
+    font-size: $kiosk-font-primary;
+    font-weight: 600;
+    line-height: 1.2;
+
+    @media (max-width: 480px) {
+      font-size: $mobile-font-primary;
+    }
+  }
+
+  .metric-label {
+    font-size: 12px;
+    color: rgba(255, 255, 255, 0.7);
+    text-transform: uppercase;
+    letter-spacing: 0.05em;
+
+    @media (max-width: 480px) {
+      font-size: 10px;
+    }
+  }
+}
+
+// Health indicator
+.health-indicator {
+  padding: $spacing-unit $spacing-unit * 2;
+  border-radius: 24px;
+  transition: background-color 0.3s ease;
+
+  &.healthy {
+    background-color: rgba($color-active, 0.15);
+  }
+
+  &.degraded {
+    background-color: rgba($color-thinking, 0.15);
+  }
+
+  &.down {
+    background-color: rgba($color-error, 0.15);
+  }
+
+  .connection-dot {
+    width: 12px;
+    height: 12px;
+    border-radius: 50%;
+    display: inline-block;
+    transition: background-color 0.3s ease;
+
+    &.connected {
+      background-color: $color-connected;
+      box-shadow: 0 0 6px $color-connected;
+    }
+
+    &:not(.connected) {
+      background-color: $color-disconnected;
+      box-shadow: 0 0 6px $color-disconnected;
+    }
+  }
+
+  .health-label {
+    font-size: 14px;
+    font-weight: 500;
+
+    @media (max-width: 480px) {
+      font-size: 12px;
+    }
+  }
+}
+
+// Status breakdown chips
+.status-breakdown {
+  flex-shrink: 0;
+}
+
+.status-chip {
+  min-height: $touch-target-min !important;
+  font-size: 14px !important;
+
+  @media (max-width: 480px) {
+    min-height: 40px !important;
+    font-size: 12px !important;
+    padding: 0 8px !important;
+  }
+
+  .chip-count {
+    font-weight: 700;
+    margin: 0 4px;
+  }
+
+  .chip-label {
+    font-size: 12px;
+    opacity: 0.8;
+  }
+
+  mat-icon {
+    font-size: 18px !important;
+    width: 18px !important;
+    height: 18px !important;
+  }
+}
+
+// Status chip color variants
+.chip-active {
+  --mdc-chip-outline-color: #{$color-active};
+
+  &.has-count {
+    background-color: rgba($color-active, 0.15) !important;
+  }
+}
+
+.chip-idle {
+  --mdc-chip-outline-color: #{$color-idle};
+
+  &.has-count {
+    background-color: rgba($color-idle, 0.15) !important;
+  }
+}
+
+.chip-thinking {
+  --mdc-chip-outline-color: #{$color-thinking};
+
+  &.has-count {
+    background-color: rgba($color-thinking, 0.15) !important;
+  }
+}
+
+.chip-error {
+  --mdc-chip-outline-color: #{$color-error};
+
+  &.has-count {
+    background-color: rgba($color-error, 0.2) !important;
+  }
+}

frontend/src/app/components/dashboard-summary/dashboard-summary.component.spec.ts

@@ -0,0 +1,103 @@
+import { ComponentFixture, TestBed } from '@angular/core/testing';
+import { DashboardSummaryComponent } from './dashboard-summary.component';
+import { AgentSummary, SystemHealth } from '../../models/agent.model';
+
+describe('DashboardSummaryComponent', () => {
+  let component: DashboardSummaryComponent;
+  let fixture: ComponentFixture<DashboardSummaryComponent>;
+
+  const mockSummary: AgentSummary = {
+    total: 7,
+    active: 4,
+    idle: 1,
+    thinking: 1,
+    error: 1,
+  };
+
+  const mockHealthy: SystemHealth = {
+    connected: true,
+    status: 'healthy',
+  };
+
+  beforeEach(async () => {
+    await TestBed.configureTestingModule({
+      imports: [DashboardSummaryComponent],
+    }).compileComponents();
+
+    fixture = TestBed.createComponent(DashboardSummaryComponent);
+    component = fixture.componentInstance;
+  });
+
+  it('should create', () => {
+    expect(component).toBeTruthy();
+  });
+
+  it('should default to zeroed summary', () => {
+    const summary = component.summary();
+    expect(summary.total).toBe(0);
+    expect(summary.active).toBe(0);
+    expect(summary.idle).toBe(0);
+    expect(summary.thinking).toBe(0);
+    expect(summary.error).toBe(0);
+  });
+
+  it('should default to disconnected/down health', () => {
+    const health = component.health();
+    expect(health.connected).toBe(false);
+    expect(health.status).toBe('down');
+  });
+
+  it('should update summary data', () => {
+    component.updateSummary(mockSummary);
+    expect(component.summary()).toEqual(mockSummary);
+  });
+
+  it('should update health data', () => {
+    component.updateHealth(mockHealthy);
+    expect(component.health()).toEqual(mockHealthy);
+  });
+
+  it('should compute hasErrors correctly', () => {
+    expect(component.hasErrors()).toBe(false);
+    component.updateSummary({ ...mockSummary, error: 2 });
+    expect(component.hasErrors()).toBe(true);
+  });
+
+  it('should compute connectionColor correctly', () => {
+    expect(component.connectionColor()).toBe('disconnected');
+    component.updateHealth({ connected: true, status: 'healthy' });
+    expect(component.connectionColor()).toBe('connected');
+  });
+
+  it('should compute statusLabel for each state', () => {
+    component.updateHealth({ connected: true, status: 'healthy' });
+    expect(component.statusLabel()).toBe('All Systems Go');
+
+    component.updateHealth({ connected: true, status: 'degraded' });
+    expect(component.statusLabel()).toBe('Degraded');
+
+    component.updateHealth({ connected: false, status: 'down' });
+    expect(component.statusLabel()).toBe('Offline');
+  });
+
+  it('should render summary values in template', () => {
+    component.updateSummary(mockSummary);
+    component.updateHealth(mockHealthy);
+    fixture.detectChanges();
+
+    const compiled = fixture.nativeElement as HTMLElement;
+    expect(compiled.textContent).toContain('4 / 7');
+    expect(compiled.textContent).toContain('Active');
+    expect(compiled.textContent).toContain('All Systems Go');
+  });
+
+  it('should render status breakdown chips', () => {
+    component.updateSummary(mockSummary);
+    fixture.detectChanges();
+
+    const compiled = fixture.nativeElement as HTMLElement;
+    expect(compiled.textContent).toContain('4');  // active count
+    expect(compiled.textContent).toContain('1');   // idle count (multiple)
+    expect(compiled.textContent).toContain('Error');
+  });
+});

frontend/src/app/components/dashboard-summary/dashboard-summary.component.ts

@@ -0,0 +1,80 @@
+import { ChangeDetectionStrategy, Component, Input, OnDestroy, signal, computed } from '@angular/core';
+import { CommonModule } from '@angular/common';
+import { MatButtonModule } from '@angular/material/button';
+import { MatIconModule } from '@angular/material/icon';
+import { MatChipsModule } from '@angular/material/chips';
+import { MatTooltipModule } from '@angular/material/tooltip';
+import { AgentSummary, SystemHealth } from '../../models/agent.model';
+
+@Component({
+  selector: 'app-dashboard-summary',
+  standalone: true,
+  imports: [
+    CommonModule,
+    MatButtonModule,
+    MatIconModule,
+    MatChipsModule,
+    MatTooltipModule,
+  ],
+  templateUrl: './dashboard-summary.component.html',
+  styleUrls: ['./dashboard-summary.component.scss'],
+  changeDetection: ChangeDetectionStrategy.OnPush,
+})
+export class DashboardSummaryComponent implements OnDestroy {
+  /** Agent summary data — reactive signal, updatable via updateSummary() */
+  readonly summary = signal<AgentSummary>({
+    total: 0,
+    active: 0,
+    idle: 0,
+    thinking: 0,
+    error: 0,
+  });
+
+  /** System health data — reactive signal, updatable via updateHealth() */
+  readonly health = signal<SystemHealth>({
+    connected: false,
+    status: 'down',
+  });
+
+  /** Computed signal: whether there are errors to highlight */
+  readonly hasErrors = computed(() => this.summary().error > 0);
+
+  /** Computed signal: whether system is degraded */
+  readonly isDegraded = computed(() => this.health().status === 'degraded');
+
+  /** Computed signal: whether system is down */
+  readonly isDown = computed(() => this.health().status === 'down');
+
+  /** Computed signal: connection indicator color */
+  readonly connectionColor = computed(() =>
+    this.health().connected ? 'connected' : 'disconnected'
+  );
+
+  /** Computed signal: overall status label */
+  readonly statusLabel = computed(() => {
+    const h = this.health();
+    if (h.status === 'healthy') return 'All Systems Go';
+    if (h.status === 'degraded') return 'Degraded';
+    return 'Offline';
+  });
+
+  /**
+   * Update the agent summary. Called by the parent or a service
+   * when new data arrives (e.g., via SignalR).
+   */
+  updateSummary(data: AgentSummary): void {
+    this.summary.set(data);
+  }
+
+  /**
+   * Update the system health. Called by the parent or a service
+   * when the connection state changes.
+   */
+  updateHealth(data: SystemHealth): void {
+    this.health.set(data);
+  }
+
+  ngOnDestroy(): void {
+    // Cleanup handled by signals — no manual subscription teardown needed
+  }
+}

frontend/src/app/components/filament-table/filament-table.component.html

@@ -0,0 +1,123 @@
+<!-- Filament Inventory Table — with low stock indicators -->
+<div class="filament-table-container" role="region" aria-label="Filament inventory">
+
+  <!-- Low Stock Alert Banner — shown when critical or low stock spools exist -->
+  @if (criticalCount() > 0) {
+    <div class="alert-banner critical" role="alert">
+      <mat-icon aria-hidden="true">error</mat-icon>
+      <span>{{ criticalCount() }} spool{{ criticalCount() > 1 ? 's' : '' }} critically low (&le;10% remaining)</span>
+    </div>
+  } @else if (lowStockCount() > 0) {
+    <div class="alert-banner low" role="alert">
+      <mat-icon aria-hidden="true">warning</mat-icon>
+      <span>{{ lowStockCount() }} spool{{ lowStockCount() > 1 ? 's' : '' }} running low (&le;25% remaining)</span>
+    </div>
+  }
+
+  <!-- Filament Table -->
+  <table mat-table
+         [dataSource]="sortedFilaments()"
+         matSort
+         (matSortChange)="sortData($event)"
+         class="filament-table"
+         aria-label="Filament inventory table">
+
+    <!-- Color Column -->
+    <ng-container matColumnDef="color">
+      <th mat-header-cell *matHeaderCellDef mat-sort-header="color">Color</th>
+      <td mat-cell *matCellDef="let filament">
+        <span class="color-swatch"
+              [style.background-color]="filament.colorHex"
+              [matTooltip]="filament.colorName"
+              matTooltipPosition="after"
+              [attr.aria-label]="filament.colorName">
+        </span>
+      </td>
+    </ng-container>
+
+    <!-- Material Column -->
+    <ng-container matColumnDef="material">
+      <th mat-header-cell *matHeaderCellDef mat-sort-header="material">Material</th>
+      <td mat-cell *matCellDef="let filament">
+        <span class="material-name">{{ filament.materialBaseName }}</span>
+        @if (filament.materialModifierName) {
+          <span class="material-modifier"> {{ filament.materialModifierName }}</span>
+        }
+      </td>
+    </ng-container>
+
+    <!-- Brand Column -->
+    <ng-container matColumnDef="brand">
+      <th mat-header-cell *matHeaderCellDef mat-sort-header="brand">Brand</th>
+      <td mat-cell *matCellDef="let filament">{{ filament.brand }}</td>
+    </ng-container>
+
+    <!-- Serial Column -->
+    <ng-container matColumnDef="serial">
+      <th mat-header-cell *matHeaderCellDef mat-sort-header="serial">Serial</th>
+      <td mat-cell *matCellDef="let filament" class="serial-cell">{{ filament.spoolSerial }}</td>
+    </ng-container>
+
+    <!-- Remaining Weight Column -->
+    <ng-container matColumnDef="remaining">
+      <th mat-header-cell *matHeaderCellDef mat-sort-header="remaining">Remaining</th>
+      <td mat-cell *matCellDef="let filament">
+        <div class="remaining-cell">
+          <span class="remaining-text">
+            {{ formatWeight(filament.weightRemainingGrams) }} / {{ formatWeight(filament.weightTotalGrams) }}
+          </span>
+          <mat-progress-bar
+            mode="determinate"
+            [value]="getRemainingPercent(filament)"
+            [ngClass]="classifyStockLevel(filament)"
+            [matTooltip]="getRemainingPercent(filament).toFixed(0) + '% remaining'"
+            matTooltipPosition="below">
+          </mat-progress-bar>
+        </div>
+      </td>
+    </ng-container>
+
+    <!-- Stock Level Indicator Column -->
+    <ng-container matColumnDef="stockLevel">
+      <th mat-header-cell *matHeaderCellDef mat-sort-header="stockLevel">Stock</th>
+      <td mat-cell *matCellDef="let filament">
+        @let level = classifyStockLevel(filament);
+        <mat-chip-set aria-label="Stock level">
+          <mat-chip
+            [ngClass]="level"
+            [matTooltip]="stockLevelLabel(level) + ' — ' + getRemainingPercent(filament).toFixed(0) + '% remaining'"
+            matTooltipPosition="below">
+            <mat-icon matChipStart [ngClass]="level">{{ stockLevelIcon(level) }}</mat-icon>
+            <span>{{ stockLevelLabel(level) }}</span>
+          </mat-chip>
+        </mat-chip-set>
+      </td>
+    </ng-container>
+
+    <!-- Status Column -->
+    <ng-container matColumnDef="status">
+      <th mat-header-cell *matHeaderCellDef mat-sort-header="status">Status</th>
+      <td mat-cell *matCellDef="let filament">
+        <span class="status-badge"
+              [class.active]="filament.isActive"
+              [class.inactive]="!filament.isActive">
+          {{ filament.isActive ? 'Active' : 'Inactive' }}
+        </span>
+      </td>
+    </ng-container>
+
+    <tr mat-header-row *matHeaderRowDef="columns()"></tr>
+    <tr mat-row *matRowDef="let row; columns: columns();"
+        [class.row-critical]="classifyStockLevel(row) === 'critical'"
+        [class.row-low]="classifyStockLevel(row) === 'low'">
+    </tr>
+  </table>
+
+  <!-- Empty state -->
+  @if (filaments().length === 0) {
+    <div class="empty-state" role="status">
+      <mat-icon aria-hidden="true">inventory_2</mat-icon>
+      <p>No filament spools found</p>
+    </div>
+  }
+</div>

frontend/src/app/components/filament-table/filament-table.component.scss

@@ -0,0 +1,259 @@
+/**
+ * Filament Table Component Styles
+ * Touch-optimized for kiosk (Raspberry Pi 5) and mobile PWA
+ * Low stock indicators use high-contrast colors for workshop visibility
+ */
+
+// Touch-optimized sizing
+$touch-target-min: 48px;
+$spacing-unit: 8px;
+
+// Stock level colors — high contrast, accessible
+$color-critical: #ef4444;   // Red — critically low
+$color-low: #f59e0b;       // Amber — running low
+$color-moderate: #3b82f6;  // Blue — moderate
+$color-healthy: #22c55e;   // Green — healthy/OK
+$color-active: #22c55e;    // Green — active spool
+$color-inactive: #94a3b8;  // Gray — inactive spool
+
+.filament-table-container {
+  width: 100%;
+  overflow-x: auto;
+  -webkit-overflow-scrolling: touch;
+}
+
+// Alert banner for low stock warnings
+.alert-banner {
+  display: flex;
+  align-items: center;
+  gap: $spacing-unit;
+  padding: $spacing-unit * 1.5 $spacing-unit * 2;
+  border-radius: 8px;
+  margin-bottom: $spacing-unit * 2;
+  font-size: 14px;
+  font-weight: 500;
+
+  mat-icon {
+    font-size: 20px !important;
+    width: 20px !important;
+    height: 20px !important;
+  }
+
+  &.critical {
+    background-color: rgba($color-critical, 0.12);
+    color: $color-critical;
+    border: 1px solid rgba($color-critical, 0.3);
+  }
+
+  &.low {
+    background-color: rgba($color-low, 0.12);
+    color: $color-low;
+    border: 1px solid rgba($color-low, 0.3);
+  }
+}
+
+// Table styling
+.filament-table {
+  width: 100%;
+  min-width: 700px;
+
+  th {
+    font-weight: 600;
+    font-size: 13px;
+    text-transform: uppercase;
+    letter-spacing: 0.04em;
+    color: var(--mat-sys-on-surface-variant);
+  }
+
+  td {
+    font-size: 14px;
+    padding: 12px 16px !important;
+    min-height: $touch-target-min;
+
+    @media (max-width: 480px) {
+      padding: 8px 12px !important;
+      font-size: 13px;
+    }
+  }
+
+  // Row highlight for low stock
+  .mat-mdc-row {
+    transition: background-color 0.2s ease;
+  }
+
+  &.row-critical {
+    background-color: rgba($color-critical, 0.06) !important;
+
+    &:hover {
+      background-color: rgba($color-critical, 0.1) !important;
+    }
+  }
+
+  &.row-low {
+    background-color: rgba($color-low, 0.06) !important;
+
+    &:hover {
+      background-color: rgba($color-low, 0.1) !important;
+    }
+  }
+}
+
+// Color swatch
+.color-swatch {
+  display: inline-block;
+  width: 28px;
+  height: 28px;
+  border-radius: 50%;
+  border: 2px solid rgba(0, 0, 0, 0.12);
+  vertical-align: middle;
+  cursor: default;
+
+  @media (max-width: 480px) {
+    width: 24px;
+    height: 24px;
+  }
+}
+
+// Material name
+.material-name {
+  font-weight: 500;
+}
+
+.material-modifier {
+  font-size: 12px;
+  color: var(--mat-sys-on-surface-variant);
+  margin-left: 4px;
+}
+
+// Serial cell — monospace
+.serial-cell {
+  font-family: 'JetBrains Mono', 'Roboto Mono', monospace;
+  font-size: 13px;
+  letter-spacing: 0.02em;
+}
+
+// Remaining weight cell
+.remaining-cell {
+  display: flex;
+  flex-direction: column;
+  gap: 4px;
+  min-width: 120px;
+
+  .remaining-text {
+    font-size: 13px;
+    color: var(--mat-sys-on-surface-variant);
+  }
+}
+
+// Progress bar stock level variants
+mat-progress-bar {
+  &.critical {
+    --mat-progress-bar-active-indicator-color: #{$color-critical};
+  }
+
+  &.low {
+    --mat-progress-bar-active-indicator-color: #{$color-low};
+  }
+
+  &.moderate {
+    --mat-progress-bar-active-indicator-color: #{$color-moderate};
+  }
+
+  &.healthy {
+    --mat-progress-bar-active-indicator-color: #{$color-healthy};
+  }
+}
+
+// Stock level chip variants
+mat-chip {
+  min-height: 32px !important;
+  font-size: 12px !important;
+
+  &.critical {
+    background-color: rgba($color-critical, 0.15) !important;
+    color: $color-critical;
+
+    mat-icon {
+      color: $color-critical;
+    }
+  }
+
+  &.low {
+    background-color: rgba($color-low, 0.15) !important;
+    color: $color-low;
+
+    mat-icon {
+      color: $color-low;
+    }
+  }
+
+  &.moderate {
+    background-color: rgba($color-moderate, 0.1) !important;
+    color: $color-moderate;
+
+    mat-icon {
+      color: $color-moderate;
+    }
+  }
+
+  &.healthy {
+    background-color: rgba($color-healthy, 0.1) !important;
+    color: $color-healthy;
+
+    mat-icon {
+      color: $color-healthy;
+    }
+  }
+
+  mat-icon {
+    font-size: 16px !important;
+    width: 16px !important;
+    height: 16px !important;
+    margin-right: 4px;
+  }
+}
+
+// Status badge
+.status-badge {
+  display: inline-flex;
+  align-items: center;
+  padding: 4px 12px;
+  border-radius: 12px;
+  font-size: 12px;
+  font-weight: 600;
+  text-transform: uppercase;
+  letter-spacing: 0.04em;
+
+  &.active {
+    background-color: rgba($color-active, 0.12);
+    color: $color-active;
+  }
+
+  &.inactive {
+    background-color: rgba($color-inactive, 0.12);
+    color: $color-inactive;
+  }
+}
+
+// Empty state
+.empty-state {
+  display: flex;
+  flex-direction: column;
+  align-items: center;
+  justify-content: center;
+  padding: 48px $spacing-unit * 2;
+  color: var(--mat-sys-on-surface-variant);
+
+  mat-icon {
+    font-size: 48px !important;
+    width: 48px !important;
+    height: 48px !important;
+    opacity: 0.4;
+    margin-bottom: $spacing-unit * 2;
+  }
+
+  p {
+    font-size: 16px;
+    margin: 0;
+  }
+}

frontend/src/app/components/filament-table/filament-table.component.spec.ts

@@ -0,0 +1,88 @@
+import { describe, it, expect } from 'vitest';
+import {
+  Filament,
+  StockLevel,
+  getRemainingPercent,
+  classifyStockLevel,
+} from '../../models/filament.model';
+
+/** Create a test filament with defaults — override specific fields */
+function createFilament(overrides: Partial<Filament> = {}): Filament {
+  return {
+    id: '00000000-0000-0000-0000-000000000001',
+    materialBaseId: '10000000-0000-0000-0000-000000000001',
+    materialBaseName: 'PLA',
+    materialFinishId: '20000000-0000-0000-0000-000000000001',
+    materialFinishName: 'Basic',
+    materialModifierId: null,
+    materialModifierName: null,
+    brand: 'Bambu Lab',
+    colorName: 'White',
+    colorHex: '#FFFFFF',
+    weightTotalGrams: 1000,
+    weightRemainingGrams: 750,
+    filamentDiameterMm: 1.75,
+    spoolSerial: 'SN-001',
+    purchasePrice: null,
+    purchaseDate: null,
+    isActive: true,
+    createdAt: '2026-01-01T00:00:00Z',
+    updatedAt: '2026-01-01T00:00:00Z',
+    qrCodeUrl: '',
+    ...overrides,
+  };
+}
+
+describe('getRemainingPercent', () => {
+  it('should return correct percentage', () => {
+    const filament = createFilament({ weightTotalGrams: 1000, weightRemainingGrams: 250 });
+    expect(getRemainingPercent(filament)).toBe(25);
+  });
+
+  it('should return 0 when total weight is 0', () => {
+    const filament = createFilament({ weightTotalGrams: 0, weightRemainingGrams: 0 });
+    expect(getRemainingPercent(filament)).toBe(0);
+  });
+
+  it('should cap at 100%', () => {
+    const filament = createFilament({ weightTotalGrams: 100, weightRemainingGrams: 200 });
+    expect(getRemainingPercent(filament)).toBe(100);
+  });
+
+  it('should floor at 0%', () => {
+    const filament = createFilament({ weightTotalGrams: 100, weightRemainingGrams: -10 });
+    expect(getRemainingPercent(filament)).toBe(0);
+  });
+});
+
+describe('classifyStockLevel', () => {
+  it('should classify as critical when ≤10%', () => {
+    const filament = createFilament({ weightTotalGrams: 1000, weightRemainingGrams: 50 });
+    expect(classifyStockLevel(filament)).toBe('critical');
+  });
+
+  it('should classify as critical at exactly 10%', () => {
+    const filament = createFilament({ weightTotalGrams: 1000, weightRemainingGrams: 100 });
+    expect(classifyStockLevel(filament)).toBe('critical');
+  });
+
+  it('should classify as low when ≤25%', () => {
+    const filament = createFilament({ weightTotalGrams: 1000, weightRemainingGrams: 200 });
+    expect(classifyStockLevel(filament)).toBe('low');
+  });
+
+  it('should classify as moderate when ≤50%', () => {
+    const filament = createFilament({ weightTotalGrams: 1000, weightRemainingGrams: 400 });
+    expect(classifyStockLevel(filament)).toBe('moderate');
+  });
+
+  it('should classify as healthy when >50%', () => {
+    const filament = createFilament({ weightTotalGrams: 1000, weightRemainingGrams: 750 });
+    expect(classifyStockLevel(filament)).toBe('healthy');
+  });
+
+  it('should classify 0 grams remaining as critical', () => {
+    const filament = createFilament({ weightTotalGrams: 1000, weightRemainingGrams: 0 });
+    expect(classifyStockLevel(filament)).toBe('critical');
+  });
+});

frontend/src/app/components/filament-table/filament-table.component.ts

@@ -0,0 +1,315 @@
+import {
+  ChangeDetectionStrategy,
+  Component,
+  Input,
+  computed,
+  signal,
+} from '@angular/core';
+import { CommonModule } from '@angular/common';
+import { MatTableModule } from '@angular/material/table';
+import { MatChipsModule } from '@angular/material/chips';
+import { MatIconModule } from '@angular/material/icon';
+import { MatProgressBarModule } from '@angular/material/progress-bar';
+import { MatTooltipModule } from '@angular/material/tooltip';
+import { MatSortModule, Sort } from '@angular/material/sort';
+import {
+  Filament,
+  StockLevel,
+  getRemainingPercent,
+  classifyStockLevel,
+} from '../../models/filament.model';
+
+/** Display column definitions for the filament table */
+export type FilamentColumn =
+  | 'color'
+  | 'material'
+  | 'brand'
+  | 'serial'
+  | 'remaining'
+  | 'stockLevel'
+  | 'status';
+
+@Component({
+  selector: 'app-filament-table',
+  standalone: true,
+  imports: [
+    CommonModule,
+    MatTableModule,
+    MatChipsModule,
+    MatIconModule,
+    MatProgressBarModule,
+    MatTooltipModule,
+    MatSortModule,
+  ],
+  templateUrl: './filament-table.component.html',
+  styleUrl: './filament-table.component.scss',
+  changeDetection: ChangeDetectionStrategy.OnPush,
+})
+export class FilamentTableComponent {
+  /** Filament data input — reactive signal for live updates */
+  readonly filaments = signal<Filament[]>([]);
+
+  /** Columns to display — defaults to all columns */
+  @Input()
+  set displayedColumns(cols: FilamentColumn[]) {
+    this._displayedColumns.set(cols);
+  }
+  get displayedColumns(): FilamentColumn[] {
+    return this._displayedColumns();
+  }
+  private readonly _displayedColumns = signal<FilamentColumn[]>([
+    'color',
+    'material',
+    'brand',
+    'serial',
+    'remaining',
+    'stockLevel',
+    'status',
+  ]);
+
+  /** Default columns for template binding */
+  readonly columns = this._displayedColumns;
+
+  /** Sorted filament data */
+  readonly sortedFilaments = signal<Filament[]>([]);
+
+  /** Computed: count of low/critical spools */
+  readonly lowStockCount = computed(() =>
+    this.filaments().filter(
+      (f) => classifyStockLevel(f) === 'low' || classifyStockLevel(f) === 'critical'
+    ).length
+  );
+
+  /** Computed: count of critical spools */
+  readonly criticalCount = computed(() =>
+    this.filaments().filter((f) => classifyStockLevel(f) === 'critical').length
+  );
+
+  constructor() {
+    // Initialize sorted data from filaments
+    // (MatSort handles sorting via sortChange; we start unsorted)
+
+    // Development: seed with sample data for visual testing
+    // TODO: Replace with service data from FilamentService / SignalR
+    this.updateFilaments([
+      {
+        id: '1',
+        materialBaseId: 'm1',
+        materialBaseName: 'PLA',
+        materialFinishId: 'f1',
+        materialFinishName: 'Basic',
+        materialModifierId: null,
+        materialModifierName: null,
+        brand: 'Bambu Lab',
+        colorName: 'White',
+        colorHex: '#F5F5F5',
+        weightTotalGrams: 1000,
+        weightRemainingGrams: 850,
+        filamentDiameterMm: 1.75,
+        spoolSerial: 'SN-001',
+        purchasePrice: 25.00,
+        purchaseDate: '2026-01-15T00:00:00Z',
+        isActive: true,
+        createdAt: '2026-01-15T00:00:00Z',
+        updatedAt: '2026-04-20T00:00:00Z',
+        qrCodeUrl: '',
+      },
+      {
+        id: '2',
+        materialBaseId: 'm2',
+        materialBaseName: 'PETG',
+        materialFinishId: 'f2',
+        materialFinishName: 'Matte',
+        materialModifierId: 'mod1',
+        materialModifierName: 'Carbon Fiber',
+        brand: 'Polymaker',
+        colorName: 'Fire Engine Red',
+        colorHex: '#FF0000',
+        weightTotalGrams: 1000,
+        weightRemainingGrams: 80,
+        filamentDiameterMm: 1.75,
+        spoolSerial: 'SN-002',
+        purchasePrice: 35.00,
+        purchaseDate: '2026-02-01T00:00:00Z',
+        isActive: true,
+        createdAt: '2026-02-01T00:00:00Z',
+        updatedAt: '2026-04-25T00:00:00Z',
+        qrCodeUrl: '',
+      },
+      {
+        id: '3',
+        materialBaseId: 'm1',
+        materialBaseName: 'PLA',
+        materialFinishId: 'f1',
+        materialFinishName: 'Basic',
+        materialModifierId: null,
+        materialModifierName: null,
+        brand: 'eSun',
+        colorName: 'Sky Blue',
+        colorHex: '#87CEEB',
+        weightTotalGrams: 1000,
+        weightRemainingGrams: 200,
+        filamentDiameterMm: 1.75,
+        spoolSerial: 'SN-003',
+        purchasePrice: 20.00,
+        purchaseDate: '2026-03-10T00:00:00Z',
+        isActive: true,
+        createdAt: '2026-03-10T00:00:00Z',
+        updatedAt: '2026-04-26T00:00:00Z',
+        qrCodeUrl: '',
+      },
+      {
+        id: '4',
+        materialBaseId: 'm3',
+        materialBaseName: 'ABS',
+        materialFinishId: 'f1',
+        materialFinishName: 'Basic',
+        materialModifierId: null,
+        materialModifierName: null,
+        brand: 'Hatchbox',
+        colorName: 'Black',
+        colorHex: '#1A1A1A',
+        weightTotalGrams: 1000,
+        weightRemainingGrams: 450,
+        filamentDiameterMm: 1.75,
+        spoolSerial: 'SN-004',
+        purchasePrice: 22.00,
+        purchaseDate: null,
+        isActive: true,
+        createdAt: '2026-01-20T00:00:00Z',
+        updatedAt: '2026-04-18T00:00:00Z',
+        qrCodeUrl: '',
+      },
+      {
+        id: '5',
+        materialBaseId: 'm1',
+        materialBaseName: 'PLA',
+        materialFinishId: 'f3',
+        materialFinishName: 'Silk',
+        materialModifierId: null,
+        materialModifierName: null,
+        brand: 'Overturn',
+        colorName: 'Gold',
+        colorHex: '#FFD700',
+        weightTotalGrams: 500,
+        weightRemainingGrams: 15,
+        filamentDiameterMm: 1.75,
+        spoolSerial: 'SN-005',
+        purchasePrice: 28.00,
+        purchaseDate: null,
+        isActive: false,
+        createdAt: '2025-12-01T00:00:00Z',
+        updatedAt: '2026-04-01T00:00:00Z',
+        qrCodeUrl: '',
+      },
+    ]);
+  }
+
+  /** Update filament data — called by parent or service */
+  updateFilaments(data: Filament[]): void {
+    this.filaments.set(data);
+    this.sortedFilaments.set([...data]);
+  }
+
+  /** Handle sort changes from MatSort */
+  sortData(sort: Sort): void {
+    const data = [...this.filaments()];
+    if (!sort.active || sort.direction === '') {
+      this.sortedFilaments.set(data);
+      return;
+    }
+    const sorted = data.sort((a, b) => {
+      const isAsc = sort.direction === 'asc';
+      switch (sort.active as FilamentColumn) {
+        case 'material':
+          return compare(a.materialBaseName, b.materialBaseName, isAsc);
+        case 'brand':
+          return compare(a.brand, b.brand, isAsc);
+        case 'serial':
+          return compare(a.spoolSerial, b.spoolSerial, isAsc);
+        case 'remaining':
+          return compare(
+            getRemainingPercent(a),
+            getRemainingPercent(b),
+            isAsc
+          );
+        case 'stockLevel':
+          return compare(
+            stockLevelOrder(classifyStockLevel(a)),
+            stockLevelOrder(classifyStockLevel(b)),
+            isAsc
+          );
+        case 'status':
+          return compare(
+            a.isActive ? 0 : 1,
+            b.isActive ? 0 : 1,
+            isAsc
+          );
+        default:
+          return 0;
+      }
+    });
+    this.sortedFilaments.set(sorted);
+  }
+
+  /** Template helper: get remaining percent */
+  getRemainingPercent = getRemainingPercent;
+
+  /** Template helper: classify stock level */
+  classifyStockLevel = classifyStockLevel;
+
+  /** Template helper: stock level icon */
+  stockLevelIcon(level: StockLevel): string {
+    switch (level) {
+      case 'critical':
+        return 'error';
+      case 'low':
+        return 'warning';
+      case 'moderate':
+        return 'info';
+      case 'healthy':
+        return 'check_circle';
+    }
+  }
+
+  /** Template helper: stock level label */
+  stockLevelLabel(level: StockLevel): string {
+    switch (level) {
+      case 'critical':
+        return 'Critical';
+      case 'low':
+        return 'Low';
+      case 'moderate':
+        return 'Moderate';
+      case 'healthy':
+        return 'Healthy';
+    }
+  }
+
+  /** Template helper: format remaining weight */
+  formatWeight(grams: number): string {
+    if (grams >= 1000) {
+      return `${(grams / 1000).toFixed(1)}kg`;
+    }
+    return `${Math.round(grams)}g`;
+  }
+}
+
+/** Compare helper for sorting */
+function compare(a: number | string, b: number | string, isAsc: boolean): number {
+  return (a < b ? -1 : a > b ? 1 : 0) * (isAsc ? 1 : -1);
+}
+
+/** Stock level sort order (critical=0, healthy=3) */
+function stockLevelOrder(level: StockLevel): number {
+  switch (level) {
+    case 'critical':
+      return 0;
+    case 'low':
+      return 1;
+    case 'moderate':
+      return 2;
+    case 'healthy':
+      return 3;
+  }
+}

frontend/src/app/models/agent-status.ts

@@ -1,15 +0,0 @@
-/**
- * Data models for agent status updates received via SignalR.
- */
-
-/** Represents a single agent status update pushed from the server. */
-export interface AgentStatusUpdate {
-  /** Unique identifier of the agent whose status changed. */
-  agentId: string;
-
-  /** Current operational status of the agent (e.g., "Online", "Offline", "Busy", "Error"). */
-  status: string;
-
-  /** ISO 8601 timestamp of when this status was observed, or null if unknown. */
-  lastSeenAt: string | null;
-}

frontend/src/app/models/agent.model.ts

@@ -0,0 +1,24 @@
+/**
+ * Represents the status of a single agent/printer in the system.
+ */
+export type AgentStatus = 'active' | 'idle' | 'thinking' | 'error';
+
+export interface AgentSummary {
+  /** Total number of agents in the system */
+  total: number;
+  /** Number of currently active agents */
+  active: number;
+  /** Number of currently idle agents */
+  idle: number;
+  /** Number of currently thinking/processing agents */
+  thinking: number;
+  /** Number of agents in error state */
+  error: number;
+}
+
+export interface SystemHealth {
+  /** Whether the SignalR connection is live */
+  connected: boolean;
+  /** Overall system health: healthy, degraded, or down */
+  status: 'healthy' | 'degraded' | 'down';
+}

frontend/src/app/models/filament.model.ts

@@ -0,0 +1,100 @@
+/**
+ * Filament model matching the Extrudex backend FilamentResponse DTO.
+ * Used for displaying spool inventory in the filament table UI.
+ */
+export interface Filament {
+  /** Unique identifier for the filament spool. */
+  id: string;
+
+  /** Foreign key to the base material. */
+  materialBaseId: string;
+
+  /** Name of the base material (e.g., "PLA", "PETG"). */
+  materialBaseName: string;
+
+  /** Foreign key to the material finish. */
+  materialFinishId: string;
+
+  /** Name of the material finish (e.g., "Basic", "Matte"). */
+  materialFinishName: string;
+
+  /** Foreign key to the optional material modifier. */
+  materialModifierId: string | null;
+
+  /** Name of the material modifier (e.g., "Carbon Fiber"). Null if none. */
+  materialModifierName: string | null;
+
+  /** Brand name (e.g., "Bambu Lab", "Polymaker"). */
+  brand: string;
+
+  /** Human-readable color name (e.g., "Fire Engine Red"). */
+  colorName: string;
+
+  /** Hex color code (e.g., "#FF0000"). */
+  colorHex: string;
+
+  /** Total spool weight in grams when full. */
+  weightTotalGrams: number;
+
+  /** Current remaining weight in grams. */
+  weightRemainingGrams: number;
+
+  /** Filament diameter in millimeters. Typically 1.75mm. */
+  filamentDiameterMm: number;
+
+  /** Manufacturer-assigned serial number. */
+  spoolSerial: string;
+
+  /** Purchase price per spool. Null if not tracked. */
+  purchasePrice: number | null;
+
+  /** Date the spool was purchased or received. */
+  purchaseDate: string | null;
+
+  /** Whether the spool is currently active and available. */
+  isActive: boolean;
+
+  /** Timestamp when this record was created (UTC). */
+  createdAt: string;
+
+  /** Timestamp when this record was last updated (UTC). */
+  updatedAt: string;
+
+  /** URL to the QR code image for this spool. */
+  qrCodeUrl: string;
+}
+
+/**
+ * Stock level classification for low stock indicators.
+ * - critical: ≤ 10% remaining
+ * - low: ≤ 25% remaining
+ * - moderate: ≤ 50% remaining
+ * - healthy: > 50% remaining
+ */
+export type StockLevel = 'critical' | 'low' | 'moderate' | 'healthy';
+
+/**
+ * Compute the remaining weight percentage for a filament spool.
+ * Returns a value from 0 to 100.
+ */
+export function getRemainingPercent(filament: Filament): number {
+  if (filament.weightTotalGrams <= 0) return 0;
+  const pct = (filament.weightRemainingGrams / filament.weightTotalGrams) * 100;
+  return Math.min(Math.max(pct, 0), 100);
+}
+
+/**
+ * Classify the stock level based on remaining percentage.
+ * Thresholds:
+ *   critical  — ≤ 10%  (nearly empty, red alert)
+ *   low       — ≤ 25%  (getting low, amber warning)
+ *   moderate  — ≤ 50%  (half or less, yellow info)
+ *   healthy   — > 50%  (plenty left, green OK)
+ */
+export function classifyStockLevel(filament: Filament): StockLevel {
+  const pct = getRemainingPercent(filament);
+  if (pct <= 10) return 'critical';
+  if (pct <= 25) return 'low';
+  if (pct <= 50) return 'moderate';
+  return 'healthy';
+}

frontend/src/app/services/agent-status-initializer.ts

@@ -1,24 +0,0 @@
-import { APP_INITIALIZER, Provider } from '@angular/core';
-import { AgentStatusService } from './agent-status.service';
-
-/**
- * Provider that starts the AgentStatusService SignalR connection
- * during application initialization. Inject this in your app config
- * providers array to ensure the hub connection is established on startup.
- *
- * Usage in app.config.ts:
- *   providers: [provideAgentStatusInitializer()]
- */
-export function provideAgentStatusInitializer(): Provider[] {
-  return [
-    {
-      provide: APP_INITIALIZER,
-      useFactory: (agentStatusService: AgentStatusService) => () => {
-        // Fire-and-forget: connection errors are logged by the service
-        agentStatusService.startConnection();
-      },
-      multi: true,
-      deps: [AgentStatusService],
-    },
-  ];
-}

frontend/src/app/services/agent-status.service.ts

@@ -1,141 +0,0 @@
-import { Injectable, OnDestroy } from '@angular/core';
-import { BehaviorSubject, Observable, Subject, Subscription } from 'rxjs';
-import * as signalR from '@microsoft/signalr';
-
-import { AgentStatusUpdate } from '../models/agent-status';
-
-/**
- * Angular service that manages a SignalR connection to the agent status hub
- * and exposes real-time status updates as observables.
- *
- * Usage:
- *   Inject `AgentStatusService` and subscribe to `onStatusUpdate()`
- *   to receive push notifications whenever an agent's status changes.
- *
- * The connection is established automatically on app start via
- * `APP_INITIALIZER` (configured in `app.config.ts`) and cleaned up
- * when the service is destroyed.
- */
-@Injectable({ providedIn: 'root' })
-export class AgentStatusService implements OnDestroy {
-  /** Base URL for the SignalR hub endpoint. */
-  private readonly hubUrl = '/hub';
-
-  /** Underlying SignalR connection instance. */
-  private hubConnection: signalR.HubConnection | null = null;
-
-  /** Internal subject that emits status updates received from the hub. */
-  private readonly statusUpdateSubject = new Subject<AgentStatusUpdate>();
-
-  /** Tracks the current connection state. Emits true when connected. */
-  private readonly connectedSubject = new BehaviorSubject<boolean>(false);
-
-  /** Subscription for auto-reconnect attempts. */
-  private reconnectSubscription: Subscription | null = null;
-
-  // ── Public Observables ──────────────────────────────────────
-
-  /** Observable that emits agent status updates pushed from the server. */
-  readonly statusUpdates$: Observable<AgentStatusUpdate> =
-    this.statusUpdateSubject.asObservable();
-
-  /** Observable that emits the current connection state (true = connected). */
-  readonly connected$: Observable<boolean> =
-    this.connectedSubject.asObservable();
-
-  // ── Lifecycle ───────────────────────────────────────────────
-
-  /** @inheritdoc */
-  ngOnDestroy(): void {
-    this.stopConnection();
-  }
-
-  // ── Connection Management ───────────────────────────────────
-
-  /**
-   * Starts the SignalR connection to the agent status hub.
-   * Safe to call multiple times — no-ops if already connected.
-   */
-  async startConnection(): Promise<void> {
-    if (this.hubConnection) {
-      return; // Already initialized
-    }
-
-    this.hubConnection = new signalR.HubConnectionBuilder()
-      .withUrl(this.hubUrl)
-      .withAutomaticReconnect([0, 2000, 5000, 10000, 30000])
-      .configureLogging(signalR.LogLevel.Information)
-      .build();
-
-    // Register server-to-client handlers
-    this.registerHandlers(this.hubConnection);
-
-    // Wire up lifecycle events
-    this.hubConnection.onreconnecting(() => {
-      console.warn('[AgentStatusService] Reconnecting to hub…');
-      this.connectedSubject.next(false);
-    });
-
-    this.hubConnection.onreconnected(() => {
-      console.info('[AgentStatusService] Reconnected to hub.');
-      this.connectedSubject.next(true);
-    });
-
-    this.hubConnection.onclose((error) => {
-      console.error('[AgentStatusService] Hub connection closed.', error);
-      this.connectedSubject.next(false);
-    });
-
-    try {
-      await this.hubConnection.start();
-      this.connectedSubject.next(true);
-      console.info('[AgentStatusService] Connected to hub at', this.hubUrl);
-    } catch (err) {
-      console.error('[AgentStatusService] Failed to connect to hub:', err);
-      this.connectedSubject.next(false);
-    }
-  }
-
-  /**
-   * Stops the SignalR connection and cleans up resources.
-   */
-  async stopConnection(): Promise<void> {
-    if (this.hubConnection) {
-      await this.hubConnection.stop();
-      this.hubConnection = null;
-      this.connectedSubject.next(false);
-    }
-    this.reconnectSubscription?.unsubscribe();
-    this.reconnectSubscription = null;
-  }
-
-  // ── Convenience Alias ────────────────────────────────────────
-
-  /**
-   * Alias for `statusUpdates$` — matches the interface described in CUB-58.
-   * Returns an Observable that emits every time the server pushes a
-   * status update for an agent.
-   */
-  onStatusUpdate(): Observable<AgentStatusUpdate> {
-    return this.statusUpdates$;
-  }
-
-  // ── Private Helpers ─────────────────────────────────────────
-
-  /**
-   * Registers handlers for server-to-client calls on the hub connection.
-   */
-  private registerHandlers(connection: signalR.HubConnection): void {
-    // Agent status changed — full update payload
-    connection.on('AgentStatusChanged', (agentId: string, status: string, lastSeenAt: string | null) => {
-      const update: AgentStatusUpdate = { agentId, status, lastSeenAt };
-      console.info('[AgentStatusService] Status update received:', update);
-      this.statusUpdateSubject.next(update);
-    });
-
-    // Generic broadcast for testing — logs to console per CUB-58 DoD
-    connection.on('BroadcastMessage', (message: string) => {
-      console.info('[AgentStatusService] Broadcast message:', message);
-    });
-  }
-}

frontend/src/app/services/index.ts

@@ -1,7 +0,0 @@
-/**
- * Barrel file for agent status services and models.
- * Re-export public API from this module for clean imports.
- */
-export { AgentStatusService } from './agent-status.service';
-export { provideAgentStatusInitializer } from './agent-status-initializer';
-export { AgentStatusUpdate } from '../models/agent-status';

frontend/src/index.html

@@ -1,13 +1,20 @@
 <!doctype html>
 <html lang="en">
-<head>
-  <meta charset="utf-8">
-  <title>Frontend</title>
-  <base href="/">
-  <meta name="viewport" content="width=device-width, initial-scale=1">
-  <link rel="icon" type="image/x-icon" href="favicon.ico">
-</head>
-<body>
-  <app-root></app-root>
-</body>
+  <head>
+    <meta charset="utf-8" />
+    <title>Frontend</title>
+    <base href="/" />
+    <meta name="viewport" content="width=device-width, initial-scale=1" />
+    <link rel="icon" type="image/x-icon" href="favicon.ico" />
+    <link rel="preconnect" href="https://fonts.googleapis.com" />
+    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin />
+    <link
+      href="https://fonts.googleapis.com/css2?family=Roboto:wght@300;400;500&display=swap"
+      rel="stylesheet"
+    />
+    <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet" />
+  </head>
+  <body>
+    <app-root></app-root>
+  </body>
 </html>

frontend/src/main.ts

@@ -1,6 +1,6 @@
 import { bootstrapApplication } from '@angular/platform-browser';
 import { appConfig } from './app/app.config';
-import { AppComponent } from './app/app.component';
+import { App } from './app/app';
 
-bootstrapApplication(AppComponent, appConfig)
+bootstrapApplication(App, appConfig)
   .catch((err) => console.error(err));

frontend/src/styles.scss

@@ -1 +1,39 @@
+// Include theming for Angular Material with `mat.theme()`.
+// This Sass mixin will define CSS variables that are used for styling Angular Material
+// components according to the Material 3 design spec.
+// Learn more about theming and how to use it for your application's
+// custom components at https://material.angular.dev/guide/theming
+@use '@angular/material' as mat;
+
+html {
+  height: 100%;
+  @include mat.theme(
+    (
+      color: (
+        primary: mat.$azure-palette,
+        tertiary: mat.$blue-palette,
+      ),
+      typography: Roboto,
+      density: 0,
+    )
+  );
+}
+
+body {
+  // Default the application to a light color theme. This can be changed to
+  // `dark` to enable the dark color theme, or to `light dark` to defer to the
+  // user's system settings.
+  color-scheme: light;
+
+  // Set a default background, font and text colors for the application using
+  // Angular Material's system-level CSS variables. Learn more about these
+  // variables at https://material.angular.dev/guide/system-variables
+  background-color: var(--mat-sys-surface);
+  color: var(--mat-sys-on-surface);
+  font: var(--mat-sys-body-medium);
+
+  // Reset the user agent margin.
+  margin: 0;
+  height: 100%;
+}
 /* You can add global styles to this file, and also import other style files */

frontend/tsconfig.app.json

@@ -1,14 +1,15 @@
-/* To learn more about this file see: https://angular.io/config/tsconfig. */
+/* To learn more about Typescript configuration file: https://www.typescriptlang.org/docs/handbook/tsconfig-json.html. */
+/* To learn more about Angular compiler options: https://angular.dev/reference/configs/angular-compiler-options. */
 {
   "extends": "./tsconfig.json",
   "compilerOptions": {
     "outDir": "./out-tsc/app",
     "types": []
   },
-  "files": [
-    "src/main.ts"
-  ],
   "include": [
-    "src/**/*.d.ts"
+    "src/**/*.ts"
+  ],
+  "exclude": [
+    "src/**/*.spec.ts"
   ]
 }

frontend/tsconfig.json

@@ -1,32 +1,33 @@
-/* To learn more about this file see: https://angular.io/config/tsconfig. */
+/* To learn more about Typescript configuration file: https://www.typescriptlang.org/docs/handbook/tsconfig-json.html. */
+/* To learn more about Angular compiler options: https://angular.dev/reference/configs/angular-compiler-options. */
 {
   "compileOnSave": false,
   "compilerOptions": {
-    "outDir": "./dist/out-tsc",
     "strict": true,
     "noImplicitOverride": true,
     "noPropertyAccessFromIndexSignature": true,
     "noImplicitReturns": true,
     "noFallthroughCasesInSwitch": true,
     "skipLibCheck": true,
-    "esModuleInterop": true,
-    "sourceMap": true,
-    "declaration": false,
+    "isolatedModules": true,
     "experimentalDecorators": true,
-    "moduleResolution": "node",
     "importHelpers": true,
     "target": "ES2022",
-    "module": "ES2022",
-    "useDefineForClassFields": false,
-    "lib": [
-      "ES2022",
-      "dom"
-    ]
+    "module": "preserve"
   },
   "angularCompilerOptions": {
     "enableI18nLegacyMessageIdFormat": false,
     "strictInjectionParameters": true,
     "strictInputAccessModifiers": true,
     "strictTemplates": true
-  }
+  },
+  "files": [],
+  "references": [
+    {
+      "path": "./tsconfig.app.json"
+    },
+    {
+      "path": "./tsconfig.spec.json"
+    }
+  ]
 }

frontend/tsconfig.spec.json

@@ -1,14 +1,15 @@
-/* To learn more about this file see: https://angular.io/config/tsconfig. */
+/* To learn more about Typescript configuration file: https://www.typescriptlang.org/docs/handbook/tsconfig-json.html. */
+/* To learn more about Angular compiler options: https://angular.dev/reference/configs/angular-compiler-options. */
 {
   "extends": "./tsconfig.json",
   "compilerOptions": {
     "outDir": "./out-tsc/spec",
     "types": [
-      "jasmine"
+      "vitest/globals"
     ]
   },
   "include": [
-    "src/**/*.spec.ts",
-    "src/**/*.d.ts"
+    "src/**/*.d.ts",
+    "src/**/*.spec.ts"
   ]
 }