# Generated by Django 5.2.13 on 2026-05-14 15:39 import django.db.models.deletion import simple_history.models from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): dependencies = [ ("mel_indicators", "0010_g21_evidence_attachment"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.AddField( model_name="historicallogframe", name="close_reason", field=models.TextField(blank=True), ), migrations.AddField( model_name="historicallogframe", name="closed_at", field=models.DateTimeField(blank=True, null=True), ), migrations.AddField( model_name="historicallogframe", name="closed_by", field=models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), migrations.AddField( model_name="historicallogframe", name="period_end", field=models.DateField( blank=True, help_text="G6 — planned programme end date. Hits trigger close eligibility.", null=True, ), ), migrations.AddField( model_name="historicallogframe", name="period_start", field=models.DateField( blank=True, help_text="G6 — programme start date. Drives current-period anchoring.", null=True, ), ), migrations.AddField( model_name="historicallogframe", name="post_project_window_months", field=models.PositiveSmallIntegerField( default=3, help_text="G6 — months after closure before tracer follow-up surveys auto-dispatch.", ), ), migrations.AddField( model_name="historicallogframe", name="status", field=models.CharField( choices=[("active", "Active"), ("closed", "Closed"), ("archived", "Archived")], db_index=True, default="active", help_text="G6 — ACTIVE accepts writes; CLOSED is read-only; ARCHIVED hides from default lists.", max_length=16, ), ), migrations.AddField( model_name="logframe", name="close_reason", field=models.TextField(blank=True), ), migrations.AddField( model_name="logframe", name="closed_at", field=models.DateTimeField(blank=True, null=True), ), migrations.AddField( model_name="logframe", name="closed_by", field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="closed_logframes", to=settings.AUTH_USER_MODEL, ), ), migrations.AddField( model_name="logframe", name="period_end", field=models.DateField( blank=True, help_text="G6 — planned programme end date. Hits trigger close eligibility.", null=True, ), ), migrations.AddField( model_name="logframe", name="period_start", field=models.DateField( blank=True, help_text="G6 — programme start date. Drives current-period anchoring.", null=True, ), ), migrations.AddField( model_name="logframe", name="post_project_window_months", field=models.PositiveSmallIntegerField( default=3, help_text="G6 — months after closure before tracer follow-up surveys auto-dispatch.", ), ), migrations.AddField( model_name="logframe", name="status", field=models.CharField( choices=[("active", "Active"), ("closed", "Closed"), ("archived", "Archived")], db_index=True, default="active", help_text="G6 — ACTIVE accepts writes; CLOSED is read-only; ARCHIVED hides from default lists.", max_length=16, ), ), migrations.CreateModel( name="AlertEscalationRule", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "hours_until_tier_2", models.PositiveSmallIntegerField( default=24, help_text="Hours of silence after tier-1 dispatch before escalating to tier 2.", ), ), ( "hours_until_tier_3", models.PositiveSmallIntegerField( default=24, help_text="Additional hours after tier-2 dispatch before escalating to tier 3.", ), ), ("is_active", models.BooleanField(db_index=True, default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "logframe", models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name="escalation_rule", to="mel_indicators.logframe", ), ), ( "tier_1_recipients", models.ManyToManyField( blank=True, related_name="alert_tier1_logframes", to=settings.AUTH_USER_MODEL, ), ), ( "tier_2_recipients", models.ManyToManyField( blank=True, related_name="alert_tier2_logframes", to=settings.AUTH_USER_MODEL, ), ), ( "tier_3_recipients", models.ManyToManyField( blank=True, related_name="alert_tier3_logframes", to=settings.AUTH_USER_MODEL, ), ), ], ), migrations.CreateModel( name="HistoricalAlertEscalation", fields=[ ( "id", models.BigIntegerField( auto_created=True, blank=True, db_index=True, verbose_name="ID" ), ), ("period_label", models.CharField(db_index=True, max_length=40)), ("tier_reached", models.PositiveSmallIntegerField(default=1)), ("acknowledged_at", models.DateTimeField(blank=True, null=True)), ("resolved_at", models.DateTimeField(blank=True, null=True)), ("last_notified_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(blank=True, editable=False)), ("updated_at", models.DateTimeField(blank=True, editable=False)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_date", models.DateTimeField(db_index=True)), ("history_change_reason", models.CharField(max_length=100, null=True)), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1 ), ), ( "acknowledged_by", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "indicator", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="mel_indicators.indicator", ), ), ], options={ "verbose_name": "historical alert escalation", "verbose_name_plural": "historical alert escalations", "ordering": ("-history_date", "-history_id"), "get_latest_by": ("history_date", "history_id"), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalAlertEscalationRule", fields=[ ( "id", models.BigIntegerField( auto_created=True, blank=True, db_index=True, verbose_name="ID" ), ), ( "hours_until_tier_2", models.PositiveSmallIntegerField( default=24, help_text="Hours of silence after tier-1 dispatch before escalating to tier 2.", ), ), ( "hours_until_tier_3", models.PositiveSmallIntegerField( default=24, help_text="Additional hours after tier-2 dispatch before escalating to tier 3.", ), ), ("is_active", models.BooleanField(db_index=True, default=True)), ("created_at", models.DateTimeField(blank=True, editable=False)), ("updated_at", models.DateTimeField(blank=True, editable=False)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_date", models.DateTimeField(db_index=True)), ("history_change_reason", models.CharField(max_length=100, null=True)), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1 ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "logframe", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="mel_indicators.logframe", ), ), ], options={ "verbose_name": "historical alert escalation rule", "verbose_name_plural": "historical alert escalation rules", "ordering": ("-history_date", "-history_id"), "get_latest_by": ("history_date", "history_id"), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="HistoricalProgrammeHealthScore", fields=[ ( "id", models.BigIntegerField( auto_created=True, blank=True, db_index=True, verbose_name="ID" ), ), ("period_label", models.CharField(db_index=True, max_length=40)), ("period_start", models.DateField(blank=True, null=True)), ("period_end", models.DateField(blank=True, null=True)), ( "rag_health", models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True), ), ( "activity_on_time", models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True), ), ( "budget_adherence", models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True), ), ( "feedback_satisfaction", models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True), ), ("score", models.DecimalField(decimal_places=2, max_digits=6)), ( "weights_applied", models.JSONField( blank=True, default=dict, help_text="Snapshot of per-term weight after redistribution (audit aid).", ), ), ("indicator_count", models.PositiveIntegerField(default=0)), ("activity_count", models.PositiveIntegerField(default=0)), ("feedback_count", models.PositiveIntegerField(default=0)), ("computed_at", models.DateTimeField(blank=True, editable=False)), ("created_at", models.DateTimeField(blank=True, editable=False)), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_date", models.DateTimeField(db_index=True)), ("history_change_reason", models.CharField(max_length=100, null=True)), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1 ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "logframe", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="mel_indicators.logframe", ), ), ], options={ "verbose_name": "historical programme health score", "verbose_name_plural": "historical programme health scores", "ordering": ("-history_date", "-history_id"), "get_latest_by": ("history_date", "history_id"), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="AlertEscalation", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("period_label", models.CharField(db_index=True, max_length=40)), ("tier_reached", models.PositiveSmallIntegerField(default=1)), ("acknowledged_at", models.DateTimeField(blank=True, null=True)), ("resolved_at", models.DateTimeField(blank=True, null=True)), ("last_notified_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "acknowledged_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="acknowledged_escalations", to=settings.AUTH_USER_MODEL, ), ), ( "indicator", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="escalations", to="mel_indicators.indicator", ), ), ], options={ "ordering": ["-created_at"], "indexes": [ models.Index(fields=["acknowledged_at"], name="mel_indicat_acknowl_7babc2_idx"), models.Index(fields=["tier_reached"], name="mel_indicat_tier_re_eb0116_idx"), ], "constraints": [ models.UniqueConstraint( fields=("indicator", "period_label"), name="uniq_escalation_per_indicator_period", ) ], }, ), migrations.CreateModel( name="ProgrammeHealthScore", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("period_label", models.CharField(db_index=True, max_length=40)), ("period_start", models.DateField(blank=True, null=True)), ("period_end", models.DateField(blank=True, null=True)), ( "rag_health", models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True), ), ( "activity_on_time", models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True), ), ( "budget_adherence", models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True), ), ( "feedback_satisfaction", models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True), ), ("score", models.DecimalField(decimal_places=2, max_digits=6)), ( "weights_applied", models.JSONField( blank=True, default=dict, help_text="Snapshot of per-term weight after redistribution (audit aid).", ), ), ("indicator_count", models.PositiveIntegerField(default=0)), ("activity_count", models.PositiveIntegerField(default=0)), ("feedback_count", models.PositiveIntegerField(default=0)), ("computed_at", models.DateTimeField(auto_now=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ( "logframe", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="health_scores", to="mel_indicators.logframe", ), ), ], options={ "ordering": ["-period_start", "-period_label", "logframe_id"], "indexes": [ models.Index( fields=["logframe", "period_label"], name="mel_indicat_logfram_8446c6_idx" ), models.Index(fields=["-period_start"], name="mel_indicat_period__4b73c9_idx"), ], "constraints": [ models.UniqueConstraint( fields=("logframe", "period_label"), name="uniq_programme_health_per_period" ) ], }, ), ]