# Generated by Django 5.2.6 on 2026-06-12 05:59 import django.db.models.deletion import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): dependencies = [ ("helpdesk", "0006_connector_config"), ("organizations", "0002_workspace_template_user_context_pref"), ("tenants", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="AIActionLog", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "created_at", models.DateTimeField( auto_now_add=True, db_index=True, verbose_name="created at" ), ), ("updated_at", models.DateTimeField(auto_now=True, verbose_name="updated at")), ( "public_id", models.UUIDField( db_index=True, default=uuid.uuid4, editable=False, unique=True, verbose_name="public id", ), ), ( "action_type", models.CharField( choices=[ ("assign", "Assign"), ("change_priority", "Change Priority"), ("change_category", "Change Category"), ("add_tag", "Add Tag"), ("remove_tag", "Remove Tag"), ("send_reply", "Send Reply"), ("change_status", "Change Status"), ("route_to_queue", "Route to Queue"), ], db_index=True, max_length=50, verbose_name="action type", ), ), ( "provider", models.CharField( blank=True, default="", help_text="AI provider that recommended this action.", max_length=100, verbose_name="provider", ), ), ( "payload_before", models.JSONField( blank=True, default=dict, help_text="Snapshot of affected fields before the action.", verbose_name="payload before", ), ), ( "payload_after", models.JSONField( blank=True, default=dict, help_text="Snapshot of affected fields after the action.", verbose_name="payload after", ), ), ( "execution_metadata", models.JSONField( blank=True, default=dict, help_text="Provider-specific metadata (latency, tokens, model version, etc.).", verbose_name="execution metadata", ), ), ( "error_message", models.TextField(blank=True, default="", verbose_name="error message"), ), ], options={ "verbose_name": "AI action log", "verbose_name_plural": "AI action logs", "ordering": ("-created_at",), }, ), migrations.CreateModel( name="AITicketSuggestion", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ( "is_deleted", models.BooleanField(db_index=True, default=False, verbose_name="deleted"), ), ( "deleted_at", models.DateTimeField(blank=True, null=True, verbose_name="deleted at"), ), ( "created_at", models.DateTimeField( auto_now_add=True, db_index=True, verbose_name="created at" ), ), ("updated_at", models.DateTimeField(auto_now=True, verbose_name="updated at")), ( "public_id", models.UUIDField( db_index=True, default=uuid.uuid4, editable=False, unique=True, verbose_name="public id", ), ), ( "provider", models.CharField( default="default", help_text="AI provider identifier (e.g. 'openai', 'azure_ai').", max_length=100, verbose_name="provider", ), ), ( "suggestion_type", models.CharField( choices=[ ("priority", "Priority"), ("category", "Category"), ("tags", "Tags"), ("reply_draft", "Reply Draft"), ("routing", "Routing"), ], db_index=True, default="tags", max_length=50, verbose_name="suggestion type", ), ), ( "status", models.CharField( choices=[ ("pending", "Pending"), ("approved", "Approved"), ("rejected", "Rejected"), ], db_index=True, default="pending", max_length=20, verbose_name="status", ), ), ( "payload", models.JSONField( blank=True, default=dict, help_text="AI recommendation payload whose shape depends on suggestion_type.", verbose_name="payload", ), ), ( "confidence_score", models.DecimalField( blank=True, decimal_places=4, help_text="Confidence score in [0.0000, 1.0000].", max_digits=5, null=True, verbose_name="confidence score", ), ), ( "rationale", models.TextField( blank=True, default="", help_text="Natural language explanation of why the AI made this suggestion.", verbose_name="rationale", ), ), ( "model_version", models.CharField( blank=True, default="", help_text="Version/hash of the AI model that produced this suggestion.", max_length=64, verbose_name="model version", ), ), ( "reviewed_at", models.DateTimeField(blank=True, null=True, verbose_name="reviewed at"), ), ( "review_comment", models.TextField(blank=True, default="", verbose_name="review comment"), ), ], options={ "verbose_name": "AI ticket suggestion", "verbose_name_plural": "AI ticket suggestions", "ordering": ("-created_at",), }, ), migrations.RenameIndex( model_name="connectorconfig", new_name="helpdesk_co_tenant__f373d2_idx", old_name="helpdesk_co_tenant__964e9c_idx", ), migrations.AlterField( model_name="connectorconfig", name="created_at", field=models.DateTimeField(auto_now_add=True, db_index=True, verbose_name="created at"), ), migrations.AlterField( model_name="connectorconfig", name="organization_node", field=models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), migrations.AlterField( model_name="ticket", name="satisfaction_rating", field=models.PositiveSmallIntegerField( blank=True, help_text="1-5 star rating from the requester.", null=True, verbose_name="satisfaction rating", ), ), migrations.AddField( model_name="aiactionlog", name="executed_by", field=models.ForeignKey( blank=True, help_text="User who approved and triggered execution, or system if autonomous.", null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="helpdesk_ai_actions_executed", to=settings.AUTH_USER_MODEL, verbose_name="executed by", ), ), migrations.AddField( model_name="aiactionlog", name="organization_node", field=models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), migrations.AddField( model_name="aiactionlog", name="tenant", field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), migrations.AddField( model_name="aiactionlog", name="ticket", field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="ai_action_logs", to="helpdesk.ticket", verbose_name="ticket", ), ), migrations.AddField( model_name="aiticketsuggestion", name="deleted_by", field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, verbose_name="deleted by", ), ), migrations.AddField( model_name="aiticketsuggestion", name="organization_node", field=models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), migrations.AddField( model_name="aiticketsuggestion", name="reviewed_by", field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="helpdesk_ai_reviews", to=settings.AUTH_USER_MODEL, verbose_name="reviewed by", ), ), migrations.AddField( model_name="aiticketsuggestion", name="tenant", field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), migrations.AddField( model_name="aiticketsuggestion", name="ticket", field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="ai_suggestions", to="helpdesk.ticket", verbose_name="ticket", ), ), migrations.AddField( model_name="aiactionlog", name="suggestion", field=models.ForeignKey( blank=True, help_text="The approved suggestion that triggered this action, if any.", null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="action_logs", to="helpdesk.aiticketsuggestion", verbose_name="suggestion", ), ), migrations.AddIndex( model_name="aiticketsuggestion", index=models.Index( fields=["ticket_id", "suggestion_type", "status"], name="hd_ai_sugg_tkt_type_status_idx", ), ), migrations.AddIndex( model_name="aiticketsuggestion", index=models.Index( fields=["tenant_id", "provider"], name="hd_ai_sugg_tenant_prov_idx" ), ), migrations.AddIndex( model_name="aiticketsuggestion", index=models.Index(fields=["tenant_id", "status"], name="hd_ai_sugg_tenant_status_idx"), ), migrations.AddIndex( model_name="aiactionlog", index=models.Index( fields=["ticket_id", "action_type"], name="hd_ai_act_ticket_type_idx" ), ), migrations.AddIndex( model_name="aiactionlog", index=models.Index( fields=["tenant_id", "created_at"], name="hd_ai_act_tenant_time_idx" ), ), migrations.AddIndex( model_name="aiactionlog", index=models.Index(fields=["suggestion_id"], name="hd_ai_act_suggestion_idx"), ), ]