# Generated by Django 5.2.13 on 2026-04-29 16:50

import django.db.models.deletion
from django.conf import settings
from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ("mel_tracking", "0004_phase7_beneficiary_feedback_status"),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name="EmploymentSnapshot",
            fields=[
                (
                    "id",
                    models.BigAutoField(
                        auto_created=True, primary_key=True, serialize=False, verbose_name="ID"
                    ),
                ),
                ("captured_at", models.DateTimeField(auto_now_add=True, db_index=True)),
                ("fte_count", models.PositiveIntegerField()),
                ("pte_count", models.PositiveIntegerField()),
                ("note", models.CharField(blank=True, max_length=255)),
                (
                    "captured_by",
                    models.ForeignKey(
                        blank=True,
                        null=True,
                        on_delete=django.db.models.deletion.SET_NULL,
                        related_name="+",
                        to=settings.AUTH_USER_MODEL,
                    ),
                ),
                (
                    "tracking_record",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="employment_snapshots",
                        to="mel_tracking.smehubtrackingrecord",
                    ),
                ),
            ],
            options={
                "verbose_name": "SME-Hub employment snapshot",
                "verbose_name_plural": "SME-Hub employment snapshots",
                "ordering": ["-captured_at"],
                "indexes": [
                    models.Index(
                        fields=["tracking_record", "-captured_at"],
                        name="mel_trackin_trackin_378cf7_idx",
                    )
                ],
            },
        ),
    ]