# Generated by Django 5.2.13 on 2026-05-03 08:55 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_feedback", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="HistoricalSurvey", fields=[ ( "id", models.BigIntegerField( auto_created=True, blank=True, db_index=True, verbose_name="ID" ), ), ("title", models.CharField(max_length=255)), ("slug", models.SlugField(max_length=140)), ("description", models.TextField(blank=True)), ( "status", models.CharField( choices=[("draft", "Draft"), ("active", "Active"), ("closed", "Closed")], db_index=True, default="draft", max_length=16, ), ), ( "trigger", models.CharField( choices=[ ("manual", "Manual dispatch"), ("post_incubation", "Post-incubation"), ("post_connection", "Post-connection"), ("post_deal", "Post-deal"), ("post_course", "Post-course completion"), ("post_graduation", "Post-graduation"), ], default="manual", max_length=24, ), ), ( "audience", models.JSONField( blank=True, default=dict, help_text="Filter spec: {'programmes': [...], 'cohorts': [...], 'roles': [...]}.", ), ), ( "response_window_days", models.PositiveIntegerField( default=14, help_text="Reminder fires when a dispatched survey has no response after this window.", ), ), ("is_anonymous", models.BooleanField(default=False)), ("version", models.PositiveIntegerField(default=1)), ("activated_at", models.DateTimeField(blank=True, null=True)), ("closed_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 ), ), ( "channel", models.ForeignKey( blank=True, db_constraint=False, help_text="FeedbackChannel created on activation.", null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="mel_feedback.feedbackchannel", ), ), ( "created_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, ), ), ], options={ "verbose_name": "historical survey", "verbose_name_plural": "historical surveys", "ordering": ("-history_date", "-history_id"), "get_latest_by": ("history_date", "history_id"), }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="Survey", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("title", models.CharField(max_length=255)), ("slug", models.SlugField(max_length=140, unique=True)), ("description", models.TextField(blank=True)), ( "status", models.CharField( choices=[("draft", "Draft"), ("active", "Active"), ("closed", "Closed")], db_index=True, default="draft", max_length=16, ), ), ( "trigger", models.CharField( choices=[ ("manual", "Manual dispatch"), ("post_incubation", "Post-incubation"), ("post_connection", "Post-connection"), ("post_deal", "Post-deal"), ("post_course", "Post-course completion"), ("post_graduation", "Post-graduation"), ], default="manual", max_length=24, ), ), ( "audience", models.JSONField( blank=True, default=dict, help_text="Filter spec: {'programmes': [...], 'cohorts': [...], 'roles': [...]}.", ), ), ( "response_window_days", models.PositiveIntegerField( default=14, help_text="Reminder fires when a dispatched survey has no response after this window.", ), ), ("is_anonymous", models.BooleanField(default=False)), ("version", models.PositiveIntegerField(default=1)), ("activated_at", models.DateTimeField(blank=True, null=True)), ("closed_at", models.DateTimeField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "channel", models.OneToOneField( blank=True, help_text="FeedbackChannel created on activation.", null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="survey", to="mel_feedback.feedbackchannel", ), ), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="mel_surveys_created", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["-created_at"], }, ), migrations.CreateModel( name="SurveyDispatch", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("recipient_email", models.EmailField(blank=True, max_length=254)), ("token", models.CharField(max_length=48, unique=True)), ("trigger_event", models.CharField(blank=True, max_length=128)), ( "status", models.CharField( choices=[ ("sent", "Sent — awaiting response"), ("reminded", "Reminder sent"), ("completed", "Completed"), ("non_responded", "Non-responded"), ("cancelled", "Cancelled"), ], db_index=True, default="sent", max_length=16, ), ), ("dispatched_at", models.DateTimeField(auto_now_add=True)), ("due_at", models.DateTimeField(blank=True, null=True)), ("reminded_at", models.DateTimeField(blank=True, null=True)), ("completed_at", models.DateTimeField(blank=True, null=True)), ( "recipient", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="mel_survey_dispatches", to=settings.AUTH_USER_MODEL, ), ), ( "survey", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="dispatches", to="mel_feedback.survey", ), ), ], options={ "ordering": ["-dispatched_at"], }, ), migrations.CreateModel( name="SurveyQuestion", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("ordinal", models.PositiveIntegerField(default=0)), ( "page", models.PositiveIntegerField( default=1, help_text="Survey-take splits questions across pages by this number.", ), ), ( "type", models.CharField( choices=[ ("short_answer", "Short answer"), ("essay", "Essay"), ("multiple_choice", "Multiple choice"), ("rating", "Rating scale"), ("nps", "Net Promoter Score (0–10)"), ("boolean", "Yes / No"), ], max_length=24, ), ), ("text", models.TextField()), ("help_text", models.CharField(blank=True, max_length=255)), ("required", models.BooleanField(default=False)), ( "options", models.JSONField( blank=True, default=list, help_text="List of {value,label} for choice/rating; rating uses {min,max,labels}.", ), ), ( "survey", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="questions", to="mel_feedback.survey", ), ), ], options={ "ordering": ["survey_id", "ordinal", "pk"], }, ), migrations.CreateModel( name="SatisfactionScore", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "dimension", models.CharField( choices=[ ("nps", "Net Promoter Score"), ("mean_rating", "Mean rating"), ("completion_rate", "Completion rate"), ("non_response_rate", "Non-response rate"), ("count", "Count"), ], max_length=24, ), ), ("value", models.DecimalField(decimal_places=4, max_digits=10)), ("sample_size", models.PositiveIntegerField(default=0)), ("payload", models.JSONField(blank=True, default=dict)), ("computed_at", models.DateTimeField(auto_now_add=True)), ( "survey", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="scores", to="mel_feedback.survey", ), ), ( "question", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="scores", to="mel_feedback.surveyquestion", ), ), ], options={ "ordering": ["-computed_at"], }, ), migrations.CreateModel( name="SurveyResponse", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("respondent_email", models.EmailField(blank=True, max_length=254)), ( "status", models.CharField( choices=[("in_progress", "In progress"), ("completed", "Completed")], db_index=True, default="in_progress", max_length=16, ), ), ("started_at", models.DateTimeField(auto_now_add=True)), ("completed_at", models.DateTimeField(blank=True, null=True)), ( "dispatch", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="responses", to="mel_feedback.surveydispatch", ), ), ( "respondent", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="mel_survey_responses", to=settings.AUTH_USER_MODEL, ), ), ( "submission", models.OneToOneField( blank=True, help_text="Created on completion so triage/corrective-action receivers fire.", null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="survey_response", to="mel_feedback.feedbacksubmission", ), ), ( "survey", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="responses", to="mel_feedback.survey", ), ), ], options={ "ordering": ["-started_at"], }, ), migrations.CreateModel( name="SurveyAnswer", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("value", models.JSONField(blank=True, default=dict)), ("free_text", models.TextField(blank=True)), ( "question", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="answers", to="mel_feedback.surveyquestion", ), ), ( "response", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="answers", to="mel_feedback.surveyresponse", ), ), ], ), migrations.AddIndex( model_name="survey", index=models.Index(fields=["status", "trigger"], name="mel_feedbac_status_da517b_idx"), ), migrations.AddIndex( model_name="surveydispatch", index=models.Index(fields=["survey", "status"], name="mel_feedbac_survey__233371_idx"), ), migrations.AddIndex( model_name="surveydispatch", index=models.Index(fields=["status", "due_at"], name="mel_feedbac_status_51c7a0_idx"), ), migrations.AddIndex( model_name="surveyquestion", index=models.Index( fields=["survey", "page", "ordinal"], name="mel_feedbac_survey__e2f8e7_idx" ), ), migrations.AddIndex( model_name="satisfactionscore", index=models.Index( fields=["survey", "dimension"], name="mel_feedbac_survey__7fc0ee_idx" ), ), migrations.AddIndex( model_name="surveyresponse", index=models.Index(fields=["survey", "status"], name="mel_feedbac_survey__7ee6e0_idx"), ), migrations.AddConstraint( model_name="surveyanswer", constraint=models.UniqueConstraint( fields=("response", "question"), name="uniq_survey_answer_per_question" ), ), ]