# Generated by Django 5.2.6 on 2026-06-12 10:59 import django.db.models.deletion import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ("contenttypes", "0002_remove_content_type_name"), ("iam", "0002_userrole"), ("organizations", "0002_workspace_template_user_context_pref"), ("tenants", "0001_initial"), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="EscalationInstance", 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", ), ), ("source_object_id", models.PositiveIntegerField(verbose_name="source entity id")), ( "status", models.CharField( choices=[ ("pending", "Pending"), ("in_progress", "In Progress"), ("escalated", "Escalated"), ("resolved", "Resolved"), ("cancelled", "Cancelled"), ("failed", "Failed"), ], db_index=True, default="pending", max_length=16, verbose_name="status", ), ), ( "escalation_level", models.PositiveSmallIntegerField( default=1, help_text="Current escalation level (1, 2, 3, …).", verbose_name="escalation level", ), ), ( "triggered_at", models.DateTimeField( blank=True, db_index=True, null=True, verbose_name="triggered at" ), ), ( "escalated_at", models.DateTimeField(blank=True, null=True, verbose_name="escalated at"), ), ( "resolved_at", models.DateTimeField(blank=True, null=True, verbose_name="resolved at"), ), ( "reason", models.TextField(blank=True, default="", verbose_name="escalation reason"), ), ( "resolution_note", models.TextField(blank=True, default="", verbose_name="resolution note"), ), ( "escalated_from_user", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name="escalations_from", to=settings.AUTH_USER_MODEL, verbose_name="escalated from", ), ), ( "escalated_to_role", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="escalation_instances", to="iam.role", verbose_name="escalated to role", ), ), ( "escalated_to_user", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="escalations_to", to=settings.AUTH_USER_MODEL, verbose_name="escalated to user", ), ), ( "source_content_type", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="escalation_source_entities", to="contenttypes.contenttype", verbose_name="source entity type", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="escalation_instances", to="tenants.tenant", verbose_name="tenant", ), ), ], options={ "verbose_name": "escalation instance", "verbose_name_plural": "escalation instances", "ordering": ("-created_at",), }, ), migrations.CreateModel( name="EscalationRule", 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", ), ), ("name", models.CharField(max_length=300, verbose_name="name")), ( "description", models.TextField(blank=True, default="", verbose_name="description"), ), ( "trigger_type", models.CharField( choices=[ ("time_based", "Time Based"), ("rule_based", "Rule Based"), ("event_based", "Event Based"), ], db_index=True, max_length=16, verbose_name="trigger type", ), ), ( "trigger_config", models.JSONField( blank=True, default=dict, help_text="JSON config defining trigger conditions: time_threshold_hours, event_names, conditions, etc.", verbose_name="trigger configuration", ), ), ( "escalation_type", models.CharField( choices=[ ("hierarchy", "Hierarchy Based"), ("role", "Role Based"), ("user", "User Based"), ], db_index=True, max_length=16, verbose_name="escalation type", ), ), ( "escalation_config", models.JSONField( blank=True, default=dict, help_text="JSON config defining escalation target: target_role_id, target_org_unit_id, max_hierarchy_levels, etc.", verbose_name="escalation configuration", ), ), ( "max_levels", models.PositiveSmallIntegerField( default=3, help_text="Maximum number of escalation levels before final decision.", verbose_name="maximum escalation levels", ), ), ( "conditions", models.JSONField( blank=True, default=dict, help_text="JSON conditions for matching this rule to specific entities.", verbose_name="conditions", ), ), ( "priority", models.CharField( blank=True, choices=[ ("low", "Low"), ("medium", "Medium"), ("high", "High"), ("urgent", "Urgent"), ], db_index=True, max_length=10, verbose_name="priority", ), ), ( "is_active", models.BooleanField(db_index=True, default=True, verbose_name="active"), ), ( "content_type", models.ForeignKey( blank=True, help_text="If set, this escalation rule only applies to this entity type.", null=True, on_delete=django.db.models.deletion.CASCADE, related_name="escalation_rules", to="contenttypes.contenttype", verbose_name="entity type", ), ), ( "deleted_by", 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", ), ), ( "organization_node", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="organizations.organizationnode", verbose_name="organization node", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="+", to="tenants.tenant", verbose_name="tenant", ), ), ], options={ "verbose_name": "escalation rule", "verbose_name_plural": "escalation rules", "ordering": ("tenant", "name"), "abstract": False, }, ), migrations.CreateModel( name="EscalationLog", 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", models.CharField( choices=[ ("triggered", "Triggered"), ("notified", "Notified"), ("escalated", "Escalated"), ("reassigned", "Reassigned"), ("resolved", "Resolved"), ("cancelled", "Cancelled"), ("failed", "Failed"), ], db_index=True, max_length=24, verbose_name="action", ), ), ("note", models.TextField(blank=True, default="", verbose_name="note")), ("metadata", models.JSONField(blank=True, default=dict, verbose_name="metadata")), ( "actor", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="escalation_logs", to=settings.AUTH_USER_MODEL, verbose_name="actor", ), ), ( "instance", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="logs", to="escalation_engine.escalationinstance", verbose_name="escalation instance", ), ), ( "tenant", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="escalation_logs", to="tenants.tenant", verbose_name="tenant", ), ), ( "rule", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="logs", to="escalation_engine.escalationrule", verbose_name="escalation rule", ), ), ], options={ "verbose_name": "escalation log", "verbose_name_plural": "escalation logs", "ordering": ("-created_at",), }, ), migrations.AddField( model_name="escalationinstance", name="rule", field=models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="instances", to="escalation_engine.escalationrule", verbose_name="escalation rule", ), ), migrations.AddIndex( model_name="escalationrule", index=models.Index( fields=["tenant", "organization_node"], name="escalation__tenant__61c082_idx" ), ), migrations.AddIndex( model_name="escalationrule", index=models.Index( fields=["tenant", "trigger_type", "is_active"], name="escal_rule_tenant_trig_act" ), ), migrations.AddConstraint( model_name="escalationrule", constraint=models.UniqueConstraint( fields=("tenant", "name"), name="escal_rule_unique_tenant_name" ), ), migrations.AddIndex( model_name="escalationlog", index=models.Index(fields=["tenant", "action"], name="escalation_log_tenant_action"), ), migrations.AddIndex( model_name="escalationlog", index=models.Index(fields=["instance", "created_at"], name="escal_log_inst_created"), ), migrations.AddIndex( model_name="escalationinstance", index=models.Index(fields=["tenant", "status"], name="escalation_inst_tenant_status"), ), migrations.AddIndex( model_name="escalationinstance", index=models.Index(fields=["tenant", "triggered_at"], name="escal_inst_tenant_trig"), ), migrations.AddIndex( model_name="escalationinstance", index=models.Index( fields=["source_content_type", "source_object_id"], name="escalation_inst_source_object", ), ), migrations.AddIndex( model_name="escalationinstance", index=models.Index(fields=["rule", "status"], name="escalation_inst_rule_status"), ), ]