Task 1 Completion Report

Laravel migration that creates the user_filter_presets table. Includes a foreign key to users.user_id with cascade delete, and a composite index on (user_id, page) for fast per-user, per-page queries.

Schema::create('user_filter_presets', function (Blueprint $table) {
    $table->id();
    $table->unsignedInteger('user_id');
    $table->string('page', 50);        // e.g. 'monitoring'
    $table->string('name', 100);        // user-given preset name
    $table->json('filters');              // saved filter state
    $table->tinyInteger('is_default')->default(0);
    $table->timestamps();
    $table->index(['user_id', 'page']);
    $table->foreign('user_id')->references('user_id')->on('users')->onDelete('cascade');
});

Eloquent model for the user_filter_presets table. The filters field auto-casts to/from PHP array. The is_default field auto-casts to boolean. Includes two query scopes for clean filtering in controllers.

class UserFilterPreset extends Model
{
    protected $fillable = ['user_id', 'page', 'name', 'filters', 'is_default'];

    protected $casts = [
        'filters'    => 'array',
        'is_default' => 'boolean',
    ];

    // Relationship
    public function user(): BelongsTo
        => $this->belongsTo(User::class, 'user_id', 'user_id');

    // Scopes
    public function scopeForPage($query, string $page)
        => $query->where('page', $page);

    public function scopeForUser($query, int $userId)
        => $query->where('user_id', $userId);
}